Support Board

Date/Time: Sat, 04 May 2024 15:13:48 +0000

Post From: Spreadsheets and System Performance...last annoying question I promise:)

[2013-12-12 21:39:35] Link To Thread - Link To Post [Go To First Post]
enemyspy - Posts: 304
So yes that suggestion makes sense, the reasoning behind why I thought this might work is that, I read somewhere either on the forums or in the manual, that every time a new row is created as the charts update, sierra chart has to recalculate all of the formulas in each row of the spreadsheet. That is why I wondered if instead of having say 100 000 rows that all have the formulas in them calculating eveything all the time, if most of the previously calculated values from say 3 weeks ago up until 20-60 minutes ago are already pre-calculated on another sheet that only updates once an hour, and then in order for the trading sheets to make new calculations based on old calculations it would only have to take into account the first few rows of the longer term spreadsheet. That is why I was wondering if itwould lighten the processing load for the rest of the time when the historical values are not updating?