Bloomberg excel add in

This is a discussion on Bloomberg excel add in within the Techies Corner forums, part of the Trading Career category; Hello, I'm trying to make a function in excel with the Bloomberg add-in so that it pulls a foreign HP ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Dec 21, 2011, 6:08pm   #1
 
1 Posts
Joined Dec 2011
Bloomberg excel add in

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
LT728 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bloomberg user forum and Bloomberg automation? mizhael Techies Corner 5 May 22, 2012 4:47pm
How to add stocks to Bloomberg iPad app? rapa-at-trade General Trading Chat 0 Apr 19, 2011 11:54am
Bloomberg add-in in excel secondrate General Trading Chat 1 Jul 17, 2010 5:07pm
bloomberg ALLQ function to excel? signhere Techies Corner 30 Aug 6, 2009 8:51am
Detecting when a futures contract is with the Bloomberg Excel plugin enterthe Trading Software 2 Aug 3, 2007 4:14pm

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)