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!

Best Answer

  • Gurpreet
    Gurpreet admin
    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

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.