Extracting Historic Timeseries Data for 0#SOY: | Johannesburg Stock Exchange Soybean Commodity Futur
I'm trying to use the Eikon API for R to extract the historic timeseries data for:
0#SOY: | Johannesburg Stock Exchange Soybean Commodity Future Chain | Johannesburg Stock Exchange | South Africa | ZAR
I'm not having any luck. I'm using the get_timeseries() function.
First off, I'm not sure if I'm using the correct naming for the RIC. I think the problem is that this commodity has contract for March, May, July, September and November.
Everything I've tried doesn't seem to work.
Can anyone assist me on this please?
Best Answer
-
Here's an example using eikonapir package
library(eikonapir)
set_app_key('USE_YOUR_APP_KEY_HERE')
instr_df <- get_data('0#SOY:','DSPLY_NAME')
df <- get_timeseries(instr_df[['Instrument']], start_date='2021-01-01T00:00:00', end_date='2021-07-19T00:00:00')
df1
Answers
-
Thank you. I was able to retrieve the information for the active instruments, but these instruments only show the data for when their contract year starting, and the previous contract year instruments also only hold data from one year back, therefore all the historical data until one year back is missing.
I see the seasonality chart for 0#SOY: has all the available historical data from 2014. Is there some way to retrieve these specific data?
0 -
The seasonality chart allows you to pick a contract month (e.g. September) and stack price history plot for a number of futures with this expiry month from prior years over the X axis that is stripped of the year info. This is done using expired future RICs, e.g. SOYU9^1 for Sep 2019 contract, which you can use in get_timeseries method. Note that the date range you request must overlap with the price history available for the RIC. Depending on what you're looking to achieve, you may also or instead want to look at continuation RICs, e.g. SOYc1, SOYc2 etc, which refer to the nearest, second nearest etc contract. When the nearest future expires SOYc1 automatically rolls over to the second nearest contract (which at that point becomes the nearest). Continuous RICs for futures provide price history going back as far as we have price history for future series as opposed to for the lifetime of a specific contract. If you're not familiar with the concept of continuous futures, take a look at this article .
1 -
Thank you very much. I'm relative new with working with the Eikon API and with these types of data and I appreciate your quick help.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 中文论坛