Bloomberg add-in in excel

[secondrate]

Hey guys, I need some help with bdp. As we know, if we have say the ISIN of a security, and if we're looking for the trading price, we can type this in an excel sheet: =bdp("ISIN corp" , "px ask").

How about for fields such as: 'spread-asset swapped' and 'spread to benchmark'? What are their "px_ask" equivalents?

It's because i downloaded this data from deutsche bank. Sample:

For security with ISIN XS0167068849, spread-asset swapped is 39.4 while spread to benchmark is 69.4 as of july 15. Help would really be appreciated. Thanks!

 

[Martinghoul]

The easiest way to find the correct abbreviation is to go through the Bloomberg wizard in Excel. If the fields you're looking for exist, you should be able to find them by using the search function in the popup. Otherwise, there's also a file in the blp directory that contains the list of all the field codes.