Support Board
Date/Time: Sat, 14 Feb 2026 22:06:43 +0000
Post From: Spreadsheet latch cell
| [2025-12-29 20:59:43] |
| TraderGD - Posts: 13 |
|
There are three cell references in the Sierra Chart example above. I have transposed those cells as follows; Sierra Chart K3 = My spreadsheet's T3 Sierra Chart H3 = My spreadsheet's U3 Sierra Chart E3 = My spreadsheet's V3 There are two formulas in the Sierra Chart Example which I transposed to the columns I am using in my spreadsheet; Formula #1 Sierra's version =OR(E3=10,K3>0) My version =OR(V3=10,T3>0) Formula #2 Sierra version =AND(OR(E3=10,K3>0),H3=FALSE) My version =AND(OR(V3=10,T3>0),U3=FALSE) There is one change that I made in my formula before I put it into my spreadsheet. Instead of using the number “10”, I am using the number “1”. Therefore, the actual formulas in my spreadsheet are as follows: Formula #1 Sierra's version =OR(E3=10,K3>0) My version =OR(V3=1,T3>0) Formula #2 Sierra version =AND(OR(E3=10,K3>0),H3=FALSE) My version =AND(OR(V3=1,T3>0),U3=FALSE) In cell V3 I have entered “=1”. The column U in my spreasheet continuously turns from 1 to 0 to 1 to 0, over and over. I have attached a PDF with colors showing the cell transposition, and a video that shows the cells going back and forth from 1 to 0. Date Time Of Last Edit: 2025-12-29 21:04:34
|
 Rev1 Latch Cell Issue.pdf - Attached On 2025-12-29 20:58:36 UTC - Size: 183.57 KB - 39 views Private File |