StockFetcher Forums · Announcements · More Math Functions Available << >>Post Follow-up
 stockfetcher977 postsmsg #32061 5/13/2004 10:47:21 AMBelow is a list of mathematical functions available for your StockFetcher filters: abs(IND): return the absolute value of the input measure. Fetcher[abs(close minus open) is above 2.0] log(IND): take the natural log of the input measure. Fetcher[log(RSI(14)) reached a new 6 week high] log10(IND): take the loge, base-10 of the input measure. Fetcher[log10(RSI(14)) reached a new 6 week high] max(IND1,IND2): return the maximum of two values. Fetcher[ show stocks where max(MACD Fast Line, MACD Slow Line) crossed above 0 and draw MACD ] min(IND1,IND2): return the minimum of two values. Fetcher[ show stocks where min(RSI(14),Smoothed RSI(14)) is above 60 and draw Smoothed RSI(14) ] sign(IND): return just the sign (1,-1) of the input measure. Fetcher[sign(MACD Fast Line) equals 1] sum(IND,LENGTH): return the sum of a measure, over the specified length. Fetcher[ set{diff, close - close 1 day ago} set{product, diff * volume}, show stocks where sum(product,10) crossed above 0 ] Please let us know if there are any that you would like to use, but do not see above! Thank you, StockFetcher.com Support TheRumpledOne6,371 postsmsg #32097- Ignore TheRumpledOne 5/15/2004 1:33:38 PMNice work!! Question: Is length in days for the following? sum(IND,LENGTH): return the sum of a measure, over the specified length. parttimer1 postsmsg #32316- Ignore parttimer 6/10/2004 11:30:35 AMHow about having the max and min functions to be applicable over a period of time like the sum function? That is: min(ind, LENGTH) max(ind, LENGTH) I can use Donchian channel concept to achieve this for price, but not for volume and other indicators.... Also I noticed that when I use add column with the sum function it works, but the min and max functions are not recognized by the add column... such that add column min(PVO(1,60) 1 day ago,PVO(1,60)) does not work, whereas add column sum(PVO(1,60),3) does work. I also can't use the user defined variables with the add column function... Thanks. cegis235 postsmsg #32317- Ignore cegis 6/10/2004 11:49:13 AMparttimer, Can't you just use "ind LENGTH day high" and "ind LENGTH day low"? (e.g., price 15 day high = max(price,15); volume 30 day low = min(volume,30)) HTH, C MrBid16 postsmsg #36417- Ignore MrBid 6/23/2005 4:53:28 AMWhat about modulo and round functions ???? gudway13 postsmsg #109714- Ignore gudway 12/30/2012 6:55:46 PMPlease Mark === for correct filters and xxx for incorrect filters Low > Low 5 day low 1 day ago Low > Close 5 day low 1 days ago Low > Low 5 day Close 1 day ago Low > High 5 day Close 1 day ago Low > Close 5 day High 1 days ago Low > Open 5 day Close 1 day ago Close > Low 5 day low 1 day ago High > Close 5 day low 1 days ago Open > Low 5 day Close 1 day ago Any rules pertaining to thie kind of filter?
 StockFetcher Forums · Announcements · More Math Functions Available << >>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.