StockFetcher Forums · General Discussion · how do I add a cummulative total to a scan<< >>Post Follow-up
smartguy
27 posts
msg #99258
Ignore smartguy
2/19/2011 6:35:25 PM

I want to be able to add up the rsi(2) of 2 days ago + rsi(2) of 1 day ago + rsi(2) of today = 3day total of these values. I then want to be able to scan for stocks with this 3 day total less then a value I choose i.e. 15 (example - stocks whose rsi(2) cummulative total for the last 3 days is 15 or less). I also want to be able to display this number with it's chart and to be able to sort the stocks that meet this criteria from lowest to highest. How do I write this in stockfetcher code- thanks for your help in advance.

Kevin_in_GA
4,550 posts
msg #99263
Ignore Kevin_in_GA
2/19/2011 7:09:32 PM

2/19/2011 6:35:25 PM

I want to be able to add up the rsi(2) of 2 days ago + rsi(2) of 1 day ago + rsi(2) of today = 3day total of these values. I then want to be able to scan for stocks with this 3 day total less then a value I choose i.e. 15 (example - stocks whose rsi(2) cummulative total for the last 3 days is 15 or less). I also want to be able to display this number with it's chart and to be able to sort the stocks that meet this criteria from lowest to highest. How do I write this in stockfetcher code- thanks for your help in advance.

++++++++++++++++++++++++++++++

Fetcher[
set{rsi1a, rsi(2) + rsi(2) 1 day ago}
set{rsisum, rsi1a + rsi(2) 2 days ago}

rsisum below 5

add column rsisum {3 day total}
add column Bollinger %B(20,2)
sort on column 5 ascending

close above 1
average volume(50)above 250000
]



8 hits for Friday. I added a column that tells you where the close was relative to the upper/lower Bollinger bands. I would look for both low rsisum values and a close at or below the lower BB.

smartguy
27 posts
msg #99270
Ignore smartguy
2/19/2011 11:46:21 PM

kevin_in_GA- thank you for you help. Many thanks.

StockFetcher Forums · General Discussion · how do I add a cummulative total to a scan<< >>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 2016 - 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