The security, field and dates can be written into the formula or referenced from other cells. Note that row and column counts will be added as extra parameters automatically after the formula has called. You can add optional extra parameters such as orientation=H|V, currency, or array=True which puts all the output data into one cell instead many rows/columns (requires array formulas afterwards). The tool will suggest auto-completion if you don’t happen to know the exact security or field code.

BDS: (Bloomberg Data Series) imports a set of bulk data such as peers.įor your chosen function, you will be asked to type in a security (such as AAPL US EQUITY), a field (such as INDUSTRY_SECTOR or PX_LAST), and dates (depending on the function).

BDH: (Bloomberg Data History) returns the historical data for a selected security.

BDP: (Bloomberg Data Point) imports a single data point of current data.The function builder will start by asking you to choose one of three major Bloomberg Functions: This more advanced tool will expose the Bloomberg API to you, where a user interface do the hard work to create functions for you, such as =BDP('AAPL US EQUITY', 'INDUSTRY_SECTOR') producing the value ‘Technology’. If you want a little more control, use the function builder, found in ‘ Bloomberg > Create > Function Builder’. (This is also true for all the Excel options below.)īuild a function from scratch, using the function builder. Note: A sheet which contains Bloomberg formulas creating live data may not load on a PC without Bloomberg unless you save as CSV or copy/paste-as-values. Sometimes the data is copied to the clipboard for you to paste into a worksheet of your choice. Sometimes the action will download and open a new Excel document the data will either be written in directly or load later via the Bloomberg API. Look for commands such as ‘ Copy data to clipboard’, ‘ Output > Excel’ or similar, by clicking on the red menu bar (Actions) or right-clicking on charts or data. Bottom-right Historical index member changes (CHNG): Not possible to export report data.

Bottom-left Member weights (MEMB): ‘ Red menu > Output > Excel’ (data is fixed).Top-right Price charts (GP): ‘ Right-click on chart > Copy/Export Options > Copy Data to Clipboard’ (then paste in Excel).Top-left Financial analysis (FA): ‘ Red menu > Output > Excel > Current Template’ (data is live).There are various ways to get data from the Bloomberg terminal into Excel (remember to work at the terminal though). Various functions in the Bloomberg terminal for accessing on-screen data for exporting to Excel.

Bloomberg terminal setup