Extract index constituents and weights through COM API

Question

Question by justin.boudreau · Jun 04, 2018 at 05:16 PM · eikon com index constituents

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

eikon-index-constituents.png (189.9 KiB)

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2018-06-05T04:01:10Z

REFINITIV

Best Answer

Answer by jirapongse.phuriphanvichai · Jun 05, 2018 at 04:01 AM

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)

0 Show 2 · Share

10 |1500 characters needed characters left characters exceeded

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

justin.boudreau · Jun 05, 2018 at 04:10 PM 0

Share

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)

REFINITIV

Alex Putkov. ♦♦ justin.boudreau · Jun 05, 2018 at 05:25 PM 0

Share

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

Extract index constituents and weights through COM API

1 Reply

Watch this question

Related Questions