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,046 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
|