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?
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') df