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

Chart Scale Increment Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Architect
Posted : Monday, June 19, 2006 9:14:22 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
One of the nice features of TCNet is the Chart Scale Increment which is printed in Helvetical Bold at the bottom of the price window in red.

Too bad you can't sort by that.

Architect
Posted : Monday, June 19, 2006 9:16:45 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
Or you could divide that number by the current price of the stock and sort by that, thus eliminating the high price bias.

Craig_S
Posted : Monday, June 19, 2006 9:27:43 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
You can sort by it.

What zoom are you looking at? We can write you PCFs for your zoom level.

- Craig
Here to Help!
Architect
Posted : Monday, June 19, 2006 9:42:34 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
Ok Craig, that would be great!
Try 15' because you can see the whole day at a high zoom level.
Zoom 9 is most important.
Bruce_L
Posted : Monday, June 19, 2006 10:03:38 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Architect,
Personal Criteria Formulas can't be written for timeframes shorter than Daily (and that's what I'm providing here):

Zoom 1++ (1125 or 1124 Bars):
100 * (MAXH1125 / MINL1125) ^ (1 / 12) - 100

Zoom 1+ (750 or 749 Bars):
100 * (MAXH750 / MINL750) ^ (1 / 12) - 100

Zoom 1 (500 or 499 Bars):
100 * (MAXH500 / MINL500) ^ (1 / 12) - 100

Zoom 2 (333 or 332 Bars):
100 * (MAXH333 / MINL333) ^ (1 / 12) - 100

Zoom 3 (222 or 221 Bars):
100 * (MAXH222 / MINL222) ^ (1 / 12) - 100

Zoom 4 (148 or 147 Bars):
100 * (MAXH148 / MINL148) ^ (1 / 12) - 100

Zoom 5 (99 or 98 Bars):
100 * (MAXH99 / MINL99) ^ (1 / 12) - 100

Zoom 6 (66 or 65 Bars):
100 * (MAXH66 / MINL66) ^ (1 / 12) - 100

Zoom 7 (44 or 43 Bars):
100 * (MAXH44 / MINL44) ^ (1 / 12) - 100

Zoom 8 (29 or 28 Bars):
100 * (MAXH29 / MINL29) ^ (1 / 12) - 100

Zoom 9 (20 or 19 Bars):
100 * (MAXH20 / MINL20) ^ (1 / 12) - 100

These formulas can be used in 15 Minute Mode (or any timeframe for that matter) as a Custom Indicator for use in Indicator Sorts. You may wish to review the following:

Plotting Custom Indicators with Examples
Real time indicator sorting (available at the Platinum level)
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Architect
Posted : Tuesday, June 20, 2006 11:09:56 AM
Registered User
Joined: 10/7/2004
Posts: 1,279
Thanks Bruce,

I tried the Zoom 9 Baby and it seems to give false readings.
Even if I lop the figures to 1 significant digit.
Architect
Posted : Tuesday, June 20, 2006 11:10:58 AM
Registered User
Joined: 10/7/2004
Posts: 1,279
I have created some 750 PCF's and still have a lot to learn there.
Bruce_L
Posted : Tuesday, June 20, 2006 12:21:00 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
The value returned by the Personal Criteria Formulas from my Monday, June 19, 2006 10:03:38 PM ET post are based on the entire chart range. The red value displayed in the lower right hand corner of the charts appears to be the percent difference between just the top two gridlines. The following PCFs should be closer to these values (that said, the first batch of PCFs might still be preferable):

Zoom 1++ (1125 or 1124 Bars):
100 * ((100 * MAXH1125 / ((MAXH1125 / MINL1125) ^ (1 / 12))) \ 1) / ((100 * MAXH1125 / ((MAXH1125 / MINL1125) ^ (1 / 6))) \ 1) - 100

Zoom 1+ (750 or 749 Bars):
100 * ((100 * MAXH750 / ((MAXH750 / MINL750) ^ (1 / 12))) \ 1) / ((100 * MAXH750 / ((MAXH750 / MINL750) ^ (1 / 6))) \ 1) - 100

Zoom 1 (500 or 499 Bars):
100 * ((100 * MAXH500 / ((MAXH500 / MINL500) ^ (1 / 12))) \ 1) / ((100 * MAXH500 / ((MAXH500 / MINL500) ^ (1 / 6))) \ 1) - 100

Zoom 2 (333 or 332 Bars):
100 * ((100 * MAXH333 / ((MAXH333 / MINL333) ^ (1 / 12))) \ 1) / ((100 * MAXH333 / ((MAXH333 / MINL333) ^ (1 / 6))) \ 1) - 100

Zoom 3 (222 or 221 Bars):
100 * ((100 * MAXH222 / ((MAXH222 / MINL222) ^ (1 / 12))) \ 1) / ((100 * MAXH222 / ((MAXH222 / MINL222) ^ (1 / 6))) \ 1) - 100

Zoom 4 (148 or 147 Bars):
100 * ((100 * MAXH148 / ((MAXH148 / MINL148) ^ (1 / 12))) \ 1) / ((100 * MAXH148 / ((MAXH148 / MINL148) ^ (1 / 6))) \ 1) - 100

Zoom 5 (99 or 98 Bars):
100 * ((100 * MAXH99 / ((MAXH99 / MINL99) ^ (1 / 12))) \ 1) / ((100 * MAXH99 / ((MAXH99 / MINL99) ^ (1 / 6))) \ 1) - 100

Zoom 6 (66 or 65 Bars):
100 * ((100 * MAXH66 / ((MAXH66 / MINL66) ^ (1 / 12))) \ 1) / ((100 * MAXH66 / ((MAXH66 / MINL66) ^ (1 / 6))) \ 1) - 100

Zoom 7 (44 or 43 Bars):
100 * ((100 * MAXH44 / ((MAXH44 / MINL44) ^ (1 / 12))) \ 1) / ((100 * MAXH44 / ((MAXH44 / MINL44) ^ (1 / 6))) \ 1) - 100

Zoom 8 (29 or 28 Bars):
100 * ((100 * MAXH29 / ((MAXH29 / MINL29) ^ (1 / 12))) \ 1) / ((100 * MAXH29 / ((MAXH29 / MINL29) ^ (1 / 6))) \ 1) - 100

Zoom 9 (20 or 19 Bars):
100 * ((100 * MAXH20 / ((MAXH20 / MINL20) ^ (1 / 12))) \ 1) / ((100 * MAXH20 / ((MAXH20 / MINL20) ^ (1 / 6))) \ 1) - 100

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Architect
Posted : Tuesday, June 20, 2006 3:04:52 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
Methinks not Bruce.

The red value is simply the scale increment between all the adjacent lines of the scale.

Bill
Craig_S
Posted : Tuesday, June 20, 2006 3:08:24 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
The red percent number is the percent increase for each line.

Example:

If the red number is 4.24 and the first gridline is 10.50 then the next number is 10.95 which is 10.50*1.0424 rounded up.

This being said, Bruce's second set of PCFs match perfectly

- Craig
Here to Help!
Architect
Posted : Tuesday, June 20, 2006 3:08:55 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
Those PCF's give false values.
You should also be able to reduce it to 2 significant digits.
Architect
Posted : Tuesday, June 20, 2006 3:10:02 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
What we're trying to do here is be able to sort on that value on any watchlist to determine the biggest swingers.
Craig_S
Posted : Tuesday, June 20, 2006 3:14:28 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
What do you mean by FALSE values? What do you mean by 2 significant digits?

