Do my backtest is good enough??

[guru]

i got the data from yahoo finance

So you are not including companies that no longer exist and that you would lose most money on.

if i limit my trade with stock that have volume $100M/day

Yes, but your Excel shows that you can make $billions or $trillions, so automatically you can see that your calculations are incorrect because it is not possible to trade so much money without affecting the price, even when daily volume is $100M. You cannot buy all $100M of shares by yourself and still have $trillions to spend.
Also, with $100M volume only $100K-$1M may be traded near the day's lowest price as many traders compete for the same shares.

Anyway, for now your results are the same as everyone else's at one point or another. There are thousands of people posting the same results when they are learning. After several months or years you will fix some issues and understand more, but no else can look at your data and algo and find all the problems.

 

[Snuskpelle]

No i did not factor in commission and slippage, but its annual return are 10 times and its in daily timeframe so i think slippage and commissions not effect too much

Slippage on market orders can be massive in small stocks (several percent even), and that's why those "inefficiencies" appear to exist in a naïve simulation. Passive limit orders or more advanced orders like peg to midpoint orders will not fill reliably (in fact, you will be the target of adverse selection). The fact that your estimated annuals return is >1000% makes no difference, slippage applies to every single transaction you make.

Save yourself additional trouble for nothing and go implement a slippage simulation before doing anything else. You can test actual slippage on a real account, or piggyback the sim of e.g. Interactive Brokers' paper account, or otherwise have a look at the typical buy-ask spread wherever shows that.

On a side note, environments with well tested slippage/fee simulations are massive time savers for beginners for this reason. You get to skip the fairytale phase where you dream of becoming a billionaire within a few years due to broken simulations - leaving that phase can take time since it's such an appealing fantasy.

 

[Peter8519]

The key issue with backtesting is static data. Depending on the lot size, the live market will react to the bid and ask.

 

[Snuskpelle]

The key issue with backtesting is static data. Depending on the lot size, the live market will react to the bid and ask.

I would agree, but he's at the stage where he doesn't even model static bid-ask spreads.

 

[Grandeurtrader]

Backtesting does not include the "psychological anxiety/money pressure" (and how it alters your behavior/discipline/hope) you'll experience when trading for real.

Trade small at first and work your way up. No need to be in a hurry to get rich. It will all still be there when you are ready.

When "psychological anxiety/money pressure" is in your equation, then your system is not completed, and you dont backtest enough, thats why you feel anxiety in your trading, because your system not completed that lead to your fear and distrust to your own system

Most likely you are peeking into the future somewhere without noticing. Also, there's no good reason NOT to account for commissions in a backtest. Slippage is more complicated.

Yes thank you for your advise, i think i am need to recalculate my system again, i should start my calculation from Close candle 0, while it should be on Open candle +1

So you are not including companies that no longer exist and that you would lose most money on.

Yes, but your Excel shows that you can make $billions or $trillions, so automatically you can see that your calculations are incorrect because it is not possible to trade so much money without affecting the price, even when daily volume is $100M. You cannot buy all $100M of shares by yourself and still have $trillions to spend.
Also, with $100M volume only $100K-$1M may be traded near the day's lowest price as many traders compete for the same shares.

Anyway, for now your results are the same as everyone else's at one point or another. There are thousands of people posting the same results when they are learning. After several months or years you will fix some issues and understand more, but no else can look at your data and algo and find all the problems.

Can you tell me where i can get data on companies that no longer exist?? Since seems yahoo is not providing it

I would agree, but he's at the stage where he doesn't even model static bid-ask spreads.

thank you for your advise, what average spreads should i use, 0.5% from Close price is good enough?? since i am using excel to backtest i only can use static spreads

 

[Scataphagos]

Can you tell me where i can get data on companies that no longer exist??

I cannot. I won't mess with any issue not included at Stockcharts.com.

 

[smallfil]

Hindsight is fine because you have the benefit of already seeing what happened. In real life trading, you have to make decisions on what to do in anticipation of what is going to happen in the future, 3 days from now, 30 days from now, 60 days from now, 1 year from now, etc. This is why paper trading for practical purposes is useless. Better to risk small amounts and test your trading system in real life conditions including, slippage which is substantial. Then, check your results based on your real life trades. This is more relevant and reflects what could have happened to your actual trades without the benefit of hindsight.

 

[d08]

Yes thank you for your advise, i think i am need to recalculate my system again, i should start my calculation from Close candle 0, while it should be on Open candle +1

Do you discard trades when you don't have enough funds to cover all entries? If yes, that is a potential source of peeking into the future.
For example dip buyers that rely on daily data. They will randomly pick trades on any given day up to the amount of equity available. Trouble is, during a down trending day with significant declines, you'd get positions that are completely unrealistic.

 

[Dicer]

I am backtesting 3700 stock, all start from their listing in exchange until 2 weeks ago. With Reward:Risk ratio 2:1, i got 27129 Win Trade 43640 Lost trade, or 38.3346% win rate, if i trade every trade opportunity i will got enormous return that even excel cant handle the number. Is that real?? i mean how to make its more close to reality beside doing real time trading?? what kind of backtesting i need to do to make its close enough to reality, so i can get profitable result when doing real time trading

If you are using daily data (lower frequency data), you need to think whether your strategy is explainable or interpretable.

 

[floridaeaton]

You can probably include the commission rates and a few other things because the difference between demo and live would be something else. If you want a proper analysis, you should probably include other factors in your assessment.
Check if the platform is suitable for a particular strategy like the price action, range trading, scalping, swing trading, etc.