Support Board

Date/Time: Sun, 05 May 2024 18:18:02 +0000

Post From: How to handle non-standard sessions in back testing?

[2019-12-02 17:07:31] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
I would like to either be able to just skip non-standard sessions, or flatten at a specific time on only short sessions The only solution is to create a table of dates/times to skip, then compare J41 to each date in the table, then sum the column, then reference that sum in your entry formulas. The table would probably need to be on an added sheet that is not associated with a chart. I would love to just ensure that no position is carried past the close on a Friday Use a formula in J29 that utilizes the WEEKDAY function. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#WEEKDAY_Function