The PCF:

100 * ((100 * MAXH20 / ((MAXH20 / MINL20) ^ (1 / 12))) \ 1) / ((100 * MAXH20 / ((MAXH20 / MINL20) ^ (1 / 6))) \ 1) - 100

Returns a value of 3.37 for CRYO

Cryo on zoom 9 log scale has a red number of 3.37

- Craig
Here to Help!
Bruce_L
Posted : Tuesday, June 20, 2006 5:01:45 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (Architect)
Those PCF's give false values. You should also be able to reduce it to 2 significant digits.

The second set of Personal Criteria Formula seems to exactly match (down to the last digit) the red value displayed in the lower left hand corner of a Daily Chart in the correct Zoom on my computer. One possible cause of any discrepencies you are seeing could be viewing Realtime charts since PCFs are based on twenty minute delayed Daily data.

QUOTE (Architect)
Methinks not Bruce. The red value is simply the scale increment between all the adjacent lines of the scale.

I'm not sure what I said with which you disagree, but your second statement is true (at least to a point). From the Chart Scaling section of the Online Help Files (only the part in the quotes):

"Logarithmic scaling - Displays the price data on a logarithmic scale where the distance between each price on the scale is a fixed percentage. The percentage (shown in red at bottom of price scale) will vary depending on the volatility on the chart.

Note: The log of a negative number does not exist so symbols or indicators with negative values, such as T2106 and T2118, you will need to set the scale to arithmetic to get an accurate chart."

This value seems to be derived from a specific set of gridlines however. The red percentage displayed in the lower right hand corner of the chart always seems to match the percentage difference between the top two gridlines (and may or may not match the percentage difference between the other gridlines depending on the symbol). The second set of PCFs is designed around this and seems to produce exact matches to the red percentage displayed in the lower right hand corner of the chart (although I would not be surprised if my use of integer divide to estimate the gridline values might not always match and result in occassional discrepencies, I've compared the values for hundreds of symbols in a variety of Zooms at this point without finding a single symbol comprised entirely of positive values that hasn't matched exactly).

QUOTE (Architect)
What we're trying to do here is be able to sort on that value on any watchlist to determine the biggest swingers.

I understand. This is why I suggested that the first batch of PCFs might still be preferable even though the second batch of PCFs more closely matches the value displayed on the chart.

It is possible to calculate the gridline values by using the results of the first set of PCFs (this is not always possible with the second set), although you would probably not wish to round the result to two digits past the decimal when attempting to do so.

If you take MAXHp (where p is the number of bars used in the PCF) and divide it by 1 plus the percentage (so 4.5% would equal 1.045) returned by the PCF from the first set twelve times (without rounding at any point), you will end up with 13 values. One will be the High, one will be the Low and the eleven in between will be the unrounded gridline values (rounding them to two points after the decimal at this point will give you the displayed gridline values).

(The same could be done by starting with MINLp and multiplying up the gridlines instead of dividing down from MAXHp.)

Computing the percentage difference between the top two rounded gridline values will produce the red percentage in the lower left hand corner of the charts (and will not necessarily match the percentage difference between the other gridlines).

The point being that the values produced by the second set of formulas involve "rounding" the results of the first set of formulas in a rather specific way to match the value displayed on the chart. If you are only interested in the "biggest swingers" and not the value displayed on the chart itself, the "unrounded" version would produce a more accurate ranking.

QUOTE (Architect)
Or you could divide that number by the current price of the stock and sort by that, thus eliminating the high price bias.

It is true that you can manipulate the value in a variety of ways if it can be reproduced using a PCF or Custom Indicator.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Architect
Posted : Tuesday, June 20, 2006 11:08:44 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
The value for CRYO is .02

I really don't care about a log scale, never mentioned it.

The log value is 1.32%, incidentally.

Log scales on intraday charts are nonsensical.

15 min chart zoom 9.

AAPL is .1

AAPL is huge comparatively.

Lower right side.

Increment is the operative word... TCNet calculates it automatically and selects the value to cram the data into the window.

Somebody is off base here.
Architect
Posted : Tuesday, June 20, 2006 11:16:20 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
The ordinate incremental value is the red number in the lower right corner of the price window.

It does not vary from grid line to grid line.

Commonly found values are:

.1
.2
.5
.01
.05

etc,etc.

I think that you have not answered my initial request.

Bill
StockGuy
Posted : Wednesday, June 21, 2006 12:05:13 AM

Administration

Joined: 9/30/2004
Posts: 9,187
I'm no math whiz but I think this will get the results you're looking for. For zoom level 5, use:

100 - ABS((MaxH99-MinL99) - maxh99)/(MaxH99) * 100

This formula returns the percentage of the max high for the period displayed that the price range covers.

As an example, I have AAPL on a 15-min chart and the custom indicator returns 4.59 in the sort. Thus the range of values on the chart for the time period displayed is 4.59% of the Max High for that same period. Even on a 15 minute arithmetic chart, "big swingers" can only be determined relative to their own stock price.

This might be just a different take on Bruce's formula, I'm not sure, but this is how my brain works. Hope this helps. If not, no need to debate. Just ignore the post.

You can get bar counts for other zoom levels from Bruce's formulas above.
StockGuy
Posted : Wednesday, June 21, 2006 12:10:27 AM

Administration

Joined: 9/30/2004
Posts: 9,187
Yep, tested Bruce's formula, 100 * (MAXH99 / MINL99) ^ (1 / 12) - 100, and the sort results are the same. But I think both are correct.

Doesn't find "biggest swingers" in terms of dollar amount, but that's not really relevant, in my opinion.
Bruce_L
Posted : Wednesday, June 21, 2006 8:07:48 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Architech,
When using Arithmetic Scale with Use Classic TeleChart Scaling checked, the number in the lower right hand corner of the chart is just the range divided by twelve (with some rounding applied that is not taken into account below). You might want to try using the following approximations:

Zoom 1++ (1125 or 1124 Bars):
(MAXH1125 / MINL1125) / 12

Zoom 1+ (750 or 749 Bars):
(MAXH750 / MINL750) / 12

Zoom 1 (500 or 499 Bars):
(MAXH500 / MINL500) / 12

Zoom 2 (333 or 332 Bars):
(MAXH333 / MINL333) / 12

Zoom 3 (222 or 221 Bars):
(MAXH222 / MINL222) / 12

Zoom 4 (148 or 147 Bars):
(MAXH148 / MINL148) / 12

Zoom 5 (99 or 98 Bars):
(MAXH99 / MINL99) / 12

Zoom 6 (66 or 65 Bars):
(MAXH66 / MINL66) / 12

Zoom 7 (44 or 43 Bars):
(MAXH44 / MINL44) / 12

Zoom 8 (29 or 28 Bars):
(MAXH29 / MINL29) / 12

Zoom 9 (20 or 19 Bars):
(MAXH20 / MINL20) / 12

When using Arithmetic Scale with Use Classic TeleChart Scaling unchecked, it's basically the same thing (range divided by gridlines plus one) except that instead of having a fixed number of gridlines (eleven), there is a maximum number of gridlines (eleven) and the result is limited to specific values when the range is less than 600000. You might want to try using the following approximations:

