Quickly download historical pricing, financial ratios, and more directly into an Excel spreadsheet.
To enable the Bloomberg Excel add-in for a user profile:
Click Spreadsheet Builder to walk through steps to build a custom table in the current worksheet.
Functions populate dynamically based on the options you select in the wizard.
After completing the wizard, you can adjust functions and variables generated by the wizard by editing them directly in the worksheet.
The Bloomberg Desktop (Excel) API enables a suite of special functions (examples below), for retrieving Bloomberg data.
Within a function's syntax,
Combined, a function could appear as follows: BDS("PFE US EQUITY", "PCT_GEO_OWNERSHIP", "cols=2;rows=50").
Access step-by-step help building a Bloomberg function by selecting Bloomberg > Function Builder from Excel's ribbon menu.
Bloomberg Query Language is a separate approach that enables more-robust, SQL-like queries.
Access examples and step-by-step help building a BQL function by selecting Bloomberg > BQL Builder from Excel's ribbon menu.
This method copies static data without calling the Bloomberg Desktop API:
Not all tables can be copied. Consider emailing a screenshot using GRAB <GO>.
Access help and resources through the Bloomberg Terminal:
Excel API functions can return empty cells (if no results match your query) or unique error codes. See several common codes below:
For additional Excel API error codes, descriptions, and troubleshooting, submit this command in the Bloomberg application:
LPHP DAPI:0:1 1489652 <GO>
Bloomberg limits the number of results users can download. Once a terminal has reached its daily or monthly limit, API data will remain unavailable until the next period. For your benefit and for others', please consider how you download data.
The following approaches may help:
Data obtained through the Bloomberg Desktop (Excel) API may not leave the local machine you used to access the Bloomberg service. Enter DAPI <GO> and see the Desktop API Guidelines section to learn more about this policy and its limited exceptions.