Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel + BBL
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel + BBL
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" wrote: 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!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel + BBL
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" wrote: 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|