Support Board
Date/Time: Sat, 18 Jan 2025 22:55:36 +0000
Post From: Flat to Flat Average price with Scale out Profits factored in it
| [2017-03-14 00:09:40] |
| Sawtooth - Posts: 4154 |
|
A persistent variable can be created in a spreadsheet study by a formula like this, e.g. in cell P3: =IF(condition1,variable1,P4) Based on what you are doing, you shouldn't need another IF to release it. The idea is to bring the value to row 3 which is the current price bar. Starting a persistent variable (#2 in post #7) in the row where the entry occurred will require an absolute reference to J42, comparing it to the time in column A. You may want to extract the time of day from the serial datetime like this: =$J$42-INT($J$42) =A3-INT(A3) |