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

• DV Intermediate Oscillator (DVI)
• Stocks Sharp Decline Strategy
• Coefficient of Determination - R Squared - Time-Series Prediction
• Relative Strength TAA System
• Trading System Based on the CloseHL Percent Rank Oscillator
• Support & Resistance Breakout Indicator
• Chi Squared Indicator
• Price Display Indicator
• Record High Percent - 10-day Simple Moving Average of the High-Low Index
• Dynamic Momentum Index
• More trading objects...

Fundamental Analysis

• Media sentiment alerts
• ASX - Short Selling
• Euronext Paris - News Data
• Ratio of Total Market Capitalization to US GDP
• ISM Manufacturing PMI Index
• Margins and Turnover
• Industry Index Name
• AAII Sentiment Survey - Historical Data
• Commitments of Traders Report for Financial Futures
• Identify Spilts Screener Script
• More trading objects...