Bloomberg Excel Plug-ins
Bloomberg Excel Plug-ins integrate Bloomberg market data, analytics, and functions directly into Microsoft Excel. The Bloomberg Add-in for Excel provides the BDH, BDP, BDS, and other Bloomberg formula functions to pull real-time and historical data, enabling quantitative analysis, financial modeling, and reporting without leaving the spreadsheet environment.
APIs
Bloomberg Excel Add-in
The Bloomberg Add-in for Microsoft Excel provides formula functions including BDP (Bloomberg Data Point), BDH (Bloomberg Data History), BDS (Bloomberg Data Set), and BQL for acc...
Bloomberg BQL in Excel
Access Bloomberg Query Language (BQL) directly within Excel to run flexible, custom queries for financial data, analytics, and derived metrics using the Bloomberg BQL Add-in.
Features
Bloomberg Data Point formula for real-time and static data retrieval in Excel.
Bloomberg Data History formula for historical time series data retrieval.
Bloomberg Data Set formula for multi-cell data retrieval and tables.
Bloomberg Query Language support directly in Excel for advanced custom queries.
Automatic data refresh for real-time market data in Excel cells.
Pre-built Excel templates for portfolio analysis, risk, and reporting.
Use Cases
Build discounted cash flow models and valuation models with live Bloomberg data.
Create automated portfolio reports with real-time and historical data.
Pull pricing, volatility, and correlation data for risk calculations.
Analyze market trends and securities data without leaving Excel.
Run quantitative screens and backtests using Bloomberg historical data in Excel.