Excel + BBL

[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!!

 

[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.

 

[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.

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!!