Zoom 1++ (1125 or 1124 Bars):
(MAXH1125 - MINL1125 > 0 AND MAXH1125 - MINL1125 < .12) * (-.01) - (MAXH1125 - MINL1125 >= .12 AND MAXH1125 - MINL1125 < .24) * .02 - (MAXH1125 - MINL1125 >= .24 AND MAXH1125 - MINL1125 < .6) * .05 - (MAXH1125 - MINL1125 >= .6 AND MAXH1125 - MINL1125 < 1.2) * .1 - (MAXH1125 - MINL1125 >= 1.2 AND MAXH1125 - MINL1125 < 2.4) * .2 - (MAXH1125 - MINL1125 >= 2.4 AND MAXH1125 - MINL1125 < 3) * .25 - (MAXH1125 - MINL1125 >= 3 AND MAXH1125 - MINL1125 < 6) * .5 - (MAXH1125 - MINL1125 >= 6 AND MAXH1125 - MINL1125 < 12) * 1 - (MAXH1125 - MINL1125 >= 12 AND MAXH1125 - MINL1125 < 24) * 2 - (MAXH1125 - MINL1125 >= 24 AND MAXH1125 - MINL1125 < 30) * 2.5 - (MAXH1125 - MINL1125 >= 30 AND MAXH1125 - MINL1125 < 60) * 5 - (MAXH1125 - MINL1125 >= 60 AND MAXH1125 - MINL1125 < 120) * 10 - (MAXH1125 - MINL1125 >= 120 AND MAXH1125 - MINL1125 < 300) * 25 - (MAXH1125 - MINL1125 >= 300 AND MAXH1125 - MINL1125 < 600) * 50 - (MAXH1125 - MINL1125 >= 600 AND MAXH1125 - MINL1125 < 1200) * 100 - (MAXH1125 - MINL1125 >= 1200 AND MAXH1125 - MINL1125 < 3000) * 250 - (MAXH1125 - MINL1125 >= 3000 AND MAXH1125 - MINL1125 < 6000) * 500 - (MAXH1125 - MINL1125 >= 6000 AND MAXH1125 - MINL1125 < 12000) * 1000 - (MAXH1125 - MINL1125 >= 12000 AND MAXH1125 - MINL1125 < 30000) * 2500 - (MAXH1125 - MINL1125 >= 30000 AND MAXH1125 - MINL1125 < 60000) * 5000 - (MAXH1125 - MINL1125 >= 60000 AND MAXH1125 - MINL1125 < 120000) * 10000 - (MAXH1125 - MINL1125 >= 120000 AND MAXH1125 - MINL1125 < 300000) * 25000 - (MAXH1125 - MINL1125 >= 300000 AND MAXH1125 - MINL1125 < 600000) * 50000 - (MAXH1125 - MINL1125 >= 600000) * (MAXH1125 - MINL1125) / 12

Zoom 1+ (750 or 749 Bars):
(MAXH750 - MINL750 > 0 AND MAXH750 - MINL750 < .12) * (-.01) - (MAXH750 - MINL750 >= .12 AND MAXH750 - MINL750 < .24) * .02 - (MAXH750 - MINL750 >= .24 AND MAXH750 - MINL750 < .6) * .05 - (MAXH750 - MINL750 >= .6 AND MAXH750 - MINL750 < 1.2) * .1 - (MAXH750 - MINL750 >= 1.2 AND MAXH750 - MINL750 < 2.4) * .2 - (MAXH750 - MINL750 >= 2.4 AND MAXH750 - MINL750 < 3) * .25 - (MAXH750 - MINL750 >= 3 AND MAXH750 - MINL750 < 6) * .5 - (MAXH750 - MINL750 >= 6 AND MAXH750 - MINL750 < 12) * 1 - (MAXH750 - MINL750 >= 12 AND MAXH750 - MINL750 < 24) * 2 - (MAXH750 - MINL750 >= 24 AND MAXH750 - MINL750 < 30) * 2.5 - (MAXH750 - MINL750 >= 30 AND MAXH750 - MINL750 < 60) * 5 - (MAXH750 - MINL750 >= 60 AND MAXH750 - MINL750 < 120) * 10 - (MAXH750 - MINL750 >= 120 AND MAXH750 - MINL750 < 300) * 25 - (MAXH750 - MINL750 >= 300 AND MAXH750 - MINL750 < 600) * 50 - (MAXH750 - MINL750 >= 600 AND MAXH750 - MINL750 < 1200) * 100 - (MAXH750 - MINL750 >= 1200 AND MAXH750 - MINL750 < 3000) * 250 - (MAXH750 - MINL750 >= 3000 AND MAXH750 - MINL750 < 6000) * 500 - (MAXH750 - MINL750 >= 6000 AND MAXH750 - MINL750 < 12000) * 1000 - (MAXH750 - MINL750 >= 12000 AND MAXH750 - MINL750 < 30000) * 2500 - (MAXH750 - MINL750 >= 30000 AND MAXH750 - MINL750 < 60000) * 5000 - (MAXH750 - MINL750 >= 60000 AND MAXH750 - MINL750 < 120000) * 10000 - (MAXH750 - MINL750 >= 120000 AND MAXH750 - MINL750 < 300000) * 25000 - (MAXH750 - MINL750 >= 300000 AND MAXH750 - MINL750 < 600000) * 50000 - (MAXH750 - MINL750 >= 600000) * (MAXH750 - MINL750) / 12

Zoom 1 (500 or 499 Bars):
(MAXH500 - MINL500 > 0 AND MAXH500 - MINL500 < .12) * (-.01) - (MAXH500 - MINL500 >= .12 AND MAXH500 - MINL500 < .24) * .02 - (MAXH500 - MINL500 >= .24 AND MAXH500 - MINL500 < .6) * .05 - (MAXH500 - MINL500 >= .6 AND MAXH500 - MINL500 < 1.2) * .1 - (MAXH500 - MINL500 >= 1.2 AND MAXH500 - MINL500 < 2.4) * .2 - (MAXH500 - MINL500 >= 2.4 AND MAXH500 - MINL500 < 3) * .25 - (MAXH500 - MINL500 >= 3 AND MAXH500 - MINL500 < 6) * .5 - (MAXH500 - MINL500 >= 6 AND MAXH500 - MINL500 < 12) * 1 - (MAXH500 - MINL500 >= 12 AND MAXH500 - MINL500 < 24) * 2 - (MAXH500 - MINL500 >= 24 AND MAXH500 - MINL500 < 30) * 2.5 - (MAXH500 - MINL500 >= 30 AND MAXH500 - MINL500 < 60) * 5 - (MAXH500 - MINL500 >= 60 AND MAXH500 - MINL500 < 120) * 10 - (MAXH500 - MINL500 >= 120 AND MAXH500 - MINL500 < 300) * 25 - (MAXH500 - MINL500 >= 300 AND MAXH500 - MINL500 < 600) * 50 - (MAXH500 - MINL500 >= 600 AND MAXH500 - MINL500 < 1200) * 100 - (MAXH500 - MINL500 >= 1200 AND MAXH500 - MINL500 < 3000) * 250 - (MAXH500 - MINL500 >= 3000 AND MAXH500 - MINL500 < 6000) * 500 - (MAXH500 - MINL500 >= 6000 AND MAXH500 - MINL500 < 12000) * 1000 - (MAXH500 - MINL500 >= 12000 AND MAXH500 - MINL500 < 30000) * 2500 - (MAXH500 - MINL500 >= 30000 AND MAXH500 - MINL500 < 60000) * 5000 - (MAXH500 - MINL500 >= 60000 AND MAXH500 - MINL500 < 120000) * 10000 - (MAXH500 - MINL500 >= 120000 AND MAXH500 - MINL500 < 300000) * 25000 - (MAXH500 - MINL500 >= 300000 AND MAXH500 - MINL500 < 600000) * 50000 - (MAXH500 - MINL500 >= 600000) * (MAXH500 - MINL500) / 12

