StockFetcher Forums · General Discussion · I've asked this before with no luck<< >>Post Follow-up
zaq777
19 posts
msg #142421
Ignore zaq777
2/23/2018 2:16:56 PM

Will try again hopefully someone knows.

Suppose you have two lines (for example a moving ave. and a Bollinger band) on a chart and while might you want to see the price close above both for the first time, that doesn't always happen. Sometimes it will cross one and then the other a day or two later.

So how do I construct a search for both happening together for the first time within a certain period of time without regard to which happens first?

four
5,087 posts
msg #142422
Ignore four
modified
2/23/2018 3:01:35 PM

https://www.stockfetcher.com/sfforums/?mid=122375
OR
1st chart: no look back -OR- 2nd chart look back and line drawn to identify location easier


OR


olathegolf
113 posts
msg #142438
Ignore olathegolf
2/24/2018 5:25:18 PM

zaq777,
Is this what you're looking for?
Just edit the number of lookback days.

Fetcher[
Average Volume(30) above 500000
close above 5

/*Set number of days for the initial lookback - say 3 days*/
set{a,count(close crossed above ma(10) 3 days ago,1)}
set{b,count(close crossed above Upper Bollinger Band(20,2) 3 days ago,1)}

/*Add both a and b together. If result above 0, the event triggered by one or both 3 days ago*/
set{MAorBBcross,a+b}
MAorBBcross above 0

/*Next you want to make sure that both events occurred at least once over the last 3 days*/
set{d,count(close crossed above ma(10),3)}
set{e,count(close crossed above Uper Upper Bollinger Band(20,2),3)}

/*Multiply d and e together to indicate that the even occurred for both over the last 3 days*/
set{MAandBBcross,d*e}
MAandBBcross above 0

/*Update Chart*/
draw ma(10)
draw Upper Bollinger Band(20,2) on plot price
draw MAorBBcross
draw MAandBBcross
]



zaq777
19 posts
msg #142445
Ignore zaq777
modified
2/25/2018 9:13:10 AM

A better way of putting the question.

How do I find when two or more indicators or situations on a chart coincide for the first time in a set number of days?

Did x AND y happen today? Yes
Did x AND y happen yesterday or any other day recently? No

Did x happen before today? Maybe
Did y happen before today? Maybe

I haven't yet tried the current suggestions and will tomorrow.

olathegolf
113 posts
msg #142449
Ignore olathegolf
2/25/2018 3:38:26 PM

Try this one. I think it's what you had in mind.
Nice little filter for breakouts. Pop.....

Fetcher[
Average Volume(30) above 500000
close above 5

/*Set number of days for the lookback - say 3 days*/
set{a,count(close crossed above ma(10) 3 days ago,1)}
set{b,count(close crossed above Upper Bollinger Band(20,2) 3 days ago,1)}

/*Multiply both a and b together. If result is 1, both events triggered 3 days ago*/
set{MAandBBcross,a*b}
MAandBBcross above 0

/*UBB*/
set{ubb,Upper Bollinger Band(20,2)}

/*Update Chart*/
draw ma(10)
draw Upper Bollinger Band(20,2) on plot price
draw MAandBBcross

/*Update Table*/
add column close 1 day ago
add column close
add column ma(10) 1 day ago
add column ma(10)
add column ubb 1 day ago
add column ubb
]



olathegolf
113 posts
msg #142450
Ignore olathegolf
2/25/2018 3:44:54 PM

I saw that mahkoh posted on your other discussion post. I agree that your best to look back at filters from other members. You'll learn fastest that way. Kevin_in_GA is no longer on SF but you'll find his work to be an encyclopedia of useful information. He also organized things so his filters are easy to follow.

zaq777
19 posts
msg #142462
Ignore zaq777
modified
2/26/2018 9:05:24 AM

I see his answer from 2014 was good after all. I misremembered that.

Thanks.

The problem for me is how incomprehensible the advanced format is.


Thank you everyone who gave it a shot.

StockFetcher Forums · General Discussion · I've asked this before with no luck<< >>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 2018 - 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.