ETF Number of securities, percent stock and cash - Historical Data

An ETF is an investment fund and it is traded like stocks on stock exchanges. An ETF is an investment tool that allows traders to easily profit from market exposure and diversification. In fact, the ETF provides the diversification many traders and investors need but cannot afford (usually because of high costs). A trader can buy a single ETF and get exposure to a specific country or a specific sector within an economy.

ETFs can hold many types of assets; some of them hold stocks, other commodities, bonds or Forex/Currency pairs and some holds a mix of two or more types of assets.

An ETF usually tracks a specific index or benchmark. In order to do so, the ETF's manager must rebalance its portfolio (ETF strategy) each time new changes appear in the underlying benchmark. On rebalance days, new securities are bought, some securities, already in the portfolio, are sold and others are scaled (scale-in or scale-out). After the rebalance day, the number of securities that the exchange traded fund holds changes as well as the percentage of capital invested in stock, cash and other elements.

The four measures introduced above can be tracked and stored in a custom database. The current download item gets historical data of these measures for iShares ETFs; it downloads the data from the iShares website and stores it in the "etf_holdings" database.

Here are the different database fields: (iShares ETFs only)
Securities: The number of holdings for each ETF
Stock: The percentage of assets invested in the securities
Cash: The proportion of cash to total net assets
Other: The percentage of assets invested in other items

For iShares ETFs, you can download fundamental data using the following trading objects: iShares Exchange-Traded Funds - ETF Fees and Expenses and iShares ETFs - Class, Total Net Assets, Inception Date and Number/Top Holdings.

Technical Analysis

• Day of week and Week number function
• Dynamic Position Sizing
• Ehler Filter Indicator
• NYSE - Trading Volume
• DeMark Range Expansion Index
• Market Breadth Indicator: Average On Balance Volume
• RSI GT 2%
• Average Correlation Index - S&P 500
• AccuTrack Indicator
• Donchian Channels
• More trading objects...

Fundamental Analysis

• Historical Earnings Calendar for Major Stock Exchanges
• Roubini Sentiment Indicator
• NSE - Short Selling
• Insider trading data
• Update the Industry Name of your U.S. Stocks
• Finviz Downloader
• Cash ON Hand for US stocks
• Company Net Income - US Stocks
• ADS Business Conditions Index
• Permabear Sentiment Index
• More trading objects...