New version 18 available now


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


New account application Trading resources
Margin rates Stock & option commissions

Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Pcf Tweak Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dhirenshah
Posted : Wednesday, June 13, 2018 2:55:18 AM
Registered User
Joined: 3/10/2012
Posts: 372

Bruce I just need a small tweak in this below formula , need OUTPUT OF FIB VALUE , when FIB RETACEMENT DRAWN from Swing low 13 to Swing High 13 when Swing low is more recent then the Swing high... 

So need to know where is the current value LOW in fibs example " XRAY" on daily chart has 13 bar swing low on MAY 08, 2018 AND 13 bar Swing high on April 18,2018 so current low is between fib retracement of 119.80 when fib retracement drawn from Swing LOW TO Swing HIGH

 

100 * (IIF(MINL13 > L13 AND L13 < MINL13.14, MAXH13, IIF(MINL13.1 > L14 AND L14 < MINL13.15, MAXH14, IIF(MINL13.2 > L15 AND L15 < MINL13.16, MAXH15, IIF(MINL13.3 > L16 AND L16 < MINL13.17, MAXH16, IIF(MINL13.4 > L17 AND L17 < MINL13.18, MAXH17, IIF(MINL13.5 > L18 AND L18 < MINL13.19, MAXH18, IIF(MINL13.6 > L19 AND L19 < MINL13.20, MAXH19, IIF(MINL13.7 > L20 AND L20 < MINL13.21, MAXH20, IIF(MINL13.8 > L21 AND L21 < MINL13.22, MAXH21, IIF(MINL13.9 > L22 AND L22 < MINL13.23, MAXH22, IIF(MINL13.10 > L23 AND L23 < MINL13.24, MAXH23, IIF(MINL13.11 > L24 AND L24 < MINL13.25, MAXH24, IIF(MINL13.12 > L25 AND L25 < MINL13.26, MAXH25, IIF(MINL13.13 > L26 AND L26 < MINL13.27, MAXH26, IIF(MINL13.14 > L27 AND L27 < MINL13.28, MAXH27, IIF(MINL13.15 > L28 AND L28 < MINL13.29, MAXH28, IIF(MINL13.16 > L29 AND L29 < MINL13.30, MAXH29, IIF(MINL13.17 > L30 AND L30 < MINL13.31, MAXH30, IIF(MINL13.18 > L31 AND L31 < MINL13.32, MAXH31, IIF(MINL13.19 > L32 AND L32 < MINL13.33, MAXH32, IIF(MINL13.20 > L33 AND L33 < MINL13.34, MAXH33, IIF(MINL13.21 > L34 AND L34 < MINL13.35, MAXH34, IIF(MINL13.22 > L35 AND L35 < MINL13.36, MAXH35, IIF(MINL13.23 > L36 AND L36 < MINL13.37, MAXH36, IIF(MINL13.24 > L37 AND L37 < MINL13.38, MAXH37, IIF(MINL13.25 > L38 AND L38 < MINL13.39, MAXH38, IIF(MINL13.26 > L39 AND L39 < MINL13.40, MAXH39, IIF(MINL13.27 > L40 AND L40 < MINL13.41, MAXH40, IIF(MINL13.28 > L41 AND L41 < MINL13.42, MAXH41, IIF(MINL13.29 > L42 AND L42 < MINL13.43, MAXH42, IIF(MINL13.30 > L43 AND L43 < MINL13.44, MAXH43, IIF(MINL13.31 > L44 AND L44 < MINL13.45, MAXH44, IIF(MINL13.32 > L45 AND L45 < MINL13.46, MAXH45, IIF(MINL13.33 > L46 AND L46 < MINL13.47, MAXH46, IIF(MINL13.34 > L47 AND L47 < MINL13.48, MAXH47, IIF(MINL13.35 > L48 AND L48 < MINL13.49, MAXH48, IIF(MINL13.36 > L49 AND L49 < MINL13.50, MAXH49, IIF(MINL13.37 > L50 AND L50 < MINL13.51, MAXH50, IIF(MINL13.38 > L51 AND L51 < MINL13.52, MAXH51, IIF(MINL13.39 > L52 AND L52 < MINL13.53, MAXH52, IIF(MINL13.40 > L53 AND L53 < MINL13.54, MAXH53, IIF(MINL13.41 > L54 AND L54 < MINL13.55, MAXH54, IIF(MINL13.42 > L55 AND L55 < MINL13.56, MAXH55, IIF(MINL13.43 > L56 AND L56 < MINL13.57, MAXH56, IIF(MINL13.44 > L57 AND L57 < MINL13.58, MAXH57, IIF(MINL13.45 > L58 AND L58 < MINL13.59, MAXH58, IIF(MINL13.46 > L59 AND L59 < MINL13.60, MAXH59, IIF(MINL13.47 > L60 AND L60 < MINL13.61, MAXH60, IIF(MINL13.48 > L61 AND L61 < MINL13.62, MAXH61, IIF(MINL13.49 > L62 AND L62 < MINL13.63, MAXH62, 1/0)))))))))))))))))))))))))))))))))))))))))))))))))) - L) / IIF(MINL13 > L13 AND L13 < MINL13.14, MAXH13 - L13, IIF(MINL13.1 > L14 AND L14 < MINL13.15, MAXH14 - L14, IIF(MINL13.2 > L15 AND L15 < MINL13.16, MAXH15 - L15, IIF(MINL13.3 > L16 AND L16 < MINL13.17, MAXH16 - L16, IIF(MINL13.4 > L17 AND L17 < MINL13.18, MAXH17 - L17, IIF(MINL13.5 > L18 AND L18 < MINL13.19, MAXH18 - L18, IIF(MINL13.6 > L19 AND L19 < MINL13.20, MAXH19 - L19, IIF(MINL13.7 > L20 AND L20 < MINL13.21, MAXH20 - L20, IIF(MINL13.8 > L21 AND L21 < MINL13.22, MAXH21 - L21, IIF(MINL13.9 > L22 AND L22 < MINL13.23, MAXH22 - L22, IIF(MINL13.10 > L23 AND L23 < MINL13.24, MAXH23 - L23, IIF(MINL13.11 > L24 AND L24 < MINL13.25, MAXH24 - L24, IIF(MINL13.12 > L25 AND L25 < MINL13.26, MAXH25 - L25, IIF(MINL13.13 > L26 AND L26 < MINL13.27, MAXH26 - L26, IIF(MINL13.14 > L27 AND L27 < MINL13.28, MAXH27 - L27, IIF(MINL13.15 > L28 AND L28 < MINL13.29, MAXH28 - L28, IIF(MINL13.16 > L29 AND L29 < MINL13.30, MAXH29 - L29, IIF(MINL13.17 > L30 AND L30 < MINL13.31, MAXH30 - L30, IIF(MINL13.18 > L31 AND L31 < MINL13.32, MAXH31 - L31, IIF(MINL13.19 > L32 AND L32 < MINL13.33, MAXH32 - L32, IIF(MINL13.20 > L33 AND L33 < MINL13.34, MAXH33 - L33, IIF(MINL13.21 > L34 AND L34 < MINL13.35, MAXH34 - L34, IIF(MINL13.22 > L35 AND L35 < MINL13.36, MAXH35 - L35, IIF(MINL13.23 > L36 AND L36 < MINL13.37, MAXH36 - L36, IIF(MINL13.24 > L37 AND L37 < MINL13.38, MAXH37 - L37, IIF(MINL13.25 > L38 AND L38 < MINL13.39, MAXH38 - L38, IIF(MINL13.26 > L39 AND L39 < MINL13.40, MAXH39 - L39, IIF(MINL13.27 > L40 AND L40 < MINL13.41, MAXH40 - L40, IIF(MINL13.28 > L41 AND L41 < MINL13.42, MAXH41 - L41, IIF(MINL13.29 > L42 AND L42 < MINL13.43, MAXH42 - L42, IIF(MINL13.30 > L43 AND L43 < MINL13.44, MAXH43 - L43, IIF(MINL13.31 > L44 AND L44 < MINL13.45, MAXH44 - L44, IIF(MINL13.32 > L45 AND L45 < MINL13.46, MAXH45 - L45, IIF(MINL13.33 > L46 AND L46 < MINL13.47, MAXH46 - L46, IIF(MINL13.34 > L47 AND L47 < MINL13.48, MAXH47 - L47, IIF(MINL13.35 > L48 AND L48 < MINL13.49, MAXH48 - L48, IIF(MINL13.36 > L49 AND L49 < MINL13.50, MAXH49 - L49, IIF(MINL13.37 > L50 AND L50 < MINL13.51, MAXH50 - L50, IIF(MINL13.38 > L51 AND L51 < MINL13.52, MAXH51 - L51, IIF(MINL13.39 > L52 AND L52 < MINL13.53, MAXH52 - L52, IIF(MINL13.40 > L53 AND L53 < MINL13.54, MAXH53 - L53, IIF(MINL13.41 > L54 AND L54 < MINL13.55, MAXH54 - L54, IIF(MINL13.42 > L55 AND L55 < MINL13.56, MAXH55 - L55, IIF(MINL13.43 > L56 AND L56 < MINL13.57, MAXH56 - L56, IIF(MINL13.44 > L57 AND L57 < MINL13.58, MAXH57 - L57, IIF(MINL13.45 > L58 AND L58 < MINL13.59, MAXH58 - L58, IIF(MINL13.46 > L59 AND L59 < MINL13.60, MAXH59 - L59, IIF(MINL13.47 > L60 AND L60 < MINL13.61, MAXH60 - L60, IIF(MINL13.48 > L61 AND L61 < MINL13.62, MAXH61 - L61, IIF(MINL13.49 > L62 AND L62 < MINL13.63, MAXH62 - L62, 1/0))))))))))))))))))))))))))))))))))))))))))))))))))

