Support Board

Date/Time: Sat, 18 May 2024 07:58:48 +0000

Post From: Flat to Flat Average price with Scale out Profits factored in it

[2017-03-14 00:09:40] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
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)