R eikonapir: returns data.frame with NA only

peter.oehlinger

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!

Gurpreet

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.