Registered User Joined: 10/26/2006 Posts: 34
|
Looking for % from days high is the close.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Daily Indicator Formula:
100 * (C / H - 1)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 10/26/2006 Posts: 34
|
QUOTE (Bruce_L)
Please try the following Daily Indicator Formula:
100 * (C / H - 1)
what would it be in excel?
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I have no idea what the structure of your spreadsheet might be. If column A is the date, and columns B, C, D, E are the open, high, low and close, it would be something like:
=100 * E1 / C1 - 100
That said, we do not support third party products and I really can't help you with Excel formulas.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|