Zoom 2 (333 or 332 Bars):
(MAXH333 - MINL333 > 0 AND MAXH333 - MINL333 < .12) * (-.01) - (MAXH333 - MINL333 >= .12 AND MAXH333 - MINL333 < .24) * .02 - (MAXH333 - MINL333 >= .24 AND MAXH333 - MINL333 < .6) * .05 - (MAXH333 - MINL333 >= .6 AND MAXH333 - MINL333 < 1.2) * .1 - (MAXH333 - MINL333 >= 1.2 AND MAXH333 - MINL333 < 2.4) * .2 - (MAXH333 - MINL333 >= 2.4 AND MAXH333 - MINL333 < 3) * .25 - (MAXH333 - MINL333 >= 3 AND MAXH333 - MINL333 < 6) * .5 - (MAXH333 - MINL333 >= 6 AND MAXH333 - MINL333 < 12) * 1 - (MAXH333 - MINL333 >= 12 AND MAXH333 - MINL333 < 24) * 2 - (MAXH333 - MINL333 >= 24 AND MAXH333 - MINL333 < 30) * 2.5 - (MAXH333 - MINL333 >= 30 AND MAXH333 - MINL333 < 60) * 5 - (MAXH333 - MINL333 >= 60 AND MAXH333 - MINL333 < 120) * 10 - (MAXH333 - MINL333 >= 120 AND MAXH333 - MINL333 < 300) * 25 - (MAXH333 - MINL333 >= 300 AND MAXH333 - MINL333 < 600) * 50 - (MAXH333 - MINL333 >= 600 AND MAXH333 - MINL333 < 1200) * 100 - (MAXH333 - MINL333 >= 1200 AND MAXH333 - MINL333 < 3000) * 250 - (MAXH333 - MINL333 >= 3000 AND MAXH333 - MINL333 < 6000) * 500 - (MAXH333 - MINL333 >= 6000 AND MAXH333 - MINL333 < 12000) * 1000 - (MAXH333 - MINL333 >= 12000 AND MAXH333 - MINL333 < 30000) * 2500 - (MAXH333 - MINL333 >= 30000 AND MAXH333 - MINL333 < 60000) * 5000 - (MAXH333 - MINL333 >= 60000 AND MAXH333 - MINL333 < 120000) * 10000 - (MAXH333 - MINL333 >= 120000 AND MAXH333 - MINL333 < 300000) * 25000 - (MAXH333 - MINL333 >= 300000 AND MAXH333 - MINL333 < 600000) * 50000 - (MAXH333 - MINL333 >= 600000) * (MAXH333 - MINL333) / 12

Zoom 3 (222 or 221 Bars):
(MAXH222 - MINL222 > 0 AND MAXH222 - MINL222 < .12) * (-.01) - (MAXH222 - MINL222 >= .12 AND MAXH222 - MINL222 < .24) * .02 - (MAXH222 - MINL222 >= .24 AND MAXH222 - MINL222 < .6) * .05 - (MAXH222 - MINL222 >= .6 AND MAXH222 - MINL222 < 1.2) * .1 - (MAXH222 - MINL222 >= 1.2 AND MAXH222 - MINL222 < 2.4) * .2 - (MAXH222 - MINL222 >= 2.4 AND MAXH222 - MINL222 < 3) * .25 - (MAXH222 - MINL222 >= 3 AND MAXH222 - MINL222 < 6) * .5 - (MAXH222 - MINL222 >= 6 AND MAXH222 - MINL222 < 12) * 1 - (MAXH222 - MINL222 >= 12 AND MAXH222 - MINL222 < 24) * 2 - (MAXH222 - MINL222 >= 24 AND MAXH222 - MINL222 < 30) * 2.5 - (MAXH222 - MINL222 >= 30 AND MAXH222 - MINL222 < 60) * 5 - (MAXH222 - MINL222 >= 60 AND MAXH222 - MINL222 < 120) * 10 - (MAXH222 - MINL222 >= 120 AND MAXH222 - MINL222 < 300) * 25 - (MAXH222 - MINL222 >= 300 AND MAXH222 - MINL222 < 600) * 50 - (MAXH222 - MINL222 >= 600 AND MAXH222 - MINL222 < 1200) * 100 - (MAXH222 - MINL222 >= 1200 AND MAXH222 - MINL222 < 3000) * 250 - (MAXH222 - MINL222 >= 3000 AND MAXH222 - MINL222 < 6000) * 500 - (MAXH222 - MINL222 >= 6000 AND MAXH222 - MINL222 < 12000) * 1000 - (MAXH222 - MINL222 >= 12000 AND MAXH222 - MINL222 < 30000) * 2500 - (MAXH222 - MINL222 >= 30000 AND MAXH222 - MINL222 < 60000) * 5000 - (MAXH222 - MINL222 >= 60000 AND MAXH222 - MINL222 < 120000) * 10000 - (MAXH222 - MINL222 >= 120000 AND MAXH222 - MINL222 < 300000) * 25000 - (MAXH222 - MINL222 >= 300000 AND MAXH222 - MINL222 < 600000) * 50000 - (MAXH222 - MINL222 >= 600000) * (MAXH222 - MINL222) / 12

Zoom 4 (148 or 147 Bars):
(MAXH148 - MINL148 > 0 AND MAXH148 - MINL148 < .12) * (-.01) - (MAXH148 - MINL148 >= .12 AND MAXH148 - MINL148 < .24) * .02 - (MAXH148 - MINL148 >= .24 AND MAXH148 - MINL148 < .6) * .05 - (MAXH148 - MINL148 >= .6 AND MAXH148 - MINL148 < 1.2) * .1 - (MAXH148 - MINL148 >= 1.2 AND MAXH148 - MINL148 < 2.4) * .2 - (MAXH148 - MINL148 >= 2.4 AND MAXH148 - MINL148 < 3) * .25 - (MAXH148 - MINL148 >= 3 AND MAXH148 - MINL148 < 6) * .5 - (MAXH148 - MINL148 >= 6 AND MAXH148 - MINL148 < 12) * 1 - (MAXH148 - MINL148 >= 12 AND MAXH148 - MINL148 < 24) * 2 - (MAXH148 - MINL148 >= 24 AND MAXH148 - MINL148 < 30) * 2.5 - (MAXH148 - MINL148 >= 30 AND MAXH148 - MINL148 < 60) * 5 - (MAXH148 - MINL148 >= 60 AND MAXH148 - MINL148 < 120) * 10 - (MAXH148 - MINL148 >= 120 AND MAXH148 - MINL148 < 300) * 25 - (MAXH148 - MINL148 >= 300 AND MAXH148 - MINL148 < 600) * 50 - (MAXH148 - MINL148 >= 600 AND MAXH148 - MINL148 < 1200) * 100 - (MAXH148 - MINL148 >= 1200 AND MAXH148 - MINL148 < 3000) * 250 - (MAXH148 - MINL148 >= 3000 AND MAXH148 - MINL148 < 6000) * 500 - (MAXH148 - MINL148 >= 6000 AND MAXH148 - MINL148 < 12000) * 1000 - (MAXH148 - MINL148 >= 12000 AND MAXH148 - MINL148 < 30000) * 2500 - (MAXH148 - MINL148 >= 30000 AND MAXH148 - MINL148 < 60000) * 5000 - (MAXH148 - MINL148 >= 60000 AND MAXH148 - MINL148 < 120000) * 10000 - (MAXH148 - MINL148 >= 120000 AND MAXH148 - MINL148 < 300000) * 25000 - (MAXH148 - MINL148 >= 300000 AND MAXH148 - MINL148 < 600000) * 50000 - (MAXH148 - MINL148 >= 600000) * (MAXH148 - MINL148) / 12

Zoom 5 (99 or 98 Bars):
(MAXH99 - MINL99 > 0 AND MAXH99 - MINL99 < .12) * (-.01) - (MAXH99 - MINL99 >= .12 AND MAXH99 - MINL99 < .24) * .02 - (MAXH99 - MINL99 >= .24 AND MAXH99 - MINL99 < .6) * .05 - (MAXH99 - MINL99 >= .6 AND MAXH99 - MINL99 < 1.2) * .1 - (MAXH99 - MINL99 >= 1.2 AND MAXH99 - MINL99 < 2.4) * .2 - (MAXH99 - MINL99 >= 2.4 AND MAXH99 - MINL99 < 3) * .25 - (MAXH99 - MINL99 >= 3 AND MAXH99 - MINL99 < 6) * .5 - (MAXH99 - MINL99 >= 6 AND MAXH99 - MINL99 < 12) * 1 - (MAXH99 - MINL99 >= 12 AND MAXH99 - MINL99 < 24) * 2 - (MAXH99 - MINL99 >= 24 AND MAXH99 - MINL99 < 30) * 2.5 - (MAXH99 - MINL99 >= 30 AND MAXH99 - MINL99 < 60) * 5 - (MAXH99 - MINL99 >= 60 AND MAXH99 - MINL99 < 120) * 10 - (MAXH99 - MINL99 >= 120 AND MAXH99 - MINL99 < 300) * 25 - (MAXH99 - MINL99 >= 300 AND MAXH99 - MINL99 < 600) * 50 - (MAXH99 - MINL99 >= 600 AND MAXH99 - MINL99 < 1200) * 100 - (MAXH99 - MINL99 >= 1200 AND MAXH99 - MINL99 < 3000) * 250 - (MAXH99 - MINL99 >= 3000 AND MAXH99 - MINL99 < 6000) * 500 - (MAXH99 - MINL99 >= 6000 AND MAXH99 - MINL99 < 12000) * 1000 - (MAXH99 - MINL99 >= 12000 AND MAXH99 - MINL99 < 30000) * 2500 - (MAXH99 - MINL99 >= 30000 AND MAXH99 - MINL99 < 60000) * 5000 - (MAXH99 - MINL99 >= 60000 AND MAXH99 - MINL99 < 120000) * 10000 - (MAXH99 - MINL99 >= 120000 AND MAXH99 - MINL99 < 300000) * 25000 - (MAXH99 - MINL99 >= 300000 AND MAXH99 - MINL99 < 600000) * 50000 - (MAXH99 - MINL99 >= 600000) * (MAXH99 - MINL99) / 12

Zoom 6 (66 or 65 Bars):
(MAXH66 - MINL66 > 0 AND MAXH66 - MINL66 < .12) * (-.01) - (MAXH66 - MINL66 >= .12 AND MAXH66 - MINL66 < .24) * .02 - (MAXH66 - MINL66 >= .24 AND MAXH66 - MINL66 < .6) * .05 - (MAXH66 - MINL66 >= .6 AND MAXH66 - MINL66 < 1.2) * .1 - (MAXH66 - MINL66 >= 1.2 AND MAXH66 - MINL66 < 2.4) * .2 - (MAXH66 - MINL66 >= 2.4 AND MAXH66 - MINL66 < 3) * .25 - (MAXH66 - MINL66 >= 3 AND MAXH66 - MINL66 < 6) * .5 - (MAXH66 - MINL66 >= 6 AND MAXH66 - MINL66 < 12) * 1 - (MAXH66 - MINL66 >= 12 AND MAXH66 - MINL66 < 24) * 2 - (MAXH66 - MINL66 >= 24 AND MAXH66 - MINL66 < 30) * 2.5 - (MAXH66 - MINL66 >= 30 AND MAXH66 - MINL66 < 60) * 5 - (MAXH66 - MINL66 >= 60 AND MAXH66 - MINL66 < 120) * 10 - (MAXH66 - MINL66 >= 120 AND MAXH66 - MINL66 < 300) * 25 - (MAXH66 - MINL66 >= 300 AND MAXH66 - MINL66 < 600) * 50 - (MAXH66 - MINL66 >= 600 AND MAXH66 - MINL66 < 1200) * 100 - (MAXH66 - MINL66 >= 1200 AND MAXH66 - MINL66 < 3000) * 250 - (MAXH66 - MINL66 >= 3000 AND MAXH66 - MINL66 < 6000) * 500 - (MAXH66 - MINL66 >= 6000 AND MAXH66 - MINL66 < 12000) * 1000 - (MAXH66 - MINL66 >= 12000 AND MAXH66 - MINL66 < 30000) * 2500 - (MAXH66 - MINL66 >= 30000 AND MAXH66 - MINL66 < 60000) * 5000 - (MAXH66 - MINL66 >= 60000 AND MAXH66 - MINL66 < 120000) * 10000 - (MAXH66 - MINL66 >= 120000 AND MAXH66 - MINL66 < 300000) * 25000 - (MAXH66 - MINL66 >= 300000 AND MAXH66 - MINL66 < 600000) * 50000 - (MAXH66 - MINL66 >= 600000) * (MAXH66 - MINL66) / 12

Zoom 7 (44 or 43 Bars):
(MAXH44 - MINL44 > 0 AND MAXH44 - MINL44 < .12) * (-.01) - (MAXH44 - MINL44 >= .12 AND MAXH44 - MINL44 < .24) * .02 - (MAXH44 - MINL44 >= .24 AND MAXH44 - MINL44 < .6) * .05 - (MAXH44 - MINL44 >= .6 AND MAXH44 - MINL44 < 1.2) * .1 - (MAXH44 - MINL44 >= 1.2 AND MAXH44 - MINL44 < 2.4) * .2 - (MAXH44 - MINL44 >= 2.4 AND MAXH44 - MINL44 < 3) * .25 - (MAXH44 - MINL44 >= 3 AND MAXH44 - MINL44 < 6) * .5 - (MAXH44 - MINL44 >= 6 AND MAXH44 - MINL44 < 12) * 1 - (MAXH44 - MINL44 >= 12 AND MAXH44 - MINL44 < 24) * 2 - (MAXH44 - MINL44 >= 24 AND MAXH44 - MINL44 < 30) * 2.5 - (MAXH44 - MINL44 >= 30 AND MAXH44 - MINL44 < 60) * 5 - (MAXH44 - MINL44 >= 60 AND MAXH44 - MINL44 < 120) * 10 - (MAXH44 - MINL44 >= 120 AND MAXH44 - MINL44 < 300) * 25 - (MAXH44 - MINL44 >= 300 AND MAXH44 - MINL44 < 600) * 50 - (MAXH44 - MINL44 >= 600 AND MAXH44 - MINL44 < 1200) * 100 - (MAXH44 - MINL44 >= 1200 AND MAXH44 - MINL44 < 3000) * 250 - (MAXH44 - MINL44 >= 3000 AND MAXH44 - MINL44 < 6000) * 500 - (MAXH44 - MINL44 >= 6000 AND MAXH44 - MINL44 < 12000) * 1000 - (MAXH44 - MINL44 >= 12000 AND MAXH44 - MINL44 < 30000) * 2500 - (MAXH44 - MINL44 >= 30000 AND MAXH44 - MINL44 < 60000) * 5000 - (MAXH44 - MINL44 >= 60000 AND MAXH44 - MINL44 < 120000) * 10000 - (MAXH44 - MINL44 >= 120000 AND MAXH44 - MINL44 < 300000) * 25000 - (MAXH44 - MINL44 >= 300000 AND MAXH44 - MINL44 < 600000) * 50000 - (MAXH44 - MINL44 >= 600000) * (MAXH44 - MINL44) / 12

Zoom 8 (29 or 28 Bars):
(MAXH29 - MINL29 > 0 AND MAXH29 - MINL29 < .12) * (-.01) - (MAXH29 - MINL29 >= .12 AND MAXH29 - MINL29 < .24) * .02 - (MAXH29 - MINL29 >= .24 AND MAXH29 - MINL29 < .6) * .05 - (MAXH29 - MINL29 >= .6 AND MAXH29 - MINL29 < 1.2) * .1 - (MAXH29 - MINL29 >= 1.2 AND MAXH29 - MINL29 < 2.4) * .2 - (MAXH29 - MINL29 >= 2.4 AND MAXH29 - MINL29 < 3) * .25 - (MAXH29 - MINL29 >= 3 AND MAXH29 - MINL29 < 6) * .5 - (MAXH29 - MINL29 >= 6 AND MAXH29 - MINL29 < 12) * 1 - (MAXH29 - MINL29 >= 12 AND MAXH29 - MINL29 < 24) * 2 - (MAXH29 - MINL29 >= 24 AND MAXH29 - MINL29 < 30) * 2.5 - (MAXH29 - MINL29 >= 30 AND MAXH29 - MINL29 < 60) * 5 - (MAXH29 - MINL29 >= 60 AND MAXH29 - MINL29 < 120) * 10 - (MAXH29 - MINL29 >= 120 AND MAXH29 - MINL29 < 300) * 25 - (MAXH29 - MINL29 >= 300 AND MAXH29 - MINL29 < 600) * 50 - (MAXH29 - MINL29 >= 600 AND MAXH29 - MINL29 < 1200) * 100 - (MAXH29 - MINL29 >= 1200 AND MAXH29 - MINL29 < 3000) * 250 - (MAXH29 - MINL29 >= 3000 AND MAXH29 - MINL29 < 6000) * 500 - (MAXH29 - MINL29 >= 6000 AND MAXH29 - MINL29 < 12000) * 1000 - (MAXH29 - MINL29 >= 12000 AND MAXH29 - MINL29 < 30000) * 2500 - (MAXH29 - MINL29 >= 30000 AND MAXH29 - MINL29 < 60000) * 5000 - (MAXH29 - MINL29 >= 60000 AND MAXH29 - MINL29 < 120000) * 10000 - (MAXH29 - MINL29 >= 120000 AND MAXH29 - MINL29 < 300000) * 25000 - (MAXH29 - MINL29 >= 300000 AND MAXH29 - MINL29 < 600000) * 50000 - (MAXH29 - MINL29 >= 600000) * (MAXH29 - MINL29) / 12

Zoom 9 (20 or 19 Bars):
(MAXH20 - MINL20 > 0 AND MAXH20 - MINL20 < .12) * (-.01) - (MAXH20 - MINL20 >= .12 AND MAXH20 - MINL20 < .24) * .02 - (MAXH20 - MINL20 >= .24 AND MAXH20 - MINL20 < .6) * .05 - (MAXH20 - MINL20 >= .6 AND MAXH20 - MINL20 < 1.2) * .1 - (MAXH20 - MINL20 >= 1.2 AND MAXH20 - MINL20 < 2.4) * .2 - (MAXH20 - MINL20 >= 2.4 AND MAXH20 - MINL20 < 3) * .25 - (MAXH20 - MINL20 >= 3 AND MAXH20 - MINL20 < 6) * .5 - (MAXH20 - MINL20 >= 6 AND MAXH20 - MINL20 < 12) * 1 - (MAXH20 - MINL20 >= 12 AND MAXH20 - MINL20 < 24) * 2 - (MAXH20 - MINL20 >= 24 AND MAXH20 - MINL20 < 30) * 2.5 - (MAXH20 - MINL20 >= 30 AND MAXH20 - MINL20 < 60) * 5 - (MAXH20 - MINL20 >= 60 AND MAXH20 - MINL20 < 120) * 10 - (MAXH20 - MINL20 >= 120 AND MAXH20 - MINL20 < 300) * 25 - (MAXH20 - MINL20 >= 300 AND MAXH20 - MINL20 < 600) * 50 - (MAXH20 - MINL20 >= 600 AND MAXH20 - MINL20 < 1200) * 100 - (MAXH20 - MINL20 >= 1200 AND MAXH20 - MINL20 < 3000) * 250 - (MAXH20 - MINL20 >= 3000 AND MAXH20 - MINL20 < 6000) * 500 - (MAXH20 - MINL20 >= 6000 AND MAXH20 - MINL20 < 12000) * 1000 - (MAXH20 - MINL20 >= 12000 AND MAXH20 - MINL20 < 30000) * 2500 - (MAXH20 - MINL20 >= 30000 AND MAXH20 - MINL20 < 60000) * 5000 - (MAXH20 - MINL20 >= 60000 AND MAXH20 - MINL20 < 120000) * 10000 - (MAXH20 - MINL20 >= 120000 AND MAXH20 - MINL20 < 300000) * 25000 - (MAXH20 - MINL20 >= 300000 AND MAXH20 - MINL20 < 600000) * 50000 - (MAXH20 - MINL20 >= 600000) * (MAXH20 - MINL20) / 12

The second set of formulas in this post can probably be simplified or shortened to some extent, but the progression changes somewhat depending on the magnitude of the range (which is why the simplest approach seemed to be to just check the range and assign a value). Symbols at the boundaries between two possible results are always evaluated to the higher of the two values. It is possible to determine which value should be assigned, but the techniques I've tried to do this so far make the formulas significantly longer.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Architect
Posted : Wednesday, June 21, 2006 12:30:17 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
Woah and Wow!

I just had a tiny little request.

15' chart, zoom nine, grid icrement.

Didn't expect the Encyclopedia Britanica!

So now where are we?

All the other zooms are irrelivant.

Zoom 9 is the most powerful zoom of all... would be nice to have a zoom 10 on the 1'chart.

Zoom 9 minimizes the span... very important to indicators.

Craig_S
Posted : Wednesday, June 21, 2006 12:32:44 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
What scaling and time frame are you using on your chart?

- Craig
Here to Help!
Architect
Posted : Wednesday, June 21, 2006 12:51:41 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
I don't wish to minimize your comments... they are giving me lots of insight... but I just had a simple question...

You see there is a trick in all this... when you plot C in the indicator windows... support and risistance automatically show up. You have revealed to me an essential for automatic programmed trading.

But I still want to just sort on that incremental value on the 15' chart at zoom 9.

That is a key figure.

If you sorted upon it on any watchlist, you'd quickly see the powerful operators.

(MAXH20 / MINL20) / 12 seems to return the correct value for AAPL but GOOG is way off... should be 2.0 instead of .09.

How in the world do you explain this?
Bruce_L
Posted : Wednesday, June 21, 2006 12:55:39 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
To me, that would seem to indicate that Use Classic TeleChart Scaling is unchecked (see Chart Display Options - customize the look and functionality of your charts). Please try the following instead:

