Support Board

Date/Time: Sat, 04 May 2024 22:54:17 +0000

Buy the close if condition on Spreadsheets trading backtests

[2020-04-13 21:08:38] #1 [Go To First Post]
JDMontero - Posts: 34
Hi, How do I get the Spreadsheets to buy the close of a bar if conditions are met in that bar?? It seems easy to me on very basic platforms compared to SC, like TOS or TradeStation, but for some reason I have been having enormous trouble trying to get absolute exactitude running a simple code in Spreadsheets bar based backtest like buy if close higher than open and sell if close lower than the open... I get crazy trades if I do that. (Yet is it very simple in TradeStation or TOS...) I try the buy if C>O and sell if C<O without the Strict signal on bar close on Spreadsheet settings of course, because then I get the trades made at the next open, which is exactly what I am trying to avoid. I wish to buy the close of the bar that has C>O, and exit at the close of the bar that has C<O Please advise because I know SC is way better than the next thing and I am the one not getting the hang of things. This is what I get from column K =E3>B3, column L =E3<B3: http://www.sierrachart.com/image.php?Image=1586811869200.png

To post a message in this thread, you need to log in with your Sierra Chart account: