Login Page - Create Account

Support Board


Date/Time: Sat, 05 Jul 2025 14:21:27 +0000



Post From: Spreadshet EMA Custom Calculation fails

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