How to retrieve historical data from Bloomberg for 20 securities

Hi, mates. Thank you for reading my question. From the datafeed documenation, I understand how to retrieve historical data for multiple stocks. For example, attached 1. However, when I was trying to expand the number of stocks, eg, 20, as attached 2, there was no any price displayed. Is there any coding-error? Looking forward to receive your answers. Thank you very much.

Best regards. John

[Prashant Arora]

Hi Jiang,

I am unable to reproduce this behavior at my end. I used your exact code and I am able to see the data populated in the variable d. You should use cell-indexing like d{1}, d{2} to see the data. The attached image only shows the "sec" variable and hence I am not sure what the "d" variable looks like after you execute your code.

[Jiang WANG]

Dear Prashant, Thank you for answering my questions. Yours support has help me a lot. Moreover, I have a question to ask that after retrieving all data from Bloomberg to the local, how to store all data without checking each d{I}? Or how to categorise them by different stocks' name? Thank you very much.