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 /
avatar image
Question by clangevin · Dec 07, 2020 at 12:45 PM · eikon python apiget_timeseries

How can I retrieve all the Hourly data in RIC Future Continuation Expiry TRDEBFVDc1

I would like to retrieve all the 24 hours data point in RIC Future Continuation Expiry TRDEBFVDc1 using the Eikon Data Python API.

I have tried:

start_str = '2020-12-07T00:00:00'
end_str = '2020-12-08T00:00:00'
data = ek.get_timeseries(RIC,
                start_date = start_str,
                end_date   = end_str,
                fields     = ['CLOSE'])

but only get one value back instead of the 24 hours data points in that RIC.

Could you please give me the correct call to retrieve all the 24 hours values in RIC TRDEBFVDc1 ?

Thank you.

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.

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jason.ramchandani · Dec 07, 2020 at 04:03 PM

@clangevin the only product I can think of that would provide a history of those fields is Tick History - which records all fields and all changes for pretty much everything we have OTC and exchange traded. All of these fields will be available at what ever timesnap you wanted from ticks to 1min bars or hourly etc bar resolution. You can speak to your account rep to get you a quote for a cut of that data or you may already have access to that product. You want to mention all of those fields from the quote monitor Hour1...Hour24. I hope this can help.

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
clangevin · Dec 07, 2020 at 04:05 PM 0
Share

Thanks Jason, what is the call for this Tick History function on TRDEBFVDc1 ?

avatar image
REFINITIV
Answer by jason.ramchandani · Dec 07, 2020 at 03:22 PM

Hi @clangevin - I am able to get some data through using the following but it does not seem complete - really this is a curve of 24 hourly points which I can see in the quote app:

Now the issue with this data is that it is not presented in our normal data model format. This means it is not accessible by the Eikon Data API. The call below does work - but I'm not sure what hour the return is from. If we look at the data model above by hovering over the fields - we can see that Hour1 is BEST_BID1, Hour2 is BEST_BID2 and so forth until Hour24 which is GEN_VAL4 - this is a problem. The timeseries API has a reduced datamodel so these FIDs would not be available at all - the new RDP datamodel does not contain these illogical FID fields either. These fields are available from a streaming API subscription to that RIC and then selecting all the Hour1...Hour24 FIDs - but that would not be a timeseries history just streaming realtime.

start_str = '2020-12-02T00:00:00'
end_str = '2020-12-08T00:00:00'
data = ek.get_timeseries('TRDEBFVDc1',
                start_date = start_str,
                end_date   = end_str,
                fields     = ['CLOSE'], interval ='hour')

data

You could perhaps get a timeseries history of this data from Point Connect which I think you also have access to. I hope this can help.


1607353771289.png (104.0 KiB)
1607352229823.png (49.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
clangevin · Dec 07, 2020 at 03:46 PM 0
Share

Thanks Jason. Point Connect doesn't have this data unfortunately so it seems it's inaccessible.

avatar image
REFINITIV
Answer by jason.ramchandani · Dec 07, 2020 at 04:28 PM

@clangevin Tick History has a REST API which you can use to make what are called on-demand extractions or if you wanted you could also schedule extractions (for on-going daily updates). There are a full set of tutorials using the REST API for an on-demand extraction. I believe Tutorial 3 and 6 should have you covered for that. In particular Tutorial 6 has a JSON request/response example for Intraday bars at an hourly resolution which I think you might find useful as a starting point. Just change the instrument and add the FIDs from the quote example. ie BEST_BID1 etc.

I hope this can help.

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
clangevin · Dec 15, 2020 at 08:26 AM 0
Share

Thanks Jason, very useful. I won't have time to look at another data feed for now unfortunately but will keep that solution in mind for the future.

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

Error with get_timeseries

How to pass a list of RICs through get_timeseries?

The truth value of a DataFrame is ambiguous.

NAICS industry with TR.BGS.BusExternalRevenue

Eikon Python API 403 response

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • 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
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • 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
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges