Can the Python API extract weather and "flows" historical data?

pnacht
pnacht
in Eikon Data APIs

I'm new to Eikon and exploring the Python API. Through this, I've managed to pull timeseries information on commodities and futures prices. However, for agricultural commodities, Eikon also has flow and weather data, which I haven't yet managed to extract via the API.

I've seen this question on how to extract current weather data for Europe, but haven't figured out how to replicate it for other countries/continents, nor does that method seem capable of extracting weather timeseries.

As for flow data, I've seen a few other questions which state that information (along with everything else PointCarbon) isn't available via the API, but they are all from 2018, so would like a confirmation that is still the case 3 years later.

Tagged:

Best Answer

  • raksina.samasiri
    raksina.samasiri admin
    Answer ✓

    Hello again @pnacht,

    I've got an update regarding case 10565205 that the historical weather data is not available in Eikon Data APIs.

    According to this question you mentioned, RIC EU/WEATHER can be used to get the 7-days of weather data (starting today) of countries in Europe. As I check with the team, this data is only available for the EU currently.

    For more detail on how to get each country's data, first, you can access RIC EU/WEATHER in Quote app

    1634033826340.pngfrom there, you may click on <EU/WEATHER3> or <EU/WEATHER4> which is redirected you to the "Forecast data by country" list

    1634033961419.png

    Let me continue in the thread as only 2 screenshots are allowed in one comment

Answers

  • raksina.samasiri
    raksina.samasiri admin

    hi @pnacht ,

    Case number 10565205 was raised to answer the weather question, the support team will reach out to you to update the solution. In case they provide you an Eikon Excel formula and you need help to convert it to Python code for Eikon Data APIs, we're happy to help you.

    About the flow data, I found the update last year in this thread mentioned that

    This dataset is not currently available through Eikon APIs. At the moment the only way to access this data programmatically is through Refinitiv Point Connect. If you need more details, please contact your Refinitiv account manager or click "Request details" button on the page following the link above.

  • raksina.samasiri
    raksina.samasiri admin

    Let say that you want to get the data of France, click on the RIC "<0#FR-FORECASTS>"
    1634034116624.png

    The list of Cities in that country will be shown with the day of forecast (Day 1 is today) so to get tomorrow's weather forecast of Paris, click on 0#PARIS-D2, you'll see the Quote app as a screenshot below. Here you need to narrow down the hour from the available options (the 2 digits after PARIS-D2-)

    1634034185734.png

    To know which field should be used when calling eikon's get_data(), hover on the field you'd like to get and the field name will be shown


    Hope this could help, please tell me in case you have any further questions

Categories