Support Board
Date/Time: Tue, 01 Jul 2025 15:57:55 +0000
Post From: Update cell value when condition is true
| [2013-11-21 20:04:15] |
| Sawtooth - Posts: 4231 |
|
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 |