And same I need for inverse where is the current high value when FIB retracement drawn from SWING High to SWING LOW  example TWTR" ON DAILY  when FIB RETRACEMENT drawn from SWING HIGH of MARCH 14,2018  to Swing LOW APRIL 04,2018 the CURRENT HIGH VALUE IS ABOVE 161.8 FIB ,

ALSO NOTE: April 20,2018 had a 13 bar swing high but it never had a 13 bar swing low so i don;t want to pick up that in the formula... it should only be true value when we get Swing high to swing low 

 

Thanks a lot 

Dhiren

Bruce_L
Posted : Wednesday, June 13, 2018 10:38:30 AM


Worden Trainer

Joined: 10/7/2004
Posts: 63,971

QUOTE (dhirenshah)
ALSO NOTE: April 20,2018 had a 13 bar swing high but it never had a 13 bar swing low so i don;t want to pick up that in the formula... it should only be true value when we get Swing high to swing low

Even without understanding the rest of your question, there still isn't a reasonable way to do this portion. It hasn't changed since the last time something similar was requested.

We can only find the value and number of bars ago of the most recent swing high and swing low (or one back if the most recent swing high or swing low would be most recently detected on the current bar).

So there is no way to determine that there was in intervening swing high on February 8, 2018 between the swing low of January 25, 2018 and the swing high on March 14, 2018.

QUOTE (dhirenshah)
Bruce I just need a small tweak in this below formula , need OUTPUT OF FIB VALUE , when FIB RETACEMENT DRAWN from Swing low 13 to Swing High 13 when Swing low is more recent then the Swing high...

So need to know where is the current value LOW in fibs example " XRAY" on daily chart has 13 bar swing low on MAY 08, 2018 AND 13 bar Swing high on April 18,2018 so current low is between fib retracement of 119.80 when fib retracement drawn from Swing LOW TO Swing HIGH

I frankly don't understand this part at all, where the 199.80 value comes from, or how it differs from what is being returned currently



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Al_Gorithm
Posted : Wednesday, June 13, 2018 10:49:18 AM

Gold Customer Gold Customer

Joined: 6/30/2017
Posts: 1,144

Dhiren,

Just a friendly suggestion.
I know it's clich&eacute;, but a picture is really worth a gazillion words ... and code.

Haven't read your request all the way through, because frankly, the barista on duty today is hot and flirty. ;)

You do seem to have a very specific example. Find a chart that exhibits this behavior, take a screenshot, and annotate it. I can't speak for Bruce (he's waaay smarter than me) but a visual example might help you get what you're looking for.

Barista, another round!

 

Al_Gorithm
Posted : Wednesday, June 13, 2018 10:52:25 AM

Gold Customer Gold Customer

Joined: 6/30/2017
Posts: 1,144

clich&eacute;

WTF?!?

hate computers.

s/b cliche.

Gotta go, my drink is ready...

dhirenshah
Posted : Wednesday, June 13, 2018 11:01:47 AM
Registered User
Joined: 3/10/2012
Posts: 372

Bruce please see the attached link below 

https://www.dhirenshah.com/retracement-swing-low-to-swing-high-when-swing-low-is-more-recent-then-swing-high/

 

https://www.dhirenshah.com/retracement-from-swing-high-to-swing-low-when-swing-low-is-more-recent-then-swing-high/

 

the above formula last time what u did is you identified the SWING LOW 13 and you identified the highest high since the swing low excluding the bar of swing low, when drawing fib retracement from Swing low to upper righ

But here i m asking to Identify SWING LOW 13 and find me Prior SWING high 13 before the Most recent swing low and drawing fib retracement from swing low to Upper LEFT  for example of XRAY and drawing Inverse from SWING high to SWING LOW (to be true only when swings both recent swings 13 are identified and remain false if they are not identified..) 

hope it helps 

dhirenshah
Posted : Wednesday, June 13, 2018 11:42:25 AM
Registered User
Joined: 3/10/2012
Posts: 372

Howz that for Picture Al-Gorithm.. ?? :))

Undoubtedly Bruce is the greatest mind of our times i have never seen more creative problem solver in math like him,, thats why i call him "Fibonacci of 21 st century"

Bruce_L
Posted : Wednesday, June 13, 2018 12:17:26 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,971

Please try the following for the swing low being more recent than the swing high.