Zoom 9 (20 or 19 Bars):
(MAXH20 - MINL20 > 0 AND MAXH20 - MINL20 < .12) * (-.01) - (MAXH20 - MINL20 >= .12 AND MAXH20 - MINL20 < .24) * .02 - (MAXH20 - MINL20 >= .24 AND MAXH20 - MINL20 < .6) * .05 - (MAXH20 - MINL20 >= .6 AND MAXH20 - MINL20 < 1.2) * .1 - (MAXH20 - MINL20 >= 1.2 AND MAXH20 - MINL20 < 2.4) * .2 - (MAXH20 - MINL20 >= 2.4 AND MAXH20 - MINL20 < 3) * .25 - (MAXH20 - MINL20 >= 3 AND MAXH20 - MINL20 < 6) * .5 - (MAXH20 - MINL20 >= 6 AND MAXH20 - MINL20 < 12) * 1 - (MAXH20 - MINL20 >= 12 AND MAXH20 - MINL20 < 24) * 2 - (MAXH20 - MINL20 >= 24 AND MAXH20 - MINL20 < 30) * 2.5 - (MAXH20 - MINL20 >= 30 AND MAXH20 - MINL20 < 60) * 5 - (MAXH20 - MINL20 >= 60 AND MAXH20 - MINL20 < 120) * 10 - (MAXH20 - MINL20 >= 120 AND MAXH20 - MINL20 < 300) * 25 - (MAXH20 - MINL20 >= 300 AND MAXH20 - MINL20 < 600) * 50 - (MAXH20 - MINL20 >= 600 AND MAXH20 - MINL20 < 1200) * 100 - (MAXH20 - MINL20 >= 1200 AND MAXH20 - MINL20 < 3000) * 250 - (MAXH20 - MINL20 >= 3000 AND MAXH20 - MINL20 < 6000) * 500 - (MAXH20 - MINL20 >= 6000 AND MAXH20 - MINL20 < 12000) * 1000 - (MAXH20 - MINL20 >= 12000 AND MAXH20 - MINL20 < 30000) * 2500 - (MAXH20 - MINL20 >= 30000 AND MAXH20 - MINL20 < 60000) * 5000 - (MAXH20 - MINL20 >= 60000 AND MAXH20 - MINL20 < 120000) * 10000 - (MAXH20 - MINL20 >= 120000 AND MAXH20 - MINL20 < 300000) * 25000 - (MAXH20 - MINL20 >= 300000 AND MAXH20 - MINL20 < 600000) * 50000 - (MAXH20 - MINL20 >= 600000) * (MAXH20 - MINL20) / 12

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Architect
Posted : Wednesday, June 21, 2006 2:20:18 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
It really doesn't appear that you can solve my simple little request using PCF's.

TCNet extracts that number and prints it out red right there on the charts for all to see.

Maybe there would be a way to extract it and print it out in a column on the spreadsheet/wl.

That way we could sort on this very important number.

It should be noted that the chart scale on the price window is handled much differently than the price scale on the indicator windows. On the price window the scale is clean and simple, incrementing on simple numbers.

It's that very simple number that is so powerful.

Sort on it and bwam!.. you instantly know what the relative power of each stock is.

Architect
Posted : Wednesday, June 21, 2006 2:22:28 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
Since you show no evidence of fulfilling upon my request using pcf's then this must become a suggestion for the program programmers.

You should be able to see the immense power of this.
Craig_S
Posted : Wednesday, June 21, 2006 2:31:14 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Seriously, Architect...

I asked you what scaling you are using... and you ignore my question.

Are you using Log or Arithmetic, Classic TeleChart or not?

Bruce has given you SEVERAL formulas that DO match the red number in the lower right corner of the top price window. The only way they DON'T work is if you are using different scaling settings than the PCF is designed to work with.

UNTIL you answer my question above, we cannot match the PCF to your charts.

WHEN we ask you a question it is because we need the answer to fulfill your request.

Please let us know the scaling setup on your charts. We already know your zoom... WHAT SCALING are you using?

- Craig
Here to Help!
Architect
Posted : Wednesday, June 21, 2006 4:34:21 PM
Registered User
Joined: 10/7/2004
Posts: 1,279


The A scale... should be obvious. No, I would never use "Classic Scaling". Presumably someone thought to create nice clean simple scaling on the charts. It is an example of brilliant, clear thinking... reducing the answer to simple, clear, rounded numbers.

Bill



Craig_S
Posted : Wednesday, June 21, 2006 4:46:22 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Ok.

Bruce gave the PCF above in his Wednesday, June 21, 2006 12:55:39 PM post:

(MAXH20 - MINL20 > 0 AND MAXH20 - MINL20 < .12) * (-.01) - (MAXH20 - MINL20 >= .12 AND MAXH20 - MINL20 < .24) * .02 - (MAXH20 - MINL20 >= .24 AND MAXH20 - MINL20 < .6) * .05 - (MAXH20 - MINL20 >= .6 AND MAXH20 - MINL20 < 1.2) * .1 - (MAXH20 - MINL20 >= 1.2 AND MAXH20 - MINL20 < 2.4) * .2 - (MAXH20 - MINL20 >= 2.4 AND MAXH20 - MINL20 < 3) * .25 - (MAXH20 - MINL20 >= 3 AND MAXH20 - MINL20 < 6) * .5 - (MAXH20 - MINL20 >= 6 AND MAXH20 - MINL20 < 12) * 1 - (MAXH20 - MINL20 >= 12 AND MAXH20 - MINL20 < 24) * 2 - (MAXH20 - MINL20 >= 24 AND MAXH20 - MINL20 < 30) * 2.5 - (MAXH20 - MINL20 >= 30 AND MAXH20 - MINL20 < 60) * 5 - (MAXH20 - MINL20 >= 60 AND MAXH20 - MINL20 < 120) * 10 - (MAXH20 - MINL20 >= 120 AND MAXH20 - MINL20 < 300) * 25 - (MAXH20 - MINL20 >= 300 AND MAXH20 - MINL20 < 600) * 50 - (MAXH20 - MINL20 >= 600 AND MAXH20 - MINL20 < 1200) * 100 - (MAXH20 - MINL20 >= 1200 AND MAXH20 - MINL20 < 3000) * 250 - (MAXH20 - MINL20 >= 3000 AND MAXH20 - MINL20 < 6000) * 500 - (MAXH20 - MINL20 >= 6000 AND MAXH20 - MINL20 < 12000) * 1000 - (MAXH20 - MINL20 >= 12000 AND MAXH20 - MINL20 < 30000) * 2500 - (MAXH20 - MINL20 >= 30000 AND MAXH20 - MINL20 < 60000) * 5000 - (MAXH20 - MINL20 >= 60000 AND MAXH20 - MINL20 < 120000) * 10000 - (MAXH20 - MINL20 >= 120000 AND MAXH20 - MINL20 < 300000) * 25000 - (MAXH20 - MINL20 >= 300000 AND MAXH20 - MINL20 < 600000) * 50000 - (MAXH20 - MINL20 >= 600000) * (MAXH20 - MINL20) / 12

Did you try it?

It returns the value of the red number under the scale in the bottom right of the top price window if you are on zoom 9, non-Classic and arithmetic.

You said above "It really doesn't appear that you can solve my simple little request using PCF's" but Bruce did solve your simple little request.

Please try the PCF and you will see it matches.

