Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

avatar image
Question by peter.oehlinger · Jan 13, 2021 at 01:42 PM · eikoneikon-data-apiworkspacepythonworkspace-data-apirefinitiv-dataplatform-eikonreikon-data-api-r

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!

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Gurpreet · Jan 13, 2021 at 03:17 PM

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)
Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
peter.oehlinger · Jan 13, 2021 at 03:37 PM 0
Share

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)

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
11 People are following this question.

Related Questions

Eikon R API install error

Eikon API timeseries time field in start and end date string

Error when accessing Eikon data via API using R

Bloomberg R user switching to Eikon/eikonapir - sample R scripts/field mappings

How to find the appropriate fields for US1YT=RR ?

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges