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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

saad.ali avatar image
22 1 0 6

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
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

Jirapongse avatar image
45.2k 103 43 60

@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)
10 |1500

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