Support Board
Date/Time: Tue, 04 Mar 2025 18:16:50 +0000
Post From: Spreadsheet for trading, persistent data is reset when a cell is modified.
| [2021-12-16 23:40:09] |
| User346098 - Posts: 47 |
|
Using this example 1. Put this formula in cell H3: =AND(OR(H3=TRUE,H4>1),H5) mine I put in P3 instead I am using this to prevent K3 from becoming TRUE, what I am doing is if stop price is hit then, disable K3 for good until I reset the lock MANUALLY Simple example: $H$10 has my Stop Loss price P3 cell: =AND(OR(ID0.SG4@3<=$H$10,P3),$H$7=0) H7 is a cell I manually turn on and back off to reset the lock state and in K3 I am checking for P3 state ... this WORKS fine, the issue is that if LAST price travels back ABOVE the stop (meaning ID0.SG4@3<=$H$10 condition is FALSE AGAIN) AND I work on the sheet modify some cells, the LOCK IS RESET it's like P3 cell previously saved TRUE value is set back to 0 if any cell on the sheet is modified it recalculates the spreadsheet possibly? and resets and previous saved value ? Date Time Of Last Edit: 2021-12-16 23:46:22
|