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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
dbishnoi avatar image
36 ●0 ●0 ●1

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?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonportfolio
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
Jirapongse avatar image
38.1k ●71 ●35 ●53

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Erik77 avatar image Erik77
Hi @dbishnoi, did you get a reply from the Eikon Excel support team?
Click below to post an Idea Post Idea