Discussions
»
Product and Service Development
»
Formula Assistance
»
CONTROLING A SIMPLE MOVING AVERAGE WITH SAY AN ATR?
Rank: Newbie
Groups: Registered, Registered Users
Joined: 3/21/2008(UTC)
Posts: 3
|
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?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/13/2004(UTC)
Posts: 673
Location: Salt Lake City, UT
|
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);
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 3/21/2008(UTC)
Posts: 3
|
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.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
CONTROLING A SIMPLE MOVING AVERAGE WITH SAY AN ATR?
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
