Backtesting an Automated Buy-Sell Model Based on Smoothing Factors for SPY and SPXL Buy-Sell models are among my favorite analytical techniques because they simulate what self-directed and institutional traders do on a regular basis – namely, buy and sell financial securities. A buy-sell model can evaluate different strategies for profitably buying and selling securities. Over the past several months, this blog introduced and examined variations of a model for buying and selling financial securities based on exponentially smoothed security close prices. Simple exponential smoothing and exponential moving averages are two different approaches available for computing exponentially weighted historical values of an underlying set of time series values – like ticker prices. This post relies on securities prices smoothed by a combination of simple exponential smoothing and exponential moving averages. The model evaluated in the post compares unsmoothed historica...
Posts
About Security Trading Analytics Blog
- Get link
- X
- Other Apps
Historical Price Use Cases for the GoogleFinance Function in Google Sheets In the quest to develop smarter, more reliable trading strategies tailored to individual preferences, historical price data plays a vital role. It helps analysts, developers, and self-directed traders fine-tune algorithms, validate models, and uncover patterns that might otherwise go unnoticed. But despite its significant benefits, acquiring and processing high-quality historical data often requires substantial investments in time, money, or both. As a security price data analyst and quantitative analysis trainer, I gravitate toward rich historical data sources that are both free and easy to use. This is because I want readers like you to be able to try out the analyses and models discussed in my articles. For years — including the early days of this blog — I relied heavily on free historical data from Yahoo Finance. That changed abruptly when Yahoo Finance discontinued free access to its data . In ...