Hello,
I'm trying to make a function in excel with the Bloomberg add-in so that it pulls a foreign HP price but in USD. I have an excel sheet already setup to pull the HP prices for US securities but not for foreign securities in USD. The formula I'm currently using is: =BDP($B2&$D2, E$1) where B2 is the cusip I'm looking for, D2 is "Equity Cusip" and E1 is "Last Price". The above formula does not pull any forgein prices at all. What I currently do to get these foreign prices is manually type in the Bloomberg eg: "TLM CN equity HP" and I have to change the currency from CAD to USD. My question is:
1. Can a formula like this be created?
2. can you help me with the formula because I can't figure it out through the function creator in excel?
Thank you,
LT
I'm trying to make a function in excel with the Bloomberg add-in so that it pulls a foreign HP price but in USD. I have an excel sheet already setup to pull the HP prices for US securities but not for foreign securities in USD. The formula I'm currently using is: =BDP($B2&$D2, E$1) where B2 is the cusip I'm looking for, D2 is "Equity Cusip" and E1 is "Last Price". The above formula does not pull any forgein prices at all. What I currently do to get these foreign prices is manually type in the Bloomberg eg: "TLM CN equity HP" and I have to change the currency from CAD to USD. My question is:
1. Can a formula like this be created?
2. can you help me with the formula because I can't figure it out through the function creator in excel?
Thank you,
LT
