Registered User Joined: 10/7/2004 Posts: 87
|
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.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
how about if i want to scan that touch the fibonaaci .618?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
thank you.
and another question about the consolidation, if i want to scan a stock like MACK, GALE what is the formula would be?
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
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??
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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).
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
great, thanks.
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
how do i narrow the MAXH and MINL range to be more close ?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
ok, thank you.
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
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
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
void last question, i got it, thank you.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I am happy to read you were able to figure it out on your own.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
dear trainer, is there anyway i can show 5 year daily chart ? thanks
|
|
Registered User Joined: 6/30/2017 Posts: 1,227
|
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.
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
okay, thanks
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
hi, i would like to ask is possible to write a scan for , todays open 5% higher than yesterday close.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following.
O >= 1.05 * C1
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
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
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following.
C / C10 > C1 / C11
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
hi i would like to ask how to write this pcf, today low is 30% drop from the 30 day high. thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following.
L <= .7 * MAXH30
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 87
|
the return is mix, i got OGEN CDTI.... , I am looking more like MNGA, HOV.
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
The condition is True for all four of those symbols.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |