指定
I need an excel backtesting code that can run through O, H, L, C and check for a given TP and SL.
My technical knowledge lacks somewhat, so I do not know if this is possible with IF funcitons, or if a macro or something is needed...
From any given price point of my choosing I would like the the code to check thorugh the prices from that point onwards, and find where it hits the given SL or TP.
Please see my excel for what I want.
I will determine Entrys by plotting MACD indicator onto the excel, then use IF functions to determine whether to trade. I would need to be able to copy the formula across the whole column, I do not want to have to do it individually each time.
Let me know if initerested, thanks
反馈
1
等级
项目
218
50%
仲裁
6
17%
/
67%
逾期
11
5%
空闲
2
等级
项目
49
22%
仲裁
14
29%
/
21%
逾期
13
27%
空闲
3
等级
项目
17
35%
仲裁
1
0%
/
100%
逾期
3
18%
空闲
4
等级
项目
395
28%
仲裁
155
20%
/
52%
逾期
112
28%
空闲
5
等级
项目
134
27%
仲裁
62
13%
/
53%
逾期
58
43%
空闲
发布者: 293 文章, 1 代码
6
等级
项目
81
83%
仲裁
1
0%
/
0%
逾期
29
36%
空闲
7
等级
项目
0
0%
仲裁
0
逾期
0
空闲
项目信息
预算
10 - 40 USD
截止日期
1 天