For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
emily123456 avatar image
1 ●0 ●0 ●1

How can I pull historical spot prices for soybeans?

I am trying to get historical spot prices for soybeans using this code in R:

get_timeseries(list("0#SOYBWCAADR:"),
         list("*"),
         "2020-01-01T15:04:05",
         "2020-01-10T15:04:05")

I cannot get it to work, and I also can't seem to find the historical prices anywhere in the desktop terminal either. I know my API key is set up properly because I can pull historical data from "MSFT.O" by doing.

get_timeseries(list("MSFT.O:"),
         list("*"),
         "2020-01-01T15:04:05",
         "2020-01-10T15:04:05")

Thanks.

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiapipricingr
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
chavalit-jintamalit avatar image
18.1k ●21 ●13 ●21

Hi @emily123456

Your API call is not correct, please refer to the document at https://docs-developers.refinitiv.com/1583434790598/14684/book/en/eikon/index.html#get_timeseries


For MSFT.O, the call should be:

df = ek.get_timeseries("MSFT.O",
                       fields='*',
                       start_date = "2020-01-01T15:04:05",
                       end_date = "2020-01-10T15:04:05")
print(df)


For 0#SOYBWCAADR: , this is a chain RIC, so you should expand it to get a full RIC list first.

Then use the RIC list in the get_timeseries API call.

df,e = ek.get_data('0#SOYBWCAADR:','DSPLY_NAME')
ric_list = df['Instrument'].tolist()

df2 = ek.get_timeseries(ric_list,
                        fields='*',
                       start_date = "2020-01-01T15:04:05",
                       end_date = "2020-01-10T15:04:05")
df2

Eikon Data API(Python) only allows you to access to "default" view of the data.

So it is not possible to retrieve the data from other views.


Here is the data retrieved from Eikon Excel (Using "LAST_QUOTE" view)


If you need to retrieve data from "LAST_QUOTE" view, I suggest you to use Eikon Data API .NET

Please see document at https://developers.refinitiv.com/eikon-apis/net-apis-use-custom-applications/learning?content=8724&type=learning_material_item


ahs.png (56.9 KiB)
ahs1.png (30.6 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

chavalit-jintamalit avatar image chavalit-jintamalit

Here is the sample code for Eikon Data API .NET

ahs1.png (99.8 KiB)