MATLAB Answers

How to retrieve historical data from Bloomberg for 20 securities

1 view (last 30 days)
Jiang WANG
Jiang WANG on 16 Oct 2017
Commented: Jiang WANG on 23 Oct 2017
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

  2 Comments

Prashant Arora
Prashant Arora on 19 Oct 2017
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
Jiang WANG on 23 Oct 2017
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.

Sign in to comment.

Answers (0)

Sign in to answer this question.