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 |

Fibonacci Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
rchen
Posted : Monday, May 1, 2017 10:19:17 AM
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.

Bruce_L
Posted : Monday, May 1, 2017 10:38:21 AM


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
rchen
Posted : Monday, May 1, 2017 10:55:12 AM
Registered User
Joined: 10/7/2004
Posts: 87

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

Bruce_L
Posted : Monday, May 1, 2017 10:59:31 AM


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
rchen
Posted : Thursday, May 4, 2017 12:58:00 PM
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?

rchen
Posted : Thursday, May 4, 2017 1:15:01 PM
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??

Bruce_L
Posted : Thursday, May 4, 2017 1:16:51 PM


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
Bruce_L
Posted : Thursday, May 4, 2017 1:22:59 PM


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
rchen
Posted : Thursday, May 4, 2017 1:23:29 PM
Registered User
Joined: 10/7/2004
Posts: 87

great, thanks.

rchen
Posted : Thursday, May 4, 2017 1:54:11 PM
Registered User
Joined: 10/7/2004
Posts: 87

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

Bruce_L
Posted : Thursday, May 4, 2017 2:07:23 PM


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
rchen
Posted : Thursday, May 4, 2017 2:12:57 PM
Registered User
Joined: 10/7/2004
Posts: 87

ok, thank you.

rchen
Posted : Thursday, May 4, 2017 8:52:49 PM
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

rchen
Posted : Thursday, May 4, 2017 9:10:38 PM
Registered User
Joined: 10/7/2004
Posts: 87

void last question, i got it, thank you.

Bruce_L
Posted : Friday, May 5, 2017 9:01:21 AM


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
rchen
Posted : Tuesday, August 15, 2017 1:53:01 PM
Registered User
Joined: 10/7/2004
Posts: 87

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

Al_Gorithm
Posted : Tuesday, August 15, 2017 2:09:23 PM

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.

rchen
Posted : Tuesday, August 15, 2017 3:07:49 PM
Registered User
Joined: 10/7/2004
Posts: 87

okay, thanks

rchen
Posted : Tuesday, August 15, 2017 7:47:02 PM
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.

Bruce_L
Posted : Wednesday, August 16, 2017 8:58:05 AM


Worden Trainer

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

Please try the following.

O >= 1.05 * C1



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
rchen
Posted : Thursday, November 16, 2017 12:03:16 PM
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

Bruce_L
Posted : Thursday, November 16, 2017 12:13:54 PM


Worden Trainer

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

Please try the following.

C / C10 > C1 / C11



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
rchen
Posted : Thursday, January 25, 2018 12:57:40 PM
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

Bruce_L
Posted : Thursday, January 25, 2018 1:10:12 PM


Worden Trainer

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

Please try the following.

L <= .7 * MAXH30



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
rchen
Posted : Thursday, January 25, 2018 3:55:14 PM
Registered User
Joined: 10/7/2004
Posts: 87

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

StockGuy
Posted : Thursday, January 25, 2018 4:02:03 PM

Administration

Joined: 9/30/2004
Posts: 9,187

The condition is True for all four of those symbols.

Bruce_L
Posted : Thursday, January 25, 2018 4:02:42 PM


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
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.