Answers

Bloomberg BDP and BDH Formulas in Google Sheets

BDP and BDH need Bloomberg's Excel add-in, and its software page lists no Sheets version. On Gloom Pro, a workbook ports to Google Sheets by find and replace: BDP( to GLOOM(, BDH( to GLOOMH(.

Checked

Last priceBloomberg=BDP(A2,"PX_LAST")Gloom=GLOOM(A2,"PX_LAST")
Market capBloomberg=BDP(A2,"CUR_MKT_CAP")Gloom=GLOOM(A2,"CUR_MKT_CAP")
Forward P/EBloomberg=BDP(A2,"BEST_PE_RATIO")Gloom=GLOOM(A2,"BEST_PE_RATIO")
RevenueBloomberg=BDP(A2,"SALES_REV_TURN")Gloom=GLOOM(A2,"SALES_REV_TURN")
Weekly historyBloomberg=BDH(A2,"PX_LAST","20260101","","Per=W")Gloom=GLOOMH(A2,"PX_LAST","20260101","","Per=W")

A2 holds a Bloomberg ticker, such as AAPL US Equity.

Set it up

  1. 1.Create a Market data only key in Cloud settings, Agents. It needs Pro.
  2. 2.In your sheet, open Extensions > Apps Script.
  3. 3.Paste gloom.js over Code.gs and save.
  4. 4.Reload, then Gloom > Set API key and paste the key.
  5. 5.Type =GLOOM("AAPL US Equity","PX_LAST").

If Google calls your script unverified, choose Advanced, then Go to your project. Full setup.

Where Gloom fits

Gloom covers

  • Bloomberg tickers and mnemonics, London prices in pence as on Bloomberg.
  • A whole table from one cell: =GLOOM(A2:A4, B1:D1).
  • #N/A with the reason, as on Bloomberg.
  • The same data over the REST API.

Gloom does not cover

  • Fields outside the field dictionary. They say why.
  • Government and corporate bonds.
  • Over 120 units a minute or 5,000 a day per key.
  • An Excel add-in.
  • A hidden key: every sheet editor can read it.
Open the terminal in your browser, no accountWhich plan includes what: Free, Pro and Team
  • Sources4 sources
    • Bloomberg software updates, read 16 October 2026: Office Tools for Microsoft Office, mobile apps, no Google Sheets add-on.
    • Google Sheets docs, updated 7 October 2026: setup, Bloomberg tickers, pence, #N/A, the key in script properties.
    • REST API docs, updated 9 October 2026: the field list, no bonds, 120 units a minute and 5,000 a day.
    • Field dictionary, no key needed.
  • Not verified2 claims
    • That Bloomberg's Excel add-in does not run on a Mac. Reported by users (r/bloomberg).
    • How many of a given workbook's fields Gloom serves. Check each one in the field dictionary before you port.