Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 05:59:36 +0000

How to Post a Message for Support

Post From: Bar Based Back Testing

[2014-10-27 06:04:44]
[Go To First Post]
jivetrader - Posts: 395
my Excel-based backtest starts, but sits at 0%, hanging the program. pressing ESC to cancel does not work. the program does not respond!

in the spreadsheet study, number of lines is set to 30, a very small amount.

here are my row3, col K-T formulas (O-R are helpers; S&T are stop loss values):
K =IF(AND(BV3<>0,BV3>O3,D3<P3),TRUE,"")
L =AND($J$8>0,BU4<>0)
M =IF(BU3<>0,AND(BU3<Q3,C3>R3),"")
N =AND($J$8<0,BV4<>0)
O =IF(BV4<>0,BV4,O4)
P =IF(BV3<>0,INDEX(D3:D20,MATCH(O3,BV3:BV20,0),1),"")
Q =IF(BU4<>0,BU4,Q4)
R =IF(BU3<>0,INDEX(C3:C20,MATCH(Q3,BU3:BU20,0),1),"")
S =AND($J$8>0,$E$3<=$J$9-$DV3*$S$1,"")
T =AND($J$8<0,$E$3>=$J$9+$DV3*$S$1,"")