If you are running an investment platform or looking to build one, an extensive ETF holdings API is probably one of the first things you would need to look out for. As ETFs are very popular investment options, ETF data is definitely something that you should have on your investment platform. This is because investors will naturally want to keep track of the ETFs they have invested in, when to sell them and analyze which ones to invest in next.
For this exact reason, we want to introduce you to Tradefeed's ETF Holdings API which is a one-in-all API when it comes to ETF holdings data!
ETF Holdings Data – ETF Compositions and Flow
Investment platforms can use the Tradefeeds ETF Holdings API to add features where their clients track compositions and the flow of the ETFs they have invested in, or are interested in.
This is possible by using the “/etf_holdings?” endpoint of the API which provides data about the holdings in an ETF, and therefore its current composition. This ETF holdings data is available both historically and in real-time as the ETF eliminates assets and new ones enter into it.
To visualize the ETF composition data better, let’s take a look at the holding data of SPDR S&P 500 ETF TRUST which is a client favorite.
https://data.tradefeeds.com/api/v1/etf_holdings?key=apikey&seriesLei=549300NZAMSJ8FXPQQ63
{
"status": {
"code": 200,
"message": "OK",
"details": ""
},
"result": {
"basics": {
"regName": "SPDR S&P 500 ETF TRUST",
"regFileNumber": "811-06125",
"regCik": "0000884394",
"regLei": "549300NZAMSJ8FXPQQ63"
},
"output": [
{
"attributes": {
"seriesName": "N/A",
"seriesId": null,
"seriesLei": "549300NZAMSJ8FXPQQ63",
"repPdDate": "2023-03-31",
"repPdEnd": "2023-09-30",
"isFinalFiling": 0
},
"signature": {
"dateSigned": "2023-04-28",
"nameOfApplicant": "SPDR S&P 500 ETF TRUST",
"signature": "Arthur Jensen",
"signerName": "Arthur Jensen",
"title": "Deputy Treasurer"
},
"invstOrSecs": [
{
"invstOrSec": {
"name": "Honeywell International Inc",
"lei": "ISRPG12PN4EIEOEMW547",
"isin": "US4385161066",
"cusip": "438516106",
"balance": "7289042.00000000",
"units": "NS",
"curCd": "USD",
"valUSD": "1393081707.04000000",
"pctVal": "0.371659064779",
"payoffProfile": "Long",
"assetCat": "EC",
"issuerCat": "CORP",
"invCountry": "US",
"isRestrictedSec": "N",
"fairValLevel": "1",
"isCashCollateral": "N",
"isNonCashCollateral": "N",
"isLoanByFund": "N"
}
},
{
"invstOrSec": {
"name": "Discover Financial Services",
"lei": "Z1YLO2USPORE63VVUL20",
"isin": "US2547091080",
"cusip": "254709108",
"balance": "2912782.00000000",
"units": "NS",
"curCd": "USD",
"valUSD": "287899372.88000000",
"pctVal": "0.076808424900",
"payoffProfile": "Long",
"assetCat": "EC",
"issuerCat": "CORP",
"invCountry": "US",
"isRestrictedSec": "N",
"fairValLevel": "1",
"isCashCollateral": "N",
"isNonCashCollateral": "N",
"isLoanByFund": "N"
}
},
{
"invstOrSec": {
"name": "FMC Corp",
"lei": "CKDHZ2X64EEBQCSP7013",
"isin": "US3024913036",
"cusip": "302491303",
"balance": "1367253.00000000",
"units": "NS",
"curCd": "USD",
"valUSD": "166982608.89000000",
"pctVal": "0.044549145926",
"payoffProfile": "Long",
"assetCat": "EC",
"issuerCat": "CORP",
"invCountry": "US",
"isRestrictedSec": "N",
"fairValLevel": "1",
"isCashCollateral": "N",
"isNonCashCollateral": "N",
"isLoanByFund": "N"
}
},
{
"invstOrSec": {
"name": "EQT Corp",
"lei": "4NT01YGM4X7ZX86ISY52",
"isin": "US26884L1098",
"cusip": "26884L109",
"balance": "3961434.00000000",
"units": "NS",
"curCd": "USD",
"valUSD": "126409358.94000000",
"pctVal": "0.033724643634",
"payoffProfile": "Long",
"assetCat": "EC",
"issuerCat": "CORP",
"invCountry": "US",
"isRestrictedSec": "N",
"fairValLevel": "1",
"isCashCollateral": "N",
"isNonCashCollateral": "N",
"isLoanByFund": "N"
}
},
{
"invstOrSec": {
"name": "Nordson Corp",
"lei": "14OS6Q5N55N95WM84M53",
"isin": "US6556631025",
"cusip": "655663102",
"balance": "585560.00000000",
"units": "NS",
"curCd": "USD",
"valUSD": "130146565.60000000",
"pctVal": "0.034721689769",
"payoffProfile": "Long",
"assetCat": "EC",
"issuerCat": "CORP",
"invCountry": "US",
"isRestrictedSec": "N",
"fairValLevel": "1",
"isCashCollateral": "N",
"isNonCashCollateral": "N",
"isLoanByFund": "N"
}
},
{
"invstOrSec": {
"name": "Charles River Laboratories International Inc",
"lei": "549300BSQ0R4UZ5KX287",
"isin": "US1598641074",
"cusip": "159864107",
"balance": "555021.00000000",
"units": "NS",
"curCd": "USD",
"valUSD": "112014338.22000000",
"pctVal": "0.029884208495",
"payoffProfile": "Long",
"assetCat": "EC",
"issuerCat": "CORP",
"invCountry": "US",
"isRestrictedSec": "N",
"fairValLevel": "1",
"isCashCollateral": "N",
"isNonCashCollateral": "N",
"isLoanByFund": "N"
}
},
{
"invstOrSec": {
"name": "EPAM Systems Inc",
"lei": "549300XCR4R530HJP604",
"isin": "US29414B1044",
"cusip": "29414B104",
"balance": "622685.00000000",
"units": "NS",
"curCd": "USD",
"valUSD": "186182815.00000000",
"pctVal": "0.049671552322",
"payoffProfile": "Long",
"assetCat": "EC",
"issuerCat": "CORP",
"invCountry": "US",
"isRestrictedSec": "N",
"fairValLevel": "1",
"isCashCollateral": "N",
"isNonCashCollateral": "N",
"isLoanByFund": "N"
}
},
...
}
]
Tip: As you keep track of an ETF’s constituents data regularly, you can display the flow of the ETFs and how assets move in and out of an ETF.
Explaining the ETF Holdings API Values
Below, we will describe the values you see for each asset in the ETF holdings API output. These are all essential values for analyzing an ETF and have a data-driven understanding of whether it is worth investing in.
| Field | Description |
|---|---|
| name | The name of the asset in the ETF. |
| lei | LEI of the asset. |
| isin | ISIN of the asset. |
| cusip | CUSIP number of the asset. |
| balance | The balance or quantity of the asset in the ETF. |
| units | The unit of measurement for the balance ("number of shares" in the example). |
| curCd | The currency code of the asset. |
| valUSD | The value of the asset in USD. |
| pctVal | The percentage value of the asset within the ETF's total portfolio value. |
| payoffProfile | The payoff profile of the asset. |
| assetCat | Categorization of the asset. |
| issuerCat | Categorization of the issuer of the asset. |
| invCountry | The country of the asset. |
| isRestrictedSec | Indicates whether the asset is a restricted security. |
| fairValLevel | Represents the level of fair valuation applied to the asset. |
| isCashCollateral | Indicates whether the asset is used as cash collateral. |
| isNonCashCollateral | Indicates whether the asset is used as non-cash collateral. |
| isLoanByFund | Indicates whether the asset is borrowed by the fund. |
Good tip: The historical availability of our ETF constituent data also allows seeing the changes in an ETF within the timeline you request. Since ETFs are easily liquidated and allow short-term buying and selling, historical ETF data can work wonders with calculating an ETF’s risk level and performance. We did not pick the title “smart investment platforms” for nothing 😉
Accessing the ETF Constituents API Easily
To sum things up, this ETF Constituents API basically provides general ETF data, ETF constituents data and ETF periodical returns data for publicly traded ETFs. If you have any requirements about ETF data that you’re unsure whether we have or not, contact our team and let’s talk about it!
To easily get an API key for the ETF constituents data and build smart investment platforms, click below!
Top comments (0)