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

• Investing in stocks using the Kelly criterion money management strategy
• 5x5 SMA & RSI Forex Strategy
• Coefficient of Determination - R Squared - Time-Series Prediction
• Up/Down Volume Spread
• Anchored Indicator
• Euronext Lisbon - Historical Quotes
• Tony Cooper Volatility Strategy #3 - VIX Contango - Tweaked v1.0
• Hammer
• NSE Nifty - S&P CNX Nifty
• Transform any order into a limit order selectively based on a trading rule
• More trading objects...

Fundamental Analysis

• Number of Potential Splits per Trading Day
• StockTwits
• Company Revenues - US Stocks
• Economic events surprise
• Next Split Ex-Date In Days
• Stock Analysts Recommendations
• NSE Board Meetings
• ETF Data: NAV - PE- Fees - Assets - Yield - Beta
• Finviz Downloader
• Business Outlook Survey
• More trading objects...