New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
arndf avatar image
7 ●2 ●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-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apifuturessettlement
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.

2 Answers

· Write an Answer
Upvotes
Accepted
nick.zincone avatar image
19.2k ●86 ●39 ●63

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.

arndf avatar image arndf

Hi @nick.zincone.1,

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

Arnd

Upvotes
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

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.

arndf avatar image arndf

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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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