Bloomberg Excel Tools 1.0

Bloomberg Excel Tools is a suite of add-ins that connects Microsoft Excel to Bloomberg’s market data and analytics, allowing you to pull real-time, historical, and reference data directly into spreadsheets. It’s designed for analysts, portfolio managers, traders, and researchers who want to build models, dashboards, and reports with live Bloomberg data inside Excel.

Key features:

• Live and delayed market data in spreadsheets with controllable refresh
• Historical time-series retrieval for pricing, fundamentals, and economic data
• Reference and bulk datasets for securities, indices, and custom universes
• Intuitive formula helpers and field search to find the right data fields
• Familiar Bloomberg Excel formulas (e.g., BDP, BDH, BDS) for flexible queries
• Prebuilt templates and wizards to accelerate model building
• VBA/COM support to automate workflows and integrate with macros
• Tools to convert live links to static values and manage refresh behavior

Common uses:

• Valuation models, portfolio monitoring, and risk analysis
• Performance and attribution reports
• Market dashboards and economic research
• Compliance and surveillance checks needing auditable data pulls

Requirements:

• Active Bloomberg Terminal subscription with API permissions
• Bloomberg Excel Add-In installed and running alongside the Terminal
• Supported Microsoft Excel (32- or 64-bit) on Windows

Note: Data access is subject to your Bloomberg licenses and entitlements, and the tools are not standalone—they require the Bloomberg Terminal and network connectivity to function.

Bloomberg Excel Tools is developed by Bloomberg L.P.. The most popular version of this product among our users is 1.0. The names of program executable files are BbAddin.exe, bfntupd.exe, EXCEL.EXE, mkroute.exe and Roxio_Central33.exe. Works with c2d, cue file types.

You can check Kutools for Excel, Bloomberg Professional Service, IP Tools for Excel and other related programs like Bloomberg Pricelink at the "download" section.