question

Upvotes
Accepted
justin.boudreau avatar image
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
eikon-index-constituents.png (189.9 KiB)
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

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 5.0 MiB each and 10.0 MiB total.

justin.boudreau avatar image justin.boudreau

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)
custom-index-excel.png (162.5 KiB)
Alex Putkov.1 avatar image Alex Putkov.1 justin.boudreau

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

Click below to post an Idea Post Idea