Registered User Joined: 10/7/2004 Posts: 80
|
Has anyone created a drawdown formula?
To be graphed and sorted?
I can do it on excel, can it be done with TC?
Thanks
|
Registered User Joined: 10/7/2004 Posts: 80
|
thank you
|
Registered User Joined: 11/19/2015 Posts: 459
|
Hi, Bruce. I've looked over the links but none does what I'm looking for. Is there a way to calculate something like the "average bars spent in drawdown over x bars"? In this case, I call any new high the price to beat.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I am not sure it will really do what you want, but maybe something similar to the following?
AVG(TrueInRow(H < MAXH252, 100), 100)
You could change any of the periods, but the sum of the periods should probably be kept under 500 if you want to have enough data for the formula to calculate a value.
The first period is the period of the high. The second value is the maximum number of draw down bars being calculated. And the third period is the number of bars over which this drawdown is being averaged.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 11/19/2015 Posts: 459
|
Yes, Bruce. I think this gets at the idea perfectly. It summarized the evaluation. Thank you!
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|