What are the Bloomberg formulas that I can use in Excel spreadsheet?
Answer
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
