Registered User Joined: 8/16/2015 Posts: 12
|
How can the following be accomplished:
The number of times "Condition" is true within X number of days, expressed as a percentage... so for example, if the close is greater than the open 9 of the last 10 days, the return would be 90... if the close is greater than the open 8 of the last 10 days, the return would be 80, etc., etc.
Thank you in advance.
- J
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
COUNTTRUE(C>O,10) / 10 * 100
|