Support Board
Date/Time: Mon, 25 Nov 2024 04:21:01 +0000
Data Limiting = 1 day and Spreadsheet Minimum Chart Bars Required = 1 bar
View Count: 130
| [2024-10-21 06:22:32] |
| User745789 - Posts: 316 |
|
After a lot of trouble shooting I think I have found a problem For spreadsheet trading, set "Minimum Chart Bars Required For Entry Exit Cell Evaluation" = 1 Then set Chart Settings > Data Limiting > Days to load for intraday chart type = 1 With this config, I do not get any spreadsheet orders printing on the chart for the second bar, and in enhanced logging I get a strange message as follows: "Buy Entry | Signal ignored because current Alert Condition is TRUE | Cell: K3" Why would an entry signal be ignored when the condition is TRUE? I am not sure this is related to my problem. But if I change "days to load" to say 5, then my spreadsheet correctly prints entry orders on the chart for the second bar as expected. I would really like to always have "days to load" set to 1, but in that case my spreadsheet doesn't work properly. |
| [2024-10-21 16:14:28] |
| John - SC Support - Posts: 36238 |
|
We do not think these things are related. It sounds like your Entry/Exit formulas have a dependency on having additional days of data loaded. You would need to look at your setup to determine why this would be the case. We are also not sure what you are referencing in terms of the "second bar". Are you only loading one day of data in your chart, so the actual second bar shown in the chart, or are you wanting to get a signal relative to the bar before the most current bar in the chart? As to the notice of "Buy Entry | Signal ignored because current Alert Condition is TRUE | Cell: K3" this is because a formula must go from False to True in order to be considered an actual signal. Staying True does not give a signal. The option for "Reset Formula on New Bar" forces a False state to exist when a new bar is started and then the formula is evaluated and if True, then it has gone from False to True which gives the correct signal. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-10-22 06:39:30] |
| User745789 - Posts: 316 |
|
It sounds like your Entry/Exit formulas have a dependency on having additional days of data loaded. You would need to look at your setup to determine why this would be the case.
We are also not sure what you are referencing in terms of the "second bar". Are you only loading one day of data in your chart, so the actual second bar shown in the chart, or are you wanting to get a signal relative to the bar before the most current bar in the chart? It is a simple opening range breakout. I need the first bar to set the opening range and place my stop entry orders at the extremes. Therefore I need to use Minimum Chart Bars Required For Entry Exit Cell Evaluation = 1 If Days to load for intraday chart type = 1 (all that is required) then my orders do not get generated. |
| [2024-10-22 14:30:29] |
| John - SC Support - Posts: 36238 |
|
Please get us a Chart that is setup for this situation and the Spreadsheet file you are using for this and we will take a look. Follow these instructions to attach the files to this thread: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-10-23 05:01:00] |
| User745789 - Posts: 316 |
|
Attached. The yellow lines mark the opening range +/- 1 tick. Bars to load is set to 5. The session starts at 8:45am. The orders will appear on the screen at 09:00am after the first bar of the session is finished. Now set bars to load to 1, and the orders no longer appear. I just tested both on this CB and that is what I observed. Hopefully you see the same. |
Private File |
| [2024-10-23 14:23:00] |
| John - SC Support - Posts: 36238 |
|
We need the spreadsheet file for this as well. It is named 'ORB_precash_SS' and will be in your 'Data' folder under your main Sierra Chart installation folder.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-10-24 05:32:53] |
| User745789 - Posts: 316 |
|
Attached spreadsheet
|
Private File |
| [2024-10-24 22:51:55] |
| John - SC Support - Posts: 36238 |
|
To start with, the spreadsheet you gave us has the Input for "Minimum Chart Bars Required for Entry Exit Cell Evaluation" set to 10, and you had 5 days of data being loaded. When we recreated the situation you have first stated, with "Minimum Chart Bars Required for Entry Exit Cell Evaluation" set to 1 and 1 day data loaded, the spreadsheet worked exactly as expected. Here is exactly what we did. Set the "Days to Load" to 1. Set the Session Times to the following: - Start Time: 17:00:00 - End Time: 21:59:59 (not that it matters) - Bar Period: 15 minutes (per your chart) - Changed your Buy Entry formula (cell K3) to be the following: -- =FRACTIME(MROUND(A3,1/86400))>=TIMEVALUE("17:15:00") When the second bar in the chart started at 17:15:00, the Buy Entry cell (K3) changed from a 0 to a 1. We are not seeing any issues with your setup. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-10-25 06:10:34] |
| User745789 - Posts: 316 |
|
When the second bar in the chart started at 17:15:00, the Buy Entry cell (K3) changed from a 0 to a 1.
I agree, I see the same.... BUT, in backtest replay mode, no orders are generated and no fills take place if Days to Load = 1 I have confirmed this on my side multiple times. If Minimum Chart Bars Required For Entry Exit Cell Evaluation = 1 and Days to load = 1 Then no orders are generated in replay, and no entries take place. There are no orders in the Trade Orders Window either. If you set Days to load = 5, then orders are generated. |
To post a message in this thread, you need to log in with your Sierra Chart account: