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 ticker symbol 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.

In case you need to know which ETFs have ownership stake in a specific stock, you can use the API to get this data.

Find out which stocks and other securities an ETF holds, get data about the entire portfolio of an ETF through the API system.

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.

Check Developer Documentation

Code Examples for the ETF Holdings API

				
					https://finnworlds.com/api/v1/etfholdings
    ?key=YOUR-KEY
        &etf_ticker_symbol=QQQ

{
    "status": {
        "message": "Success"
    },
    "results": [
        {
        "basics": {
            "name": "Invesco"
            "etf_ticker_symbol": "QQQ"
            "isin_identifier": "US46090E1038"
            "exchange": "nasdaq"
            "date": "2020:12:31"
            "number_of_holdings": "100"
            },
        "output": {
            "name": "Apple Inc"
            "stock_ticker_symbol": "AAPL"
            "isin_identifier": "US0378331005"
            "exchange": "nasdaq"
            "number_of_holdings": "142,085,775"
            "percent_of_portfolio": "10.99"
            "value_of_holdings": "20,724,631,141.50"
            },
            {
            "name": "Microsoft Corporation"
            "stock_ticker_symbol": "MSFT"
            "isin_identifier": "US0378331005"
            "exchange": "nasdaq"
            "number_of_holdings": "64,127,005"
            "percent_of_portfolio": "9.81"
            "value_of_holdings": "18,401,244,084.75"
             },
            {
            "name": "Amazon.com, Inc."
            "stock_ticker_symbol": "AMZN"
            "isin_identifier": "US0378331005"
            "exchange": "nasdaq"
            "number_of_holdings": "4,293,952"
            "percent_of_portfolio": "8.34"
            "value_of_holdings": "14,136,162,318.72"
             },
            {
            "name": "Facebook, Inc. Common Stock"
            "stock_ticker_symbol": "FB"
            "isin_identifier": "US0378331005"
            "exchange": "nasdaq"
            "number_of_holdings": "20,401,110"
            "percent_of_portfolio": "4.01"
            "value_of_holdings": "7,343,583,555.60"
            }
        }
    [
}
				
			

				
					https://finnworlds.com/api/v1/etfholdings
    ?key=YOUR-KEY
        &etf_isin_identifier=US46090E1038

{
    "status": {
        "message": "Success"
    },
    "results": [
        {
        "basics": {
            "name": "Invesco"
            "etf_ticker_symbol": "QQQ"
            "isin_identifier": "US46090E1038"
            "exchange": "nasdaq"
            "date": "2020:12:31"
            "number_of_holdings": "100"
            },
        "output": {
            "name": "Apple Inc"
            "stock_ticker_symbol": "AAPL"
            "isin_identifier": "US0378331005"
            "exchange": "nasdaq"
            "number_of_holdings": "142,085,775"
            "percent_of_portfolio": "10.99"
            "value_of_holdings": "20,724,631,141.50"
            },
            {
            "name": "Microsoft Corporation"
            "stock_ticker_symbol": "MSFT"
            "isin_identifier": "US0378331005"
            "exchange": "nasdaq"
            "number_of_holdings": "64,127,005"
            "percent_of_portfolio": "9.81"
            "value_of_holdings": "18,401,244,084.75"
             },
            {
            "name": "Amazon.com, Inc."
            "stock_ticker_symbol": "AMZN"
            "isin_identifier": "US0378331005"
            "exchange": "nasdaq"
            "number_of_holdings": "4,293,952"
            "percent_of_portfolio": "8.34"
            "value_of_holdings": "14,136,162,318.72"
             },
            {
            "name": "Facebook, Inc. Common Stock"
            "stock_ticker_symbol": "FB"
            "isin_identifier": "US0378331005"
            "exchange": "nasdaq"
            "number_of_holdings": "20,401,110"
            "percent_of_portfolio": "4.01"
            "value_of_holdings": "7,343,583,555.60"
            }
        }
    [
}
				
			

				
					https://finnworlds.com/api/v1/etfholdings
    ?key=YOUR-KEY
        &stock_ticker_symbol=AAPL

{
    "status": {
        "message": "Success"
    },
    "results": [
        {
        "basics": {
            "name": "Apple Inc"
            "etf_ticker_symbol": "AAPL"
            "isin_identifier": "US0378331005"
            "exchange": "nasdaq"
            "date": "2020:12:31"
            "number_of_holdings": "."
            },
        "output": {
            "name": "Vanguard Information Technology ETF"
            "stock_ticker_symbol": "VGT"
            "isin_identifier": "US92204A7028"
            "exchange": "nasdaq"
            "number_of_holdings": "."
            "percent_of_portfolio": "19.51"
            "value_of_holdings": "."
            },
            {
            "name": "iShares U.S. Technology ETF"
            "stock_ticker_symbol": "IYW"
            "isin_identifier": "US4642877215"
            "exchange": "nasdaq"
            "number_of_holdings": "."
            "percent_of_portfolio": "18.14"
            "value_of_holdings": "."
             },
            {
            "name": "iShares Global Tech ETF"
            "stock_ticker_symbol": "IXN"
            "isin_identifier": "US4642872919"
            "exchange": "nasdaq"
            "number_of_holdings": "."
            "percent_of_portfolio": "17.24"
            "value_of_holdings": "."
             },
            {
            "name": "Wahed FTSE USA Shariah ETF"
            "stock_ticker_symbol": "HLAL"
            "isin_identifier": "US53656F6079"
            "exchange": "nasdaq"
            "number_of_holdings": "."
            "percent_of_portfolio": "16.60"
            "value_of_holdings": "."
            }
        }
    [
}
				
			

				
					https://finnworlds.com/api/v1/etfholdings
    ?key=YOUR-KEY
        &isin_identifier=US0378331005

{
    "status": {
        "message": "Success"
    },
    "results": [
        {
        "basics": {
            "name": "Apple Inc"
            "etf_ticker_symbol": "AAPL"
            "isin_identifier": "US0378331005"
            "exchange": "nasdaq"
            "date": "2020:12:31"
            "number_of_holdings": "."
            },
        "output": {
            "name": "Vanguard Information Technology ETF"
            "stock_ticker_symbol": "VGT"
            "isin_identifier": "US92204A7028"
            "exchange": "nasdaq"
            "number_of_holdings": "."
            "percent_of_portfolio": "19.51"
            "value_of_holdings": "."
            },
            {
            "name": "iShares U.S. Technology ETF"
            "stock_ticker_symbol": "IYW"
            "isin_identifier": "US4642877215"
            "exchange": "nasdaq"
            "number_of_holdings": "."
            "percent_of_portfolio": "18.14"
            "value_of_holdings": "."
             },
            {
            "name": "iShares Global Tech ETF"
            "stock_ticker_symbol": "IXN"
            "isin_identifier": "US4642872919"
            "exchange": "nasdaq"
            "number_of_holdings": "."
            "percent_of_portfolio": "17.24"
            "value_of_holdings": "."
             },
            {
            "name": "Wahed FTSE USA Shariah ETF"
            "stock_ticker_symbol": "HLAL"
            "isin_identifier": "US53656F6079"
            "exchange": "nasdaq"
            "number_of_holdings": "."
            "percent_of_portfolio": "16.60"
            "value_of_holdings": "."
            }
        }
    [
}
				
			

ObjectsDescription
etf_ticker_symbolETF for which you want to know the portfolio
etf_isin_identifierISIN identifier for the ETF for which you want to know the portfolio
stock_ticker_symbolThe stock security of which you want to know the ETFs that have invested in it.
exchangeThe exchange platform where the stock security trades on
stock_isin_identifierThe ISIN identifier of the stock security of which you want to know the ETFs that have invested in it.
dateThe date from which you would like to have the data. It will take the data from the report released closest before the input date.

ETF Constituents Data API

The ETF Holdings API returns ETF portfolio data based on the unique ticker symbols of ETFs on the market. 

The ETF Holdings API lets you obtain 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.

Sign Up
Sign Up

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.

Contact us

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.  

Contact us
Excel and CSV
If you choose this data format, you will access ETF data through database downloads formatted as either Excel or CSV files.
E-mail link
If you choose this data format, you will receive an email containing a link through which you can download ETF data.
Pdf Report
If you choose this data format, you will get ETF data in a downloadable PDF report.

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

The API works with: Javascript, JQuery, VueJS, Angular, JAVA, PHP, NodeJS, Python, Go, Ruby, C#, R, Strest, Rust, Swift and Scala.

REST JSON and XML

Data output can be requested in REST Json format or XML format.

Excel and CSV

In case you do not want the data through our API, request it in Excel or CSV format.

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