StockFetcher Forums · Filter Exchange · Is it possible to do conditional sums at all<< >>Post Follow-up
styliten
7 posts
msg #149588
Ignore styliten
modified
11/14/2019 1:49:04 AM

So as to analyze trends in the most recent 10/15/20 days:

A1 = sumIF(day change > 1, 10)

Vs

B1 = sumIF(day change < -1, 10)

KSK8
453 posts
msg #149589
Ignore KSK8
11/14/2019 8:22:12 AM

Would this be what you are looking for?

Fetcher[

market is NASDAQ

set{day_change_positive, count(Day Change > 0,1)}
set{a1, sum(day_change_positive,10)}
add column a1

set{day_change_negative, count(Day Change < 0,1)}
set{b1, sum(day_change_negative,10)}
add column b1


]



StockFetcher Forums · Filter Exchange · Is it possible to do conditional sums at all<< >>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