Support Board
Date/Time: Fri, 27 Dec 2024 15:38:05 +0000
[User Discussion] - spreadsheet study and time
View Count: 921
| [2015-12-22 01:07:16] |
| User175327 - Posts: 36 |
|
hi- i am trying to write buy/sell entries based upon certain criteria being met at the open....specifically within 5 minutes of the open. i have been through several threads on the support board but cant get this to work. not sure what i am doing wrong....=AND($J$41>=TIMEVALUE("08:00:00"),($J$41<=TIMEVALUE("08:10:00"),(id0.sg4@3>id3.sg1@3)).... this is where i am. i only want the spreadsheet to look at the first 5 minutes after the open and include at least one other qualifier like the example, but i can't get it to work. any help would be super!!
|
| [2015-12-22 04:41:02] |
| Sawtooth - Posts: 4143 |
|
Try this: =AND($J$41>=TIMEVALUE("08:00:00"),$J$41<=TIMEVALUE("08:10:00"),(id0.sg4@3>id3.sg1@3) |
| [2015-12-23 02:43:23] |
| User175327 - Posts: 36 |
|
Hi, thanks for the response but that still does not seem to work. This is the current equation i am using: =AND($J$41>=TIMEVALUE("08:00:00"),$J$41<=TIMEVALUE("08:10:00"),CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@4,ID3.SG1@3:ID3.SG1@4)) the ending part works just fine all on its own but when i couple it with the time constraint it doesnt return any signals. Any ideas?! |
| [2015-12-23 03:57:49] |
| Sawtooth - Posts: 4143 |
|
If you are expecting an arrow, it will only appear in Replay or in real time because J41 is the chart's update DateTime.
|
| [2015-12-23 21:36:44] |
| User175327 - Posts: 36 |
|
It does not appear in replay as well, for some reason the time command negates any signal from occurring. I have it written exactly as above and it does not work in replay. Again, the "crossfrom...signal is fine until I add the time part to the equation.
|
| [2015-12-23 22:05:17] |
| Sawtooth - Posts: 4143 |
|
Oops. Use this instead: =AND($J$41-INT($J$41)>=TIMEVALUE("08:00:00"),$J$41-INT($J$41)<=TIMEVALUE("08:10:00"),CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@4,ID3.SG1@3:ID3.SG1@4)) J41 includes the date and time, and the TIMEVALUE function is only the time, so $J$41-INT($J$41) is needed to remove the date and leave only the time. |
| [2016-01-04 20:40:16] |
| User175327 - Posts: 36 |
|
Thank you very much!! That works and is exactly what I wanted. Is there a way to limit the signal to only fire once per day, possibly with (J7=0) where the prior position must have equaled 0, though this does not seem to update on a per day basis, rather after each trade..... Thanks!! |
| [2016-01-05 00:49:58] |
| Sawtooth - Posts: 4143 |
|
Take a look at this thread: Multiple Entries |
To post a message in this thread, you need to log in with your Sierra Chart account: