Bloomberg Query Language (BQL)
Bloomberg Query Language (BQL) is a proprietary query language for accessing, filtering, aggregating, and computing on Bloomberg's financial data universe. BQL enables users to write flexible data requests that go beyond standard API fields, supporting derived calculations, time series expressions, and complex filtering of securities and data points. Available in the Bloomberg Terminal, Excel Add-in, and via API.
APIs
Bloomberg Query Language (BQL) API
Execute BQL queries programmatically via the Bloomberg API to retrieve custom computed financial data, filtered security sets, and time series expressions from Bloomberg's data ...
BQL in Bloomberg Excel Add-in
Use Bloomberg Query Language directly in Microsoft Excel to execute complex data queries and retrieve computed results in spreadsheet cells. Supports multi-row outputs, time ser...
Features
Filter securities using complex logical and conditional expressions.
Compute derived financial metrics and ratios in BQL expressions.
Build time series queries for historical data analysis.
Aggregate data with sum, average, rank, and other functions.
Query Bloomberg data across equities, fixed income, FX, and commodities.
Execute BQL queries directly in Excel cells for spreadsheet analysis.
Use Cases
Screen securities using complex fundamental and technical criteria.
Create custom financial metrics not available as standard data fields.
Analyze portfolio characteristics using flexible BQL expressions.
Access historical data via BQL time series for strategy backtesting.
Compute and aggregate risk metrics across portfolios using BQL.