Hi, I am trying to build a Fibonaaci scan I don't know if is possible, can you help me out here,

1. I am looking for Highest high last 26 week and lowest low 26 week

2. would be highest high or lowest low has bouns back and touch Fibonaaci level of 50%

thanks.

A Condition Formula for a bar or candle which touches the midpoint of the most recent 26 bars can be written as follows (so this would use a weekly time frame).

L <= (MAXH26 + MINL26) / 2 AND (MAXH26 + MINL26) / 2 <= H

If you wanted to do this using a daily time frame, you would probably want to change the period 126 instead.

L <= (MAXH126 + MINL126) / 2 AND (MAXH126 + MINL126) / 2 <= H

how about if i want to scan that touch the fibonaaci .618?  

If the .618 is closer to the high then you would use the following for the weekly version.

L <= .618 * MAXH26 + .382 * MINL26 AND .618 * MAXH26 + .382 * MINL26 <= H

If the .618 is closer to the low.

L <= .382 * MAXH26 + .618 * MINL26 AND .382 * MAXH26 + .618 * MINL26 <= H

And the following for the daily version.

L <= .618 * MAXH126 + .382 * MINL126 AND .618 * MAXH126 + .382 * MINL126 <= H

If the .618 is closer to the low.

L <= .382 * MAXH126 + .618 * MINL126 AND .382 * MAXH126 + .618 * MINL126 <= H

thank you.

and another question about the consolidation, if i want to scan a stock like MACK, GALE what is the formula would be?

follow up last question, i have use MAXH60 < C1 *1.10 AND MINL60 > C1 *0.90 did not see those two stock on the list, what did i do wrong??

There are lots of formula which would return both MACK and GALE currently. One possibility would be to compare the range over a short period to the range over a long period.

100 * (MAXH50 - MINL50) / (MAXH200- MINL200) <  15

Another would be to check for the percent range over a period to be less than some arbitrary value.

100 * (MAXH20 / MINL20 - 1) < 30

Yet another would be to check the average range as a percentage of the total range over an arbitrary period.

100 * (AVGH50 - AVGL50) / (MAXH60 - MINL50) > 15

The periods and percentages are all adjustable and you can combine the approaches by connecting them with OR (meeting any of the requiremenst) or with AND (needing to meet all of the requirements).

It looks like you didn't just set the range big enough.

While MINL60 is less than 8% below C1 for GALE, MAXH60 is more than 55% above C1.

While MAXH60 is less than 5% above C1 for MACK, MINL60 is more than 12% below C1.

great, thanks.

how do i narrow the MAXH and MINL range to be more close ?

For the first two formula in my Thursday, May 04, 2017 1:16:51 PM ET post you would reduce the value after the < sign at the end of the formula. For the third formula you would increase the value after the > sign at the end of the formula.

ok, thank you.

hi, if I want to use yesterday's day  to calculate consolidation is this right?

100 * (MAXH50.1 - MINL50.1) / (MAXH200.1- MINL200.1) <  15

void last question, i got it, thank you.

I am happy to read you were able to figure it out on your own.

dear trainer, is there anyway i can show 5 year daily chart ? thanks

Fyi, TC2000 is limited to 500 bars of data. 

5 years * around 252 trading days in a year = 1,260 bars.

About the best you can do (I tihnk) is flip to a 2-Day or 3-Day chart.

okay, thanks

hi, i would like to ask is possible to write a scan for , todays open 5% higher than yesterday close.

Please try the following.

O >= 1.05 * C1

hi, I like to ask how to write pcf on momentum scan? momentum 10 period, today momentum is greater than or higher than yesterday, thanks

Please try the following.

C / C10 > C1 / C11

hi i would like to ask how to write this pcf, today low is 30% drop from the 30 day high. thanks

Please try the following.

L <= .7 * MAXH30

the return is mix, i got OGEN CDTI.... , I am looking more like MNGA, HOV.

The condition is True for all four of those symbols.

You would eliminate the undesired symbols (OGEN & CDTI) if you checked for today's high being a 30% drop from 30 day high.

H <= .7 * MAXH30

Or even if you checked for the current price being a 30% drop from the 30 day high.

C <= .7 * MAXH30

But if you check for today's low instead of the high or current price as requested, then you will get the undesired symbols.