StockFetcher Forums · Announcements · More Math Functions Available<< >>Post Follow-up
stockfetcher
980 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,411 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

    add column sum(PVO(1,60),3) does work.

    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


    MrBid
    16 posts
    msg #36417
    Ignore MrBid
    6/23/2005 4:53:28 AM

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


    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.