Login Page - Create Account

Support Board


Date/Time: Wed, 01 Apr 2026 16:05:14 +0000



Post From: Spreadshet EMA Custom Calculation fails

[2019-09-20 04:36:51]
Sawtooth - Posts: 4322
Is it possible to catch/stop a SMA calculation in a spreadsheet if
the number of quotes < length of the MA?
Here's the formula for an SMA Skip Zeros. Maybe this would do what you want.

Or maybe you could modify this moving average study to start averaging dynamically:
https://www.sawtoothtrade.com/free-stuff-18.html