Login Page - Create Account

Support Board


Date/Time: Wed, 17 Sep 2025 10:50:21 +0000



Post From: Spreadshet EMA Custom Calculation fails

[2019-09-20 04:36:51]
Sawtooth - Posts: 4263
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