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 |