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 data in an API response provides information about the ETF requested and which stocks it holds. This includes the total owned shares, percentage of the stocks in the portfolio, the indicators of the stock and more.
Data on Which ETFs Hold a Certain Stock
In case you need to know which ETFs have ownership stake in a specific stock, you can use the API to get this data.
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 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.
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 Data API
The ETF Holdings API returns ETF portfolio data based on an ETF’s identifier. However, if you want to focus on a stock in an ETF rather than an ETF itself, 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. In this way, you are able 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 daily in the market.
Finworlds ETF API response returns data from the ETF Holdings Database and allows you to view the particular details of the ETF you have request including data on the symbols and identifiers of the ETF, the number of holdings in the ETF as well as the individual stock ticker symbols, names, ISIN identifiers of the stocks in that ETF, the number of shares, the percentage of portfolio and the market value of these shares
ETF Data Converts
The ETF Holdings API is a useful tool that enables you to check which stocks and securities are included in an ETF, and view the market value and the particular details of the ETFs of your choice both currently and historically. 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 ETF Holdings Database 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. Keep in mind that an API response returns up-to-date ETF data with its corresponding date of update.
By integrating the ETF Holdings API, you can build a platform, an application, a website or a web tool that allows your clients to get updated information on multiple ETFs on a daily basis. You will also be able to 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 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.
Historical Data of ETF Holdings
The ETFs data stored in Finnworlds Database addresses all investor needs with its wide coverage. The ETF Holdings API is a useful data tool for examining ETFs that achieve their investment objectives on a daily basis, and for those ETFs that are more suitable for a long-term investment. For both cases, historical and current changes in values of the ETF could indicate whether an EFT is trending and promising, or does not offer a good position. Historical ETF holdings data will give you and your clients a solid idea to catch trends in ETF holdings 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 behavior was during both risk-on and risk-off periods.
ETF Purchase Potential
The ETF API also provides data on indicators that measure ETF purchase potential for investors, such as the portfolio limitations of ETFs. 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.
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 this 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 Holdings 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 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