in Search

CONTROLING A SIMPLE MOVING AVERAGE WITH SAY AN ATR?

Last post 03-26-2008, 16:10 by shadmax. 2 replies.
Sort Posts: Previous Next
  •  03-26-2008, 0:00 26746

    CONTROLING A SIMPLE MOVING AVERAGE WITH SAY AN ATR?

    I LIKE A SIMPLE MOVING AVERAGE ENVELOPE TO CAPTURE  THE PRICE PERCENTAGE ACTION THAT I WANT . HOWEVER, ONE DRAW BACK TO USING THEM SEEMS TO BE THAT IF I CREATE A TEMPLATE TO USE,  EVERY STOCK HAS THAT EXACT SAME SETTING. SO IF I CREATE  A SEARCH CRITERIA THAT PULLS UP 20 STOCKS.  I HAVE TO ADJUST THE ENVELOPE 20 TIMES. DOES ANYONE KNOW HOW TO USE SAY AN ATR VALUE TO CONTROL THIS FUNCTION? 

  •  03-26-2008, 7:17 26749 in reply to 26746

    Re: CONTROLING A SIMPLE MOVING AVERAGE WITH SAY AN ATR?

    You are referring to creating a vertical shift of the moving average based off an indicator rather than a fixed number?  It would require a custom formula, i.e.:

    {Positive Vertical Shift}

    Mov(C,30,S) + ATR(14);

    {Negative Vertical Shift}

    Mov(C,30,S) - ATR(14);

  •  03-26-2008, 16:10 26753 in reply to 26749

    Re: CONTROLING A SIMPLE MOVING AVERAGE WITH SAY AN ATR?

    THANKS  YOU PYRADIUS,

    I'LL WORK ON THIS, HOWEVER I'M THINKING THE EXAMPLE YOU GAVE WOULD THEN HAVE TO THEN BE MULTIPLIED BY A PERCENTAGE.

    SINCE I AM NEW TO MS CODING AND I WASN'T A MATH MAJOR, COMBINED WITH ITS BEEN YEARS SINCE I HAD TO DO ANYTHING HARDER THAN BALANCING MY CHECK BOOK. LOOKS LIKE I' LL HAVE MY HEAD IN THE MS FORMULA GUIDE AND MAYBE AN OLD MATH BOOK.      

     

View as RSS news feed in XML