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 |

Relative Volume and Easyscan to Find Consecutive Lower Lows Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
edge13
Posted : Friday, July 14, 2017 1:41:54 AM
Registered User
Joined: 6/1/2017
Posts: 14

Hi, 

I'm a novice to TC2000 v17 and I'm trying to teach myself PCF. I have 2 problems now:

  1. Regard to relative volume, what are the differences between "V / AVGV20.1" and "V / AVGV(20.1)"? TC2000 gives me different numbers, why?
  2. I'm trying to make a scan to find at least 4 consecutive lower lows, is that possible for TC2000 to find the results with uncertain numbers? If so, how?

Thanks in advance!

Bruce_L
Posted : Friday, July 14, 2017 7:37:00 AM


Worden Trainer

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

V / AVGV20.1 is the volume of the current bar divided by the average volume of the 20 bars ending 1 bar ago.

V / AVGV(20.1) is an attempt to do the same thing, but it is not using the correct syntax. The period and bars ago parameters in functions need to be separated by commas instead of periods, so the actual format should be the following (and this is why the values don't match).

V / AVGV(20, 1)

Yes, it is possible. The following would check for at least 4 consecutive lower lows in TC2000 v17.

TrueInRow(L < L1, 4) = 4

If you wanted to check for exactly 4 consecutive lower lows (I know this isn't what you want to do, just want you to see why the other version works), you would have to check to make sure that prior to this there wasn't a lower low.

TrueInRow(L < L1, 4) = 4 AND L4 >= L5

Checking for exactly 4 consecutive lower lows could also be written as follows.

TrueInRow(L < L1, 5) = 4



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
edge13
Posted : Saturday, July 15, 2017 2:22:40 PM
Registered User
Joined: 6/1/2017
Posts: 14

That's Cool! Thank you, Bruce!

edge13
Posted : Monday, July 17, 2017 11:42:01 PM
Registered User
Joined: 6/1/2017
Posts: 14

Hi Bruce,

When you have time, can you explain the PCF "TrueInRow(L < L1, 4) = 4" for me a little bit please? Why is there a "=4" in the end?

Thank you very much!

Bruce_L
Posted : Tuesday, July 18, 2017 8:45:59 AM


Worden Trainer

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

TrueInRow(L < L1, 4) by itself returns a numeric value ranging from 0 (if L >= L1 for the most recent bar) to 4 (if L < L1 has been true for all of the most recent 4 bars).

Adding the = 4 to the end makes it so the formula returns true if L < L1 has been true for all of the most recent 4 bars bars (because the first part equals 4) and returns false otherwise.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
edge13
Posted : Wednesday, July 19, 2017 11:44:32 AM
Registered User
Joined: 6/1/2017
Posts: 14

Hi Bruce,

I want to make the 4 or more lower lows to be all open < close, I wrote it as:

TrueInRow(L < L1, 4)  = 4 AND TrueInRow(O < C, 4) = 4

It seems doesn't work, how can I do that please?

Thanks in Advance!

StockGuy
Posted : Wednesday, July 19, 2017 11:48:48 AM

Administration

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

Your formula is working for me. Returning True for AAPL on 4/27/2016

Bruce_L
Posted : Wednesday, July 19, 2017 11:56:25 AM


Worden Trainer

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

There is nothing wrong with your syntax, that just isn't going to happen very often.

You have the lows of the bars going down, but the internal action of the bar going up. This does happen, but happening four bars in a row is going to be very rare. It is currently only happening in a daily time frame for DUST, SCGLY, and T2105 in the largest WatchList in my copy of TC2000.

All of that said, I would probably write the formula as follows instead.

TrueInRow(L < L1 AND O < C, 4) = 4



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
edge13
Posted : Wednesday, July 19, 2017 7:04:57 PM
Registered User
Joined: 6/1/2017
Posts: 14

Maybe I descriped it wrong, I think what I want scan is very common. Please check the pictures.

and

Bruce_L
Posted : Thursday, July 20, 2017 9:05:52 AM


Worden Trainer

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

The close is below the open in your examples instead of the open being below the close as in your formula. Please try the following instead.

TrueInRow(L < L1 AND C < O, 4) = 4



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