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

• DeMark Range Expansion Index
• Technical Analysis Continuation Pattern: Descending Triangle Indicator
• Indicator -> Moving average -> Rate of change -> Trading rule
• Elliott Wave Oscillator
• Strategy Optimization on Random in-sample and out-of-sample Periods
• Longterm Investments
• Maximum Drawdown Composite Indicator
• ATR - Average True Range Drawing Tool
• Transform any order into a limit order selectively based on a trading rule
• Screen for finding potential high volume momentum growth for the next day
• More trading objects...

Fundamental Analysis

• Trade Weighted Exchange Index
• Income Statement & Growth
• Business Outlook Survey diffusion indexes
• Commitments of Traders
• Insider Trading Data
• Stock Analysts Recommendations
• Fails to deliver
• SocialPicks Analysis
• Market Cap Historical Data for the US Stock Market
• Analyst comments
• More trading objects...