• Download software • Tutorial videos
• Subscription & data-feed pricing • Class schedule


• New account application • Trading resources
• Margin rates • Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 12/18 » Formula / Condition Assistance

Formula / Condition Assistance Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
RayS22
Posted : Friday, June 29, 2018 9:11:05 AM
Registered User
Joined: 5/14/2018
Posts: 1

Hi,

Still learning and like trying to figure out  stuff myself but I need a little nudge here ty!!...

I have a simple true/false condition:  C<C1 and C<C2 and C<3 and when this condition was last true over the last 10 bars, I would like to return the close value of that bar.

So if this condition was met 6 times in the last 10 bars, I only wanted the value of the most recent bar when this condition was last true.
Back to top
Bruce_L
Posted : Friday, June 29, 2018 9:37:44 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

I am going to assume that is a type and the third term is actually C < C3 and just just C < 3.

IIF(C < MINC3.1, C, IIF(C1 < MINC3.2, C1, IIF(C2 < MINC3.3, C2, IIF(C3 < MINC3.4, C3, IIF(C4 < MINC3.5, C4, IIF(C5 < MINC3.6, C5, IIF(C6 < MINC3.7, C6, IIF(C7 < MINC3.8, C7, IIF(C8 < MINC3.9, C8, IIF(C9 < MINC3.10, C9, 1 / 0))))))))))


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.