Portfolio Holdings as of a specific date in Eikon through python

I'm trying to pull the holdings and shares of a portfolio I've uploaded into Eikon, in Python.


My code is :

ek.get_data(instruments=['Portfolio(xxxx)'],fields=['TR.PortfolioStatementDate','TR.PortfolioName','TR.PortfolioConstituentName', 'TR.PortfolioShares'],parameters={'SDate':'20200115','EDate':'20200115'})

I still only get back the latest shares, how can i pull on a specific day, and also over a range, daily?

Best Answer

  • @dbishnoi

    I have tested it with Eikon Excel and found that it only returns the latest shares.

    Therefore, you need to contact the Eikon Excel support team via my.refinitiv.com and ask for the TR formula used to pull the shares on a specific day.

    Then, if the formula is available, we can apply it to the get_data method.

Answers