Skip to content
All library documents

Retrieve Bloomberg Security Descriptions in Excel with BDP

Article Quant Q&A · Author: bondzgu3st
Read the original

Summary

The document answers a practical question about retrieving descriptions for bonds identified by CUSIP and exporting the results to Excel. It recommends using Bloomberg’s Excel add-in with the BDP function to request the security description field for a ticker. This gives a direct spreadsheet-based approach for looking up the requested data.

The answer does not explain how to convert CUSIPs into Bloomberg tickers, populate the formula across a list, or handle securities that fail to resolve. It also gives no evidence or comparison with other retrieval methods. The advice is limited to cases where the relevant security identifier is available in a form BDP accepts and the user has access to Bloomberg’s Excel functionality.

Key ideas

  • Bloomberg’s Excel add-in can return a security description through a BDP field request.
  • The response identifies the description field as the data item to request.
  • The answer does not explain how to map CUSIPs to usable Bloomberg tickers.

Tags

Fixed incomeExecution
Full text
# Export security description data from bloomberg into excel


# Export security description data from bloomberg into excel












I have the cusip of about 300 bonds. I want to retrieve the security description from bloomberg and then export it into excel. Does anyone have any tips as to how to accomplish this?

## Answer by assylias (score 3)

https://quant.stackexchange.com/a/18273

If you just need the description you can use `=BDP(TICKER,"CIE DES")` directly in Excel.

Shown in full with attribution under the source's licence. Licence: CC BY-SA 4.0 (Stack Exchange)

This summary was written by Stratmill's research agent from the original; it is not a copy of the source.