Support Board
Date/Time: Sat, 10 May 2025 21:30:49 +0000
[User Discussion] - Spreadsheet System for Trading
View Count: 896
| [2015-07-01 16:21:59] |
| User49478 - Posts: 8 |
|
I compare the current bar with the previous bar within the Spreadsheet System for Trading, but when a new trading session starts I don't want the first bar of the day be compared with the last of yesterday. Is there a way to get around this? Some session reset? Thanks. |
| [2015-07-01 17:07:57] |
| TechTrader - Posts: 116 |
|
Add the 'Daily OHLC' study to your spreadsheet study. Study settings - Hide the study if required. Study settings - Reference Days Back to 0. Incorporate the following condition to your comparison say (AA3=AA4) or whichever column refers to the 'Open' column of the "Daily OHLC' study in your spreadsheet. This column retains the 'Open' value for the required session. |
| [2015-07-01 18:18:54] |
| User49478 - Posts: 8 |
|
Thanks, but I'm using 5 min bars. Anyway I think I didn't understand my own problem very well ;). The point is I'm using "Signal only on bar close", this means row 4 is monitored, my session is from 08:00 till 22:00. So when a new session starts with bar 08:00, in row 4 bar 21:55 from yesterday is monitored and acted on. This seems resolved when I start trading at 08:05:01. Correct me if i'm wrong or when there is a better solution :). |
| [2015-07-01 19:07:01] |
| TechTrader - Posts: 116 |
|
Post #2 will work with any intraday bar. If row 4 is the previous session 'Open' AA3<>AA4 and the comparison will not be made until the second bar of the session. |
| [2015-07-01 23:36:22] |
| TechTrader - Posts: 116 |
|
Another solution is to utilise the 'Chart Start Time' J75 and the 'Seconds Per Bar' J36 from your spreadsheet. The following formula will add one intraday bar to the Chart Start Time. AND(MOD(TEXT(A3,"HH:MM:SS"),100)>$J$75+1/(86400/$J$36)) |
| [2015-07-02 09:10:55] |
| User49478 - Posts: 8 |
|
Thanks, that's a nice one.
|
To post a message in this thread, you need to log in with your Sierra Chart account: