Login Page - Create Account

Support Board


Date/Time: Tue, 30 Apr 2024 02:16:23 +0000



Post From: Update cell value when condition is true

[2013-11-21 20:04:15]
Sawtooth - Posts: 3985
The only way to capture with a spreadsheet the occurrence of each trade that meets a condition it to use a 1 tick chart. Set the Number of Trades Per Bar to 1.

=F3>n
This would be TRUE or FALSE

=IF(F3>n,A3,0)
This would grab the datetimestamp