| DIL0579 9 posts
 msg #157555
 - Ignore DIL0579
 | 9/11/2021 10:40:04 PM 
 I want to find out highest value among the ( low for last 10 days).
 I am not able to create the expression. Is this possible? pl help!
 
 
 | 
| redversa721 157 posts
 msg #157558
 - Ignore redversa721
 | 9/12/2021 5:16:44 AM 
 Try this
 Caveat is i only have the basic subscription [so I can run for last 5 days]  , so you will need an advanced subscription to get more days into your filter
 
 Also you will also want to add low of today as well to include today's low
 
 Maybe there is a one line code for this, but I could not find one now, but this should work for you in a jiffy
 
 
 
 
 
 | 
| xarlor 619 posts
 msg #157559
 - Ignore xarlor
 | 9/12/2021 11:57:29 AM 
 See my response in this post as it answers your question: https://bfleqgs.stockfetcher.com/forums/General-Discussion/What-is-wrong-with-this-filter/151491
 
 As for your specific solution:
 
 
 
 
 
 | 
| redversa721 157 posts
 msg #157563
 - Ignore redversa721
 | 9/12/2021 1:39:05 PM 
 Nice Xarlor.. hahaha . Should have known there is a better way :)
 
 
 | 
| nibor100 1,099 posts
 msg #157574
 - Ignore nibor100
 | 9/13/2021 1:59:17 PM 
 For those who like 1 line solutions that don't use Set statements, I offer several:
 Ed S.
 
 
 
 
 the next 1 liner adds the price line drawing at 10 day highest Low
 
 
 
 
 the next 1 liner adds filtering for only lows greater than $100, note SF overrides my column header label
 
 
 
 
 my final 1 liner adds filtering for those 10 day highest Lows that occurred today
 
 
 
 
 
 | 
| redversa721 157 posts
 msg #157575
 - Ignore redversa721
 | 9/13/2021 2:26:42 PM 
 Beautiful.. Thanks
 
 
 | 
| snappyfrog 749 posts
 msg #157577
 - Ignore snappyfrog
 | 9/13/2021 10:49:45 PM 
 nibor100
 
 awesome, some great ideas for me to work with now!
 
 
 | 
| DIL0579 9 posts
 msg #157578
 - Ignore DIL0579
 | 9/13/2021 11:26:53 PM 
 Thank you redversa721, Xarlor, Nibor100 , Brilliant!
 
 
 | 
| Cheese 1,374 posts
 msg #157579
 - Ignore Cheese
 | 9/13/2021 11:38:40 PM 
 /*
 https://www.stockfetcher.com/forums/Filter-Exchange/Need-help-to-write-filter/157555
 
 low 10-day high
 only lows greater than $100
 */
 ====================================================================
 
 Thank you, xarlor and Ed S
 
 
 
 |