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...

How to Populate a Trading Database with Refinitiv, Excel, and SQL Server—Update 2 Computer‑based trading analytics requires clean, reliable historical price data.  Whether you are evaluating trading models, comparing performance across securities, or projecting future price paths, the first prerequisite is a trustworthy method for downloading and preparing historical prices from a quality data vendor. This post is the third entry in a series on transferring historical price data from Excel’s STOCKHISTORY function into SQL Server for downstream analysis.  The earlier posts—“ How to Populate a Trading Database with Refinitiv, Excel, and SQL Server ” and “ How to Populate a Trading Database with Refinitiv, Excel, and SQL Server—Update 1 ”—introduced the workflow and addressed several formatting issues that arise when importing STOCKHISTORY output into SQL Server. Excel’s STOCKHISTORY function retrieves historical prices from the London Stock Exchange Group (LSEG), formerly Refini...