Rank: Newbie
Groups: Registered, Registered Users
Joined: 5/2/2006(UTC)
Posts: 3
|
Hi Guys:
Can anyone tell me how to create a formula that calculates ( Standard Deviation / Moving Average) for the same number of days? Thanks.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Deja vu?
wabbit wrote:
Well my approach to this problem is fairly straight-forward and methodical....
[list:cbb6dfc2a3][*:cbb6dfc2a3]First, I would read the MS Users Manual that came shipped with my legitimate copy of MetaStock, then
[*:cbb6dfc2a3]I would download the Equis Formula Primer from the downloads section and work my way through it, whilst
[*:cbb6dfc2a3]Reading through this forum (yes, we know the search function has gone awry - but that will be fixed in the new forum version coming soon(?)), then
[*:cbb6dfc2a3]I would have a go at writing this indicator myself, and post a request for help here if I ran into difficulties doing any of the above (I would also post my source code so others may see where I made any mistakes, or could coach you on ways to improve your code)[/list:u:cbb6dfc2a3]
But.... that's just me. You might strike it lucky and find that someone might be kind enough to do all your work for you...
wabbit :D
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346
|
hey vnecaxa..... might need to explain than phrase for us..... ( Standard Deviation / Moving Average) ..... both standard deviation and moving average are in the indicator list.... your phrase appears to be a division of some sort.... could you better describe it..... h
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Anyone want to take a quick guess at what dividing a small number, like say SD, by a large number, like MA, will get you?
If you guessed a really small number, then you're right.
If you also said the changes in SD and MA (if they are computed on the same data array) will mean the resultant pattern is the same as that of the SD due to laws of scale, then you are even more right!
wabbit :D
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 5/2/2006(UTC)
Posts: 3
|
Not really, since the average moving average I'm using is 1500 and the standard deviation is 615. By the way, I am not using Metastock to follow stock, futures, options or anything like that. I am using it to reduce finished goods inventories in several distribution centers across the world. So far, - $ 15 million since 2005. I am tracking over 20,000 s[censored] and Metastock works great for me because it quickly let me see changes in trends without having to use a statistical package and I can quickly adjust inventory levels accordingly without affecting customer delivery rates. I bet none of you ever came up with an idea like this !
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
vnecaxa-
Honestly, no one here is a mind reader. Theoretical or non-traditional solutions with Equis software are great, I'm sure, but that's not the point of this forum. In the future, if you need help- especially regarding these novel uses, please fully disclose what it is that you are doing so that you can get the best possible answer. Otherwise, questions regarding statistical queries are probably better handled somewhere else.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 5/2/2006(UTC)
Posts: 3
|
This is the formula that was sent to me by the Technical Department of Equis:
x:=Input("Moving Average And Standard Deviation Periods",10,1000,10);
Stdev(C,x)/Mov(C,x,S)
Thanks to everybody that got involved in this request.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
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.
