Bloomberg Excel Plug-ins

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
deliveryModel:
  model: saas
  open_source: false
  commercial: true
  callable_host: false
  label: Hosted service · you call their endpoint
  confidence: medium
  source:
  - pricing
  generated: '2026-08-28'
  method: derived
accessModel:
  pricing: freemium
  onboarding: unknown
  trial: false
  try_now: false
  public: false
  label: Freemium
  confidence: low
  source:
  - plans
  - security
  generated: '2026-11-06'
  method: derived
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/bloomberg-excel-plug-ins.png
url: https://raw.githubusercontent.com/api-evangelist/bloomberg-excel-plug-ins/refs/heads/main/apis.yml
created: '2024-01-01'
modified: '2026-09-16'
specificationVersion: '0.23'
x-docs-platform: redoc
x-docs-platform-confidence: medium
x-docs-platform-checked: 2026-09-20
tags:
- Excel
- Spreadsheets
- Financial Modeling
- Market Data
- Bloomberg
- Add-in
tags_raw:
- 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: Plans
  url: plans/bloomberg-excel-plug-ins-plans-pricing.yml
- type: RateLimits
  url: rate-limits/bloomberg-excel-plug-ins-rate-limits.yml
- type: FinOps
  url: finops/bloomberg-excel-plug-ins-finops.yml
- type: Website
  url: https://bloomberg.com
- type: ParentCompany
  url: https://apis.io/providers/bloomberg/
  name: Bloomberg
  x-relationship: product
  x-generated-by: bloomberg-family:2026-08-27
- type: DomainSecurity
  url: security/bloomberg-excel-plug-ins-domain-security.yml
- 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: kinlane@gmail.com
x-parent: bloomberg
x-relationship: product