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 587 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,044 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 731 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
|