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
22 4 5 8

Historical Spot Prices data for corn and Soybean

I have to extract the historical spot prices for Corn and Soybean commodities. I write the code in Python API and the results are N/A values for Corn while "No data available for requested range" for Soybeans. Is there anything that I am making any mistake or any leads how could I extract this data?

Screenshots are attached for both cases.

screenshot-2021-11-12-012500.pngscreenshot-2021-11-12-012613.png


python apicommodities
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.

hi @saad.ali ,

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


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
79.3k 253 52 74

@saad.ali

Regarding MXZWX, the data is also not available via the Eikon Chart application.

1636691573110.png

Please contact the Eikon support team directly via MyRefinitiv to verify the data.

Regarding C-US2YNOLAF-C1, please try the code below.

df = ek.get_timeseries('C-US2YNOLAF-C1',
            start_date = '2011-01-01',
            end_date   = '2020-12-31',
            fields     = ['*'],
            interval   = 'monthly')

The output is:

1636691730337.png



1636691573110.png (21.5 KiB)
1636691730337.png (11.9 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.

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.