How to fetch Market Data in Excel like a Pro
Tell a financial analyst to download market data into Excel, and the odds are that he will start
typing the following formula in an Excel spreadsheet:
This formula stands for "Bloomerg Data History" and will download the end-of-period prices of the indicated ticker
directly into your spreadsheet - given that you have Bloomberg's Excel addin connected to a Bloomberg terminal.
This blog post post is about creating such a formula with xlwings that you can attach to any data source like
Quandl, Yahoo! Finance or Google Finance.
READ MORE >