Post #2171 by Aussi on the Mechanical Investing board

Investment Strategies / Mechanical Investing

Unthreaded | Threaded | Whole Thread (2)

Post Reply | Report Post | Recommend It!

No. of Recommendations: 0

Using GTR1, i want to calculated the volume weighted moving average of gprc. I am trying to determine if the method proposed by Dormeier in "Investing with Volume Analysis" adds value.

E.G
((gprc(1) x agv(1,1)) + (gprc(2) x agv(2,1)) + (gprc(3) x agv(3,1))/((agv(1,1) +agv(2,1) + agv (3,1)) x 3)

I would like to do this for up to 90 days so it becomes a bit tedious. I believe it can be done with sgsum() but I am not sure of the structure to do this.

Suggestions would be appreciated.

Thanks

Aussi

Print the post

Post Reply | Report Post | Recommend It!

No. of Recommendations: 4

Looks like: adv() / average actual volume

Consider the edge cases:
constant price and volume
stock split

adv adds up the daily dollar volumes (equal to each day's actual volume multiplied by its actual closing price)
agv adds up the daily g-volumes
http://www.datahelper.com/mi/search.phtml?nofool=y...

Print the post

Post New

Unthreaded | Threaded | Whole Thread (2)

Prev | Next

Announcements

Mechanical Investing FAQ

Contact Shrewd'm
Contact the developer of these message boards.

A community forum supporting civilized, and highly helpful, self-educating investors that come together for Shrewdness and merry spirits. These message boards closely follow the look and feel of the old message boards at boards.fool.com prior to the boards redirected to discussion.fool.com. Shrewd'm is not affiliated with the comprehensive and excellent investment website, The Motley Fool (TMF), in any way. The Shrewd commmunity here has owed, and continues to owe, gratitude to The Motley Fool for nurturing a culture of jovial irreverence towards Wall St, and that tradition will continue here.