ETF Holdings API
Receive an API key immediately and have access to the ETF Holdings data right away.
ETF Holdings API - Features
Through the ETF Holdings API, you are offered a complete set of exchange-traded funds data based on the unique identifier code of an ETF. Alternatively, you can also request stocks by their ticker symbol and see all ETFs that hold this specific stock in it. Each set of ETF performance data in an API response provides information about the ETF requested and which stocks it holds. This includes the total owned shares, the percentage of the stocks in the portfolio, the indicators of the stock and more.
ETF Fundamentals
Finnworlds ETF fundamentals data includes key identifiers (CIK, ISIN, LEI, ticker), net assets, total assets and liabilities, which are useful for understanding the ETF’s structure and financial standing. Additionally, metrics like expense ratio, holdings breakdown, weights, and more allow a complete fundamental analysis.
Data on Which Securities an ETF Holds
Find out which stocks and other securities an ETF holds, get data about the entire portfolio of an ETF through the ETF analysis API system.
Historical and Real-time Data on ETF Holdings
The ETF holdings database includes historical and current stock and security holdings of an ETF and gets updated as the portfolio of the ETFs changes.
ETF Periodic Returns
The API also provides ETF periodic returns data, allowing the calculation of performance metrics of the ETF’s investment returns, including realized and unrealized gains.
Code Examples for the ETF Holdings API
Code Examples for the ETF Holdings API
Endpoints:
GET /etfinfo – Basic information about the ETF
GET /etfreturns – Returns or periodical returns of the ETF
GET /etfholdings – Holdings of the ETF at any point in time
https://api.finnworlds.com/api/v1/etfinfo
?key=API-KEY
&cik=1137095
{
"status": {
"code": 200,
"message": "OK",
"details": ""
},
"result": {
"basics": {
"fund_name": "USA Mutuals",
"file_number": "811-10319",
"cik": "0001137095",
"reg_lei": "549300IJ0KFT977YGX93"
},
"output": [
{
"general": {
"fund_name": "USA Mutuals",
"cik": "0001137095",
"reg_lei": "549300IJ0KFT977YGX93",
"country": "US",
"state": "US-TX",
"city": "Dallas",
"zip": "75201",
"street": "700 N. Pearl Street",
"phone": "866-264-8783"
},
"attributes": {
"series_name": "USA Mutuals Vitium Global Fund",
"series_id": "S000005505",
"series_lei": "549300GX5CPIZQ5PDX31",
"date_report_period": "2020-12-31",
"end_report_period": "2021-03-31",
"final_filing": 1
},
"fund_info": {
"total_assets": "111438858.600000000000",
"total_liabilities": "1741129.050000000000",
"net_assets": "109697729.550000000000",
"assets_attr_misc_sec": "0.000000000000",
"invested_assets": "0.000000000000",
"one_yr_banks_borr": "591000.000000000000",
"one_yr_ctrld_comp": "0.000000000000",
"one_yr_oth_affil": "0.000000000000",
"one_yr_other": "0.000000000000",
"aft_one_yr_banks_borr": "0.000000000000",
"aft_one_yr_ctrld_comp": "0.000000000000",
"aft_one_yr_oth_affil": "0.000000000000",
"aft_one_yr_other": "0.000000000000",
"delivery_delay": "0.000000000000",
"standby_commit": "0.000000000000",
"liquid_pref": "0.000000000000",
"cash_not_reported_in_cor_d": "2545141.120000000000",
"non_cash_collateral": "N",
"currency": "Null"
}
},
{
"general": {
"fund_name": "USA Mutuals",
"cik": "0001137095",
"reg_lei": "549300IJ0KFT977YGX93",
"country": "US",
"state": "US-TX",
"city": "Dallas",
"zip": "75201",
"street": "700 N. Pearl Street",
"phone": "866-264-8783"
},
"attributes": {
"series_name": "USA Mutuals Navigator Fund",
"series_id": "S000058976",
"series_lei": "549300CS0EIS27ZLBG68",
"date_report_period": "2020-12-31",
"end_report_period": "2021-03-31",
"final_filing": 1
},
"fund_info": {
"total_assets": "44290035.570000000000",
"total_liabilities": "208427.160000000000",
"net_assets": "44081608.410000000000",
"assets_attr_misc_sec": "0.000000000000",
"invested_assets": "0.000000000000",
"one_yr_banks_borr": "0.000000000000",
"one_yr_ctrld_comp": "0.000000000000",
"one_yr_oth_affil": "0.000000000000",
"one_yr_other": "0.000000000000",
"aft_one_yr_banks_borr": "0.000000000000",
"aft_one_yr_ctrld_comp": "0.000000000000",
"aft_one_yr_oth_affil": "0.000000000000",
"aft_one_yr_other": "0.000000000000",
"delivery_delay": "0.000000000000",
"standby_commit": "0.000000000000",
"liquid_pref": "0.000000000000",
"cash_not_reported_in_cor_d": "34462732.210000000000",
"non_cash_collateral": "N",
"currency": "Null"
}
}
]
}
}
https://api.finnworlds.com/api/v1/etfinfo
?key=API-KEY
&cik=1137095
&series_id=S000005505
{
"status": {
"code": 200,
"message": "OK",
"details": ""
},
"result": {
"basics": {
"fund_name": "USA Mutuals",
"file_number": "811-10319",
"cik": "0001137095",
"reg_lei": "549300IJ0KFT977YGX93"
},
"output": [
{
"general": {
"fund_name": "USA Mutuals",
"cik": "0001137095",
"reg_lei": "549300IJ0KFT977YGX93",
"country": "US",
"state": "US-TX",
"city": "Dallas",
"zip": "75201",
"street": "700 N. Pearl Street",
"phone": "866-264-8783"
},
"attributes": {
"series_name": "USA Mutuals Vitium Global Fund",
"series_id": "S000005505",
"series_lei": "549300GX5CPIZQ5PDX31",
"date_report_period": "2020-12-31",
"end_report_period": "2021-03-31",
"final_filing": 1
},
"fund_info": {
"total_assets": "111438858.600000000000",
"total_liabilities": "1741129.050000000000",
"net_assets": "109697729.550000000000",
"assets_attr_misc_sec": "0.000000000000",
"invested_assets": "0.000000000000",
"one_yr_banks_borr": "591000.000000000000",
"one_yr_ctrld_comp": "0.000000000000",
"one_yr_oth_affil": "0.000000000000",
"one_yr_other": "0.000000000000",
"aft_one_yr_banks_borr": "0.000000000000",
"aft_one_yr_ctrld_comp": "0.000000000000",
"aft_one_yr_oth_affil": "0.000000000000",
"aft_one_yr_other": "0.000000000000",
"delivery_delay": "0.000000000000",
"standby_commit": "0.000000000000",
"liquid_pref": "0.000000000000",
"cash_not_reported_in_cor_d": "2545141.120000000000",
"non_cash_collateral": "N",
"currency": "Null"
}
}
]
}
}
https://api.finnworlds.com/api/v1/etfreturns
?key=API-KEY
&series_id=S000005505
{
"status": {
"code": 200,
"message": "OK",
"details": ""
},
"result": {
"basics": {
"fund_name": "USA Mutuals",
"file_number": "811-10319",
"cik": "0001137095",
"reg_lei": "549300IJ0KFT977YGX93"
},
"output": [
{
"attributes": {
"series_name": "USA Mutuals Vitium Global Fund",
"series_id": "S000005505",
"series_lei": "549300GX5CPIZQ5PDX31",
"date_report_period": "2020-12-31",
"end_report_period": "2021-03-31",
"final_filing": 1
},
"signature": {
"date_signed": "2021-02-09",
"name_of_applicant": "USA Mutuals",
"signature": "/s/ Richard Sapio",
"signer_name": "Richard Sapio",
"title": "President"
},
"return_info": {
"monthly_total_returns": [
{
"class_id": "C000014988",
"0": {
"rtn1": "-6.820000000000",
"rtn2": "15.030000000000",
"rtn3": "4.540000000000"
}
},
{
"class_id": "C000106574",
"0": {
"rtn1": "-6.780000000000",
"rtn2": "15.000000000000",
"rtn3": "4.530000000000"
}
},
{
"class_id": "C000106575",
"0": {
"rtn1": "-6.850000000000",
"rtn2": "14.920000000000",
"rtn3": "4.520000000000"
}
},
{
"class_id": "C000129812",
"0": {
"rtn1": "-6.780000000000",
"rtn2": "15.060000000000",
"rtn3": "4.560000000000"
}
}
],
"other_monthly1": {
"net_realized_gain": "1047242.290000000000",
"net_unrealized_appreciation": "-8495540.410000000000"
},
"other_monthly2": {
"net_realized_gain": "682677.450000000000",
"net_unrealized_appreciation": "14452752.560000000000"
},
"other_monthly3": {
"net_realized_gain": "81689.110000000000",
"net_unrealized_appreciation": "4566807.660000000000"
},
"month_1_flow": {
"redemption": "-2555820.560000000000",
"reinvestment": ".000000000000",
"sales": "127367.110000000000"
},
"month_2_flow": {
"redemption": "-3177883.990000000000",
"reinvestment": ".000000000000",
"sales": "769141.370000000000"
},
"month_3_flow": {
"redemption": "-3281011.540000000000",
"reinvestment": "4079781.690000000000",
"sales": "240630.130000000000"
},
"monthly_return_categories": {
"equity": {
"month1": {
"net_realized_gain": "-68969.790000000000",
"net_unrealized_appreciation": "455219.160000000000"
},
"month2": {
"net_realized_gain": "-107563.080000000000",
"net_unrealized_appreciation": "-708108.530000000000"
},
"month3": {
"net_realized_gain": "162179.700000000000",
"net_unrealized_appreciation": "2346.670000000000"
},
"future_category": {
"instrmon1": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "N/A"
},
"instrmon2": {
"net_realized_gain": "102949.590000000000",
"net_unrealized_appreciation": "N/A"
},
"instrmon3": {
"net_realized_gain": "199347.040000000000",
"net_unrealized_appreciation": "51156.750000000000"
}
},
"option_category": {
"instrmon1": {
"net_realized_gain": "-68969.790000000000",
"net_unrealized_appreciation": "455219.160000000000"
},
"instrmon2": {
"net_realized_gain": "-210512.670000000000",
"net_unrealized_appreciation": "-708108.530000000000"
},
"instrmon3": {
"net_realized_gain": "-37167.340000000000",
"net_unrealized_appreciation": "-48810.080000000000"
}
}
}
}
}
},
{
"attributes": {
"series_name": "USA Mutuals Vitium Global Fund",
"series_id": "S000005505",
"series_lei": "549300GX5CPIZQ5PDX31",
"date_report_period": "2020-09-30",
"end_report_period": "2021-03-31",
"final_filing": 0
},
"signature": {
"date_signed": "2020-11-23",
"name_of_applicant": "USA Mutuals",
"signature": "/s/ Richard Sapio",
"signer_name": "USA Mutuals",
"title": "President"
},
"return_info": {
"monthly_total_returns": [
{
"class_id": "C000014988",
"0": {
"rtn1": "1.610000000000",
"rtn2": "5.250000000000",
"rtn3": "-3.730000000000"
}
},
{
"class_id": "C000106574",
"0": {
"rtn1": "1.580000000000",
"rtn2": "5.280000000000",
"rtn3": "-3.750000000000"
}
},
{
"class_id": "C000106575",
"0": {
"rtn1": "1.500000000000",
"rtn2": "5.220000000000",
"rtn3": "-3.810000000000"
}
},
{
"class_id": "C000129812",
"0": {
"rtn1": "1.590000000000",
"rtn2": "5.310000000000",
"rtn3": "-3.740000000000"
}
}
],
"other_monthly1": {
"net_realized_gain": "17728.310000000000",
"net_unrealized_appreciation": "2149139.690000000000"
},
"other_monthly2": {
"net_realized_gain": "425818.750000000000",
"net_unrealized_appreciation": "5464610.260000000000"
},
"other_monthly3": {
"net_realized_gain": "-1692066.620000000000",
"net_unrealized_appreciation": "-2557720.590000000000"
},
"month_1_flow": {
"redemption": "-3327168.330000000000",
"reinvestment": ".000000000000",
"sales": "382606.240000000000"
},
"month_2_flow": {
"redemption": "-3852681.050000000000",
"reinvestment": ".000000000000",
"sales": "120353.170000000000"
},
"month_3_flow": {
"redemption": "-2077752.460000000000",
"reinvestment": ".000000000000",
"sales": "118110.300000000000"
},
"monthly_return_categories": {
"equity": {
"month1": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "-417175.900000000000"
},
"month2": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "-337050.000000000000"
},
"month3": {
"net_realized_gain": "-431129.000000000000",
"net_unrealized_appreciation": "538894.960000000000"
},
"option_category": {
"instrmon1": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "-417175.900000000000"
},
"instrmon2": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "-337050.000000000000"
},
"instrmon3": {
"net_realized_gain": "-431129.000000000000",
"net_unrealized_appreciation": "538894.960000000000"
}
}
}
}
}
},
{
"attributes": {
"series_name": "USA Mutuals Vitium Global Fund",
"series_id": "S000005505",
"series_lei": "549300GX5CPIZQ5PDX31",
"date_report_period": "2020-06-30",
"end_report_period": "2021-03-31",
"final_filing": 0
},
"signature": {
"date_signed": "2020-08-11",
"name_of_applicant": "USA Mutuals",
"signature": "/s/ Richard Sapio",
"signer_name": "USA Mutuals",
"title": "President"
},
"return_info": {
"monthly_total_returns": [
{
"class_id": "C000014988",
"0": {
"rtn1": "11.730000000000",
"rtn2": "5.690000000000",
"rtn3": "-1.100000000000"
}
},
{
"class_id": "C000106574",
"0": {
"rtn1": "11.710000000000",
"rtn2": "5.690000000000",
"rtn3": "-1.110000000000"
}
},
{
"class_id": "C000106575",
"0": {
"rtn1": "11.610000000000",
"rtn2": "5.620000000000",
"rtn3": "-1.130000000000"
}
},
{
"class_id": "C000129812",
"0": {
"rtn1": "11.730000000000",
"rtn2": "5.720000000000",
"rtn3": "-1.080000000000"
}
}
],
"other_monthly1": {
"net_realized_gain": "-2130751.400000000000",
"net_unrealized_appreciation": "13968148.260000000000"
},
"other_monthly2": {
"net_realized_gain": "52361.540000000000",
"net_unrealized_appreciation": "6134166.550000000000"
},
"other_monthly3": {
"net_realized_gain": "-314956.190000000000",
"net_unrealized_appreciation": "-1040043.970000000000"
},
"month_1_flow": {
"redemption": "-2606649.580000000000",
"reinvestment": ".000000000000",
"sales": "436922.980000000000"
},
"month_2_flow": {
"redemption": "-3384584.510000000000",
"reinvestment": ".000000000000",
"sales": "699109.070000000000"
},
"month_3_flow": {
"redemption": "-3494245.050000000000",
"reinvestment": ".000000000000",
"sales": "408949.640000000000"
},
"monthly_return_categories": {
"equity": {
"month1": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "N/A"
},
"month2": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "N/A"
},
"month3": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "163161.150000000000"
},
"option_category": {
"instrmon1": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "N/A"
},
"instrmon2": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "N/A"
},
"instrmon3": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "163161.150000000000"
}
}
}
}
}
},
{
"attributes": {
"series_name": "USA Mutuals Vitium Global Fund",
"series_id": "S000005505",
"series_lei": "549300GX5CPIZQ5PDX31",
"date_report_period": "2020-03-31",
"end_report_period": "2020-03-31",
"final_filing": 0
},
"signature": {
"date_signed": "2020-05-28",
"name_of_applicant": "USA Mutuals",
"signature": "/s/ Richard Sapio",
"signer_name": "USA Mutuals",
"title": "President"
},
"return_info": {
"monthly_total_returns": [
{
"class_id": "C000014988",
"0": {
"rtn1": "-1.380000000000",
"rtn2": "-8.420000000000",
"rtn3": "-18.560000000000"
}
},
{
"class_id": "C000106574",
"0": {
"rtn1": "-1.390000000000",
"rtn2": "-8.430000000000",
"rtn3": "-18.530000000000"
}
},
{
"class_id": "C000106575",
"0": {
"rtn1": "-1.390000000000",
"rtn2": "-8.540000000000",
"rtn3": "-18.570000000000"
}
},
{
"class_id": "C000129812",
"0": {
"rtn1": "-1.400000000000",
"rtn2": "-8.400000000000",
"rtn3": "-18.510000000000"
}
}
],
"other_monthly1": {
"net_realized_gain": "-1536818.810000000000",
"net_unrealized_appreciation": "-263003.810000000000"
},
"other_monthly2": {
"net_realized_gain": "-253.590000000000",
"net_unrealized_appreciation": "-11963363.090000000000"
},
"other_monthly3": {
"net_realized_gain": "2889957.560000000000",
"net_unrealized_appreciation": "-27422527.950000000000"
},
"month_1_flow": {
"redemption": "-2904481.300000000000",
"reinvestment": ".000000000000",
"sales": "596938.080000000000"
},
"month_2_flow": {
"redemption": "-2857512.430000000000",
"reinvestment": ".000000000000",
"sales": "600369.900000000000"
},
"month_3_flow": {
"redemption": "-4990773.570000000000",
"reinvestment": ".000000000000",
"sales": "689616.070000000000"
},
"monthly_return_categories": {
"equity": {
"month1": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "-749.980000000000"
},
"month2": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "N/A"
},
"month3": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "N/A"
},
"warrant_category": {
"instrmon1": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "-749.980000000000"
},
"instrmon2": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "N/A"
},
"instrmon3": {
"net_realized_gain": "N/A",
"net_unrealized_appreciation": "N/A"
}
}
}
}
}
}
]
}
}
https://api.finnworlds.com/api/v1/etfholdings
?key=API-KEY
&series_id=S000005505
&date_from=2020-09-01&date_to=2020-12-30
{
"status": {
"code": 200,
"message": "OK",
"details": ""
},
"result": {
"basics": {
"fund_name": "USA Mutuals",
"file_number": "811-10319",
"cik": "0001137095",
"reg_lei": "549300IJ0KFT977YGX93"
},
"output": [
{
"attributes": {
"series_name": "USA Mutuals Vitium Global Fund",
"series_id": "S000005505",
"series_lei": "549300GX5CPIZQ5PDX31",
"date_report_period": "2020-09-30",
"end_report_period": "2021-03-31",
"final_filing": 0
},
"signature": {
"date_signed": "2020-11-23",
"name_of_applicant": "USA Mutuals",
"signature": "/s/ Richard Sapio",
"signer_name": "USA Mutuals",
"title": "President"
},
"holdings": [
{
"investment_security": {
"name": "Altria Group Inc",
"lei": "XSGZFLO9YTNO9VCQV219",
"isin": "US02209S1033",
"cusip": "02209S103",
"balance": "40000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "1545600.000000000000",
"percent_value": "1.4645203739",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "BAE Systems PLC",
"lei": "8SVCSVKSGDWMW2QHOH83",
"isin": "GB0002634946",
"cusip": "G06940103",
"balance": "469194.000000000000",
"units": "NS",
"currency": "GBP",
"value_usd": "2918159.280000000000",
"percent_value": "2.7650774585",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "GB",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "Boeing Co/The",
"lei": "RVHJWBXLJ1RFUBSY1F30",
"isin": "US0970231058",
"cusip": "097023105",
"balance": "17000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "2809420.000000000000",
"percent_value": "2.6620424618",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "British American Tobacco PLC",
"lei": "213800FKA5MF17RJKT63",
"isin": "US1104481072",
"cusip": "110448107",
"balance": "143000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "5169450.000000000000",
"percent_value": "4.8982691816",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "GB",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "Y"
}
},
{
"investment_security": {
"name": "Cameco Corp",
"lei": "N4BHALMXL3GMZKCUON55",
"isin": "CA13321L1085",
"cusip": "13321L108",
"balance": "500000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "5050000.000000000000",
"percent_value": "4.7850853315",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "CA",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "Constellation Brands Inc",
"lei": "5493005GKEG8QCVY7037",
"isin": "US21036P1084",
"cusip": "21036P108",
"balance": "19000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "3600690.000000000000",
"percent_value": "3.4118037430",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "Diageo PLC",
"lei": "213800ZVIELEA55JMJ32",
"isin": "US25243Q2057",
"cusip": "25243Q205",
"balance": "39500.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "5437570.000000000000",
"percent_value": "5.1523240487",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "GB",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "DraftKings Inc",
"lei": "5493008P45UYYL683Z97",
"isin": "US26142R1041",
"cusip": "26142R104",
"balance": "100000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "5884000.000000000000",
"percent_value": "5.5753350674",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "Y"
}
},
{
"investment_security": {
"name": "First American Treasury Obliga",
"lei": "N/A",
"isin": "US31846V3289",
"cusip": "31846V328",
"balance": "607103.830000000000",
"units": "NS",
"currency": "USD",
"value_usd": "607103.830000000000",
"percent_value": "0.5752561647",
"payoff_profile": "Long",
"asset_category": "STIV",
"issuer_category": "RF",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
ETC
}
]
}
]
}
}
https://api.finnworlds.com/api/v1/etfreturns
?key=API-KEY
&series_id=S000005505
{
"status": {
"code": 200,
"message": "OK",
"details": ""
},
"result": {
"basics": {
"fund_name": "USA Mutuals",
"file_number": "811-10319",
"cik": "0001137095",
"reg_lei": "549300IJ0KFT977YGX93"
},
"output": [
{
"attributes": {
"series_name": "USA Mutuals Vitium Global Fund",
"series_id": "S000005505",
"series_lei": "549300GX5CPIZQ5PDX31",
"date_report_period": "2020-12-31",
"end_report_period": "2021-03-31",
"final_filing": 1
},
"signature": {
"date_signed": "2021-02-09",
"name_of_applicant": "USA Mutuals",
"signature": "/s/ Richard Sapio",
"signer_name": "Richard Sapio",
"title": "President"
},
"holdings": [
{
"investment_security": {
"name": "BAE Systems PLC",
"lei": "8SVCSVKSGDWMW2QHOH83",
"isin": "GB0002634946",
"cusip": "G06940103",
"balance": "477704.000000000000",
"units": "NS",
"currency": "GBP",
"value_usd": "3193142.180000000000",
"percent_value": "2.9108553049",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "GB",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "British American Tobacco PLC",
"lei": "213800FKA5MF17RJKT63",
"isin": "US1104481072",
"cusip": "110448107",
"balance": "143000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "5361070.000000000000",
"percent_value": "4.8871294073",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "GB",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "Cameco Corp",
"lei": "N4BHALMXL3GMZKCUON55",
"isin": "CA13321L1085",
"cusip": "13321L108",
"balance": "500000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "6700000.000000000000",
"percent_value": "6.1076924996",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "CA",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "Constellation Brands Inc",
"lei": "5493005GKEG8QCVY7037",
"isin": "US21036P1084",
"cusip": "21036P108",
"balance": "19000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "4161950.000000000000",
"percent_value": "3.7940165371",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "Diageo PLC",
"lei": "213800ZVIELEA55JMJ32",
"isin": "US25243Q2057",
"cusip": "25243Q205",
"balance": "39500.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "6272995.000000000000",
"percent_value": "5.7184364943",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "GB",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "Direxion Russell 1000 Value Ov",
"lei": "5493003NCTXSFN4SD519",
"isin": "US25460E4558",
"cusip": "25460E455",
"balance": "7000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "343727.300000000000",
"percent_value": "0.3133403958",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "RF",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "DraftKings Inc",
"lei": "5493008P45UYYL683Z97",
"isin": "US26142R1041",
"cusip": "26142R104",
"balance": "100000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "4656000.000000000000",
"percent_value": "4.2443904893",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "Y"
}
},
{
"investment_security": {
"name": "First American Treasury Obliga",
"lei": "N/A",
"isin": "US31846V3289",
"cusip": "31846V328",
"balance": "851.730000000000",
"units": "NS",
"currency": "USD",
"value_usd": "851.730000000000",
"percent_value": "0.0007764336",
"payoff_profile": "Long",
"asset_category": "STIV",
"issuer_category": "RF",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "Gaming and Leisure Properties",
"lei": "5493006GWRDBCZYWTM57",
"isin": "US36467J1088",
"cusip": "36467J108",
"balance": "28322.427000000000",
"units": "NS",
"currency": "USD",
"value_usd": "1200870.900000000000",
"percent_value": "1.0947089834",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
ETC
}
}
}
}
}
}
]
}
}
https://api.finnworlds.com/api/v1/etfreturns
?key=API-KEY
&series_id=S000005505
&date_from=2020-09-01&date_to=2020-12-30
{
"status": {
"code": 200,
"message": "OK",
"details": ""
},
"result": {
"basics": {
"fund_name": "USA Mutuals",
"file_number": "811-10319",
"cik": "0001137095",
"reg_lei": "549300IJ0KFT977YGX93"
},
"output": [
{
"attributes": {
"series_name": "USA Mutuals Vitium Global Fund",
"series_id": "S000005505",
"series_lei": "549300GX5CPIZQ5PDX31",
"date_report_period": "2020-09-30",
"end_report_period": "2021-03-31",
"final_filing": 0
},
"signature": {
"date_signed": "2020-11-23",
"name_of_applicant": "USA Mutuals",
"signature": "/s/ Richard Sapio",
"signer_name": "USA Mutuals",
"title": "President"
},
"holdings": [
{
"investment_security": {
"name": "Altria Group Inc",
"lei": "XSGZFLO9YTNO9VCQV219",
"isin": "US02209S1033",
"cusip": "02209S103",
"balance": "40000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "1545600.000000000000",
"percent_value": "1.4645203739",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "BAE Systems PLC",
"lei": "8SVCSVKSGDWMW2QHOH83",
"isin": "GB0002634946",
"cusip": "G06940103",
"balance": "469194.000000000000",
"units": "NS",
"currency": "GBP",
"value_usd": "2918159.280000000000",
"percent_value": "2.7650774585",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "GB",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "Boeing Co/The",
"lei": "RVHJWBXLJ1RFUBSY1F30",
"isin": "US0970231058",
"cusip": "097023105",
"balance": "17000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "2809420.000000000000",
"percent_value": "2.6620424618",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "British American Tobacco PLC",
"lei": "213800FKA5MF17RJKT63",
"isin": "US1104481072",
"cusip": "110448107",
"balance": "143000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "5169450.000000000000",
"percent_value": "4.8982691816",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "GB",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "Y"
}
},
{
"investment_security": {
"name": "Cameco Corp",
"lei": "N4BHALMXL3GMZKCUON55",
"isin": "CA13321L1085",
"cusip": "13321L108",
"balance": "500000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "5050000.000000000000",
"percent_value": "4.7850853315",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "CA",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "Constellation Brands Inc",
"lei": "5493005GKEG8QCVY7037",
"isin": "US21036P1084",
"cusip": "21036P108",
"balance": "19000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "3600690.000000000000",
"percent_value": "3.4118037430",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "Diageo PLC",
"lei": "213800ZVIELEA55JMJ32",
"isin": "US25243Q2057",
"cusip": "25243Q205",
"balance": "39500.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "5437570.000000000000",
"percent_value": "5.1523240487",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "GB",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "DraftKings Inc",
"lei": "5493008P45UYYL683Z97",
"isin": "US26142R1041",
"cusip": "26142R104",
"balance": "100000.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "5884000.000000000000",
"percent_value": "5.5753350674",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "Y"
}
},
{
"investment_security": {
"name": "First American Treasury Obliga",
"lei": "N/A",
"isin": "US31846V3289",
"cusip": "31846V328",
"balance": "607103.830000000000",
"units": "NS",
"currency": "USD",
"value_usd": "607103.830000000000",
"percent_value": "0.5752561647",
"payoff_profile": "Long",
"asset_category": "STIV",
"issuer_category": "RF",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "Gaming and Leisure Properties",
"lei": "5493006GWRDBCZYWTM57",
"isin": "US36467J1088",
"cusip": "36467J108",
"balance": "27936.930000000000",
"units": "NS",
"currency": "USD",
"value_usd": "1031710.820000000000",
"percent_value": "0.9775889725",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
"name": "General Dynamics Corp",
"lei": "9C1X8XOOTYY2FNYTVH06",
"isin": "US3695501086",
"cusip": "369550108",
"balance": "26500.000000000000",
"units": "NS",
"currency": "USD",
"value_usd": "3668395.000000000000",
"percent_value": "3.4759570504",
"payoff_profile": "Long",
"asset_category": "EC",
"issuer_category": "CORP",
"invested_country": "US",
"restricted_sec": "N",
"fair_value_level": "1",
"cash_collateral": "N",
"non_cash_collateral": "N",
"loan_by_fund": "N"
}
},
{
"investment_security": {
ETC
}
}
]
}
]
}
}
| Response Objects | Description |
| name | Name of the security |
| lei | lei of the security |
| isin | ISIN of the security |
| cusip | Cusip of the security |
| balance | balance held in this security |
| units | Number of units held in this security |
| currency | The currency of this security |
| value_usd | The value in USD of this security holding |
| percent_value | Percentage of the total value of the security |
| payoff_profile | Payoff profile of security, for example “long” |
ETF Constituents Asset Allocation API
The ETF Holdings API returns ETF portfolio data based on an ETF’s identifier. With the asset allocation data, you can assess the distribution of investments within a fund and the performance of individual stocks within the fund over time. This also enables analyzing the diversification of an ETF, understanding the exposure to different sectors or asset types, and tracking how each holding contributes to the overall fund performance.
Additionally, if you want to focus on a stock in an ETF rather than the ETF as a whole, the ETF Holdings API allows you to do so. By making a query based on a stock’s ticker symbol instead of an ETF’s, you get a list of all ETFs that hold this stock in it. This way, it is possible to track the changes in the market values of the shares and other securities in a specific ETF in real-time one by one while having the opportunity to examine how the ETF buys and sells in the market.
Historical ETF API
The Historical ETF Holdings API is a useful tool that enables you to check which stocks and securities are included in an ETF historically, and view the market value and the particular details of the ETFs of your choice. An in-house ETF database that contains real-time and historical data, regularly updated, can be hard to maintain manually. The data stored in Finnworlds Historical ETF API is updated daily, weekly, quarterly or annually from SEC filings of companies as well as directly from the funds when they publicly provide this information. With the use of historical ETF data, compare and analyze the future performance of ETFs.
By integrating the ETF Holdings API, you can build a platform, an application, a website or an ETF performance tool that allows your clients to get updated information on multiple ETFs on a daily basis with historical ETF data to view along with this. Keep up with the changes in the market values of the shares in the ETFs of your choice and offer your clients the same feature. Simply access Finnworlds ETF Holdings Database through our API and focus on building your ETF comparison tool projects instead of trying to find correct data to integrate from multiple sources.
Sources
The ETF data is gathered from the SEC daily, weekly, quarterly, annually or irregularly, and on top of that, from the websites and reports the ETFs disclose. This aggregated data is then stored and maintained in our ETF Holdings Database that you may access anytime via the API or as a standalone database. The ETF data you get is official and correct information as made publicly by the ETFs.
SEC Filings
Every quarter, the ETFs file their reports to the SEC, we will have our database updated based on this on top of other daily, weekly, annual or irregular reports.
Directly From the Mutual Fund Reports
We obtain reports from ETFs directly as they update their holdings.
Mutual Fund Websites
As an ETF updates their holding information on their website, we will update our database accordingly.
ETF NAV API
Finnworld’s ETF NAV API addresses all investor needs by its wide coverage of ETF net asset value data. The ETF NAV API provides up-to-date access to the net asset values which is crucial to monitor a fund’s collective market value. By combining this with the constituent data, break down the ETF’s performance values based on underlying assets and NAVs. Historical and current changes in net asset values and the assets of the ETF could indicate whether an EFT is trending and promising, or does not offer a good position. Historical and real-time ETF NAV data will give you and your clients a solid idea to catch trends in ETFs and analyze their historical and future positions before making an entry. Since ETFs are well known for having a slight liquidity risk as they can be shorted, it is important to analyze how an ETF’s historical net asset value behavior was during both risk-on and risk-off periods.
ETF Purchase Potential and ETF Portfolio Management
The ETF API also provides data on indicators that measure ETF purchase potential for investors and assist in ETF portfolio management. For example, the data is useful for checking which ETFs still have the “capacity” to buy and include a certain stock or security. In other words, if all or the majority of ETFs on the market have saturated their portfolios with stocks and securities that have already reached a certain buy potential, this could indicate that the ETFs are not likely to be bought. As a result, the ETFs should stop including any more of these stocks and securities since such an action would limit the growth of the ETF. However, stocks with comparatively higher potential and bigger capacity to grow could end up in more ETF portfolios or enlarge their share in existing ones which is the key to efficient ETF portfolio management.
For example, an ETF holds a maximum of 10% of a stock in its portfolio and only buys and sells according to the stock price point. Since you have the real-time access to the current portfolio of ETFs, you can use the ETF portfolio management data to identify whether a stock is still available to be bought by an ETF or it is already saturated. If it is already at 10% (according to the example), this may be an indicator that this ETF is not likely to buy any more of the specific stock. In this way, the ETF portfolio management API provides data that enhances investors’ knowledge on the limitations on ETFs and offers improved insights about the ETF purchase potential data.
Formats to Download the Data
The ETF data is accessible in three main formats. In this way, Finnworlds fully addresses your needs for data delivery formats. Request your data format and get ETF data instantly. No matter the format of your choice, you obtain ETF data without any differences in the data transfer time. Please, contact support@finnworlds.com for notifying which data format you prefer. You can always change the data delivery format.
Developer Notes
The ETF Holdings API returns data in JSON format with response times around 0.3 ms depending on the load of the data requested in one call. In finance, it is important to be able to access the most recent data available on the markets. With server uptimes at 99.5%, accessibility is at high levels. You can query based on either the ticker symbol of an ETF or a stock. The endpoint for each is only slightly different. The API returns information of all holdings in an ETF according to its latest report or all ETFs that hold a specific stock or security depending on the endpoint you use. The API was created to address the needs of developers, businesses, analysts and hobbyists with all levels of experience. You can use it with any of the leading software development kits and all major programming and scripting languages.
SDKs and Devkits
REST JSON and XML
Excel and CSV
ETF API - Get started!
All sounds good to start? Choose a subscription plan on the button below and receive your API key to your email address immediately. Benefit from the trial rates. Upgrade, downgrade or cancel your plan anytime. Start getting ETF performance data within a minute!
For any questions, feel free to contact the team.
Control the Data
/etfholdings&stock_ticker_symbol= GOOG AAPL AMZN TSLA NFLX SQ AMD FB MSFT
stock_ticker_symbol= GOOG AAPL AMZN TSLA NFLX SQ AMD FB MSFT