Support Board
Date/Time: Sun, 15 Jun 2025 16:03:40 +0000
spreadsheet help
View Count: 227
| [2025-05-31 22:58:17] |
| User411320 - Posts: 331 |
|
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 - 86 views Screenshot 2025-05-31 183602.png / V - Attached On 2025-05-31 22:58:08 UTC - Size: 4.69 KB - 83 views |
| [2025-06-02 13:13:23] |
| User411320 - Posts: 331 |
|
anyone?
|
| [2025-06-02 13:57:26] |
| Sawtooth - Posts: 4227 |
|
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: 331 |
|
Thank you i will try this
|
To post a message in this thread, you need to log in with your Sierra Chart account: