max draw down screener based on close

• 09/03/2018 at 10:41 AM #79619
  jrh_han

  i like to screen shares and to sort those screened out by max draw down. but i fail to write the code as i have no idea how to realise the conditions as described below:

  maxdrawdown = (highest[…](close) – lowest[…](close)) / ( highest[…](close) * 100

  Conditions:

  1. the lowest…close must be occured later than the the highest…close – it shall represent the max. loss risk if the share was bought on highest close in that period
  2. as soon as a new highest…close is reached after a past lowest…close, this becames valid for the maxdrawdown calculation in combination with the lowest…close occured after this new high was reached etc.

  The criteria for sorting shall be the maxdrawdown occured during the last 254 days or 254 weeks.

  I would appreciate your support.

  Thanks in advance.

  Roger

   

  

  jrh_han

  Participant

  Topics: 5

  Replies: 6

  Been thanked: 0 times
  09/03/2018 at 12:38 PM #79633
  Nicolas

  Ok, not so easy at first glance.. let me think of it so I can give a try to find you a relevant code.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4774 times
  09/03/2018 at 12:59 PM #79637
  Nicolas

  So basically, you want the max spread between the overall max price and minimum price occurred in the last 254 days? Or do you want to use periods to limit the found highest and lowest prices?

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4774 times
  09/03/2018 at 2:28 PM #79649
  jrh_han

  I attached an illustration with some examples.

  What I am looking for is a sorting criteria – i. e. max. DrawDown in the last year, max. Drawdown in the last month etc.

  This is not the period just to calculate highest[period](price) minus lowest[Period](price). In this period serveral DrawDowns may occur – and I just want for each share the biggest / smallest as sorting criteria.

  If its not getting clearer please let me know – than I try to explain it better.

  

  jrh_han

  Participant

  Topics: 5

  Replies: 6

  Been thanked: 0 times
  09/03/2018 at 3:04 PM #79657
  Nicolas

  Visually, your chart is clear and I’ve understood what you are trying to get, but how do you find tops and bottoms? Basically what are the green and red arrows?

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4774 times
  09/03/2018 at 3:43 PM #79662
  jrh_han

  Looking on the chart I just recognise that it is visually clear to me, but I doesn’t believe, that there could be any mathematical description for it.

  So i try to simplify:

  Top = highest[Period](high)

  Low = lowest … (low) – AFTER the top AND before the next top = between current and next top.

  Any idea if this could be realised?

   

  

  jrh_han

  Participant

  Topics: 5

  Replies: 6

  Been thanked: 0 times
  09/03/2018 at 4:05 PM #79664
  Nicolas

  You can give a try with this screener:

  screener

  period = 50 top = highest[Period](close) if top<>top[1] then topbar=barindex bot=1000000 endif bot = min(bot,close) if topbar>0 then maxspread=max(maxspread,(top-bot)/top*100) endif test = maxspread>0 screener[test](maxspread)

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

  period = 50   top = highest[Period](close)   if top<>top[1] then topbar=barindex bot=1000000 endif   bot = min(bot,close)   if topbar>0 then maxspread=max(maxspread,(top-bot)/top*100) endif   test = maxspread>0   screener[test](maxspread)

  I used Close instead of high, because it was how you explained it the first time, you can change the price serie if you want to.

  And an indicator to confirm the calculation and see how and when the max spread between highest high and the low was found:

  indicator

  defparam calculateonlastbars=254 period = 50 top = highest[Period](close) if top<>top[1] then topbar=barindex bot=1000000 endif bot = min(bot,close) if topbar>0 then maxspread=max(maxspread,(top-bot)/top*100) endif return maxspread

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

  defparam calculateonlastbars=254   period = 50   top = highest[Period](close)   if top<>top[1] then topbar=barindex bot=1000000 endif   bot = min(bot,close)   if topbar>0 then maxspread=max(maxspread,(top-bot)/top*100) endif   return maxspread

   

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4774 times
  09/04/2018 at 9:41 AM #79708
  jrh_han

  Great – the indicator does exactly what I intended.

  But not so the screener. The screener just takes into account the “last” maxspread fromm current high to current low. The previous highs / lows are not taken into account.

  

  jrh_han

  Participant

  Topics: 5

  Replies: 6

  Been thanked: 0 times
  09/04/2018 at 12:31 PM #79738
  Nicolas

  The screener does the same, always saving the highest maxspread, please verify on stocks that you have a live data subscription (not “End Of Day”). Bear in mind that ProScreener only have 254 bars of history available.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4774 times
  09/04/2018 at 2:02 PM #79758
  jrh_han

  It works.

  Thx a lot

  

  jrh_han

  Participant

  Topics: 5

  Replies: 6

  Been thanked: 0 times
• Author
  Posts