Portfolio Holdings as of a specific date in Eikon through python

Question

Question by dbishnoi · Jan 17, 2020 at 07:13 PM · python eikon portfolio

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?

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2020-01-21T08:54:46Z

REFINITIV

Best Answer

Answer by jirapongse.phuriphanvichai · Jan 21, 2020 at 08:54 AM

@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.

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Erik77 · Sep 09, 2020 at 07:44 AM 0

Share

Hi @dbishnoi, did you get a reply from the Eikon Excel support team?

Portfolio Holdings as of a specific date in Eikon through python

1 Reply

Watch this question

Related Questions