How to go about retrieving historical data
I have been working on the RFA C# API from Reuters, and specifically, I have been building upon the examples provided in rfanet8.0.0.L1.win.rrg/Examples/StarterConsumer, to retrieve real-time data.
How can I retrieve historical data for equity, commodity, and FX?
Is there another package that I need to install for this?
I would prefer to use Python 3.3, if there is an API available for it. Otherwise, C# is fine.
Thanks!
Best Answer
-
RFA and other TREP APIs(EMA, UPA etc) support only Time Series One(TS1) data. TS1 provides access to historical data distributed via Elektron data feed. It provides a range of facts (such as Open, High, Low, Close) for the equity, money, fixed income, commodities and energy markets. TS1 data is available in three frequencies; daily, weekly, and monthly. For daily data there is up to two years worth of history, for weekly data there is five years, and for monthly data up to ten years.
To request TS1 data using RFA.NET, you don't need to install additional package. You have to use TS1 interfaces from TS1 library(TS1_NET<VS Version>_64.dll provided in folder Libs) to parse the TS1 data. You can find more details about TS1 and RFA.NET interfaces from TS1 Reference Manual(TS1Data.pdf) and TS1 Developer Guide(TS1_DevGuideNET.pdf).
You may also try StarterConsumer_TS1 example which demonstrates how to request and parse TS1 historical data from TREP-RT. Please find the description of the example from README file locates in the same folder.
Regarding to API for python. Currently we don't have TREP API which support python.
0
Answers
-
TS1 and TAS are end-of-life as of 30th June, 2016 -- DN082484
0 -
Judging that you are on the desktop using C# I would suggest asking for access to the Eikon Scripting APIs (EAP) - that include Python access to historical data.
For immediate production use one has to look at DataScope Select or Tick History as a web service for accessing historical data, these are marketed under the Elektron Data Solutions umbrella.
Longer term but not available on early-access so far is Elektron Time Series, this will be available through the Elektron SDK and RFA APIs.
0 -
From what I know, the Elektron Feed Product Manager has cancelled the DNDN082484 as they have postponed
the IDN TAS/TS1 sunset. The plans to launch an
Elektron Time Series service for API consumers are on hold and they don't have committed timescales.1 -
Also check out PyRFA which has support for TS1 data as well: http://devcartel.com/blog/13910454
0 -
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 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
- 367 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
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