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.
Best Answer
-
@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.
0
Answers
-
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')
dataYou 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.
0 -
Thanks Jason. Point Connect doesn't have this data unfortunately so it seems it's inaccessible.
0 -
Thanks Jason, what is the call for this Tick History function on TRDEBFVDc1 ?
0 -
@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.
0 -
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.
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 162 App Studio
- 4 Block Chain
- 5 Bot Platform
- 17 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 370 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