Support Board
Date/Time: Wed, 27 Nov 2024 08:34:11 +0000
[User Discussion] - spreadsheet question
View Count: 1065
| [2014-08-05 19:18:50] |
| User021827 - Posts: 174 |
|
Hi How would you flatten positions at a certain time with spreadsheet trading ? regards |
| [2014-08-05 19:33:18] |
| vegasfoster - Posts: 444 |
|
Try this, In I90, "FLATTEN HOUR=" In J91, "FLATTEN MINUTE=" In J90, enter hour you want to exit, from 0 to 23 In J90, enter minute you want to exit, from 0 to 59 In J29, =IF(TIME(DAY(A3),HOUR(A3), MINUTE(A3)) >= TIME(DAY(A3),HOUR(J90), MINUTE(J91)), TRUE, FALSE) Or could simply replace HOUR(J90) and MINUTE(J91) with desired figures, e.g. for 1:00 p.m. would use, In J29, =IF(TIME(DAY(A3),HOUR(A3), MINUTE(A3)) >= TIME(DAY(A3), 13, 0)), TRUE, FALSE) |
| [2014-08-05 19:48:12] |
| User021827 - Posts: 174 |
|
Thanks Vegas ! what happens with vegasfoster, stays with vegasfoster ! best regards |
| [2014-08-05 22:28:02] |
| vegasfoster - Posts: 444 |
|
One thing, it will only update with an incoming tick, so if you have to be flat by a certain time, then you may want to set it before. How long before will depend on the instrument and type of bar chart you are using :-P |
| [2014-08-05 23:19:51] |
| User021827 - Posts: 174 |
|
hi Ok, thanks again good info shane |
| [2014-08-05 23:53:51] |
| User021827 - Posts: 174 |
|
Where can I read about I90 and J90 cells being used for flatten thanks shane Date Time Of Last Edit: 2014-08-05 23:58:46
|
| [2014-08-06 02:59:58] |
| Sawtooth - Posts: 4120 |
|
This is what I use, in cell J29: =J41-INT(J41)>TIMEVALUE("15:59:00") |
To post a message in this thread, you need to log in with your Sierra Chart account: