How to extract index or portfolio constituents and weights through Workspace DAPI

Hello,

I am familiar with how to request index or portfolio weights and constituents from Eikon COM API

My question is about how to do this with Workspace DAPI (through the Refinitiv Data Libraries). What RDP API would be providing this data and is it currently released?

Ultimately I would like to make Workspace DAPI requests to retrieve constituent data - for either Index or Portfolio:

TR.PortfolioWeight

TR.PortfolioConstituentName

TR.PortfolioShares

For a specified index (eg .STOXX50) or a portfolio in PORT

Related cases:

https://community.developers.refinitiv.com/questions/28188/extract-index-constituents-and-weights-through-com.html

https://community.developers.refinitiv.com/questions/54209/download-portfolio-and-benchmark-data-in-eikon-usi.html

Best Answer

  • @Nick.Straatsma

    Thanks for reaching out to us.

    You can use the Refinitiv Data Library to retrieve those data.

    For a portfolio, the code looks like this:

    rd.get_data(['PORTFOLIO("wwwww")'],
                ['TR.PortfolioWeight','TR.PortfolioConstituentName','TR.PortfolioShares'])

    The output is:

    1673401470724.png

    For an index, the code looks like this:

    rd.get_data(['0#.STOXX50'],
                ['TR.IndexConstituentName','TR.IndexConstituentWeightPercent'])      

    The output is:

    1673401556805.png

    I hope this will help.