R eikonapir: returns data.frame with NA only

peter.oehlinger
peter.oehlinger
in Eikon Data APIs

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!

Tagged:

Best Answer

  • Gurpreet
    Gurpreet
    Answer ✓

    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.

    image

Answers

  • peter.oehlinger
    peter.oehlinger

    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).image


Categories