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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
97 5 9 11

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-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikontime-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.

Upvotes
Accepted
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
97 5 9 11

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.