eikon python data api timeseries

newuser

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)

m.bunkowski

Hi @newuser

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'})