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

• Hammer
• watchlist4
• Time-series Sum for the first Minutes/Hours of a Trading Day
• Best Performing VS Worst Performing Stocks
• Murrey Math Lines Indicator
• Traders Active Zone (Bullish)
• Relative strength index multiple-length
• Up/Down Volume Spread
• Sleep Well Bond Rotation Strategy V1.1
• Set the First Trading Bar Values to Not a Number
• More trading objects...

Fundamental Analysis

• St. Louis Fed Financial Stress Index
• Historical Earnings Calendar for Major Stock Exchanges
• Industrial Production Index - IPI - Historical data
• Analyst Rating
• AAII Sentiment Survey - Historical Data
• ForexRate RSS Feed
• Recent mergers and acquisitions
• Company Net Income - US Stocks
• Stock Grade - Fundamental Analysis
• Currency Pairs Calendar Data
• More trading objects...