Support Board
Date/Time: Fri, 14 Mar 2025 22:20:05 +0000
[User Discussion] - How about this solution for Large SprdSheet Formula Processing speed
View Count: 451
| [2022-07-09 02:32:46] |
| User791263 - Posts: 151 |
|
Before I add a sheet just for long average, I'd like your opinion-guess; Many users need high speed: The question is: How much load (a guess is good) does A) adding a 2nd sheet with only 3 or 4 longer averages-- compared to B) being able to cut rows of Main Sheet with big formulas from 60 to 30. Large Spreadsheet formulas near the size of a page of paper can cause lag if Rows and days to load are set too hign, with many charts,--- when time unit is 1 second or less. Long Moving Averages in formula columns require rows count equal or more to lookback, to keep use of lower columns. My 53 Charts, 2300 studies, 13 spreadsheets on 1 second feed can get lag above 60 rows in a fast market. 30 rows is much safer. What do you think of this, where Sheet #'s are standard (matching Chart#;Chart 53 formula sheet is #53) Add a second sheet, such as # 532 with same columns count (aligned), such sheet just to handle 4 longer averages and sampling. Sheet 53 - row 3 then refers to Sheet532!AB3 (MovAvg in col AB), Now Sheet 53 with big formulas needs only 30 rows; Sheet 532 has 120 rows (allows sampling back further, like "averages of medium averages",using commas instead of colons ":" or both-- for Speed). Users should note, when fast scalping: using an Average(AB3:AB20) <- starting in current row) can cause a recalculation of the spreadsheet (a speed loss of 1 row). I've seen this; Regular averages in Studies don't cause that. Only long "sampling" peculiar rows (ie: AVERAGE(AB4,AB8,AB12,AB18,AB24,:AB30) ) require not using a "study"; Note that started at row 4, causes no recalc. For long avg, row 3 not very significant. What think? Even your worst guess is better than our long analysis. |
To post a message in this thread, you need to log in with your Sierra Chart account: