question

Upvotes
Accepted
1 0 0 2

Extract index constituents and weights through COM API

I would like to extract the list of index constituents and weights through the COM API. Is this possible, and can you provide a sample?eikon-index-constituents.png

eikoneikon-com-apiindex
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
56k 145 45 65

If you uses COM APIs for use in custom applications, you can use DEX2 to retrieve this information. The example is in Fundamental and Reference Data example.

Asset Class : .STOXX50

Fields List: TR.IndexConstituentName;TR.IndexConstituentWeightPercent

The result is:

If you use a different API, please provide me a link to that API.


dex2.png (54.9 KiB)
icon clock
10 |1500

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

Thank you, this is helpful.

Is it possible to extract similar data for a custom index/portfolio that I have created in the PORT tool?

The formula builder found my index, but the TR.IndexConstituent fields return null.

custom-index.png (83.2 KiB)

You can use field names from the Portfolio category in the Formula Builder, e.g. TR.PortfolioConstituentName, TR.PortfolioShares, TR.PortfolioWeight.