eikon python data api timeseries

newuser
newuser
in Eikon Data APIs 
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)
Tagged:

Best Answer

  • marcin.bunkowski
    marcin.bunkowski
    Answer ✓

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

Answers

Categories