Support Board
Date/Time: Sat, 08 Feb 2025 02:54:45 +0000
Post From: Spreadsheet System - Capture a value for later use?
| [2020-06-19 14:15:03] |
| Sawtooth - Posts: 4173 |
|
Is there some way to capture the trigger value when it appears, store it on a different cell, then clear it again on exit?
It's not possible to capture an intrabar value unless it endures until close of bar. A persistent value in a spreadsheet study is only from bar to bar.You could use this method to capture an intrabar TRUE, but it is only a TRUE(1) not the value at its occurrence: Spreadsheet Studies Special Tasks: Locking the State of a One Time Condition Here is another example: https://www.sawtoothtrade.com/example-9.html How can I revert the TWC back to its original, saved state, after closing a trade that used the spreadsheet offset (J80)?
J80/J81 only sets the initial Attached Orders' target and stop offsets, and it overrides the Trade Window Config. If you leave one of these cells blank, it assumes you don't want to use it. Also, it assumes you are using a single target and a static stop.The preferred method to do what you want is: - Don't use J80 or J81. - Use your saved TWC with its target and stop and BE setting - Use the Trade Management by Study study to move the target, referencing a Formula Column/subgraph formula: Attached Orders: Study Controlled Targets and Stops This will keep your TWC and allow you to dynamically control your target. Date Time Of Last Edit: 2020-06-19 14:32:20
|