R eikonapir: returns data.frame with NA only
Hi,
I am using R eikonapir to download data. I can access the data using Excel so I am convinced that the chosen fields and rics are correct. However, get_timeseries() returns a data.frame with NA's only. This is my code:
get_timeseries( rics = list( "EURCHF1YP=" ),
fields = list( "FCAST_MED.Timestamp",
"FCAST_MED.Value" ),
start_date = "2018-03-01T14:00:00",
end_date = "2021-06-30T15:00:00",
interval = "quarterly" )
And this the result:
FCAST_MED.Timestamp FCAST_MED.Value NA 1 NA NA EURCHF1YP= 2 NA NA EURCHF1YP= 3 NA NA EURCHF1YP= 4 NA NA EURCHF1YP= 5 NA NA EURCHF1YP= 6 NA NA EURCHF1YP= 7 NA NA EURCHF1YP= 8 NA NA EURCHF1YP= 9 NA NA EURCHF1YP= 10 NA NA EURCHF1YP= 11 NA NA EURCHF1YP= 12 NA NA EURCHF1YP=
When I use list( "*" ) for the fields argument, the function returns values.
Any help would be highly appreciated!
Hi @Peter Oehlinger, The timeseries API call only returns the bar data, i.e. Open/High/Low/Close etc or in case of this RIC, the "forecast value". It can not provide other fields like FCAST_MED. Actually, I am not even able to find FCAST_MED - this does not seem to be a valid field.
You can use Data Item Browser in Eikon to look to fields, and use the get_data API call to get timeseries information for fields which have series option available.
Hi @Gurpreet, thank you for your quick response!
That's unfortunate. I thought get_timeseries() is similar to the Excel-Function =RHistory() (as explained here). But now I understand what was meant by "only default view is accessible from this API".
Regarding FCAST_MED: in the Excel Formula Builder it is a valid field (see screenshot).
