Support Board
Date/Time: Tue, 24 Mar 2026 06:11:37 +0000
Post From: Update cell value when condition is true
| [2013-11-21 20:04:15] |
| Sawtooth - Posts: 4321 |
|
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 |