Support Board
Date/Time: Tue, 26 Nov 2024 02:42:05 +0000
Spreadsheet Column H Calculation Order?
View Count: 244
| [2024-01-11 21:39:37] |
| j4ytr4der_ - Posts: 938 |
|
Spreadsheets calculate in a specific order, as outlined in the documentation: Spreadsheet Systems, Alerts and Automated Trading: Order of Formula Column Processing and Internal Calculation Order It states: When the formula results in columns K through Z (last formula column by default) are processed for Trade Order or Alert signals by the Spreadsheet System for Trading or Spreadsheet System/Alert studies, column K is evaluated first, then L, then M, and so on through and including the last formula column (by default column Z).
But what about column H? When is it calculated? |
| [2024-01-11 21:39:59] |
| j4ytr4der_ - Posts: 938 |
|
Ad for that matter what about formulas in column J?
|
| [2024-01-11 22:26:06] |
| Sierra_Chart Engineering - Posts: 17179 |
|
This is outside the scope of our support. Because the calculation order is going to be determined upon the cell formulas and how they reference each other. It is quite complex how it all works.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2024-01-11 22:26:23
|
| [2024-01-11 22:46:59] |
| j4ytr4der_ - Posts: 938 |
|
I see, yes that makes sense if there are any calculations that reference other cells etc. But for the sake of this question, let's assume any formulas in H only reference J (for rounding floating points, etc.). Does it basically follow that columns calculate from left to right, top to bottom? So H1:Hxxx first, then J1:Jxxx, K - Z, etc.?
|
| [2024-01-13 18:20:28] |
| sgne - Posts: 105 |
|
I eventually put all order logic in col. J, below row 113. Column H experiences auto-delete when the number of spreadsheet rows is reduced to a small value for purposes of replay. Any values in col. H below the last row with DT.OHLCV data just disappear. I decided not to put any order logic out in remote columns (like CA, etc.) in case calculations there are significantly slower. |
| [2024-01-13 21:11:23] |
| j4ytr4der_ - Posts: 938 |
|
Yep I noticed the same about column H, annoying so I'm just used to copying and pasting it back after reducing bars. Using column J below the dynamic data is a worthy idea though, thanks for sharing!
|
| [2024-01-14 01:28:41] |
| Sawtooth - Posts: 4120 |
|
I eventually put all order logic in col. J, below row 113.
That will work, until SC adds new items in Column J.A few years ago there were no items below row 80. |
To post a message in this thread, you need to log in with your Sierra Chart account: