Support Board
Date/Time: Sun, 24 Nov 2024 19:01:34 +0000
[User Discussion] - Update cell value when condition is true
View Count: 1192
| [2013-11-21 17:01:16] |
| TastyRisk - Posts: 119 |
|
I know it's possible to do this as I've seen it mentioned on this site before... I would like to update a spreadsheetcell with the last trade that occurs with last trade volume > n. There's a few other different things that I'd like to do with this spreadsheet functionality so an example would be very welcome. Thanks. |
| [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 |
To post a message in this thread, you need to log in with your Sierra Chart account: