question

Upvotes
Accepted
thorsten.meyer avatar image
3 ●0 ●1 ●0

How do I get ETF details like ETF composition or base data via TRKD API?

I can find ETF using the TRKD Search API by filtering the

{"Search_Request_1": { "Collection": "SearchAll", "Filter": "AssetCategory eq 'ETF'", "ResponseProperties": "CommonName,RIC,....." }}

But the list of properties for the "Response Properties " seems not to contain base data for the ETF, such as:

  • ETF composition details
  • Fees : Total expense ratio
  • Dividend/ Taxes :
    • Distribution policy / Use of profit (accumulating / distributing)
  • Replication method ( full replication / sampling / swap-based)
  • Asset class
  • Share strategy
  • Age / Duration
  • Pension strategy
  • Segment
  • Type (active / passive / leveraged)

Is there a TRKD request (like GetGeneralInformation_1 for Company/Share) that returns these details or is there special API that has to be used for ETF?






rkd-apirkdetf
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.

2 Answers

Upvotes
Accepted
mohammad.waseem avatar image
381 ●1 ●2 ●3

Hello,

You need to use TRKD API Lipper services to retrieve these information about ETFs/MFs. Please find the details of specific Lipper services and API calls below.

Lipper Fundamentals > GetCharges_1. the field to refer is 'Total Net Expenses'.

Lipper Fundamentals > GetDividendDetails_1 or GetDistribution_1. (Dividend/ distribution info)

Lipper Overview > GetAssetDetailsAttributes_1.(Asset Type and other attributes).

Lipper Overview > GetAssetDetailsOverviewBasic_1.(Objectives, IPO details etc)

Lipper Asset Views > GetAssetHoldings_1. (Composition)

let me know if any questions.

thank you,

Waseem


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.

Upvotes
thorsten.meyer avatar image
3 ●0 ●1 ●0

Thx, your tipp was exacly i was looking for.

But one new question about the lipper search came up ...

We are searching vor ETF with "German Tax Transparency", and I didn't found any search using an attribute as filter. I found the "German Tax Transparency" in the "GetScreeningMetaData" but not a way to use it.

Can we search for ETF using the attribute "German Tax Transparency" ?

Value ID : 33323
Value Name : German Tax Transparency
Value Code : YES



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.