Home >> Support Board

Support Board

Date/Time: Fri, 19 Apr 2024 20:40:01 +0000

How to Post a Message for Support

[User Discussion] - spreadsheet question

View Count: 996

[2014-08-05 19:18:50] #1 [Go To First Post]
User021827 - Posts: 174
Hi How would you flatten positions at a certain time with spreadsheet trading ? regards

[2014-08-05 19:33:18] #2 [Go To First Post]
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] #3 [Go To First Post]
User021827 - Posts: 174
Thanks Vegas ! what happens with vegasfoster, stays with vegasfoster ! best regards

[2014-08-05 22:28:02] #4 [Go To First Post]
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] #5 [Go To First Post]
User021827 - Posts: 174
hi Ok, thanks again good info shane

[2014-08-05 23:53:51] #6 [Go To First Post]
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] #7 [Go To First Post]
Sawtooth - Posts: 3975
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: