The Bloomberg Excel Add-in, formally known as Bloomberg API (Application Program Interface), is a tool that delivers Bloomberg data directly into an Excel spreadsheet for custom analysis and calculations.
If you are using the Excel plugin for the first time at any kiosk, you have to do a one-time installation.
To install, close all Excel spreadsheets and follow this path: Start > All Programs > Bloomberg > Install Excel Add-In.
Once installed, the Bloomberg tab will appear in the Excel ribbon.
Bloomberg has various pre-built templates to help users retrieve data.
To see a list of templates, use the command XLTP <GO>
Details on Excel API formulas: Use the command HELP DAPI <GO>Excel Guides:
Bloomberg Query Language (BQL) is Bloomberg’s new API. It allows you to perform custom calculations/analysis in the Bloomberg Cloud. This makes it possible to extract the right information by synthesizing large amounts of data.
BQL is based on normalized, curated, cross asset data. BQL allows you to define the data and the analytics (for eg., aggregation/ trend/ filtering/ scoring/ ranking / zscore) you need – to get the answer rather than the data.
Data extracted through the Excel API is subject to monthly download limits. Please be judicious in downloading data to avoid hitting the limits for yourself and all other users. Once the monthly limit is reached at a terminal, data cannot be downloaded until the start of the next month.
If the monthly limit has been reached on a terminal:
If you need to download large amounts of data: