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.

2 APIs 6 Features

ExcelSpreadsheetFinancial ModelingMarket DataBloombergAdd-in

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

BDP Formula

Bloomberg Data Point formula for real-time and static data retrieval in Excel.

BDH Formula

Bloomberg Data History formula for historical time series data retrieval.

BDS Formula

Bloomberg Data Set formula for multi-cell data retrieval and tables.

BQL Integration

Bloomberg Query Language support directly in Excel for advanced custom queries.

Real-Time Updates

Automatic data refresh for real-time market data in Excel cells.

Portfolio Analysis Templates

Pre-built Excel templates for portfolio analysis, risk, and reporting.

Use Cases

Financial Modeling

Build discounted cash flow models and valuation models with live Bloomberg data.

Portfolio Reporting

Create automated portfolio reports with real-time and historical data.

Risk Analysis

Pull pricing, volatility, and correlation data for risk calculations.

Market Research

Analyze market trends and securities data without leaving Excel.

Quantitative Analysis

Run quantitative screens and backtests using Bloomberg historical data in Excel.

Resources

Sources

aid: bloomberg-excel-plug-ins
name: Bloomberg Excel Plug-ins
description: 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.
type: Index
image: https://kinlane-productions.s3.amazonaws.com/apis-json/apis-json-logo.jpg
url: https://raw.githubusercontent.com/api-evangelist/bloomberg-excel-plug-ins/refs/heads/main/apis.yml
created: '2024-01-01'
modified: '2026-04-21'
specificationVersion: '0.19'
tags:
- Excel
- Spreadsheet
- Financial Modeling
- Market Data
- Bloomberg
- Add-in
apis:
- aid: bloomberg-excel-plug-ins:bloomberg-excel-addin
  name: Bloomberg Excel Add-in
  description: 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 accessing Bloomberg data directly in spreadsheets.
  humanURL: https://www.bloomberg.com/professional/support/software-updates/
  baseURL: https://bloomberg.com/excel
  tags:
  - Excel
  - Add-in
  - BDP
  - BDH
  - BDS
  - Formulas
  properties:
  - type: Documentation
    url: https://www.bloomberg.com/professional/support/software-updates/
- aid: bloomberg-excel-plug-ins:bloomberg-bql-excel
  name: Bloomberg BQL in Excel
  description: 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.
  humanURL: https://www.bloomberg.com/professional/solution/bloomberg-excel/
  baseURL: https://bloomberg.com/bql-excel
  tags:
  - BQL
  - Excel
  - Query Language
  - Analytics
  properties:
  - type: Documentation
    url: https://www.bloomberg.com/professional/solution/bloomberg-excel/
common:
- type: Portal
  url: https://www.bloomberg.com/professional/
- type: Documentation
  url: https://developer.bloomberg.com/
- type: TermsOfService
  url: https://www.bloomberg.com/notices/tos/
- type: PrivacyPolicy
  url: https://www.bloomberg.com/privacy/
- type: Support
  url: https://www.bloomberg.com/professional/support/
- type: Features
  data:
  - name: BDP Formula
    description: Bloomberg Data Point formula for real-time and static data retrieval
      in Excel.
  - name: BDH Formula
    description: Bloomberg Data History formula for historical time series data retrieval.
  - name: BDS Formula
    description: Bloomberg Data Set formula for multi-cell data retrieval and tables.
  - name: BQL Integration
    description: Bloomberg Query Language support directly in Excel for advanced
      custom queries.
  - name: Real-Time Updates
    description: Automatic data refresh for real-time market data in Excel cells.
  - name: Portfolio Analysis Templates
    description: Pre-built Excel templates for portfolio analysis, risk, and reporting.
- type: UseCases
  data:
  - name: Financial Modeling
    description: Build discounted cash flow models and valuation models with live
      Bloomberg data.
  - name: Portfolio Reporting
    description: Create automated portfolio reports with real-time and historical
      data.
  - name: Risk Analysis
    description: Pull pricing, volatility, and correlation data for risk calculations.
  - name: Market Research
    description: Analyze market trends and securities data without leaving Excel.
  - name: Quantitative Analysis
    description: Run quantitative screens and backtests using Bloomberg historical
      data in Excel.
maintainers:
- FN: Kin Lane
  email: [email protected]