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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

How to change price unit when download data

Hi,

I want to know how to change price unit when download data.For example,when downloading Dutch TTF gas futures data,the original data is denoted by EUR/GWH.How can I change the price unit to USD/MMBTU when using ek.get_timeseries?

thank you

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
18k 21 12 20

Hi @lianye

There are 2 conversions in your question:

1. convert EUR to USD currency

get_timeseries does not support currency parameters.


2. convert GWh to MMBtu

This is a static conversion, it can be done in your code.

https://www.unitconverters.net/power/gigawatt-to-mbtu-it-hour.htm


So the answer is no, it is not possible to convert the unit in get_timeseries (because of the currency)

Since you did not include any instrument, I think you may try using get_data

For example, I can get the price of equity in 2 different currencies.

You may try the same on the Dutch TTF Gas future instrument.



ahs.png (16.4 KiB)
ahs2.png (40.2 KiB)
icon clock
10 |1500

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

Click below to post an Idea Post Idea