Support Board
Date/Time: Sun, 02 Feb 2025 19:08:17 +0000
Post From: Spreadshet EMA Custom Calculation fails
| [2019-09-20 01:21:10] |
| User403758 - Posts: 25 |
|
Hey, thank you very much! :) Last question, which make me struggeling. My custom SMA has a length of 100 => SMA(100) It averages another formula. If there are only lets say 50 data sets (quotes/lines) availaible the SMA averages < 100 lines. My envelope spreads because of that extrem at the left end of the chart. In Excel you havent this problem. Is it possible to catch/stop a SMA calculation in a spreadsheet if the number of quotes < length of the MA? |