Simple 52 week low in last 4 weeeks

• 07/02/2017 at 6:49 AM #39568
  croc49

  Not having much luck with trying to find 52 week lows in last 4 weeks, then sieve through them for incremental rises one week at a time (52 week low < close[15] and close [10] > close [15] and close [5] > close [10] and close [0] > close [5] …….if you get my drift.

  Also, can’t seem to make ProScreener produce weekly charts, always defaults to daily. I do set TIMEFRAME(Weekly)

  

  croc49

  Participant

  Topics: 2

  Replies: 5

  Been thanked: 2 times
  07/02/2017 at 9:12 AM #39569
  GraHal

  Easiest way to get help is to put your full code on here (using <> Insert PR Code button). Then any helpful member could copy and run your code on their Platform and report back on what results they get?

   

  

  GraHal

  Participant

  Topics: 211

  Replies: 8774

  Been thanked: 2180 times
  07/02/2017 at 12:30 PM #39581
  croc49

  Sorry to be a pain, but I can’t get to first base.

  I’m new at this and I can’t see <> insert PR code button.

  You’ll notice I’m hung up on finding close value for 52 week low.

  What I’m after is each week for 4 weeks greater than that 52 week low., and I’m getting mixed results.

  In other words, I only want a +ve graph only.

  As I mentioned, the output is always daily although I put in TIMEFRAME(Weekly)

  TIMEFRAME(Weekly)
  // find 52 week low
  ll = Lowest[250](close)

  // closing price 4 weeks ago
  close20 = close[20]

  // closing price 3 weeks ago
  close15 = close[15]

  // closing price 2 weeks ago
  close10 = close[10]

  // closing price 1 week ago
  close5 = close[5]

  // closing price today
  close0 = close[0]

  SCREENER[ll<close20 and close20<close15 and close15<close10 and close10<close5 and close5<close0]

  

  croc49

  Participant

  Topics: 2

  Replies: 5

  Been thanked: 2 times
  07/02/2017 at 12:36 PM #39582
  GraHal

  You have coded a Screener, but you say …. I only want a +ve graph only … the result / ouput of a Screener is a Table so your mention of a graph confuses me.

  Please can you add (on this page) a screen shot of your graph so we can see what you are talking about?

  Also please can you add a screen shot of the buttons that you do see? Attached are the buttons I see.

  

  GraHal

  Participant

  Topics: 211

  Replies: 8774

  Been thanked: 2180 times
  07/02/2017 at 11:16 PM #39600
  GraHal

  TIMEFRAME(Weekly) // find 52 week low ll = Lowest[250](close) // closing price 4 weeks ago close20 = close[20] // closing price 3 weeks ago close15 = close[15] // closing price 2 weeks ago close10 = close[10] // closing price 1 week ago close5 = close[5] // closing price today close0 = close[0] YearLow = (ll<close20) and (close20<close15) and (close15<close10) and (close10<close5) and (close5<close0) SCREENER (Yearlow)

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

  TIMEFRAME(Weekly) // find 52 week low ll = Lowest[250](close)   // closing price 4 weeks ago close20 = close[20]   // closing price 3 weeks ago close15 = close[15]   // closing price 2 weeks ago close10 = close[10]   // closing price 1 week ago close5 = close[5]   // closing price today close0 = close[0]   YearLow = (ll<close20) and (close20<close15) and (close15<close10) and (close10<close5) and (close5<close0)   SCREENER (Yearlow)

   

  

  GraHal

  Participant

  Topics: 211

  Replies: 8774

  Been thanked: 2180 times
  07/03/2017 at 1:11 AM #39612
  croc49

  I appreciate your patience. I did find the <> button (was looking for some text as well) – getting there.

  It is a Screener that I’m after.

  The theory being that if price hits bottom and turns more than 20% in weekly, it is an established trend, and will probably keep going.

  Attached is a type of graph that I would like to see in the qualifiers in ProScreener.

  Scoured through multitudes of examples but none seem to touch the subject.

  I tried your solution which seems to me to do pretty much the right thing, but the 52 week bottom isn’t 5 weeks ago.

  Added my tweak in <> box, but I didn’t get if/then/else right.

  Some weeks still produce lower than the week before.

  Also the damn TIMEFRAME stills spits out daily.

  Is it that Proscreener will only do dailys, because I’ve looked all over settings and can’t find a switch

  TIMEFRAME(Weekly) // find 52 week low bottom250 = Lowest[250](close) // closing price 5 weeks ago close25 = close[25] IF close25 = bottom250 THEN bottom = close25 ENDIF // closing price 4 weeks ago close20 = close[20] // closing price 3 weeks ago close15 = close[15] // closing price 2 weeks ago close10 = close[10] // closing price 1 week ago close5 = close[5] // closing price today close0 = close[0] YearLow = (bottom<close20) and (close20<close15) and (close15<close10) and (close10<close5) and (close5<close0) SCREENER (Yearlow)

  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

  TIMEFRAME(Weekly) // find 52 week low bottom250 = Lowest[250](close)   // closing price 5 weeks ago close25 = close[25] IF close25 = bottom250 THEN bottom = close25 ENDIF   // closing price 4 weeks ago close20 = close[20]   // closing price 3 weeks ago close15 = close[15]   // closing price 2 weeks ago close10 = close[10]   // closing price 1 week ago close5 = close[5]   // closing price today close0 = close[0]   YearLow = (bottom<close20) and (close20<close15) and (close15<close10) and (close10<close5) and (close5<close0)   SCREENER (Yearlow)

   

  ?

  

  croc49

  Participant

  Topics: 2

  Replies: 5

  Been thanked: 2 times
  07/03/2017 at 9:32 AM #39648
  Nicolas

  The screener condition must be enclosed in square brackets instead of parenthesis:

  SCREENER [Yearlow]

  1	SCREENER [Yearlow]

   

  1 user thanked author for this post.

  GraHal

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  07/03/2017 at 12:05 PM #39673
  GraHal

  On a Weekly TF the line below is looking for the lowest 5 years ago.

  bottom250 = Lowest[250](close)

  1	bottom250 = Lowest[250](close)

  I still don’t know what you mean  …  the damn TIMEFRAME stills spits out daily … a picture tells a thousand words, can you add a screencapture of what you mean?

  Weekly work fine for me … are you using the setting attached? When I click on a result I get a chart with the x axis in weeks (each bar is a week apart). What is the period between each bar on your x axis axis when you click on a result after screening on Weekly TF?

  ,

  

  GraHal

  Participant

  Topics: 211

  Replies: 8774

  Been thanked: 2180 times
  07/03/2017 at 12:27 PM #39676
  GraHal

  Below is the code I am using on a Weekly TF with ALL Commodities and ALL Indices selected and attached are my results … do you get the same / similar?

  //TIMEFRAME(Weekly) // find 52 week low ll = Lowest[52](close) // closing price 4 weeks ago close20 = close[20] // closing price 3 weeks ago close15 = close[15] // closing price 2 weeks ago close10 = close[10] // closing price 1 week ago close5 = close[5] // closing price today close0 = close[0] YearLow = (ll<=close20) and (close20<=close15) and (close15<=close10) and (close10<=close5) and (close5<=close0) SCREENER [Yearlow]

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

  //TIMEFRAME(Weekly) // find 52 week low ll = Lowest[52](close)   // closing price 4 weeks ago close20 = close[20]   // closing price 3 weeks ago close15 = close[15]   // closing price 2 weeks ago close10 = close[10]   // closing price 1 week ago close5 = close[5]   // closing price today close0 = close[0]   YearLow = (ll<=close20) and (close20<=close15) and (close15<=close10) and (close10<=close5) and (close5<=close0)   SCREENER [Yearlow]

   

   

  

  GraHal

  Participant

  Topics: 211

  Replies: 8774

  Been thanked: 2180 times
  07/03/2017 at 1:44 PM #39696
  croc49

  Probably bitten off more than I can chew with so many variables.

  I think what I’m trying to nail down in Proscreener is a ticker that had a 52 week low say 4 or 5 weeks ago and everything since then is +ve.

  If I can nail that, I understand how to manipulate the weeks in between.

  As I’ve said previously, I have scoured the PDF lessons, and through lots of examples but none seem to play with 52 week low.

  My latest attempt is listed – I still can’t nail that recent 52 week low with a few rises – see my graph

  My objective – The theory being that if price hits bottom and turns more than 20% in weekly, it is an established trend, and will probably keep going.

  latest version to get recent 52 week low

  TIMEFRAME(Weekly) // find 52 week low bottom250 = Lowest[250](close) CLOSE0 = Close[0] if close0 > bottom250 then bottom = close0 endif SCREENER [bottom]

  1 2 3 4 5 6 7 8

  TIMEFRAME(Weekly) // find 52 week low bottom250 = Lowest[250](close) CLOSE0 = Close[0] if close0 > bottom250 then bottom = close0 endif SCREENER [bottom]

   

  

  croc49

  Participant

  Topics: 2

  Replies: 5

  Been thanked: 2 times
  07/03/2017 at 2:57 PM #39704
  GraHal

  Yeah it all sounds good, but with  Lowest[250](close) on a Weekly TF you are screening for the lowest in the last 250 weeks which is 5 years!

  

  GraHal

  Participant

  Topics: 211

  Replies: 8774

  Been thanked: 2180 times
  07/03/2017 at 3:09 PM #39705
  Nicolas

  If you want to find a 52 weeks low, why are you looking back through 250 periods?

  To find that current close has turned more than 20% since the last 52 weeks low, you could give a try with:

  TIMEFRAME(Weekly) // find 52 week low bottom250 = Lowest[52](close) // price has retrace more than 20% since the bottom condition = close/bottom250>=1.2 SCREENER [condition] (close/bottom250 as "retrace%")

  1 2 3 4 5 6 7

  TIMEFRAME(Weekly) // find 52 week low bottom250 = Lowest[52](close) // price has retrace more than 20% since the bottom condition = close/bottom250>=1.2   SCREENER [condition] (close/bottom250 as "retrace%")

   

  1 user thanked author for this post.

  GraHal

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  07/04/2017 at 12:26 AM #39741
  croc49

  Thank you for the help. I think I understand the concept I’m after a lot better.

  Will play around for a while and repost when I’m done.

  I certainly had the wrong idea about a couple of things.

  2 users thanked author for this post.

  Nicolas, GraHal

  

  croc49

  Participant

  Topics: 2

  Replies: 5

  Been thanked: 2 times
• Author
  Posts