Rblp/Rblpapi

Error in bdh_Impl: Attempt to access out of range index '0' on array element 'fieldData' which has 0 value(s).

Closed this issue · 2 comments

egghead168 commented

Hi,

the following code keeps getting an error. Is it because my blpapi version is not compatible? I believe I'm using blpapi 3.7.1.1.

Thanks.

library(Rblpapi)
Rblpapi version 0.3.11 using Blpapi headers 3.8.18.1 and run-time 3.8.18.1.
Please respect the Bloomberg licensing agreement and terms of service.
con <- blpConnect()
a <- bdh("IBM Equity", c("PX LAST", "VOLUME"), start.date = Sys.Date()-30)
Error in bdh_Impl(con, securities, fields, start.date, end.date, options, :
Attempt to access out of range index '0' on array element 'fieldData' which has 0 value(s).

mtkerbeR commented

I think the reason are typos in parameter securities (where an exchange ticker like "US" is missing) and a missing underscore "_" in parameter fields ("PX LAST" should be "PX_LAST"):

library(Rblpapi)
blpConnect()

# not working
bdh("IBM Equity", c("PX LAST", "VOLUME"), start.date = Sys.Date()-30)

# working - adding "US" in securities and "_" in field "PX_LAST"
bdh("IBM US Equity", c("PX_LAST", "VOLUME"), start.date = Sys.Date()-30)
  • 👍1
egghead168 commented

ah, changing "PX LAST" to "PX_LAST" worked. Thanks a lot. If you use Bloomberg API in excel, both will work fine. So I didn't realize they were treated differently here.