#BUGZILLA EXPORT TO EXCEL PC#

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.

#BUGZILLA EXPORT TO EXCEL PC#

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.

Bugzilla export to excel