| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 9/30/2011
Posts: 788
|
I would like to have a PCF Formula with the following parameter:
Based on yesterday's closing value, the calculation of the P% value of the first higher Pivot Point.
Thank you and goodbye.
Raider45
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
So the Pivot Points are based on yesterday's closing values (this would be normal) and you want the percent that the current price would need to increase to get to the next pivot point?
100 * (IIF(3 * C >= 5 * H1 - 4 * L1 + 2 * C1, 1 / 0, IIF(3 * C >= 4 * H1 - 2 * L1 + C1, 5 * H1 - 4 * L1 + 2 * C1, IIF(3 * C >= 2 * H1 - L1 + 2 * C1, 4 * H1 - 2 * L1 + C1, IIF(3 * C >= H1 + L1 + C1, 2 * H1 - L1 + 2 * C1, IIF(3 * C >= 2 * L1 - H1 + 2 * C1, H1 + L1 + C1, IIF(3 * C >= 4 * L1 - 2 * H1 + C1, 2 * L1 - H1 + 2 * C1, IIF(3 * C >= 5 * L1 - 4 * H1 + 2 * C1, 4 * L1 - 2 * H1 + C1, 5 * L1 - 4 * H1 + 2 * C1))))))) / 3 / C - 1)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/30/2011
Posts: 788
|
Right interpretation, the formula works correctly, congratulations !
Thank you !
Best regards !
|
|
Registered User
Joined: 9/30/2011
Posts: 788
|
Yes, I would like the transformation of the percentage in the value of the first higher pivot.
Thank you and goodbye
Raider45
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I do not undrestand how your clarification differs from the original request.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/30/2011
Posts: 788
|
The formula returns the distance calculated as a percentage with respect to the first higher Pivot, the second request concerns the return of the value of the future quotation of the above mentioned first higher Pivot, to set this value as Target Price !
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following.
IIF(3 * C >= 5 * H1 - 4 * L1 + 2 * C1, 1 / 0, IIF(3 * C >= 4 * H1 - 2 * L1 + C1, 5 * H1 - 4 * L1 + 2 * C1, IIF(3 * C >= 2 * H1 - L1 + 2 * C1, 4 * H1 - 2 * L1 + C1, IIF(3 * C >= H1 + L1 + C1, 2 * H1 - L1 + 2 * C1, IIF(3 * C >= 2 * L1 - H1 + 2 * C1, H1 + L1 + C1, IIF(3 * C >= 4 * L1 - 2 * H1 + C1, 2 * L1 - H1 + 2 * C1, IIF(3 * C >= 5 * L1 - 4 * H1 + 2 * C1, 4 * L1 - 2 * H1 + C1, 5 * L1 - 4 * H1 + 2 * C1))))))) / 3
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/30/2011
Posts: 788
|
Big congratulations, thank you!
Best regards !
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |