StockFetcher Forums · Announcements · More Math Functions Available << >>Post Follow-up
stockfetcher
977 posts
msg #32061
5/13/2004 10:47:21 AM

Below 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

• TheRumpledOne
6,370 posts
msg #32097
Ignore TheRumpledOne
5/15/2004 1:33:38 PM

Nice work!!

Question: Is length in days for the following?

sum(IND,LENGTH): return the sum of a measure, over the specified length.

parttimer
1 posts
msg #32316
Ignore parttimer
6/10/2004 11:30:35 AM

How 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

I also can't use the user defined variables with the add column function...
Thanks.

cegis
235 posts
msg #32317
Ignore cegis
6/10/2004 11:49:13 AM

parttimer,

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 ????
gudway
13 posts
msg #109714
Ignore gudway
12/30/2012 6:55:46 PM

Please 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.