Quickly download historical pricing, financial ratios, and more directly into an Excel spreadsheet.
To enable the Bloomberg Excel add-in:
You will need to perform the above steps on each machine you use before Bloomberg will appear in Excel's menu.
Click Spreadsheet Builder to walk through steps to build a custom table in the current 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:
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.