- Craig
Here to Help!
Architect
Posted : Thursday, June 22, 2006 11:09:36 AM
Registered User
Joined: 10/7/2004
Posts: 1,279
I tried it...

AAPL is currently displaying .2

The PCF reads 1.0


GOOG reads 1.0

PCF reads 2.5

Seems that doesn't work.

Is TCNet written in Visual Basic? Maybe a VB programmer could hook the data and print it out.
Craig_S
Posted : Thursday, June 22, 2006 11:17:28 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
All PCFs are based on Daily Data. GOOG gives 5.0 on a daily chart, the PCF gives 5.0 (no idea where you are seeing the PCF give 2.5 for GOOG)

I am concerned that you are not using the PCF I gave above, or not updating the PCF. Create a new PCF, test it on GOOG. Be sure you use the formula I gave you above:

(MAXH20 - MINL20 > 0 AND MAXH20 - MINL20 < .12) * (-.01) - (MAXH20 - MINL20 >= .12 AND MAXH20 - MINL20 < .24) * .02 - (MAXH20 - MINL20 >= .24 AND MAXH20 - MINL20 < .6) * .05 - (MAXH20 - MINL20 >= .6 AND MAXH20 - MINL20 < 1.2) * .1 - (MAXH20 - MINL20 >= 1.2 AND MAXH20 - MINL20 < 2.4) * .2 - (MAXH20 - MINL20 >= 2.4 AND MAXH20 - MINL20 < 3) * .25 - (MAXH20 - MINL20 >= 3 AND MAXH20 - MINL20 < 6) * .5 - (MAXH20 - MINL20 >= 6 AND MAXH20 - MINL20 < 12) * 1 - (MAXH20 - MINL20 >= 12 AND MAXH20 - MINL20 < 24) * 2 - (MAXH20 - MINL20 >= 24 AND MAXH20 - MINL20 < 30) * 2.5 - (MAXH20 - MINL20 >= 30 AND MAXH20 - MINL20 < 60) * 5 - (MAXH20 - MINL20 >= 60 AND MAXH20 - MINL20 < 120) * 10 - (MAXH20 - MINL20 >= 120 AND MAXH20 - MINL20 < 300) * 25 - (MAXH20 - MINL20 >= 300 AND MAXH20 - MINL20 < 600) * 50 - (MAXH20 - MINL20 >= 600 AND MAXH20 - MINL20 < 1200) * 100 - (MAXH20 - MINL20 >= 1200 AND MAXH20 - MINL20 < 3000) * 250 - (MAXH20 - MINL20 >= 3000 AND MAXH20 - MINL20 < 6000) * 500 - (MAXH20 - MINL20 >= 6000 AND MAXH20 - MINL20 < 12000) * 1000 - (MAXH20 - MINL20 >= 12000 AND MAXH20 - MINL20 < 30000) * 2500 - (MAXH20 - MINL20 >= 30000 AND MAXH20 - MINL20 < 60000) * 5000 - (MAXH20 - MINL20 >= 60000 AND MAXH20 - MINL20 < 120000) * 10000 - (MAXH20 - MINL20 >= 120000 AND MAXH20 - MINL20 < 300000) * 25000 - (MAXH20 - MINL20 >= 300000 AND MAXH20 - MINL20 < 600000) * 50000 - (MAXH20 - MINL20 >= 600000) * (MAXH20 - MINL20) / 12

I will assume you are looking at intraday data (where GOOG does have 1.0).

In order for you to use this PCF with intraday data, you will have to plot it as a Custom Indictator (as Bruce told you above).

Plot the formula as a Custom Indicator and it has a value of 1.0 (matching your red number). The PCF will always match the number.

If you want to RANK stocks based on this number while looking at INTRADAY charts you can sort by the plotted indictator.

- Craig
Here to Help!
Craig_S
Posted : Thursday, June 22, 2006 11:21:39 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
TeleChart is written in VB but the data you are using is streaming in. TeleChart does not grant outside access to the feed.

Plot the PCF as a custom indicator and sort by it. You will rank the WatchList by your red number on a intraday basis.

Please notice Bruce noted the CI option in his Tuesday, June 20, 2006 5:01:45 PM and Monday, June 19, 2006 10:03:38 PM posts.

As an experienced TeleChart Platinum user, I am confident you know calculated PCFs cannot be run on intraday data, only daily data. You can plot formulas as custom indicators and use them on intraday charts.

- Craig
Here to Help!
Architect
Posted : Thursday, June 22, 2006 11:56:14 AM
Registered User
Joined: 10/7/2004
Posts: 1,279
I have pasted it in twice now and when I hit the test button I get the result 1.0 for AAPL.

The sort value reads 100.

Currently the 15' chart reads .2

I just had a simple request....
Craig_S
Posted : Thursday, June 22, 2006 12:01:12 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
You need to sort by the ACTUAL value of the indicator, not the VISUAL VALUE.

Your test of 1.0 for AAPL is correct. AAPL has a red number of 1.0 on a daily chart (which, as mentioned, is what PCFs are calculated on). Save the PCF, calculate it and you will see a value returned for GOOG of 5.00 (which is correct for a daily chart).

Take the formula, plot as a Custom Indicator and sort by the ACTUAL VALUE (change Visual Value to Actual Value).

You did have a simple suggestion. Instead of leaving it as a just a suggestion, Bruce and I have taken the steps to get you what you want now. I am sure you would rather have the capability now vs. waiting to see if it is added as a future feature.

If you don't want our help, please let us know.

- Craig
Here to Help!
StockGuy
Posted : Thursday, June 22, 2006 12:13:10 PM

Administration

Joined: 9/30/2004
Posts: 9,187
Picture is always worth a thousand words.





Oops, those were in Daily mode, but works the same. Here's a 15-min chart, zoom 9:

Architect
Posted : Thursday, June 22, 2006 12:26:42 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
Ok. Sorting by ACTUAL VALUE is the trick!

It works and it is accurate. Thank you very much!
Good work, much appreciated... now to divide by C too.

Bravo and thanks again.

Pwhew! Exhausting but great.

Bill



Architect
Posted : Thursday, June 22, 2006 12:29:10 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
This PCF reveals the magnitude of the moves being made so far in the day and should be of great service to those who want to know "what's going on" in the realm of current "power".

Bill
Craig_S
Posted : Thursday, June 22, 2006 12:31:07 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
You're welcome.

- Craig
Here to Help!
StockGuy
Posted : Thursday, June 22, 2006 12:34:05 PM

Administration

Joined: 9/30/2004
Posts: 9,187
QUOTE (Architect)
Ok. Sorting by ACTUAL VALUE is the trick!

It works and it is accurate. Thank you very much!
Good work, much appreciated... now to divide by C too.


Just put ( ) around the current formula and add /C to the end (after the closing parens).
Architect
Posted : Thursday, June 22, 2006 12:50:32 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
Another way of saying this is that this suffices for an intraday movement sorter.

...It is an intraday indicator...

which allows you to sort by strength of movement, both positive and negative.

You could probably also modify it to just look for the long stuff and/or the short stuff.
Architect
Posted : Thursday, June 22, 2006 12:55:18 PM
Registered User
Joined: 10/7/2004
Posts: 1,279
Thanks Stock Guy too!

Really neat... just sorted for stocks greater than $2 with volume greater than 50,000 shares.

Fun!

Should eliminate a lot of flailing around hunting for stocks moving with strength.

This is huge!

We all should get bottles of wine for this.

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.