Historical Spot Prices data for corn and Soybean

saad.ali
saad.ali
in Eikon Data APIs

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


Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

    @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


Categories