Upgrade from Eikon -> Workspace. Learn about programming differences.

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.

wasin.w avatar image   wasin.w

Hello @emily123456

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.

Thanks,


AHS


pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
chavalit-jintamalit avatar image
18.2k ●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)

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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