For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
7 1 0 1

python ek.get_timeseries: get historic settlement prices

When using the python package eikon, you can easily access OTC data (High, Close, low Open) for a given power future, e.g. TRDEBMc1 (TRPC Electricity Germany Baseload Monthly Continuation 1)

df = ek.get_timeseries('TRDEBMc1')

I would like to access settlement prices for futures and there is a way for single days described in this discussion

https://community.developers.refinitiv.com/answers/43498/view.html

df, b = ek.get_data('TRDEBMc1', 'TR.SETTLEMENTPRICE', parameters = {"SDate":"2019-05-30"})

But how can I easily access historic settlement prices for longer intervals similar to ek.get_timesieries?

eikoneikon-data-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikonfuturessettlement
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
12.1k 59 39 61

Hi @arndf,

Try this:

You can try different frequencies such as: 'W' - weekly, 'Q' - quarterly, 'Y' - yearly, etc.


ahs.png (17.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi @nick.zincone.1,

Very nice, this is exactly what I was looking for. Thanks for your help!

Arnd

Upvotes
18k 21 12 20

Hi @arndf,

You can use get_data() as Nick's comment.

Or you can use get_timeseries() as below example.

Full document and example is here.


ahs.png (44.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi @chevalit.jintamalit,

I'd be nice to access all price data (including settlement prices) through get_timeseries() but just OTC-data is returned for some reason. Another column could be easily added. In the screenshot you can see that closing and settlement prices are two different things. The request using get_data() works nicely though.