Support Board
Date/Time: Mon, 21 Apr 2025 16:15:56 +0000
spreadsheet help
View Count: 96
| [2025-02-26 21:21:14] |
| User411320 - Posts: 319 |
|
Hello, I have a formula and a function that is based off the 2 default moving averages. but I have to constantly recalculate all formulas because it goes blank |
 Screenshot 2025-02-26 161752.png / V - Attached On 2025-02-26 21:21:00 UTC - Size: 9.09 KB - 29 views Screenshot 2025-02-26 161823.png / V - Attached On 2025-02-26 21:21:06 UTC - Size: 5.08 KB - 27 views |
| [2025-02-26 22:51:41] |
| John - SC Support - Posts: 39379 |
|
In general, the Spreadsheet Studies only calculate the most recent 10 rows. This is to ensure that the spreadsheets do not create an overload for the charts. And, in general, this should not be a problem, as most data does not change once a bar is closed. Therefore the data should continue to "move down" the column as new bars are added. Is there something about your formula in which data prior to the most recent 10 bars is changing? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-02-27 14:19:25] |
| User411320 - Posts: 319 |
|
I'm not sure. one column is utilizing the percent rank function, the other is using a simple ratio "/". the 2 moving averages are the default SMA based off spreadsheet column utilizing ABS function
|
| [2025-02-27 16:44:47] |
| John - SC Support - Posts: 39379 |
|
The PERCENTRANK() function could cause this, as it is trying to look at a range of data. If you need the data down the entire row, then you would need to force a full recalculation. Refer to the following for a study that will force this: Chart Recalculation - Periodic For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: