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

Request PCF Formula Price History Crossing UP Pivot Points R1 Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
raider45
Posted : Wednesday, February 14, 2018 2:32:38 PM
Registered User
Joined: 9/30/2011
Posts: 788

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:

 
Price History Crossing UP Pivot Points R1
 
Thank you and goodbye.
 
Raider45
Bruce_L
Posted : Wednesday, February 14, 2018 2:44:31 PM


Worden Trainer

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

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Thursday, February 15, 2018 4:41:21 AM
Registered User
Joined: 9/30/2011
Posts: 788
I request the modification of the formula with the following parameters:
 
The closing price on the previous trading day is equal to or higher than the current PIVOT central line and the current price is lower than the current R1.
Bruce_L
Posted : Thursday, February 15, 2018 9:04:03 AM


Worden Trainer

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

Please try the following.

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Thursday, February 15, 2018 9:16:49 AM
Registered User
Joined: 9/30/2011
Posts: 788
Big congratulations, thank you!
 
Best regards !
raider45
Posted : Thursday, February 15, 2018 1:05:16 PM
Registered User
Joined: 9/30/2011
Posts: 788
I would like the same formula with the following parameters:
 
The closing price on the previous trading day is equal to or higher than the current PIVOT S1 and the current price is lower than the current one at central PIVOT.
Bruce_L
Posted : Thursday, February 15, 2018 1:12:44 PM


Worden Trainer

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

Please try the following.

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Thursday, February 15, 2018 1:42:32 PM
Registered User
Joined: 9/30/2011
Posts: 788
Thank you!
 
Best regards !
stanleyikem
Posted : Thursday, May 17, 2018 5:21:33 PM
Registered User
Joined: 2/9/2011
Posts: 76

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

 

StockGuy
Posted : Thursday, May 17, 2018 9:02:35 PM

Administration

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

V > AVGV10.1 * 2

C > AVGC10.1

O > MAXH10.1

stanleyikem
Posted : Wednesday, May 23, 2018 11:35:43 AM
Registered User
Joined: 2/9/2011
Posts: 76

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

Bruce_L
Posted : Wednesday, May 23, 2018 11:44:50 AM


Worden Trainer

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

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stanleyikem
Posted : Wednesday, May 23, 2018 11:51:33 AM
Registered User
Joined: 2/9/2011
Posts: 76

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?

Bruce_L
Posted : Wednesday, May 23, 2018 12:04:14 PM


Worden Trainer

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

Yes, the formulas are in bars and not days.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stanleyikem
Posted : Tuesday, June 5, 2018 4:08:18 PM
Registered User
Joined: 2/9/2011
Posts: 76

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

Bruce_L
Posted : Wednesday, June 6, 2018 9:17:13 AM


Worden Trainer

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

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stanleyikem
Posted : Thursday, June 14, 2018 1:38:06 PM
Registered User
Joined: 2/9/2011
Posts: 76

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.

Bruce_L
Posted : Thursday, June 14, 2018 3:14:41 PM


Worden Trainer

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

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stanleyikem
Posted : Thursday, June 14, 2018 4:22:52 PM
Registered User
Joined: 2/9/2011
Posts: 76

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 

 

 

Bruce_L
Posted : Thursday, June 14, 2018 4:31:30 PM


Worden Trainer

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

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stanleyikem
Posted : Thursday, June 14, 2018 5:45:02 PM
Registered User
Joined: 2/9/2011
Posts: 76

Thank you Bruce.

very helpful. 

You rock!

stanleyikem
Posted : Monday, June 18, 2018 3:42:25 PM
Registered User
Joined: 2/9/2011
Posts: 76

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

Bruce_L
Posted : Monday, June 18, 2018 4:44:56 PM


Worden Trainer

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

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stanleyikem
Posted : Friday, June 29, 2018 12:52:03 PM
Registered User
Joined: 2/9/2011
Posts: 76

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

Bruce_L
Posted : Friday, June 29, 2018 1:01:06 PM


Worden Trainer

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

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stanleyikem
Posted : Friday, August 10, 2018 10:13:18 AM
Registered User
Joined: 2/9/2011
Posts: 76

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.

 

Bruce_L
Posted : Friday, August 10, 2018 10:25:15 AM


Worden Trainer

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

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stanleyikem
Posted : Friday, August 10, 2018 10:52:35 AM
Registered User
Joined: 2/9/2011
Posts: 76

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

 

 

Bruce_L
Posted : Friday, August 10, 2018 11:28:43 AM


Worden Trainer

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

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stanleyikem
Posted : Friday, August 10, 2018 11:54:57 AM
Registered User
Joined: 2/9/2011
Posts: 76

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

stanleyikem
Posted : Monday, September 10, 2018 2:44:52 PM
Registered User
Joined: 2/9/2011
Posts: 76

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

 

 

Bruce_L
Posted : Monday, September 10, 2018 2:59:17 PM


Worden Trainer

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

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)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stanleyikem
Posted : Monday, September 10, 2018 3:32:01 PM
Registered User
Joined: 2/9/2011
Posts: 76

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

 

 

 

Bruce_L
Posted : Monday, September 10, 2018 4:20:52 PM


Worden Trainer

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

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)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stanleyikem
Posted : Monday, September 10, 2018 4:28:55 PM
Registered User
Joined: 2/9/2011
Posts: 76

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

C  >MINH3.1 AND (TrueInRow(C1 > C2, 3) = 3 OR TrueInRow(H1 > H2, 3) = 3)
 
What is the primary difference between that and this (as per interpretation).
 
C > MAXH3.1 AND (TrueInRow(C1 > C2, 3) = 3 OR TrueInRow(L1 > L2, 3) = 3)
Bruce_L
Posted : Monday, September 10, 2018 4:35:46 PM


Worden Trainer

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

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stanleyikem
Posted : Monday, September 10, 2018 4:37:04 PM
Registered User
Joined: 2/9/2011
Posts: 76

Excellent - thanks Bruce

stanleyikem
Posted : Sunday, September 16, 2018 5:02:50 PM
Registered User
Joined: 2/9/2011
Posts: 76

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

Bruce_L
Posted : Monday, September 17, 2018 10:38:03 AM


Worden Trainer

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

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
stanleyikem
Posted : Thursday, September 20, 2018 10:07:02 PM
Registered User
Joined: 2/9/2011
Posts: 76

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 -

 

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.