Security Trading Analytics

 Should I Trade Single-Stock Leveraged ETFs? This post examines a set of seventeen single-stock leveraged ETFs that are tracked from their inception through April 30, 2026.  An additional set of seventeen underlying securities is also tracked to help you appreciate how underlying securities can provide important clues about when to buy and sell single-stock leveraged ETFs. A single-stock leveraged ETF is based on an individual stock instead of a basket of securities.  Unlike traditional ETFs, single-stock leveraged ETFs do not have built-in diversification.  If you feel uncomfortable about managing a collection of individual securities that complement one another, then you should avoid single-stock ETFs in favor of traditional ETFs, such as  SPY, QQQ, and DIA, which offer broad diversification. Because many single-stock ETFs employ leverage, they are best suited for short-term trades during periods of rapid price acceleration.  They can also be hazardous: d...

 Building Thirty-four Ticker Historical Price Datasets with Excel’s STOCKHISTORY and Sheets’ GOOGLEFINANCE Functions A prior post in this blog reported model results that showed three of four leveraged single-stock ETFs outperformed their underlying security counterparts.  A reader of the prior post asked a very important question: does the outperformance apply to more than just three of four ticker pairs? The reader wanted the model results replicated for a larger set of tickers than just four pairs.  Providing more results for more tickers depends on the easy availability of historical ticker prices for financial instruments, such as single-stock ETFs and their underlying tickers. To provide more empirical evidence about any trading strategy, self-directed traders and non-institutional analysts require easy ways to compile historical prices for custom sets of financial instruments.  This post offers self-directed traders and non-institutional analysts step-by-step ...