Support Board
Date/Time: Thu, 28 Nov 2024 21:49:03 +0000
Post From: Restart of spreadsheets calculations on new session.
| [2023-03-31 18:15:45] |
| John - SC Support - Posts: 36350 |
|
You can control the number of "Bars" that are calculated within the spreadsheet through the Input for Number of Rows. Refer to the following: Spreadsheet Study Inputs: Number of Rows If you are wanting to only have a particular calculation performed on the current session, then you would have to add a test for the Date and/or Time (depending on when exactly you want to start the calculation) and add that into your calculation. For example, to test if the Day of the month is the same as today's day of the month, you would enter the following: =DAY(TODAY()) You can then use this with an IF statement to only get calculations for bars that are on the same day of the month as today, for example: = IF(DAY(A3) = DAY(TODAY()), X, Y) Where X is the calculation you want when true and Y is the calculation/value you want when false (typically 0). For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |