Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

7-13-2005 Worden post question Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
formyira
Posted : Tuesday, February 21, 2006 5:46:09 PM
Registered User
Joined: 8/30/2005
Posts: 3
I was reviewing some posts I had not read and came across one I need some help determining where I am going wrong. The report was posted on 7-13-2005 by Sir Methodical were he presented a PCF to determine the relative volume times the % price change over a 10 bar period. I have no problem with the relative volume part of the formula
(AvgV10/Avg50.10)
however I'm not getting the % price change for 10 bars portion of the formula
(((C-C10)/C10)-1)*100.

If I assume that stock XYZ closed at 28 ten days (bars) ago, then a 2% increase from that close would be 28.56 for today (i.e. (28.56 - 28)/28 = .02)
This is where my confusion sets in. Where does the -1 in the formula come from? Should the formula just be (((C-C10)/C10)*100) to give a 2 % increase?
If I calculate the formula strictly as posted the result would give -98 (i.e. (((28.56 - 28)/28)-1)*100 ).

Thanks in advance for pointing out the "obvious" to everyone but me and resolving my confusion.

Harv
Bruce_L
Posted : Tuesday, February 21, 2006 6:11:28 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I would tend to agree with your analysis. The formula mentioned appears to be a mix of two other rather popular formula formats to calculate Price Percent Change (and would not be correct as is):

100 * (C - C10) / C10

or:

100 * (C / C10 - 1)

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
formyira
Posted : Tuesday, February 21, 2006 7:01:47 PM
Registered User
Joined: 8/30/2005
Posts: 3
Thanks for the reassurance, Bruce. I was afraid that "modern math" had whipped me again.
Harv
Users browsing this topic
Guest-1

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.