Registered User Joined: 4/16/2005 Posts: 18
|
Tried setting up the Personal Criteria Formula to search for signficant volume and price changes over the last 10 days as outlined by Sir Methodical. When I do, I always get negative values when testing it.
The formula given was (avgV10/avgV50.10)*(((C-C10)/C10)-1)*100
After trying several times I came up with a formula which gives me positive values but am not sure it is pertinent. Would appreciate your comments.
(avgV10/avgV50.10)*(((C/C10)-1)*100)
Sam
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Bruce and I cannot make sense of the '-1' part of the formula. Try this, it should work as he describes:
(AVGV10/AVGV50.10)*((C/C10)-1)
If the stock was up in the last 10 days, the result will be a positive number.
- Craig Here to Help!
|