How can I pull historical spot prices for soybeans?

emily123456
emily123456 Newcomer
in Eikon Data APIs

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.

Tagged:

Best Answer

  • chavalit-jintamalit
    chavalit-jintamalit admin
    Answer ✓

    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.

    image


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

    image


    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

Answers

Categories