Answered By: Jiaxin Low Last Updated: Jun 28, 2019 Views: 195100
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