Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
newuser avatar image
97 ●10 ●12 ●13

eikon python data api timeseries

The following code doesn't work although it returns data (5 rows) in excel

=TR($H$3,"TR.SharesUnclassified","SDate=2015-10-31 EDate=2019-03-12 CH=Fd RH=IN;date")


Could you tell me how I can get this data through python data api?

--------------
import eikon as ek;
import pandas as pd;

columns = ['TR.SharesUnclassified'];<br><br>df = ek.get_timeseries(["MSFT.OQ"], start_date="2018-02-28", end_date="2019-03-10", fields=columns)
eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apitime-series
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
marcin.bunkowski avatar image
3.8k ●4 ●4 ●6

Hi @dong.han

You can do it with the formula below.

You can also check this tutorial that can help you in converting Eikon Excel syntax to a Python query.

ek.get_data('MSFT.OQ', ['TR.SharesUnclassified.date','TR.SharesUnclassified'], parameters={'SDate':'2015-10-31', 'EDate':'2019-03-12'})
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
newuser avatar image
97 ●10 ●12 ●13

Thank you. That solved my issue.

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.

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.