You may need to look at page 2 for the answer to your question.

I would like to have a PCF Formula with the signal on the following parameter:

There isn't a way to do what I suspect you want. You can't write a  formula to check for an intraday bar going up through pivot points based on daily values because you can't mix time frames in a single formula.

The formula checks for the closing price of the previous trading day to be at or below the current R1 and the current price to above the current R1.

C1 <= 2 * (H1 + L1 + C1) / 3 - L1 AND 2 * (H1 + L1 + C1) / 3 - L1 < C

Please try the following.

C1 >= (H1 + L1 + C1) / 3 AND 2 * (H1 + L1 + C1) / 3 - L1 > C

Please try the following.

C >= 2 * (H1 + L1 + C1) / 3 - H1 AND (H1 + L1 + C1) / 3 > C

Hello Bruce - I need a quick help - 

I want to write each of these as a PCF formula that does the following - 

1) Current Volume on the day is 2x greater than the average volume for the last 10days (for instance)

2). Current price is greater than the average price for the last 10days (for instance). 

3). Current opening price is greater than the maximum highest price within the last 10 days (for instance)

I appreciate

ST

V > AVGV10.1 * 2

C > AVGC10.1

O > MAXH10.1

Hi Stockguy - Is it possible to transpose this formular to work for me intraday simply by choosing the time frame on the edit condition box?

V > AVGV10.1 * 2

C > AVGC10.1

O > MAXH10.1

Yes. Changing the time frame for the contdition should allow the formulas to work intraday instead of daily.

So I assume if we do that on 5mins fo instance... in a formular like C > AVGC10.1 

it would read Current price is greater than the average price for the last 10 bars within the 5mins time frame - right?

Which assume would mean that if I changed the "10" (as in the formula) to "300" on the same 5min time frame, it would mean 300 bars.... so that C > AVGC300.1  would mean, Current price (on the 5mins) is greater than the average price for the last 300 (5min) bars  - correct?

Yes, the formulas are in bars and not days.

Hello Bruce, I need your help.

Is it possible to write a formular that I can use as a market on the chart such that; 

1) I want to indicate the points in the charts where the price number of a bars High (for instance) = the price number of a bars low and I can a way to indicate that on my charts or on a list.... not sure how that is going to work. 

So if on a 5min chart of $TWTR for instance, the high of a bar is $39 and the low of a bar within a 250 day selection for instance is $39 - I want to highlight that point... and I like to have this done in realtime as the days bars play out.

Is that a possibility?

Please advise.

Stanley

No, there really isn't any sort of good way to do this in TC2000 currently.

Hello Bruce - Isn't there a formular that can be written on TC2000 that helps to scan for stocks with range? Not sure the ATR does it for me.... Something that I can say; scan for stocks that over a period of X has an average range of Y% and I should be able to transpose that in any time frame.

Please advise.

You can change for total range over a certain period. For example, the total range over the most recent 100 bars would be:

MAXH100 - MINL100

You can calculate the percent range over the period as well. For example, the total range as a percentage of teh low over the most recent 50 bars would be:

100 * (MAXH50 / MINL50 - 1)

You can also check for the average range. For example the average range over the most recent 21 bars would be the following.

AVG(H - L, 21)

If you want something to be at least some minimum range, you would add a >= after this with the desired value. If you want it to be a certain range at most, you would add a <= after this with the desired value.

Thanks Bruce - what if I wanted to check something like the average range over the most recent 21 bars for instance should be above 3% or 0.50 cents for instance.... How do I write that?

Secondly, How do I find stocks for instance that are greater than say 3% or higher - Cant seem to find "% change" option 

The average range over the most recent 21 bars being above 3% would be the following.

AVG(H / L, 21) > 1.03

The average range over the most recent 21 bars being greater than $0.50 would be the following.

AVG(H - L, 21) > .5

The total range over the most recent 21 bars being above 3% would be the following.

MAXH21 > 1.03 * MINL21

The total range over the most recent 21 being greater than $0.50 would be the following.

MAXH21 > MINL21 + .5

A 21 period price percent change over the most recent 21 bars being greater than 3% would be the following.

C > 1.03 * C21

A 21 period price change over the most recent 21 bars being greater than $0.50 would be the following.

C > C21 + .5

A 1 period price percent change greater than 3% would be the following.

C > 1.03 * C1

A 1 period net change greater $0.50 would be the following.

C > C1 + .5

There is a Rate of Change Percent indicator for calculating percent changes. There is a Rate of Change indicator calculating net changes.

Thank you Bruce.

very helpful. 

You rock!

Hello Bruce - I need to ask your professional advise - 

There is tc2000 formular I use on my charts that helps me identify support and resistance levels - works well for my style of trading - However I have always manually adjust these levels based on the formular (because it is not static) - and this is not only cumbersome but can sometime disract me while trading..... What would you advise as a thirdparty tool that I can transpose this formula to - to somewhat automate this process, so I don't always have to do this manually.... I am not a programmer atall, but I assuming if the data is available one can use Python of something of that sort right?

I wished there was a way to integrate some of these languages (Python, R etc) wit TC2000.... Any plans to do that in the future?

Please advise.

Stanley

I am not aware of any plans for TC2000 v18 to integrate or interface with a full programming language.

I do not know what third party tool my work for what you want to do. You can export chart data one symbol at a time, but I don't know of a good way to automate this process to get the data into another program.

Hello Bruce is there  a way to caluclate the distance/spacing between two moving average bands...? I not sure if using Standard Deviation apploies in this context.

So imagine a situation where we have the 9EMA and the 14SMA for instance.... and I want to be able to check the width between the bands - such that I can know when the moving average bands is tighter and when it is far apart.... What I want to be able to do in this case, is to write a formular for instance that does this;

