Answered By: Jiaxin Low
Last Updated: May 26, 2016     Views: 75274

Key Bloomberg formulas which you can use in Excel are:

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 historial 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 forumulas gives multi-cells of data such as company description, index members' weightage, top holders, etc.

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

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

Related Topics

Need further help?

Ask Us!
Your Info
Fields marked with * are required.