Rblp / Rblpapi

R package interfacing the Bloomberg API from https://www.bloomberglabs.com/api/
Other
166 stars 75 forks source link

Does this work with Bloomberg anywhere? #319

Closed CaleHarr closed 3 years ago

CaleHarr commented 3 years ago

Hi team, I'm attempting to use blpConnect in conjuction with my Bloomberg anywhere subscription. I have attempted this fix. I have the excel add-in installed per stackoverflow guidance. In addition, I am running BBcomm.exe through the command line on my windows machine, but I am still receiving the following error:

15JAN2021_16:01:46.997 15340:22144 ERROR blpapi_platformtransporttcp.cpp:671 blpapi.session.transporttcp.{2}.<localhost:8194> Connection failed 
Error in blpConnect_Impl(host, port, appName) : Failed to start session.

15JAN2021_16:01:46.997 15340:22144 WARN blpapi_platformcontroller.cpp:371 blpapi.session.platformcontroller.{2} Platform: 0 failed 1 consecutive connect attempts, stopped trying to reconnect. 

Apologies in advance if this is too similar to error #152 but I'm hoping that my just using vanilla windows means I'll be able to run the package succesfully.

wmorgan85 commented 3 years ago

Hi there. It sounds like the same issue as #152. Are you running Bloomberg Anywhere from the browser, or have you installed the terminal and Excel add-ins? That's a pre-requisite.

CaleHarr commented 3 years ago

Hi Morgan,

Thanks for the prompt response. Having spoken to my Bloomberg rep, I'm currently accessing the terminal through the disaster recovery option, although I do have the excel add in installed and said excel functionality is working fine. Does this mean I should use excel instead of the R-API? Thanks, Cale

wmorgan85 commented 3 years ago

Hey Cale

Ok so if your Excel add-in is working then everything should be fine. You shouldn't need to run BBCOMM manually, as it will run in the background when you start your Bloomberg up.

One thing that I can think of is that perhaps your BBCOMM isn't running on port 8194. There are a few anti-virus programs, Sophos being one, that use that port by default and block Bloomberg functionality.

The other thing that is worth trying is to use the API Diagnostic Tool that should be located in the Bloomberg part of your start menu. That will highlight whether the standard BBG implementation of the programmatic API is having issues connecting.

As for whether you should use Excel instead of the R-API it all depends what you want to do and how much patience you have :)

Morgan

CaleHarr commented 3 years ago

Hi Morgan,

Ok perfect thanks, I ultimately figured out how to get the data I needed using the Excel API, but appreciate you taking the time to explain. Thanks again, Cale