Support Board
Date/Time: Mon, 23 Dec 2024 12:01:05 +0000
[User Discussion] - Time based order SS
View Count: 1694
| [2015-09-30 13:30:09] |
| MadCashflow - Posts: 5 |
|
Good day everyone, I am currently looking to find a way to send order based strictly on the time it is with the spreadsheet. Ex: Buy AAPL at 13:00. I tried to include the bar end time study, which allow a value depending on the time it is for each row, Ex: 13:00 = 0.654444 on the indicator cell. For the entry row I've then entered ''=AA1=0.654444''. Pretty simple and it should be working, but the cell is showing False value, even if it is True. When I click on the indicator cell to edit, and just press enter, now the entry cell of the row is showing True, but no data has been changed... I thought maybe it would automatically refresh like it does when I click on the Ind Cell during a backtest, but zero order sent. Perhaps somebody can explain to me why it is doing so, or show me another way to send order based on the time. Thanks |
| [2015-09-30 14:08:20] |
| Sawtooth - Posts: 4141 |
|
You'll need to compare the Bar End Time to the chart update time. Use cell J41, like this in cell K3: =AND($J$41-INT($J$41)>=AA3,$J$41-INT($J$41)<AA3+1/1440) This gives a 1 minute window for an entry because there might not be a chart update exactly at the top of the hour. You could also do it without the Bar End Time study: =AND($J$41-INT($J$41)>=TIMEVALUE("13:00:00"),$J$41-INT($J$41)<TIMEVALUE("13:01:00")) In a fast market like AAPL, you could alter the window to something less, like this 10 second window starting 1 second before 13:00 =AND($J$41-INT($J$41)>=TIMEVALUE("12:59:59"),$J$41-INT($J$41)<TIMEVALUE("13:00:09")) Date Time Of Last Edit: 2015-09-30 14:15:48
|
| [2015-10-01 00:53:30] |
| MadCashflow - Posts: 5 |
|
Tom, It now works exactly the way I wanted. Thank you very much for the help. Have good trades. |
To post a message in this thread, you need to log in with your Sierra Chart account: