Skip to main content

Command Palette

Search for a command to run...

How to Access Historical and Real-time ETF Holdings API

Published
4 min read
How to Access Historical and Real-time ETF Holdings API
F

Finnworlds is a financial data provider that answers the needs of developers in finance.

The data focuses on ETF, mutual funds, commodity prices, stock index, OHLC, analyst ratings, analyst consensus, company identification, bond yields, financial statements, SEC filings, technical indicators and much more. Contact us if you have a project in mind and let's talk!

Meet the ETF Holdings API by Finnworlds! The API is built to provide real-time and historical ETF holdings data, delivered in JSON format. This is to make it easy for developers to integrate it into their apps and projects which also allows you to use any programming language, including Java, Python, and PHP to build powerful apps and features. The API fetches data about both the ETFs and the assets in them individually to maximize ETF performance analysis.

First, it is useful to get to know the filters you can use and what the data looks like, so you can visualize what you can build using the ETH Holdings API. You can use the following parameters to filter the data to get the exact ETF or asset that you'd like:

  • /etfinfo&cik=1137095: With this parameter, you can fetch data about a particular ETF based on its identifier, in this case, the CIK.

  • /etfinfo&cik=1137095&series_id=S000005505: Using this parameter, you can fetch data about a particular series of an ETF. Many ETFs have multiple series, each of which may have different investment objectives or expense ratios.

  • /etfreturns&series_id=S000005505&date_from=2020-09-01&date_to=2020-12-30: This parameter allows fetching historical ETF return data for a particular series of an ETF. By specifying a start and end date, you can retrieve data for a given ETF return over a specific time period. This can be particularly useful for analyzing the performance of the ETF and comparing it to other investment options.

  • /etfholdings&series_id=S000005505&date_from=2020-09-01&date_to=2020-12-30: This option allows getting holdings data for a particular series of an ETF. By specifying a start and end date, you can gain insight into the ETF's holdings over time. This data can be useful for analyzing the composition of the ETF's portfolio, identifying trends in its holdings, and making more informed investment decisions.


JSON Output for the ETF Holdings API

``` 
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"
                }
            }
        ]
    }
}
```

Find our full documentation here for further details.


Banks, asset management firms, and similar financial service providers, investment and portfolio managers, financial analysts, data scientists, and data-driven businesses as well as stockbrokers, traders, and online trading platforms will find great use in this API. Some of the most popular use cases for the ETF holdings data are:

  • Using real-time ETF holdings data to analyze ETF portfolios

  • Analyzing the performance of ETFs over time by comparing and analyzing historical ETF holdings data

  • Providing accurate ETF investment recommendations and monitoring the ETF market

  • Creating sample projects to practice developing finance sector apps

Want to exchange ideas about the project you have in mind? We'd love that! Contact us anytime.


Accessing the Historical and Current ETF Holdings Data

If you believe our ETF details API can be useful for you, feel free to get an API key here and start testing or implementing the data. Start building ETF tracking features for powerful financial projects as ETF investment is on the rise. Don't skip this opportunity to have the upper hand in providing the best financial solutions!