Q. What are the Bloomberg formulas that I can use in Excel spreadsheet?

Bloomberg Data Point (BDP)

BDP formulas provide current data and descriptive real-time/streaming data.

Formula: =BDP(security ticker, field)
Example: =BDP("SIA SP Equity", "px_last")

Bloomberg Data History (BDH)

BDH formulas provide historical end-of-day and historical intra-day data.

Formula: =BDH(security, field(s), start date, end date)
Example: =BDH("SIA SP Equity","px_last", "12/30/2008", "12/30/2009")

Bloomberg Data Set (BDS)

BDS formulas gives multi-cells of data such as company description, index members' weightage, top holders, etc.

Formula: =BDS(ticker, field)
Example: =BDS(PSI20 Index, indx mweight, "cols=2;rows=20")

For template with formulas set up, enter API <GO> > click Sample Spreadsheet > choose Tutorials > Bloomberg API.