Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 18:36:34 +0000



Post From: Update cell value when condition is true

[2013-11-21 20:04:15]
Sawtooth - Posts: 4119
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