Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 06:00:08 +0000



Post From: Data Limiting = 1 day and Spreadsheet Minimum Chart Bars Required = 1 bar

[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