Support Board
Date/Time: Sun, 24 Nov 2024 09:03:07 +0000
[User Discussion] - Buy/Sell signal at last bar close yesterday are trigger today when the market was open.
View Count: 1757
| [2013-09-26 23:30:10] |
| Amit Levy - Posts: 9 |
|
Hello Support, I have this error when this situation is appear : If on the last bar at bar close 1 day ago have Buy/Sell Signal (I used buy/sell at close). When the market is opened on the next day at the morning same signal from yesterday are trigger at bar open. My first trade at the next morning will continue with the signal buy/sell from yesterday at bar close signal. I like to start trading at first Buy/Sell signal if they appear at bar close on the next day and do not continue from the last signal from bar close at yesterday. I use this formula at column j29 (Flatten and Cancel Working Orders (read/write): =J41-INT(J41)>TIMEVALUE("15:55:00")to close all buy/sell signal 5 minute before market will closed. I want to trade only the same day signals appear from 9:30AM until 16:00PM. How can I do that? I changed the parameters on chart settings at session time to be always between working hours without loading weekend data. Please Advice, Thanks alot, L.A Date Time Of Last Edit: 2013-09-26 23:31:24
|
| [2013-09-28 08:17:02] |
| |
|
It sounds as though you need to look at the current date in the Buy/Sell formulas and ignore any signals from Spreadsheet rows that are in the prior day. You can get the date of a row from column A.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2013-09-28 08:17:45
|
| [2013-09-28 15:02:55] |
| Amit Levy - Posts: 9 |
|
Hello Support, I used this formula to buy: =OR(CROSSFROMBELOW(AA3:AA4,AI3:AI4),CROSSFROMBELOW(AA3:AA4,AJ3:AJ4),CROSSFROMBELOW(AA3:AA4,AK3:AK4),CROSSFROMBELOW(AA3:AA4,AL3:AL4)) How can i add your solution to this line? To buy or sell at current day and ignore any signals from Spreadsheet rows those are in the prior day. Please Advice, Thanks. |
| [2013-09-29 12:50:16] |
| Sawtooth - Posts: 4118 |
|
Try this: =AND(INT(A3)=INT(A4),OR(CROSSFROMBELOW(AA3:AA4,AI3:AI4),CROSSFROMBELOW(AA3:AA4,AJ3:AJ4),CROSSFROMBELOW(AA3:AA4,AK3:AK4),CROSSFROMBELOW(AA3:AA4,AL3:AL4))) |
To post a message in this thread, you need to log in with your Sierra Chart account: