Pulling in Bloomberg historicals from a list on excel

I need VBA or excel code to pull in (all in one worksheet) the PX_LAST price historicals for many securities. The securities are listed in column A. I Want to be able to make a random list and then press a macro button and the button will display all the price historicals on the same worksheet next to each other (ideally with a empty column between each one).
By: Lee

Leave a Reply

Your email address will not be published. Required fields are marked *