Blog - page 2

September 23, 2016

How to fetch Market Data in Excel like a Pro

Posted by Felix Zumstein

Get market data from Quandl and other data providers directly via cell formulas: Overview Bloomberg’s infamous BDH formula Enter xlwings Building QDH Bloomberg’s infamous BDH formula Tell a financial analyst to download market data into Excel, and the odds are that they will start typing the following formula in an Excel spreadsheet: =BDH("TICKER", "PX_LAST",...). This formula stands for “Bloomberg Data History” and will download the end-of-period prices of the indicated ticker directly into your spreadsheet... Read More...