How to get flat price history for Geograin data

I am trying to pull flat price data from any number of Geograin RICS, but the ek.get_timeseries function only seems to pull the commodity basis, the default value. In the Eikon app, I can get the historical flat price using the Chart function by changing the field to "Last Quote", but I cannot find a way to get it using the Eikon API.

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

Hi @seb248

You can try this code:

#pip install refinitiv.dataplatform

import refinitiv.dataplatform as rdp
rdp.open_desktop_session('xxxA Valid App Keyxxx')

df = rdp.get_historical_price_summaries('WHRWDMCDMS-K', start='2020-05-01', end='2020-05-20')
df.head()

All comments

chavalit-jintamalit

Hi @seb248

You can try this code:

#pip install refinitiv.dataplatform

import refinitiv.dataplatform as rdp
rdp.open_desktop_session('xxxA Valid App Keyxxx')

df = rdp.get_historical_price_summaries('WHRWDMCDMS-K', start='2020-05-01', end='2020-05-20')
df.head()

seb248

chavalit.jintamalit Thank you, that at least pulls the data I am looking for, but it appears as if it only pulls 20 items at once? How can I pull more, like all data provided since 2001 as I was originally attempting?

chavalit-jintamalit

Hi @seb248

You can adjust the start and end parameters.

I just use 1st to 20th May 2020 to demonstrate the same data point with your screenshot only.

EXPLORE OUR SITES