Can any one Help me on this formula - Can any one Help me on this formula Options  Email this topic  Watch this topic  Print this topic » Normal Threaded

Previous Topic Next Topic

majoo		#1 Posted : Tuesday, June 24, 2014 12:37:11 PM(UTC)
Rank: Newbie Groups: Registered, Registered Users Joined: 4/5/2014(UTC) Posts: 5		Greetings, Appreciate if any one can help me in writing the formula to get the following: Volume average of 3 days Expo is less than the avg of 15 days Expo. so i need to have the output for the only stocks that has been traded in the last 3 days less than the 15 days. Thanks
User Profile View All Posts by User View Thanks

	Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.

majoo		#2 Posted : Wednesday, June 25, 2014 1:35:15 PM(UTC)
Rank: Newbie Groups: Registered, Registered Users Joined: 4/5/2014(UTC) Posts: 5		Appreciate the help.
User Profile View All Posts by User View Thanks

mstt		#3 Posted : Wednesday, June 25, 2014 3:01:44 PM(UTC)
Rank: Advanced Member Groups: Registered, Registered Users, Subscribers Joined: 7/25/2005(UTC) Posts: 1,042 Was thanked: 57 time(s) in 54 post(s)		Hi majoo It's the "Expo" part of the question that prevents me from offering any suggestions - I have no idea what that means. Nobody wants to answer the "wrong" question and look like an idiot, so a little more detail please. Roy
User Profile View All Posts by User View Thanks

MS Support		#4 Posted : Wednesday, June 25, 2014 3:03:28 PM(UTC)
Rank: Advanced Member Groups: Moderators, Registered, Registered Users, Subscribers Joined: 10/8/2010(UTC) Posts: 1,960 Thanks: 92 times Was thanked: 155 time(s) in 150 post(s)		majoo wrote: Greetings, Appreciate if any one can help me in writing the formula to get the following: Volume average of 3 days Expo is less than the avg of 15 days Expo. so i need to have the output for the only stocks that has been traded in the last 3 days less than the 15 days. Thanks You may want to check out the Formula Primer as it should be able to provide some building blocks for constructing fairly simple formulas. https://www.metastock.com/customer/resources/formulas/primer.aspx The MOV function can be used with any data, so the formula would simply be: Mov(V,3,E) < Mov(V,15,E)
User Profile View All Posts by User View Thanks

majoo		#5 Posted : Saturday, June 28, 2014 9:22:42 AM(UTC)
Rank: Newbie Groups: Registered, Registered Users Joined: 4/5/2014(UTC) Posts: 5		Hi Roy, I am really sorry for not being clear Expo is "EXPONENTIAL", i will be grateful id you can assist on this.
User Profile View All Posts by User View Thanks

majoo		#6 Posted : Saturday, June 28, 2014 9:26:56 AM(UTC)
Rank: Newbie Groups: Registered, Registered Users Joined: 4/5/2014(UTC) Posts: 5		Thanks Administrator for your help i will go for the learning also.
User Profile View All Posts by User View Thanks

mstt		#7 Posted : Saturday, June 28, 2014 4:52:42 PM(UTC)
Rank: Advanced Member Groups: Registered, Registered Users, Subscribers Joined: 7/25/2005(UTC) Posts: 1,042 Was thanked: 57 time(s) in 54 post(s)		Hi majoo Oops, I'll know for next tine. Roy
User Profile View All Posts by User View Thanks

majoo		#8 Posted : Wednesday, July 2, 2014 3:20:50 PM(UTC)
Rank: Newbie Groups: Registered, Registered Users Joined: 4/5/2014(UTC) Posts: 5		Thank you all for your great support, i started to learn how to write formula. Thank you Roy and Administrator
User Profile View All Posts by User View Thanks

Users browsing this topic

Guest (Hidden)