How can I download historical Brent and WTI contract.

I am looking to download historical Brent contracts. For example, on the Reuters terminal or on the Excel API, if I am looking for the Brent contract expiring in December 2012, I am able to download prices by using the RIC code "LCOZ2^1".

However, on the Eikon API for Python, when I type:

bre = ek.get_timeseries('LCOZ2ˆ1', start_date = dt.datetime(2007,1,1))

I get:

EikonError: 'Error code Error | LCOZ2ˆ1: Invalid RIC |  '

Is it normal? How can I access the historical data for this contract through the API?

Find more posts tagged with

python

eikon

api

commodities

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Alex Putkov.1

I have no problem on my end executing get_timeseries method with parameters you specified. I could not however copy & paste the RIC from your request to mine. The encoding of the caret symbol appears to be wrong. Try executing the same request again, but make sure to type in the RIC from keyboard as opposed to copy & paste it.

All comments

Alex Putkov.1

a.mahoudi

Hi Axel,

I have trying to type the RIC using my keyboard or by copy-pasting it. It doesn't work. I use the ^ symbol which is on the 6 key on a QWERTY board but this do not change anything.

Alex Putkov.1

I'm curious if converting the RIC input to a list will make a difference. Could you try
ek.get_timeseries(['LCOZ2^1'], start_date = dt.datetime(2007,1,1))?

If you still get the same error, please add debug=True parameter to the request and share the full response including the traceback of the error.
ek.get_timeseries(['LCOZ2^1'], start_date = dt.datetime(2007,1,1), debug=True)

a.mahoudi

Hi Axel,

Thank you very much, the first solution works and I get the data when I convert it to a list.

EXPLORE OUR SITES