Excel + BBL

A

Arne Hegefors

Hello! I try to perform a very simple task using Bloomberg and Execl. I have
an Excel spreadsheet that contains a list of bank names, their ISIN codes and
their Bloomberg tickers. I then have a macro that I (am trying to) use to
extract ratings for these banks from BBL into Excel. I use a simple DDE
connection (I know it sucks but we are not allowed to use Active X due to
security reasons and I cannot use C or other languages so I am pretty much
stuck with this). Anyway my code opens a DDE link to BBL, loops through the
ISIN codes and asks BBL for the rating that is then displayed in the
spreadsheet. This works fine. However for several reasons I would like to use
the BBL tickers instead of ISIN codes. When i try to do that my code does not
work. I get Error: #/N/A Sec (I know that they are valid tickers eg BNP FP).
Please help me with this problem! I have tried using the BBL helpdesk but
even for this easy question they cannot help me!!

BBL = "BNP FP"
channelNumber = Application.DDEInitiate(app:="BLP", topic:="S")
BloomQuery = "'" BBL & " Corp, [RTG_SP]"
returnList = Application.DDERequest(channelNumber, BloomQuery)
Rating = returnList(1)
MsgBox Rating

Please I would really really need help with this! Any help appreciated!
Thank you very much in advance!!
 
P

Post Tenebras Lux

Have you tried using the Bloomberg addin wizard? It will let you build your
own template. Much better to use the single cell blp or RTD option, as you
can then make the cells completely flexible afterwards.

Alternatively, you can type: IDOC API BANK <GO> and download their
templates, which will almost certainly have ratings as one of the fields.

You should also be able to use the BLPH wizard (in Excel, if youhave the blp
addin loaded) to get serial ratings.

HTH.
 
A

Arne Hegefors

thanks alot for your help!! I solved my problem. it was quite simple since
there are many s&p ratings for an equity but only one for an isin code. thus
i had to change the [RTG_SP] to a more precise request. i will however
benefit from your help since it seems to give good hints. thank you very much!

"Post Tenebras Lux" skrev:
Have you tried using the Bloomberg addin wizard? It will let you build your
own template. Much better to use the single cell blp or RTD option, as you
can then make the cells completely flexible afterwards.

Alternatively, you can type: IDOC API BANK <GO> and download their
templates, which will almost certainly have ratings as one of the fields.

You should also be able to use the BLPH wizard (in Excel, if youhave the blp
addin loaded) to get serial ratings.

HTH.


Arne Hegefors said:
Hello! I try to perform a very simple task using Bloomberg and Execl. I have
an Excel spreadsheet that contains a list of bank names, their ISIN codes and
their Bloomberg tickers. I then have a macro that I (am trying to) use to
extract ratings for these banks from BBL into Excel. I use a simple DDE
connection (I know it sucks but we are not allowed to use Active X due to
security reasons and I cannot use C or other languages so I am pretty much
stuck with this). Anyway my code opens a DDE link to BBL, loops through the
ISIN codes and asks BBL for the rating that is then displayed in the
spreadsheet. This works fine. However for several reasons I would like to use
the BBL tickers instead of ISIN codes. When i try to do that my code does not
work. I get Error: #/N/A Sec (I know that they are valid tickers eg BNP FP).
Please help me with this problem! I have tried using the BBL helpdesk but
even for this easy question they cannot help me!!

BBL = "BNP FP"
channelNumber = Application.DDEInitiate(app:="BLP", topic:="S")
BloomQuery = "'" BBL & " Corp, [RTG_SP]"
returnList = Application.DDERequest(channelNumber, BloomQuery)
Rating = returnList(1)
MsgBox Rating

Please I would really really need help with this! Any help appreciated!
Thank you very much in advance!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top