IIF(TrueInRow(NOT(MINL13 > L13 AND L13 < MINL13.14), 50) < TrueInRow(NOT(MAXH13 < H13 AND H13 > MAXH13.14), 50), 100 * (IIF(MAXH13 < H13 AND H13 > MAXH13.14, H13, IIF(MAXH13.1 < H14 AND H14 > MAXH13.15, H14, IIF(MAXH13.2 < H15 AND H15 > MAXH13.16, H15, IIF(MAXH13.3 < H16 AND H16 > MAXH13.17, H16, IIF(MAXH13.4 < H17 AND H17 > MAXH13.18, H17, IIF(MAXH13.5 < H18 AND H18 > MAXH13.19, H18, IIF(MAXH13.6 < H19 AND H19 > MAXH13.20, H19, IIF(MAXH13.7 < H20 AND H20 > MAXH13.21, H20, IIF(MAXH13.8 < H21 AND H21 > MAXH13.22, H21, IIF(MAXH13.9 < H22 AND H22 > MAXH13.23, H22, IIF(MAXH13.10 < H23 AND H23 > MAXH13.24, H23, IIF(MAXH13.11 < H24 AND H24 > MAXH13.25, H24, IIF(MAXH13.12 < H25 AND H25 > MAXH13.26, H25, IIF(MAXH13.13 < H26 AND H26 > MAXH13.27, H26, IIF(MAXH13.14 < H27 AND H27 > MAXH13.28, H27, IIF(MAXH13.15 < H28 AND H28 > MAXH13.29, H28, IIF(MAXH13.16 < H29 AND H29 > MAXH13.30, H29, IIF(MAXH13.17 < H30 AND H30 > MAXH13.31, H30, IIF(MAXH13.18 < H31 AND H31 > MAXH13.32, H31, IIF(MAXH13.19 < H32 AND H32 > MAXH13.33, H32, IIF(MAXH13.20 < H33 AND H33 > MAXH13.34, H33, IIF(MAXH13.21 < H34 AND H34 > MAXH13.35, H34, IIF(MAXH13.22 < H35 AND H35 > MAXH13.36, H35, IIF(MAXH13.23 < H36 AND H36 > MAXH13.37, H36, IIF(MAXH13.24 < H37 AND H37 > MAXH13.38, H37, IIF(MAXH13.25 < H38 AND H38 > MAXH13.39, H38, IIF(MAXH13.26 < H39 AND H39 > MAXH13.40, H39, IIF(MAXH13.27 < H40 AND H40 > MAXH13.41, H40, IIF(MAXH13.28 < H41 AND H41 > MAXH13.42, H41, IIF(MAXH13.29 < H42 AND H42 > MAXH13.43, H42, IIF(MAXH13.30 < H43 AND H43 > MAXH13.44, H43, IIF(MAXH13.31 < H44 AND H44 > MAXH13.45, H44, IIF(MAXH13.32 < H45 AND H45 > MAXH13.46, H45, IIF(MAXH13.33 < H46 AND H46 > MAXH13.47, H46, IIF(MAXH13.34 < H47 AND H47 > MAXH13.48, H47, IIF(MAXH13.35 < H48 AND H48 > MAXH13.49, H48, IIF(MAXH13.36 < H49 AND H49 > MAXH13.50, H49, IIF(MAXH13.37 < H50 AND H50 > MAXH13.51, H50, IIF(MAXH13.38 < H51 AND H51 > MAXH13.52, H51, IIF(MAXH13.39 < H52 AND H52 > MAXH13.53, H52, IIF(MAXH13.40 < H53 AND H53 > MAXH13.54, H53, IIF(MAXH13.41 < H54 AND H54 > MAXH13.55, H54, IIF(MAXH13.42 < H55 AND H55 > MAXH13.56, H55, IIF(MAXH13.43 < H56 AND H56 > MAXH13.57, H56, IIF(MAXH13.44 < H57 AND H57 > MAXH13.58, H57, IIF(MAXH13.45 < H58 AND H58 > MAXH13.59, H58, IIF(MAXH13.46 < H59 AND H59 > MAXH13.60, H59, IIF(MAXH13.47 < H60 AND H60 > MAXH13.61, H60, IIF(MAXH13.48 < H61 AND H61 > MAXH13.62, H61, IIF(MAXH13.49 < H62 AND H62 > MAXH13.63, H62, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))) - L) / (IIF(MAXH13 < H13 AND H13 > MAXH13.14, H13, IIF(MAXH13.1 < H14 AND H14 > MAXH13.15, H14, IIF(MAXH13.2 < H15 AND H15 > MAXH13.16, H15, IIF(MAXH13.3 < H16 AND H16 > MAXH13.17, H16, IIF(MAXH13.4 < H17 AND H17 > MAXH13.18, H17, IIF(MAXH13.5 < H18 AND H18 > MAXH13.19, H18, IIF(MAXH13.6 < H19 AND H19 > MAXH13.20, H19, IIF(MAXH13.7 < H20 AND H20 > MAXH13.21, H20, IIF(MAXH13.8 < H21 AND H21 > MAXH13.22, H21, IIF(MAXH13.9 < H22 AND H22 > MAXH13.23, H22, IIF(MAXH13.10 < H23 AND H23 > MAXH13.24, H23, IIF(MAXH13.11 < H24 AND H24 > MAXH13.25, H24, IIF(MAXH13.12 < H25 AND H25 > MAXH13.26, H25, IIF(MAXH13.13 < H26 AND H26 > MAXH13.27, H26, IIF(MAXH13.14 < H27 AND H27 > MAXH13.28, H27, IIF(MAXH13.15 < H28 AND H28 > MAXH13.29, H28, IIF(MAXH13.16 < H29 AND H29 > MAXH13.30, H29, IIF(MAXH13.17 < H30 AND H30 > MAXH13.31, H30, IIF(MAXH13.18 < H31 AND H31 > MAXH13.32, H31, IIF(MAXH13.19 < H32 AND H32 > MAXH13.33, H32, IIF(MAXH13.20 < H33 AND H33 > MAXH13.34, H33, IIF(MAXH13.21 < H34 AND H34 > MAXH13.35, H34, IIF(MAXH13.22 < H35 AND H35 > MAXH13.36, H35, IIF(MAXH13.23 < H36 AND H36 > MAXH13.37, H36, IIF(MAXH13.24 < H37 AND H37 > MAXH13.38, H37, IIF(MAXH13.25 < H38 AND H38 > MAXH13.39, H38, IIF(MAXH13.26 < H39 AND H39 > MAXH13.40, H39, IIF(MAXH13.27 < H40 AND H40 > MAXH13.41, H40, IIF(MAXH13.28 < H41 AND H41 > MAXH13.42, H41, IIF(MAXH13.29 < H42 AND H42 > MAXH13.43, H42, IIF(MAXH13.30 < H43 AND H43 > MAXH13.44, H43, IIF(MAXH13.31 < H44 AND H44 > MAXH13.45, H44, IIF(MAXH13.32 < H45 AND H45 > MAXH13.46, H45, IIF(MAXH13.33 < H46 AND H46 > MAXH13.47, H46, IIF(MAXH13.34 < H47 AND H47 > MAXH13.48, H47, IIF(MAXH13.35 < H48 AND H48 > MAXH13.49, H48, IIF(MAXH13.36 < H49 AND H49 > MAXH13.50, H49, IIF(MAXH13.37 < H50 AND H50 > MAXH13.51, H50, IIF(MAXH13.38 < H51 AND H51 > MAXH13.52, H51, IIF(MAXH13.39 < H52 AND H52 > MAXH13.53, H52, IIF(MAXH13.40 < H53 AND H53 > MAXH13.54, H53, IIF(MAXH13.41 < H54 AND H54 > MAXH13.55, H54, IIF(MAXH13.42 < H55 AND H55 > MAXH13.56, H55, IIF(MAXH13.43 < H56 AND H56 > MAXH13.57, H56, IIF(MAXH13.44 < H57 AND H57 > MAXH13.58, H57, IIF(MAXH13.45 < H58 AND H58 > MAXH13.59, H58, IIF(MAXH13.46 < H59 AND H59 > MAXH13.60, H59, IIF(MAXH13.47 < H60 AND H60 > MAXH13.61, H60, IIF(MAXH13.48 < H61 AND H61 > MAXH13.62, H61, IIF(MAXH13.49 < H62 AND H62 > MAXH13.63, H62, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))) - IIF(MINL13 > L13 AND L13 < MINL13.14, L13, IIF(MINL13.1 > L14 AND L14 < MINL13.15, L14, IIF(MINL13.2 > L15 AND L15 < MINL13.16, L15, IIF(MINL13.3 > L16 AND L16 < MINL13.17, L16, IIF(MINL13.4 > L17 AND L17 < MINL13.18, L17, IIF(MINL13.5 > L18 AND L18 < MINL13.19, L18, IIF(MINL13.6 > L19 AND L19 < MINL13.20, L19, IIF(MINL13.7 > L20 AND L20 < MINL13.21, L20, IIF(MINL13.8 > L21 AND L21 < MINL13.22, L21, IIF(MINL13.9 > L22 AND L22 < MINL13.23, L22, IIF(MINL13.10 > L23 AND L23 < MINL13.24, L23, IIF(MINL13.11 > L24 AND L24 < MINL13.25, L24, IIF(MINL13.12 > L25 AND L25 < MINL13.26, L25, IIF(MINL13.13 > L26 AND L26 < MINL13.27, L26, IIF(MINL13.14 > L27 AND L27 < MINL13.28, L27, IIF(MINL13.15 > L28 AND L28 < MINL13.29, L28, IIF(MINL13.16 > L29 AND L29 < MINL13.30, L29, IIF(MINL13.17 > L30 AND L30 < MINL13.31, L30, IIF(MINL13.18 > L31 AND L31 < MINL13.32, L31, IIF(MINL13.19 > L32 AND L32 < MINL13.33, L32, IIF(MINL13.20 > L33 AND L33 < MINL13.34, L33, IIF(MINL13.21 > L34 AND L34 < MINL13.35, L34, IIF(MINL13.22 > L35 AND L35 < MINL13.36, L35, IIF(MINL13.23 > L36 AND L36 < MINL13.37, L36, IIF(MINL13.24 > L37 AND L37 < MINL13.38, L37, IIF(MINL13.25 > L38 AND L38 < MINL13.39, L38, IIF(MINL13.26 > L39 AND L39 < MINL13.40, L39, IIF(MINL13.27 > L40 AND L40 < MINL13.41, L40, IIF(MINL13.28 > L41 AND L41 < MINL13.42, L41, IIF(MINL13.29 > L42 AND L42 < MINL13.43, L42, IIF(MINL13.30 > L43 AND L43 < MINL13.44, L43, IIF(MINL13.31 > L44 AND L44 < MINL13.45, L44, IIF(MINL13.32 > L45 AND L45 < MINL13.46, L45, IIF(MINL13.33 > L46 AND L46 < MINL13.47, L46, IIF(MINL13.34 > L47 AND L47 < MINL13.48, L47, IIF(MINL13.35 > L48 AND L48 < MINL13.49, L48, IIF(MINL13.36 > L49 AND L49 < MINL13.50, L49, IIF(MINL13.37 > L50 AND L50 < MINL13.51, L50, IIF(MINL13.38 > L51 AND L51 < MINL13.52, L51, IIF(MINL13.39 > L52 AND L52 < MINL13.53, L52, IIF(MINL13.40 > L53 AND L53 < MINL13.54, L53, IIF(MINL13.41 > L54 AND L54 < MINL13.55, L54, IIF(MINL13.42 > L55 AND L55 < MINL13.56, L55, IIF(MINL13.43 > L56 AND L56 < MINL13.57, L56, IIF(MINL13.44 > L57 AND L57 < MINL13.58, L57, IIF(MINL13.45 > L58 AND L58 < MINL13.59, L58, IIF(MINL13.46 > L59 AND L59 < MINL13.60, L59, IIF(MINL13.47 > L60 AND L60 < MINL13.61, L60, IIF(MINL13.48 > L61 AND L61 < MINL13.62, L61, IIF(MINL13.49 > L62 AND L62 < MINL13.63, L62, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))), 1 / 0)

And the following when the swing high is more recent than the swing low.

IIF(TrueInRow(NOT(MINL13 > L13 AND L13 < MINL13.14), 50) > TrueInRow(NOT(MAXH13 < H13 AND H13 > MAXH13.14), 50), 100 * (IIF(MINL13 > L13 AND L13 < MINL13.14, L13, IIF(MINL13.1 > L14 AND L14 < MINL13.15, L14, IIF(MINL13.2 > L15 AND L15 < MINL13.16, L15, IIF(MINL13.3 > L16 AND L16 < MINL13.17, L16, IIF(MINL13.4 > L17 AND L17 < MINL13.18, L17, IIF(MINL13.5 > L18 AND L18 < MINL13.19, L18, IIF(MINL13.6 > L19 AND L19 < MINL13.20, L19, IIF(MINL13.7 > L20 AND L20 < MINL13.21, L20, IIF(MINL13.8 > L21 AND L21 < MINL13.22, L21, IIF(MINL13.9 > L22 AND L22 < MINL13.23, L22, IIF(MINL13.10 > L23 AND L23 < MINL13.24, L23, IIF(MINL13.11 > L24 AND L24 < MINL13.25, L24, IIF(MINL13.12 > L25 AND L25 < MINL13.26, L25, IIF(MINL13.13 > L26 AND L26 < MINL13.27, L26, IIF(MINL13.14 > L27 AND L27 < MINL13.28, L27, IIF(MINL13.15 > L28 AND L28 < MINL13.29, L28, IIF(MINL13.16 > L29 AND L29 < MINL13.30, L29, IIF(MINL13.17 > L30 AND L30 < MINL13.31, L30, IIF(MINL13.18 > L31 AND L31 < MINL13.32, L31, IIF(MINL13.19 > L32 AND L32 < MINL13.33, L32, IIF(MINL13.20 > L33 AND L33 < MINL13.34, L33, IIF(MINL13.21 > L34 AND L34 < MINL13.35, L34, IIF(MINL13.22 > L35 AND L35 < MINL13.36, L35, IIF(MINL13.23 > L36 AND L36 < MINL13.37, L36, IIF(MINL13.24 > L37 AND L37 < MINL13.38, L37, IIF(MINL13.25 > L38 AND L38 < MINL13.39, L38, IIF(MINL13.26 > L39 AND L39 < MINL13.40, L39, IIF(MINL13.27 > L40 AND L40 < MINL13.41, L40, IIF(MINL13.28 > L41 AND L41 < MINL13.42, L41, IIF(MINL13.29 > L42 AND L42 < MINL13.43, L42, IIF(MINL13.30 > L43 AND L43 < MINL13.44, L43, IIF(MINL13.31 > L44 AND L44 < MINL13.45, L44, IIF(MINL13.32 > L45 AND L45 < MINL13.46, L45, IIF(MINL13.33 > L46 AND L46 < MINL13.47, L46, IIF(MINL13.34 > L47 AND L47 < MINL13.48, L47, IIF(MINL13.35 > L48 AND L48 < MINL13.49, L48, IIF(MINL13.36 > L49 AND L49 < MINL13.50, L49, IIF(MINL13.37 > L50 AND L50 < MINL13.51, L50, IIF(MINL13.38 > L51 AND L51 < MINL13.52, L51, IIF(MINL13.39 > L52 AND L52 < MINL13.53, L52, IIF(MINL13.40 > L53 AND L53 < MINL13.54, L53, IIF(MINL13.41 > L54 AND L54 < MINL13.55, L54, IIF(MINL13.42 > L55 AND L55 < MINL13.56, L55, IIF(MINL13.43 > L56 AND L56 < MINL13.57, L56, IIF(MINL13.44 > L57 AND L57 < MINL13.58, L57, IIF(MINL13.45 > L58 AND L58 < MINL13.59, L58, IIF(MINL13.46 > L59 AND L59 < MINL13.60, L59, IIF(MINL13.47 > L60 AND L60 < MINL13.61, L60, IIF(MINL13.48 > L61 AND L61 < MINL13.62, L61, IIF(MINL13.49 > L62 AND L62 < MINL13.63, L62, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))) - H) / (IIF(MINL13 > L13 AND L13 < MINL13.14, L13, IIF(MINL13.1 > L14 AND L14 < MINL13.15, L14, IIF(MINL13.2 > L15 AND L15 < MINL13.16, L15, IIF(MINL13.3 > L16 AND L16 < MINL13.17, L16, IIF(MINL13.4 > L17 AND L17 < MINL13.18, L17, IIF(MINL13.5 > L18 AND L18 < MINL13.19, L18, IIF(MINL13.6 > L19 AND L19 < MINL13.20, L19, IIF(MINL13.7 > L20 AND L20 < MINL13.21, L20, IIF(MINL13.8 > L21 AND L21 < MINL13.22, L21, IIF(MINL13.9 > L22 AND L22 < MINL13.23, L22, IIF(MINL13.10 > L23 AND L23 < MINL13.24, L23, IIF(MINL13.11 > L24 AND L24 < MINL13.25, L24, IIF(MINL13.12 > L25 AND L25 < MINL13.26, L25, IIF(MINL13.13 > L26 AND L26 < MINL13.27, L26, IIF(MINL13.14 > L27 AND L27 < MINL13.28, L27, IIF(MINL13.15 > L28 AND L28 < MINL13.29, L28, IIF(MINL13.16 > L29 AND L29 < MINL13.30, L29, IIF(MINL13.17 > L30 AND L30 < MINL13.31, L30, IIF(MINL13.18 > L31 AND L31 < MINL13.32, L31, IIF(MINL13.19 > L32 AND L32 < MINL13.33, L32, IIF(MINL13.20 > L33 AND L33 < MINL13.34, L33, IIF(MINL13.21 > L34 AND L34 < MINL13.35, L34, IIF(MINL13.22 > L35 AND L35 < MINL13.36, L35, IIF(MINL13.23 > L36 AND L36 < MINL13.37, L36, IIF(MINL13.24 > L37 AND L37 < MINL13.38, L37, IIF(MINL13.25 > L38 AND L38 < MINL13.39, L38, IIF(MINL13.26 > L39 AND L39 < MINL13.40, L39, IIF(MINL13.27 > L40 AND L40 < MINL13.41, L40, IIF(MINL13.28 > L41 AND L41 < MINL13.42, L41, IIF(MINL13.29 > L42 AND L42 < MINL13.43, L42, IIF(MINL13.30 > L43 AND L43 < MINL13.44, L43, IIF(MINL13.31 > L44 AND L44 < MINL13.45, L44, IIF(MINL13.32 > L45 AND L45 < MINL13.46, L45, IIF(MINL13.33 > L46 AND L46 < MINL13.47, L46, IIF(MINL13.34 > L47 AND L47 < MINL13.48, L47, IIF(MINL13.35 > L48 AND L48 < MINL13.49, L48, IIF(MINL13.36 > L49 AND L49 < MINL13.50, L49, IIF(MINL13.37 > L50 AND L50 < MINL13.51, L50, IIF(MINL13.38 > L51 AND L51 < MINL13.52, L51, IIF(MINL13.39 > L52 AND L52 < MINL13.53, L52, IIF(MINL13.40 > L53 AND L53 < MINL13.54, L53, IIF(MINL13.41 > L54 AND L54 < MINL13.55, L54, IIF(MINL13.42 > L55 AND L55 < MINL13.56, L55, IIF(MINL13.43 > L56 AND L56 < MINL13.57, L56, IIF(MINL13.44 > L57 AND L57 < MINL13.58, L57, IIF(MINL13.45 > L58 AND L58 < MINL13.59, L58, IIF(MINL13.46 > L59 AND L59 < MINL13.60, L59, IIF(MINL13.47 > L60 AND L60 < MINL13.61, L60, IIF(MINL13.48 > L61 AND L61 < MINL13.62, L61, IIF(MINL13.49 > L62 AND L62 < MINL13.63, L62, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))) - IIF(MAXH13 < H13 AND H13 > MAXH13.14, H13, IIF(MAXH13.1 < H14 AND H14 > MAXH13.15, H14, IIF(MAXH13.2 < H15 AND H15 > MAXH13.16, H15, IIF(MAXH13.3 < H16 AND H16 > MAXH13.17, H16, IIF(MAXH13.4 < H17 AND H17 > MAXH13.18, H17, IIF(MAXH13.5 < H18 AND H18 > MAXH13.19, H18, IIF(MAXH13.6 < H19 AND H19 > MAXH13.20, H19, IIF(MAXH13.7 < H20 AND H20 > MAXH13.21, H20, IIF(MAXH13.8 < H21 AND H21 > MAXH13.22, H21, IIF(MAXH13.9 < H22 AND H22 > MAXH13.23, H22, IIF(MAXH13.10 < H23 AND H23 > MAXH13.24, H23, IIF(MAXH13.11 < H24 AND H24 > MAXH13.25, H24, IIF(MAXH13.12 < H25 AND H25 > MAXH13.26, H25, IIF(MAXH13.13 < H26 AND H26 > MAXH13.27, H26, IIF(MAXH13.14 < H27 AND H27 > MAXH13.28, H27, IIF(MAXH13.15 < H28 AND H28 > MAXH13.29, H28, IIF(MAXH13.16 < H29 AND H29 > MAXH13.30, H29, IIF(MAXH13.17 < H30 AND H30 > MAXH13.31, H30, IIF(MAXH13.18 < H31 AND H31 > MAXH13.32, H31, IIF(MAXH13.19 < H32 AND H32 > MAXH13.33, H32, IIF(MAXH13.20 < H33 AND H33 > MAXH13.34, H33, IIF(MAXH13.21 < H34 AND H34 > MAXH13.35, H34, IIF(MAXH13.22 < H35 AND H35 > MAXH13.36, H35, IIF(MAXH13.23 < H36 AND H36 > MAXH13.37, H36, IIF(MAXH13.24 < H37 AND H37 > MAXH13.38, H37, IIF(MAXH13.25 < H38 AND H38 > MAXH13.39, H38, IIF(MAXH13.26 < H39 AND H39 > MAXH13.40, H39, IIF(MAXH13.27 < H40 AND H40 > MAXH13.41, H40, IIF(MAXH13.28 < H41 AND H41 > MAXH13.42, H41, IIF(MAXH13.29 < H42 AND H42 > MAXH13.43, H42, IIF(MAXH13.30 < H43 AND H43 > MAXH13.44, H43, IIF(MAXH13.31 < H44 AND H44 > MAXH13.45, H44, IIF(MAXH13.32 < H45 AND H45 > MAXH13.46, H45, IIF(MAXH13.33 < H46 AND H46 > MAXH13.47, H46, IIF(MAXH13.34 < H47 AND H47 > MAXH13.48, H47, IIF(MAXH13.35 < H48 AND H48 > MAXH13.49, H48, IIF(MAXH13.36 < H49 AND H49 > MAXH13.50, H49, IIF(MAXH13.37 < H50 AND H50 > MAXH13.51, H50, IIF(MAXH13.38 < H51 AND H51 > MAXH13.52, H51, IIF(MAXH13.39 < H52 AND H52 > MAXH13.53, H52, IIF(MAXH13.40 < H53 AND H53 > MAXH13.54, H53, IIF(MAXH13.41 < H54 AND H54 > MAXH13.55, H54, IIF(MAXH13.42 < H55 AND H55 > MAXH13.56, H55, IIF(MAXH13.43 < H56 AND H56 > MAXH13.57, H56, IIF(MAXH13.44 < H57 AND H57 > MAXH13.58, H57, IIF(MAXH13.45 < H58 AND H58 > MAXH13.59, H58, IIF(MAXH13.46 < H59 AND H59 > MAXH13.60, H59, IIF(MAXH13.47 < H60 AND H60 > MAXH13.61, H60, IIF(MAXH13.48 < H61 AND H61 > MAXH13.62, H61, IIF(MAXH13.49 < H62 AND H62 > MAXH13.63, H62, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))), 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Wednesday, June 13, 2018 12:49:35 PM
Registered User
Joined: 3/10/2012
Posts: 372

 

Bruce the first formula works perfect but in the second formula "following when the swing high is more recent than the swing low." thatS not correct FOR ME 

I still want Swing low to be more recent then the swing high like example of TWTR " so when i m drawing Fib retracement from Swing high of MARCH 14 TO SWING LOW OF APRIL 04 2018 SO DRAWING OF FIB IS FROM UPPER LEFT(SWING HIGH) TO LOWER RIGHT (SWING LOW) AND THAT'S WHERE THE FIB RETRACEMENT OF CURRENT HIGH I GET AT ABOVE 161.80 as shown in the link 

 

Bruce_L
Posted : Wednesday, June 13, 2018 1:01:59 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,971

Well that isn't happening with your TWTR example currently, because the swing high of April 20, 2018 is more recent than the swing low of April 4, 2018.

IIF(TrueInRow(NOT(MINL13 > L13 AND L13 < MINL13.14), 50) < TrueInRow(NOT(MAXH13 < H13 AND H13 > MAXH13.14), 50), 100 * (H - IIF(MINL13 > L13 AND L13 < MINL13.14, L13, IIF(MINL13.1 > L14 AND L14 < MINL13.15, L14, IIF(MINL13.2 > L15 AND L15 < MINL13.16, L15, IIF(MINL13.3 > L16 AND L16 < MINL13.17, L16, IIF(MINL13.4 > L17 AND L17 < MINL13.18, L17, IIF(MINL13.5 > L18 AND L18 < MINL13.19, L18, IIF(MINL13.6 > L19 AND L19 < MINL13.20, L19, IIF(MINL13.7 > L20 AND L20 < MINL13.21, L20, IIF(MINL13.8 > L21 AND L21 < MINL13.22, L21, IIF(MINL13.9 > L22 AND L22 < MINL13.23, L22, IIF(MINL13.10 > L23 AND L23 < MINL13.24, L23, IIF(MINL13.11 > L24 AND L24 < MINL13.25, L24, IIF(MINL13.12 > L25 AND L25 < MINL13.26, L25, IIF(MINL13.13 > L26 AND L26 < MINL13.27, L26, IIF(MINL13.14 > L27 AND L27 < MINL13.28, L27, IIF(MINL13.15 > L28 AND L28 < MINL13.29, L28, IIF(MINL13.16 > L29 AND L29 < MINL13.30, L29, IIF(MINL13.17 > L30 AND L30 < MINL13.31, L30, IIF(MINL13.18 > L31 AND L31 < MINL13.32, L31, IIF(MINL13.19 > L32 AND L32 < MINL13.33, L32, IIF(MINL13.20 > L33 AND L33 < MINL13.34, L33, IIF(MINL13.21 > L34 AND L34 < MINL13.35, L34, IIF(MINL13.22 > L35 AND L35 < MINL13.36, L35, IIF(MINL13.23 > L36 AND L36 < MINL13.37, L36, IIF(MINL13.24 > L37 AND L37 < MINL13.38, L37, IIF(MINL13.25 > L38 AND L38 < MINL13.39, L38, IIF(MINL13.26 > L39 AND L39 < MINL13.40, L39, IIF(MINL13.27 > L40 AND L40 < MINL13.41, L40, IIF(MINL13.28 > L41 AND L41 < MINL13.42, L41, IIF(MINL13.29 > L42 AND L42 < MINL13.43, L42, IIF(MINL13.30 > L43 AND L43 < MINL13.44, L43, IIF(MINL13.31 > L44 AND L44 < MINL13.45, L44, IIF(MINL13.32 > L45 AND L45 < MINL13.46, L45, IIF(MINL13.33 > L46 AND L46 < MINL13.47, L46, IIF(MINL13.34 > L47 AND L47 < MINL13.48, L47, IIF(MINL13.35 > L48 AND L48 < MINL13.49, L48, IIF(MINL13.36 > L49 AND L49 < MINL13.50, L49, IIF(MINL13.37 > L50 AND L50 < MINL13.51, L50, IIF(MINL13.38 > L51 AND L51 < MINL13.52, L51, IIF(MINL13.39 > L52 AND L52 < MINL13.53, L52, IIF(MINL13.40 > L53 AND L53 < MINL13.54, L53, IIF(MINL13.41 > L54 AND L54 < MINL13.55, L54, IIF(MINL13.42 > L55 AND L55 < MINL13.56, L55, IIF(MINL13.43 > L56 AND L56 < MINL13.57, L56, IIF(MINL13.44 > L57 AND L57 < MINL13.58, L57, IIF(MINL13.45 > L58 AND L58 < MINL13.59, L58, IIF(MINL13.46 > L59 AND L59 < MINL13.60, L59, IIF(MINL13.47 > L60 AND L60 < MINL13.61, L60, IIF(MINL13.48 > L61 AND L61 < MINL13.62, L61, IIF(MINL13.49 > L62 AND L62 < MINL13.63, L62, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))) / (IIF(MAXH13 < H13 AND H13 > MAXH13.14, H13, IIF(MAXH13.1 < H14 AND H14 > MAXH13.15, H14, IIF(MAXH13.2 < H15 AND H15 > MAXH13.16, H15, IIF(MAXH13.3 < H16 AND H16 > MAXH13.17, H16, IIF(MAXH13.4 < H17 AND H17 > MAXH13.18, H17, IIF(MAXH13.5 < H18 AND H18 > MAXH13.19, H18, IIF(MAXH13.6 < H19 AND H19 > MAXH13.20, H19, IIF(MAXH13.7 < H20 AND H20 > MAXH13.21, H20, IIF(MAXH13.8 < H21 AND H21 > MAXH13.22, H21, IIF(MAXH13.9 < H22 AND H22 > MAXH13.23, H22, IIF(MAXH13.10 < H23 AND H23 > MAXH13.24, H23, IIF(MAXH13.11 < H24 AND H24 > MAXH13.25, H24, IIF(MAXH13.12 < H25 AND H25 > MAXH13.26, H25, IIF(MAXH13.13 < H26 AND H26 > MAXH13.27, H26, IIF(MAXH13.14 < H27 AND H27 > MAXH13.28, H27, IIF(MAXH13.15 < H28 AND H28 > MAXH13.29, H28, IIF(MAXH13.16 < H29 AND H29 > MAXH13.30, H29, IIF(MAXH13.17 < H30 AND H30 > MAXH13.31, H30, IIF(MAXH13.18 < H31 AND H31 > MAXH13.32, H31, IIF(MAXH13.19 < H32 AND H32 > MAXH13.33, H32, IIF(MAXH13.20 < H33 AND H33 > MAXH13.34, H33, IIF(MAXH13.21 < H34 AND H34 > MAXH13.35, H34, IIF(MAXH13.22 < H35 AND H35 > MAXH13.36, H35, IIF(MAXH13.23 < H36 AND H36 > MAXH13.37, H36, IIF(MAXH13.24 < H37 AND H37 > MAXH13.38, H37, IIF(MAXH13.25 < H38 AND H38 > MAXH13.39, H38, IIF(MAXH13.26 < H39 AND H39 > MAXH13.40, H39, IIF(MAXH13.27 < H40 AND H40 > MAXH13.41, H40, IIF(MAXH13.28 < H41 AND H41 > MAXH13.42, H41, IIF(MAXH13.29 < H42 AND H42 > MAXH13.43, H42, IIF(MAXH13.30 < H43 AND H43 > MAXH13.44, H43, IIF(MAXH13.31 < H44 AND H44 > MAXH13.45, H44, IIF(MAXH13.32 < H45 AND H45 > MAXH13.46, H45, IIF(MAXH13.33 < H46 AND H46 > MAXH13.47, H46, IIF(MAXH13.34 < H47 AND H47 > MAXH13.48, H47, IIF(MAXH13.35 < H48 AND H48 > MAXH13.49, H48, IIF(MAXH13.36 < H49 AND H49 > MAXH13.50, H49, IIF(MAXH13.37 < H50 AND H50 > MAXH13.51, H50, IIF(MAXH13.38 < H51 AND H51 > MAXH13.52, H51, IIF(MAXH13.39 < H52 AND H52 > MAXH13.53, H52, IIF(MAXH13.40 < H53 AND H53 > MAXH13.54, H53, IIF(MAXH13.41 < H54 AND H54 > MAXH13.55, H54, IIF(MAXH13.42 < H55 AND H55 > MAXH13.56, H55, IIF(MAXH13.43 < H56 AND H56 > MAXH13.57, H56, IIF(MAXH13.44 < H57 AND H57 > MAXH13.58, H57, IIF(MAXH13.45 < H58 AND H58 > MAXH13.59, H58, IIF(MAXH13.46 < H59 AND H59 > MAXH13.60, H59, IIF(MAXH13.47 < H60 AND H60 > MAXH13.61, H60, IIF(MAXH13.48 < H61 AND H61 > MAXH13.62, H61, IIF(MAXH13.49 < H62 AND H62 > MAXH13.63, H62, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))) - IIF(MINL13 > L13 AND L13 < MINL13.14, L13, IIF(MINL13.1 > L14 AND L14 < MINL13.15, L14, IIF(MINL13.2 > L15 AND L15 < MINL13.16, L15, IIF(MINL13.3 > L16 AND L16 < MINL13.17, L16, IIF(MINL13.4 > L17 AND L17 < MINL13.18, L17, IIF(MINL13.5 > L18 AND L18 < MINL13.19, L18, IIF(MINL13.6 > L19 AND L19 < MINL13.20, L19, IIF(MINL13.7 > L20 AND L20 < MINL13.21, L20, IIF(MINL13.8 > L21 AND L21 < MINL13.22, L21, IIF(MINL13.9 > L22 AND L22 < MINL13.23, L22, IIF(MINL13.10 > L23 AND L23 < MINL13.24, L23, IIF(MINL13.11 > L24 AND L24 < MINL13.25, L24, IIF(MINL13.12 > L25 AND L25 < MINL13.26, L25, IIF(MINL13.13 > L26 AND L26 < MINL13.27, L26, IIF(MINL13.14 > L27 AND L27 < MINL13.28, L27, IIF(MINL13.15 > L28 AND L28 < MINL13.29, L28, IIF(MINL13.16 > L29 AND L29 < MINL13.30, L29, IIF(MINL13.17 > L30 AND L30 < MINL13.31, L30, IIF(MINL13.18 > L31 AND L31 < MINL13.32, L31, IIF(MINL13.19 > L32 AND L32 < MINL13.33, L32, IIF(MINL13.20 > L33 AND L33 < MINL13.34, L33, IIF(MINL13.21 > L34 AND L34 < MINL13.35, L34, IIF(MINL13.22 > L35 AND L35 < MINL13.36, L35, IIF(MINL13.23 > L36 AND L36 < MINL13.37, L36, IIF(MINL13.24 > L37 AND L37 < MINL13.38, L37, IIF(MINL13.25 > L38 AND L38 < MINL13.39, L38, IIF(MINL13.26 > L39 AND L39 < MINL13.40, L39, IIF(MINL13.27 > L40 AND L40 < MINL13.41, L40, IIF(MINL13.28 > L41 AND L41 < MINL13.42, L41, IIF(MINL13.29 > L42 AND L42 < MINL13.43, L42, IIF(MINL13.30 > L43 AND L43 < MINL13.44, L43, IIF(MINL13.31 > L44 AND L44 < MINL13.45, L44, IIF(MINL13.32 > L45 AND L45 < MINL13.46, L45, IIF(MINL13.33 > L46 AND L46 < MINL13.47, L46, IIF(MINL13.34 > L47 AND L47 < MINL13.48, L47, IIF(MINL13.35 > L48 AND L48 < MINL13.49, L48, IIF(MINL13.36 > L49 AND L49 < MINL13.50, L49, IIF(MINL13.37 > L50 AND L50 < MINL13.51, L50, IIF(MINL13.38 > L51 AND L51 < MINL13.52, L51, IIF(MINL13.39 > L52 AND L52 < MINL13.53, L52, IIF(MINL13.40 > L53 AND L53 < MINL13.54, L53, IIF(MINL13.41 > L54 AND L54 < MINL13.55, L54, IIF(MINL13.42 > L55 AND L55 < MINL13.56, L55, IIF(MINL13.43 > L56 AND L56 < MINL13.57, L56, IIF(MINL13.44 > L57 AND L57 < MINL13.58, L57, IIF(MINL13.45 > L58 AND L58 < MINL13.59, L58, IIF(MINL13.46 > L59 AND L59 < MINL13.60, L59, IIF(MINL13.47 > L60 AND L60 < MINL13.61, L60, IIF(MINL13.48 > L61 AND L61 < MINL13.62, L61, IIF(MINL13.49 > L62 AND L62 < MINL13.63, L62, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))), 1 / 0)


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Wednesday, June 13, 2018 1:18:46 PM
Registered User
Joined: 3/10/2012
Posts: 372

Sorry Bruce but that is still not correct... 

In my TWTR example I mentioned to you about that formula should be true only when it meets Swing low as most recent and Swing high in past 

SO SWING HIGH = MARCH 14 TH 

SWINg LOW = APRIL 04TH 

SWING HIGH = APRIL 20TH BUT but but THERE IS NO 13 bar SWING LOW AFTER APRIL 20TH SO the main swing  will be MARCH 14th to APRIL 04th  hence that what i said is my criteria is to draw FIB FROMSWING HIGH IN PAST TO most recent IDENTIFIED SWING LOW OF 13 BAR , 

So in simple terms if u pick up your drawing tool of FIB RETRACEMENT AND PLOT FROM SWING HIGH OF MARCH 14TH THAT IS 100% AND SWING LOW OF APRIL 04TH IS "0" %

hope it make sense or i can link another example 

Bruce_L
Posted : Wednesday, June 13, 2018 1:22:02 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,971

Then refer to my previous response about only being able to detect the most recent swing high and swing low. There is no way for the formula to just ignore the April 20, 2018 swing high.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Wednesday, June 13, 2018 1:39:29 PM
Registered User
Joined: 3/10/2012
Posts: 372

Okay Bruce I see what u mean... so how about changing SWING HIGH paramenters to 34 bars and keeping Swing Low same as 13 bars so that will not pick up April 20th Swing high correct  ??

And then when i draw fib retracement from Swing High of March 14th to swing low of April 04th the curent high value of fib should be between 161.8 and 175.00

thanks 

Bruce_L
Posted : Wednesday, June 13, 2018 2:50:53 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,971

Please try the following indicator formula.

IIF(TrueInRow(NOT(MINL13 > L13 AND L13 < MINL13.14), 50) + 13 < TrueInRow(NOT(MAXH34 < H34 AND H34 > MAXH34.35), 50) + 34, 100 * (H - IIF(MINL13 > L13 AND L13 < MINL13.14, L13, IIF(MINL13.1 > L14 AND L14 < MINL13.15, L14, IIF(MINL13.2 > L15 AND L15 < MINL13.16, L15, IIF(MINL13.3 > L16 AND L16 < MINL13.17, L16, IIF(MINL13.4 > L17 AND L17 < MINL13.18, L17, IIF(MINL13.5 > L18 AND L18 < MINL13.19, L18, IIF(MINL13.6 > L19 AND L19 < MINL13.20, L19, IIF(MINL13.7 > L20 AND L20 < MINL13.21, L20, IIF(MINL13.8 > L21 AND L21 < MINL13.22, L21, IIF(MINL13.9 > L22 AND L22 < MINL13.23, L22, IIF(MINL13.10 > L23 AND L23 < MINL13.24, L23, IIF(MINL13.11 > L24 AND L24 < MINL13.25, L24, IIF(MINL13.12 > L25 AND L25 < MINL13.26, L25, IIF(MINL13.13 > L26 AND L26 < MINL13.27, L26, IIF(MINL13.14 > L27 AND L27 < MINL13.28, L27, IIF(MINL13.15 > L28 AND L28 < MINL13.29, L28, IIF(MINL13.16 > L29 AND L29 < MINL13.30, L29, IIF(MINL13.17 > L30 AND L30 < MINL13.31, L30, IIF(MINL13.18 > L31 AND L31 < MINL13.32, L31, IIF(MINL13.19 > L32 AND L32 < MINL13.33, L32, IIF(MINL13.20 > L33 AND L33 < MINL13.34, L33, IIF(MINL13.21 > L34 AND L34 < MINL13.35, L34, IIF(MINL13.22 > L35 AND L35 < MINL13.36, L35, IIF(MINL13.23 > L36 AND L36 < MINL13.37, L36, IIF(MINL13.24 > L37 AND L37 < MINL13.38, L37, IIF(MINL13.25 > L38 AND L38 < MINL13.39, L38, IIF(MINL13.26 > L39 AND L39 < MINL13.40, L39, IIF(MINL13.27 > L40 AND L40 < MINL13.41, L40, IIF(MINL13.28 > L41 AND L41 < MINL13.42, L41, IIF(MINL13.29 > L42 AND L42 < MINL13.43, L42, IIF(MINL13.30 > L43 AND L43 < MINL13.44, L43, IIF(MINL13.31 > L44 AND L44 < MINL13.45, L44, IIF(MINL13.32 > L45 AND L45 < MINL13.46, L45, IIF(MINL13.33 > L46 AND L46 < MINL13.47, L46, IIF(MINL13.34 > L47 AND L47 < MINL13.48, L47, IIF(MINL13.35 > L48 AND L48 < MINL13.49, L48, IIF(MINL13.36 > L49 AND L49 < MINL13.50, L49, IIF(MINL13.37 > L50 AND L50 < MINL13.51, L50, IIF(MINL13.38 > L51 AND L51 < MINL13.52, L51, IIF(MINL13.39 > L52 AND L52 < MINL13.53, L52, IIF(MINL13.40 > L53 AND L53 < MINL13.54, L53, IIF(MINL13.41 > L54 AND L54 < MINL13.55, L54, IIF(MINL13.42 > L55 AND L55 < MINL13.56, L55, IIF(MINL13.43 > L56 AND L56 < MINL13.57, L56, IIF(MINL13.44 > L57 AND L57 < MINL13.58, L57, IIF(MINL13.45 > L58 AND L58 < MINL13.59, L58, IIF(MINL13.46 > L59 AND L59 < MINL13.60, L59, IIF(MINL13.47 > L60 AND L60 < MINL13.61, L60, IIF(MINL13.48 > L61 AND L61 < MINL13.62, L61, IIF(MINL13.49 > L62 AND L62 < MINL13.63, L62, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))) / (IIF(MAXH34.0 < H34 AND H34 > MAXH34.35, H34, IIF(MAXH34.1 < H35 AND H35 > MAXH34.36, H35, IIF(MAXH34.2 < H36 AND H36 > MAXH34.37, H36, IIF(MAXH34.3 < H37 AND H37 > MAXH34.38, H37, IIF(MAXH34.4 < H38 AND H38 > MAXH34.39, H38, IIF(MAXH34.5 < H39 AND H39 > MAXH34.40, H39, IIF(MAXH34.6 < H40 AND H40 > MAXH34.41, H40, IIF(MAXH34.7 < H41 AND H41 > MAXH34.42, H41, IIF(MAXH34.8 < H42 AND H42 > MAXH34.43, H42, IIF(MAXH34.9 < H43 AND H43 > MAXH34.44, H43, IIF(MAXH34.10 < H44 AND H44 > MAXH34.45, H44, IIF(MAXH34.11 < H45 AND H45 > MAXH34.46, H45, IIF(MAXH34.12 < H46 AND H46 > MAXH34.47, H46, IIF(MAXH34.13 < H47 AND H47 > MAXH34.48, H47, IIF(MAXH34.14 < H48 AND H48 > MAXH34.49, H48, IIF(MAXH34.15 < H49 AND H49 > MAXH34.50, H49, IIF(MAXH34.16 < H50 AND H50 > MAXH34.51, H50, IIF(MAXH34.17 < H51 AND H51 > MAXH34.52, H51, IIF(MAXH34.18 < H52 AND H52 > MAXH34.53, H52, IIF(MAXH34.19 < H53 AND H53 > MAXH34.54, H53, IIF(MAXH34.20 < H54 AND H54 > MAXH34.55, H54, IIF(MAXH34.21 < H55 AND H55 > MAXH34.56, H55, IIF(MAXH34.22 < H56 AND H56 > MAXH34.57, H56, IIF(MAXH34.23 < H57 AND H57 > MAXH34.58, H57, IIF(MAXH34.24 < H58 AND H58 > MAXH34.59, H58, IIF(MAXH34.25 < H59 AND H59 > MAXH34.60, H59, IIF(MAXH34.26 < H60 AND H60 > MAXH34.61, H60, IIF(MAXH34.27 < H61 AND H61 > MAXH34.62, H61, IIF(MAXH34.28 < H62 AND H62 > MAXH34.63, H62, IIF(MAXH34.29 < H63 AND H63 > MAXH34.64, H63, IIF(MAXH34.30 < H64 AND H64 > MAXH34.65, H64, IIF(MAXH34.31 < H65 AND H65 > MAXH34.66, H65, IIF(MAXH34.32 < H66 AND H66 > MAXH34.67, H66, IIF(MAXH34.33 < H67 AND H67 > MAXH34.68, H67, IIF(MAXH34.34 < H68 AND H68 > MAXH34.69, H68, IIF(MAXH34.35 < H69 AND H69 > MAXH34.70, H69, IIF(MAXH34.36 < H70 AND H70 > MAXH34.71, H70, IIF(MAXH34.37 < H71 AND H71 > MAXH34.72, H71, IIF(MAXH34.38 < H72 AND H72 > MAXH34.73, H72, IIF(MAXH34.39 < H73 AND H73 > MAXH34.74, H73, IIF(MAXH34.40 < H74 AND H74 > MAXH34.75, H74, IIF(MAXH34.41 < H75 AND H75 > MAXH34.76, H75, IIF(MAXH34.42 < H76 AND H76 > MAXH34.77, H76, IIF(MAXH34.43 < H77 AND H77 > MAXH34.78, H77, IIF(MAXH34.44 < H78 AND H78 > MAXH34.79, H78, IIF(MAXH34.45 < H79 AND H79 > MAXH34.80, H79, IIF(MAXH34.46 < H80 AND H80 > MAXH34.81, H80, IIF(MAXH34.47 < H81 AND H81 > MAXH34.82, H81, IIF(MAXH34.48 < H82 AND H82 > MAXH34.83, H82, IIF(MAXH34.49 < H83 AND H83 > MAXH34.84, H83, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))) - IIF(MINL13 > L13 AND L13 < MINL13.14, L13, IIF(MINL13.1 > L14 AND L14 < MINL13.15, L14, IIF(MINL13.2 > L15 AND L15 < MINL13.16, L15, IIF(MINL13.3 > L16 AND L16 < MINL13.17, L16, IIF(MINL13.4 > L17 AND L17 < MINL13.18, L17, IIF(MINL13.5 > L18 AND L18 < MINL13.19, L18, IIF(MINL13.6 > L19 AND L19 < MINL13.20, L19, IIF(MINL13.7 > L20 AND L20 < MINL13.21, L20, IIF(MINL13.8 > L21 AND L21 < MINL13.22, L21, IIF(MINL13.9 > L22 AND L22 < MINL13.23, L22, IIF(MINL13.10 > L23 AND L23 < MINL13.24, L23, IIF(MINL13.11 > L24 AND L24 < MINL13.25, L24, IIF(MINL13.12 > L25 AND L25 < MINL13.26, L25, IIF(MINL13.13 > L26 AND L26 < MINL13.27, L26, IIF(MINL13.14 > L27 AND L27 < MINL13.28, L27, IIF(MINL13.15 > L28 AND L28 < MINL13.29, L28, IIF(MINL13.16 > L29 AND L29 < MINL13.30, L29, IIF(MINL13.17 > L30 AND L30 < MINL13.31, L30, IIF(MINL13.18 > L31 AND L31 < MINL13.32, L31, IIF(MINL13.19 > L32 AND L32 < MINL13.33, L32, IIF(MINL13.20 > L33 AND L33 < MINL13.34, L33, IIF(MINL13.21 > L34 AND L34 < MINL13.35, L34, IIF(MINL13.22 > L35 AND L35 < MINL13.36, L35, IIF(MINL13.23 > L36 AND L36 < MINL13.37, L36, IIF(MINL13.24 > L37 AND L37 < MINL13.38, L37, IIF(MINL13.25 > L38 AND L38 < MINL13.39, L38, IIF(MINL13.26 > L39 AND L39 < MINL13.40, L39, IIF(MINL13.27 > L40 AND L40 < MINL13.41, L40, IIF(MINL13.28 > L41 AND L41 < MINL13.42, L41, IIF(MINL13.29 > L42 AND L42 < MINL13.43, L42, IIF(MINL13.30 > L43 AND L43 < MINL13.44, L43, IIF(MINL13.31 > L44 AND L44 < MINL13.45, L44, IIF(MINL13.32 > L45 AND L45 < MINL13.46, L45, IIF(MINL13.33 > L46 AND L46 < MINL13.47, L46, IIF(MINL13.34 > L47 AND L47 < MINL13.48, L47, IIF(MINL13.35 > L48 AND L48 < MINL13.49, L48, IIF(MINL13.36 > L49 AND L49 < MINL13.50, L49, IIF(MINL13.37 > L50 AND L50 < MINL13.51, L50, IIF(MINL13.38 > L51 AND L51 < MINL13.52, L51, IIF(MINL13.39 > L52 AND L52 < MINL13.53, L52, IIF(MINL13.40 > L53 AND L53 < MINL13.54, L53, IIF(MINL13.41 > L54 AND L54 < MINL13.55, L54, IIF(MINL13.42 > L55 AND L55 < MINL13.56, L55, IIF(MINL13.43 > L56 AND L56 < MINL13.57, L56, IIF(MINL13.44 > L57 AND L57 < MINL13.58, L57, IIF(MINL13.45 > L58 AND L58 < MINL13.59, L58, IIF(MINL13.46 > L59 AND L59 < MINL13.60, L59, IIF(MINL13.47 > L60 AND L60 < MINL13.61, L60, IIF(MINL13.48 > L61 AND L61 < MINL13.62, L61, IIF(MINL13.49 > L62 AND L62 < MINL13.63, L62, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))), 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Wednesday, June 13, 2018 3:16:48 PM
Registered User
Joined: 3/10/2012
Posts: 372

Bruce one thing I know is you never disappoint... thank you now it works perfect... AWESOME

One last question since we are on this topic ... if you check the link screen of TWTR" above

I want to identify C" Point when i draw FIB retracement from SWING HIGH of 34 bar to SWING low of 13 bar the current Low C" point fib value will come in BETWEEN 18 and 16 when retracement drawn from swing high of March 14th to Swing Low of April 04th ... 

So do u think its possible to compute in pcf ?? 

thanks 

Bruce_L
Posted : Wednesday, June 13, 2018 3:36:17 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,971

Maybe it is in there and I am just not comprehending it, but I would need a specific unambiguous objective definition of C in order to identify it using an algorithm.

I can see it in the picture, but why is it C and why isn't some other bar C?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Wednesday, June 13, 2018 4:03:57 PM
Registered User
Joined: 3/10/2012
Posts: 372

Ah! Ok Bruce so we have to work on harmonic patterns some day since that topic is not explored well in the forums .. since we have established some ground rules so for today lets take break and will come back to you with more Visual examples and will open whole new subject of Harmonics patterns for computations 

Thanks for everything 

Cheers

 

Bruce_L
Posted : Wednesday, June 13, 2018 4:11:03 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,971

The big problem with harmonic patterns in TC2000 is identifying more than the most recent swing high and swing low.

There is some pretty good harmonics related stuff for StockFinder, but RealCode is a full programming language.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Wednesday, June 13, 2018 4:17:24 PM
Registered User
Joined: 3/10/2012
Posts: 372

Yes I realized that but using the Fractals and combination of fib ratios we can still define and draw them ,,, but for you to compute them i will type them how exactly i want to conditions to meet those W" AND M" Patterns so it will be easy viewing for others who are learning or following the pattern trading.. 

Cheers

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.