Support Board
Date/Time: Tue, 26 Aug 2025 18:17:00 +0000
spreadsheet help
View Count: 322
| [2025-05-31 22:58:17] |
| User411320 - Posts: 334 |
|
using the moving average exponential twice, using inputs based off spreadsheet formula instead of the default settings. Every time I change the length of one of the averages. The data erases and I have to recalculate all the formulas again. please see attached
|
 Screenshot 2025-05-31 183534.png / V - Attached On 2025-05-31 22:58:02 UTC - Size: 24.76 KB - 110 views Screenshot 2025-05-31 183602.png / V - Attached On 2025-05-31 22:58:08 UTC - Size: 4.69 KB - 112 views |
| [2025-06-02 13:13:23] |
| User411320 - Posts: 334 |
|
anyone?
|
| [2025-06-02 13:57:26] |
| Sawtooth - Posts: 4261 |
|
Every time I change the length of one of the averages. The data erases
Two solutions:1. Use the Chart Recalculation - Periodic study. 2. Use a spreadsheet formula to calc the EMA (instead of the study Based On a spreadsheet subgraph), using this example: Spreadsheet Example Formulas and Usage: Exponential Moving Average Date Time Of Last Edit: 2025-06-02 13:58:27
|
| [2025-06-02 14:45:42] |
| User411320 - Posts: 334 |
|
Thank you i will try this
|
To post a message in this thread, you need to log in with your Sierra Chart account: