StockFetcher Forums · Filter Exchange · Need help to write filter<< >>Post Follow-up
DIL0579
7 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
84 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

Fetcher[
apply to symlist (aapl)


set{low1, low 1 day ago}
set{low2, low 2 day ago}
set{low3, low 3 day ago}
set{low4, low 4 day ago}
set{low5, low 5 day ago}
set{low6, low 6 day ago}

set{m1,max(low1,low2)}
set{m2,max(m1,low2)}
set{m3,max(m2,low3)}
set{m4,max(m3,low4)}




add column separator
add column low1
add column low2
add column low3
add column low4
add column low5
add column low6
add column separator
add column m4

]



xarlor
417 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:

Fetcher[
/* Highest Low in last 10 days */
set{L10DH,low 10-day high}

/* Flashy stuff and things */
not otcbb
add column L10DH {Highest Low in Last 10 days}
draw price line at L10DH
]



redversa721
84 posts
msg #157563
Ignore redversa721
9/12/2021 1:39:05 PM

Nice Xarlor.. hahaha . Should have known there is a better way :)

nibor100
818 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.

Fetcher[
add column low 10-day high {Highest Low past 10 days}
]



the next 1 liner adds the price line drawing at 10 day highest Low

Fetcher[
add column low 10-day high {Highest Low past 10 days} draw price line at low 10 day high
]



the next 1 liner adds filtering for only lows greater than $100, note SF overrides my column header label

Fetcher[
add column low 10-day high is greater than 100 {Highest Low past 10 days}
]



my final 1 liner adds filtering for those 10 day highest Lows that occurred today

Fetcher[
add column low 10-day high is equal to low
]



redversa721
84 posts
msg #157575
Ignore redversa721
9/13/2021 2:26:42 PM

Beautiful.. Thanks

snappyfrog
415 posts
msg #157577
Ignore snappyfrog
9/13/2021 10:49:45 PM

nibor100

awesome, some great ideas for me to work with now!

DIL0579
7 posts
msg #157578
Ignore DIL0579
9/13/2021 11:26:53 PM

Thank you redversa721, Xarlor, Nibor100 , Brilliant!

Cheese
1,260 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


StockFetcher Forums · Filter Exchange · Need help to write filter<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2021 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.