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.

Bloomberg Excel Plug-ins publishes 2 APIs on the APIs.io network. Tagged areas include Excel, Spreadsheet, Financial Modeling, Market Data, and Bloomberg.

Bloomberg Excel Plug-ins’ developer surface includes developer portal, documentation, support, and 3 more developer resources.

🌐 Visit website 📡 Source on GitHub

28.3/100 thin ▬ flat Agent 3/100 human only Full breakdown ↓
scored 2026-07-28 · rubric v0.6

AccessFreemium

2 APIs 6 Features 5 Use Cases

ExcelSpreadsheetFinancial ModelingMarket DataBloombergAdd-in

Kin Score

Kin Score How this is scored →
scored 2026-07-28 · rubric v0.6

Composite quality — 28.3/100 · thin

Contract Quality 0.0 / 25

Developer Ergonomics 4.3 / 20

Commercial Clarity 12.1 / 20

Operational Transparency 4.1 / 13

Governance 0.0 / 12

Discoverability 6.9 / 10

Agent readiness — 3/100 · human only

Machine-Readable Contract 0 / 18

Agentic Access Contract 0 / 10

MCP Server 0 / 12

Machine-Readable Auth 0 / 10

Idempotency 0 / 9

Stable Error Semantics 0 / 8

Request/Response Examples 0 / 7

Rate-Limit Signaling 7 / 7

Typed Event Surface 0 / 6

Agent Skills 0 / 5

Well-Known Catalog 0 / 4

Consent & Bot Identity 0 / 3

A2A Agent Card 0 / 8

Dry-Run / Simulate Mode 0 / 4

Improve this rating by publishing the missing artifacts — every area above can be raised, and the full rubric is at apis.io/rating/. This rating is computed from github.com/api-evangelist/bloomberg-excel-plug-ins: open an issue to ask a question, or submit a pull request to add artifacts. Want it done for you? Prioritized profiling — $2,500 →

APIs 2

Individual APIs this provider publishes, each with its own machine-readable definition.

Rate Limits 1

Documented rate limits and quota policies.

Bloomberg Excel Plug Ins Rate Limits

5 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals for API financial operations.

Bloomberg Excel Plug Ins Finops

FINOPS

Features 6

Notable capabilities this provider offers.

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.

Security Posture 1

Authentication, domain security, vulnerability disclosure, and trust-center signals.

Bloomberg Excel Plug Ins Domain Security

TLSv1.3 · DMARC

SECURITY

Use Cases 5

What developers build with this provider.

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

Get Started 1

Portal, sign-up, and the first successful call

Portal

Portal

Documentation 1

Reference material describing how the API behaves

Documentation

Documentation

Access & Security 1

Authentication, authorization, and security posture

DomainSecurity

DomainSecurity

Operate 1

Status, limits, changes, and where to get help

Support

Support

Commercial 2

Pricing, plans, and the legal terms of use

TermsOfService

TermsOfService

PrivacyPolicy

PrivacyPolicy

Source (apis.yml)

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
accessModel:
  pricing: freemium
  onboarding: unknown
  trial: false
  try_now: false
  public: false
  label: Freemium
  confidence: medium
  source:
  - plans
  generated: '2026-07-22'
  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-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: 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