Let me know when Price closes above the 9EMA and 14SMA; provided both moving averages are X away from each other -  (I assume we could use STD - maybe provided both bands are X STD away or close) - Not sure if STD applies - Just thinking...

The idea is to only get a signal of the closing bar above the moving avergae band ( the tighter the band is) and I want to be able to flip it to and get a signal of the closing bar below the moving average band (when the band is wider).

I really can't help much if you are just thinking at this point.

If you want to see how standard deviation, percentages, and average true range compare, add Bollinger Bands, Envelope Channels, and Keltner Channels with the same period and average type settings to the chart (you can adjust the std dev, width (%), and atr multiplier setings as desired to make the best comparisons).

The Keltner Channels will have a slightly different centerline (because it is a moving average of typical price instead of just price), but the widths of these bands can be quite a bit different depending on the underlying behavior of the symbol to which they are applied.

Hey Bruce,

How do I write a formular that indicates to me when premarket High or Low of a stock is broken.... I like to use it as a condition column on my existing watch lists.

Say for instance when the Opening price is above premarket high etc...

Please advise.

While you can plot pre and post market data on the chart if you have real time service, there is no way to create WatchList Columns, sorts, scans based the pre and post market data.

You can create formulas based on the pre and post market data if they are restricted to the charts using Custom PCF Indicators of some sort, but there is no way to distingish the normal market data from the pre and post market data within the formula.

Ok Bruce... Since as you say, "You can create formulas based on the pre and post market data if they are restricted to the charts using Custom PCF Indicators of some sort,...." Ok Can you give me an idea of how this can be done, if for instance I have premarket data on my charts of say $AWX today and I want to create a formula/indicator/condition whatever it is... that tells me that price has gone over the High of thde premarket (or I assume in the case where there is no difference between premarket and realtime date) a NEW HIGH or LOW above X bars (most of which could in this case be premarket bars).

All you can do is your fallback of checking for say the open of the current bar being above the high of some arbitrary number of previous bars (20 in this case).

O > MAXH20.1

You would create that as a Custom PCF % True Indicator.

If you were 10 bars into the trading day and the premarket data was 50 bars long, you could check to see if price had at any point during the trading day gone over the high of the pre-market using:

MAX10 > MAXH50.10

But keep in mind that these formulas are on the bar for which they were actually written. So you would need to look at the first bar of the trading day to check the first formula and the second formula would only do what you want on exactly the 10th bar of the trading day.

Thanks a lot Bruce. I would test whats given. Regards

Bruce, I need to write a formular that helps me find stocks beased on these conditions.....

1. Price has closed red (down) consequitively for the last 3days (daily) or price has had 3days of consequitive lower highs.

2. Only if (1) is true, then current price is lower (or crosses below) the average of the Low of the last 3days.

\Thanks

Please try the following if Color Based On is set to Net Change.

C < MINL3.1 AND (TrueInRow(C1 < C2, 3) = 3 OR TrueInRow(H1 < H2, 3) = 3)

Or the following if Color Based On is set to Open vs Close.

C < MINL3.1 AND (TrueInRow(C1 < O1, 3) = 3 OR TrueInRow(H1 < H2, 3) = 3)

Thanks Bruce. You rock. I assume if I want to do the reverse I would just flip the < signs to >? 

Or to be safe, help me write the same for the reverse. Thanks

It is mostly a matter of versing the less than signs into greater than signs, but there is also the matter of switching the highs and lows.

Please try the following if Color Based On is set to Net Change.

C > MAXH3.1 AND (TrueInRow(C1 > C2, 3) = 3 OR TrueInRow(L1 > L2, 3) = 3)

Or the following if Color Based On is set to Open vs Close.

C > MAXH3.1 AND (TrueInRow(C1 > O1, 3) = 3 OR TrueInRow(L1 > L2, 3) = 3)

O! Thanks Bruce - I had used this earlier though and got some interesting rsearchable results....

MINH3.1 is the lowest high over the most recent 3 bars ending 1 bar ago.

MAXH3.1 is the highest high over the most recent 3 bars ending 1 bar ago.

TrueInRow(H1 > H2, 3) = 3 checks for the high of 1 bar age being higher than the high of 2 bars ago for at least 3 bars in a row.

TrueInRow(L1 > L2, 3) = 3 checks for the low of 1 bar ago being higher than the low of 2 bars ago for at least 3 bars in a row.

Excellent - thanks Bruce

Hello Bruce - Is it possible to know the formular tha is used to calculate the pivot points on TC2000?

I would appreciate it - 

Secondly, is there a way to customize or write our own formular to calculate pivot points?

I appreciate

Stanley

The basic calculations used are available in the Pivot Points topic.

You can use the Last Value Horizontal Plot Style in a Custom PCF Indicator to plot horizontal lines for a formula similar to what are plotted for the Pivot Points, but there isn't a way to mix time frames so you could plot a daily formula on an intraday chart.

Hi bruce, thanks for the feedback - 

I am a litte unclear about the  Last Value Horizontal Plot Style .

Are you saying there is a way to write a PCF and have a horizontal line plotted? So for instance is there a way to draw/plot a horizontal line on my charts if I wanted calculate the average of the high over the last 50bars and show the results by plotting a horizontal line. Is that possible?

secondly, Is there a way to have a vertical line permanently fixed on my charts and have it reflect on ANY chart I pull up relative to time? That means I want a vertical line drawn at 10am and 2;30pm EST and I want to have this permanently on my charts without having to always do this everyday. Anyways to get that done?

Thanks -