How do I import data into Excel from Bloomberg using Excel 2007 (Microsoft Vista). I need to import historical prices of 14 tickers into the same workbook.
How do I import data into Excel from Bloomberg using Excel 2007 (Microsoft Vista). I need to import historical prices of 14 tickers into the same workbook.
It is not a kind of simple process which you are asking. Also there is no addin support for the same. The two main ideas that come to mind. First can be crossing the bloomberg terminal of a network station. Here > Recording (not authorized by BBG) hard data on the file and opening the file on the computer non terminal. Second crossing the FTP system of BBG. Here > File generation with sending text query and retrieval of results.
It is not difficult to download historical intraday or over a period of several months, simply use the macro recorder and import the data from "new query on the web" I can not make a macro as an example because I have to be subscribed to Bloomberg and Reuters. I use the free sites. We must calculate the historical returns and volatility.
Bookmarks