StockFetcher Forums · General Discussion · "Or" operand inquiry<< >>Post Follow-up
c1916
77 posts
msg #125609
Ignore c1916
10/16/2015 10:46:12 AM

I'm trying to write a simple fetcher to monitor MACD momentum on my current holdings. I would expect it to look something like this:

apply to watchlist(MASTER)
and MACD Fast Line(12,26,9) crossed below MACD Slow Line(12,26,9) within the last 3 days
or MACD Fast Line(12,26,9) is below 0
or MACD Histogram(12,26,9) is below 0

However, it does not appear that "or" is allowed as an operand, as when I run this query, the first operation has holdings that meet the criteria, but operation 2 and 3 do not, yet the entire query returns null set. I've reviewed the user guide, and there is time spent on the use of "and" (page 5), but I see nothing about "or"

Am I down the wrong path here?

SAFeTRADE
630 posts
msg #125616
Ignore SAFeTRADE
10/16/2015 12:20:49 PM

set{a, count(MACD Fast Line(12,26,9) crossed below MACD Slow Line(12,26,9) within the last 3 days,1)}
set{b, count(MACD Fast Line(12,26,9) is below 0,1)}
set{c,count(MACD Histogram(12,26,9) is below 0,1)}

set{d, a+b}
set{e,c+d}

add column e{signal}

s&p 500
draw MACD Fast Line(12,26,9)
draw e

c1916
77 posts
msg #125621
Ignore c1916
10/16/2015 4:13:53 PM

Clearly I have a lot more coding study in my future. The fact that the last time I coded professionally, it was in COBOL, and was probably 1985 also makes me feel silly.

Thanks for the quick response.

sshymko
9 posts
msg #125623
Ignore sshymko
modified
10/16/2015 7:19:58 PM

Indeed, there's a way to express the OR condition in the filters. However, it greatly complicates and obscures an otherwise natural and descriptive filtering language.

Given how common OR conditions are (the topic have been brought up on the forum over and over gain), would be great to extend the language itself rather than suggest the workaround. Internally it can be implemented as count(), summation, and comparison operators. But end users would greatly appreciate the high-level OR syntax.

Thanks in advance.

StockFetcher Forums · General Discussion · "Or" operand inquiry<< >>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 2022 - 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.