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

thorsten.meyer
thorsten.meyer
in TRKD

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?






Tagged:

Best Answer

  • mohammad.waseem
    mohammad.waseem
    Answer ✓

    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


Answers

  • thorsten.meyer
    thorsten.meyer

    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



Categories