Overcoming the lack of tick by tick data with simulation.

• 12/08/2018 at 3:01 PM #86566
  Vonasi

  I wrote a long only daily strategy that bought at calculated support prices and sold at resistance prices and that required the use of tick by tick data as it used LIMIT and STOP pending orders. It looked great but using tick by tick limited the data sample to starting from just August 2010. The strategy never bought and sold on the same day so I decided to write an indicator that simulated the strategy so that I could test further back – this way I could have a much bigger data sample to test on. Obviously this will only work if your strategy has no zero bar trades – that is ones that open and close in the same bar.

  As well as graphing my simulated equity curve I graphed my ‘onmark’ variable multiplied by the equity to show when the simulated strategy was on market.

  

  Here is the simulated bit of code – I have removed the actual main parts of the strategy:

  Spread = 3.8 //simulated entry if not onmark and close[1] > supportprice[1] and low < supportprice and open > supportprice and filter then entryprice = supportprice onmark = 1 stoplossprice = (my calculated stoploss price) endif //simulated win exit if onmark and high > resistanceprice then exitprice = resistanceprice onmark = 0 equity = (equity + (exitprice - entryprice)) - spread endif //simulated hit stoploss if onmark and low < stoplossprice then exitprice = stoplossprice onmark = 0 equity = (equity + (exitprice - entryprice)) - spread endif if onmark then floatingequity = (equity + (close - entryprice)) else floatingequity = equity endif return floatingequity coloured(0,0,255) style(line,2) as "Equity", (onmark * floatingequity) coloured(0,128,0,150) style(histogram,2) as "OnMarket"

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

  Spread = 3.8   //simulated entry if not onmark and close[1] > supportprice[1] and low < supportprice and open > supportprice and filter then entryprice = supportprice onmark = 1 stoplossprice = (my calculated stoploss price) endif   //simulated win exit if onmark and high > resistanceprice then exitprice = resistanceprice onmark = 0 equity = (equity + (exitprice - entryprice)) - spread endif   //simulated hit stoploss if onmark and low < stoplossprice then exitprice = stoplossprice onmark = 0 equity = (equity + (exitprice - entryprice)) - spread endif   if onmark then floatingequity = (equity + (close - entryprice)) else floatingequity = equity endif   return floatingequity coloured(0,0,255) style(line,2) as "Equity", (onmark * floatingequity) coloured(0,128,0,150) style(histogram,2) as "OnMarket"

  Obviously my strategies entry and exit points are very simple to simulate and so if your strategy is very complicated then simulating it might not be quite so easy – but I post this here just in case someone else might find the concept useful for their own back testing of any strategy with STOP and LIMIT pending orders and no zero bar entry and exits.

  Technically this is an indicator but as it is really a strategy equity curve I post it here rather than in the indicator section.

  1 user thanked author for this post.

  Nicolas

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  12/08/2018 at 3:23 PM #86570
  Vonasi

  I made some slight improvements by adding a buy and hold line and also calculating the win rate and average gain per trade. In fact this is better than the PRT results as you can see historically how the win rate and average return has been rather than just the final totals.

  

  Spread = 3.8 //simulated entry if not onmark and close[1] > supportprice[1] and low < supportprice and open > supportprice and filter then entryprice = supportprice onmark = 1 stoplossprice = (my calculated stop loss price) endif //simulated win exit if onmark and high > resistanceprice then exitprice = resistanceprice onmark = 0 equity = (equity + (exitprice - entryprice)) - spread endif //simulated hit stoploss if onmark and low < stoplossprice then exitprice = stoplossprice onmark = 0 equity = (equity + (exitprice - entryprice)) - spread if equity > equity[1] then win = win + 1 count = count + 1 endif if equity < equity[1] then count = count + 1 endif endif if onmark then floatingequity = (equity + (close - entryprice)) else floatingequity = equity if equity > equity[1] then win = win + 1 count = count + 1 endif if equity < equity[1] then count = count + 1 endif endif buyandhold = buyandhold + (close - open) winrate = (win/count) * 100 avegain = (equity /count) return floatingequity coloured(0,0,255) style(line,2) as "Equity", buyandhold as "Buy and Hold", winrate as "Win Rate", avegain as "Average Gain", (onmark * floatingequity) coloured(0,128,0,150) style(histogram,2) as "OnMarket"

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49

  Spread = 3.8   //simulated entry if not onmark and close[1] > supportprice[1] and low < supportprice and open > supportprice and filter then entryprice = supportprice onmark = 1 stoplossprice = (my calculated stop loss price) endif   //simulated win exit if onmark and high > resistanceprice then exitprice = resistanceprice onmark = 0 equity = (equity + (exitprice - entryprice)) - spread endif   //simulated hit stoploss if onmark and low < stoplossprice then exitprice = stoplossprice onmark = 0 equity = (equity + (exitprice - entryprice)) - spread if equity > equity[1] then win = win + 1 count = count + 1 endif if equity < equity[1] then count = count + 1 endif endif   if onmark then floatingequity = (equity + (close - entryprice)) else floatingequity = equity if equity > equity[1] then win = win + 1 count = count + 1 endif if equity < equity[1] then count = count + 1 endif endif   buyandhold = buyandhold + (close - open)   winrate = (win/count) * 100 avegain = (equity /count)   return floatingequity coloured(0,0,255) style(line,2) as "Equity", buyandhold as "Buy and Hold", winrate as "Win Rate", avegain as "Average Gain", (onmark * floatingequity) coloured(0,128,0,150) style(histogram,2) as "OnMarket"

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  12/08/2018 at 3:40 PM #86575
  Vonasi

  I’ve just realised that if your strategy has no zero bar issues of trades opening and closing on the same bar then by just turning off the tick by tick you will get an accurate equity graph – so my above code is a waste of time! I suppose at least with it you can see a running win rate and average gain per trade.

  I won’t delete the posts so that someone might read it and use my experience/stupidity and not waste their own time.

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  12/08/2018 at 3:48 PM #86576
  Vonasi

  I modified it to just show the win rate and average gain. Maybe it is not all wasted time.

  Interesting to note the win rate dropping but the average gain increasing.

  

  Spread = 3.8 //simulated entry if not onmark and close[1] > supportprice[1] and low < supportprice and open > supportprice and filter then entryprice = supportprice onmark = 1 stoplossprice = (my calculated stop loss price) endif //simulated win exit if onmark and high > resistanceprice then exitprice = resistanceprice onmark = 0 equity = (equity + (exitprice - entryprice)) - spread endif //simulated hit stoploss if onmark and low < stoplossprice then exitprice = stoplossprice onmark = 0 equity = (equity + (exitprice - entryprice)) - spread if equity > equity[1] then win = win + 1 count = count + 1 endif if equity < equity[1] then count = count + 1 endif endif if equity > equity[1] then win = win + 1 count = count + 1 endif if equity < equity[1] then count = count + 1 endif winrate = (win/count) * 100 avegain = (equity /count) return winrate as "Win Rate", avegain as "Average Gain"

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

  Spread = 3.8   //simulated entry if not onmark and close[1] > supportprice[1] and low < supportprice and open > supportprice and filter then entryprice = supportprice onmark = 1 stoplossprice = (my calculated stop loss price) endif   //simulated win exit if onmark and high > resistanceprice then exitprice = resistanceprice onmark = 0 equity = (equity + (exitprice - entryprice)) - spread endif   //simulated hit stoploss if onmark and low < stoplossprice then exitprice = stoplossprice onmark = 0 equity = (equity + (exitprice - entryprice)) - spread if equity > equity[1] then win = win + 1 count = count + 1 endif if equity < equity[1] then count = count + 1 endif endif   if equity > equity[1] then win = win + 1 count = count + 1 endif if equity < equity[1] then count = count + 1 endif   winrate = (win/count) * 100 avegain = (equity /count)   return winrate as "Win Rate", avegain as "Average Gain"

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  12/12/2018 at 11:32 AM #86940
  pippo999

  Great Vanosi very interisting Thing.

   

  

  pippo999

  Participant

  Topics: 1

  Replies: 29

  Been thanked: 0 times
• Author
  Posts