For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
peter.oehlinger avatar image
3 ●0 ●1 ●1

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!

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apireikon-data-api-r
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
Gurpreet avatar image
16.7k ●43 ●12 ●19

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.


1610550994295.png (41.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

peter.oehlinger avatar image 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).


excel-fomula-builder.png (97.6 KiB)