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 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
Jirapongse avatar image
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.

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.