Login Page - Create Account

Support Board


Date/Time: Sat, 15 Mar 2025 07:15:14 +0000



Post From: SPREADSHEETS - save last ES price to column if $tick-nyse hits 0

[2022-06-18 22:07:58]
Sawtooth - Posts: 4183
Can you tell me how in spreadsheets if and when Tick Last crossed over the 0 line, from under or above, I can track the ES price at that instance?
It's not possible with a spreadsheet study to make an intrabar value persistent.

It is only possible to lock an intrabar TRUE, using this method:
https://www.sawtoothtrade.com/example-9.html
Spreadsheet Studies Special Tasks: Locking the State of a One Time Condition