New version 17 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

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

Profile: Bruce_L
About
User Name: Bruce_L
Groups: Gold User, Platinum User, TeleChart, Worden Staff, Worden Training Agent
Rank: Worden Trainer
Real Name:
Location
Occupation:
Interests:
Gender: Unsure
Statistics
Joined: Thursday, October 07, 2004
Last Visit: Thursday, July 27, 2017 5:01:40 PM
Number of Posts: 59,682
[21.16% of all post / 12.76 posts per day]
Avatar
Last 10 Posts
Topic: Request PCF Formula Hanging Man Pattern
Posted: Thursday, July 27, 2017 3:28:03 PM

Please try the following condition formula.

H - GREATEST(O, C) < (H - L) / 10 AND LEAST(O, C) - L > ABS(O - C) * 2 AND H1 > MAXH5.2



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Pivot Points-Intraday basis
Posted: Thursday, July 27, 2017 12:20:10 PM

We only carry the most recent block of pre / post market data. So the current pivot points on a 5-minute chart would be calculated using the data from 9:30 AM through midnight ET yesterday when using pre / post market data.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Request correction PCF Formula Tilson T3
Posted: Thursday, July 27, 2017 11:38:59 AM

You can plot the following formulas as Custom PCF Indicators in the same pane and scale as price.

T3 (3, .7):

-((7 / 10) ^ 3) * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC3, 3), 3), 3), 3), 3) + 3 * (((7 / 10) ^ 2) + ((7 / 10) ^ 3)) * XAVG(XAVG(XAVG(XAVG(XAVGC3, 3), 3), 3), 3) - (6 * ((7 / 10) ^ 2) + 3 * ((7 / 10) + ((7 / 10) ^ 3))) * XAVG(XAVG(XAVG(XAVGC3, 3), 3), 3) + (1 + 3 * (7 / 10) + ((7 / 10) ^ 3) + 3 * ((7 / 10) ^ 2)) * XAVG(XAVG(XAVGC3, 3), 3)

T3 (5, .7):

-((7 / 10) ^ 3) * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC5, 5), 5), 5), 5), 5) + 3 * (((7 / 10) ^ 2) + ((7 / 10) ^ 3)) * XAVG(XAVG(XAVG(XAVG(XAVGC5, 5), 5), 5), 5) - (6 * ((7 / 10) ^ 2) + 3 * ((7 / 10) + ((7 / 10) ^ 3))) * XAVG(XAVG(XAVG(XAVGC5, 5), 5), 5) + (1 + 3 * (7 / 10) + ((7 / 10) ^ 3) + 3 * ((7 / 10) ^ 2)) * XAVG(XAVG(XAVGC5, 5), 5)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Request correction PCF Formula MACD
Posted: Thursday, July 27, 2017 10:57:41 AM

You&#39;re welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Request correction PCF Formula Tilson T3
Posted: Thursday, July 27, 2017 10:23:30 AM

I&#39;m not sure if you wanted the 3 to crossup the 5 (which is what I wrote) or the 5 to crossup the 3.

XUP(-((7 / 10) ^ 3) * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC3, 3), 3), 3), 3), 3) + 3 * (((7 / 10) ^ 2) + ((7 / 10) ^ 3)) * XAVG(XAVG(XAVG(XAVG(XAVGC3, 3), 3), 3), 3) - (6 * ((7 / 10) ^ 2) + 3 * ((7 / 10) + ((7 / 10) ^ 3))) * XAVG(XAVG(XAVG(XAVGC3, 3), 3), 3) + (1 + 3 * (7 / 10) + ((7 / 10) ^ 3) + 3 * ((7 / 10) ^ 2)) * XAVG(XAVG(XAVGC3, 3), 3), -((7 / 10) ^ 3) * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC5, 5), 5), 5), 5), 5) + 3 * (((7 / 10) ^ 2) + ((7 / 10) ^ 3)) * XAVG(XAVG(XAVG(XAVG(XAVGC5, 5), 5), 5), 5) - (6 * ((7 / 10) ^ 2) + 3 * ((7 / 10) + ((7 / 10) ^ 3))) * XAVG(XAVG(XAVG(XAVGC5, 5), 5), 5) + (1 + 3 * (7 / 10) + ((7 / 10) ^ 3) + 3 * ((7 / 10) ^ 2)) * XAVG(XAVG(XAVGC5, 5), 5))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Request correction PCF Formula MACD
Posted: Thursday, July 27, 2017 10:07:24 AM

You didn&#39;t specify a value, but you can change the zero in the following formula to something else.

XUP(MACD(1, 5), 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: price high to touch ma 8
Posted: Thursday, July 27, 2017 10:03:12 AM

So I am not quite sure what you want. If you want the price bar intersected by the moving average with the high above it:

&#39;|*****************************************************************|
&#39;|*** StockFinder RealCode Condition - Version 5.0 www.worden.com 
&#39;|*** Copy and paste this header and code into StockFinder *********
&#39;|*** Condition:Average Intersects Price Bar
&#39;|******************************************************************
If Price.High > Price.AVGC(8) AndAlso _
	Price.AVGC(8) >= Price.Low Then
	Pass
End If

If instead you want the high to have been at or below the moving average during the previous bar and above it now:

&#39;|*****************************************************************|
&#39;|*** StockFinder RealCode Condition - Version 5.0 www.worden.com 
&#39;|*** Copy and paste this header and code into StockFinder *********
&#39;|*** Condition:High Crossed Up Average
&#39;|******************************************************************
If Price.High > Price.AVGC(8) AndAlso _
	Price.AVGC(8, 1) >= Price.High(1) Then
	Pass
End If

If you want something else, we would need further clarification from you as to what you want.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Help with Indicator
Posted: Thursday, July 27, 2017 9:50:50 AM

It is theoretically possible to write such formulas.

PCF for Order Statistics

And this technique can even be optimized somewhat using IIF() and CountTrue() functions. That said, writing a formula to find the 3 highest open prices in the last 6 months results in a formula which is way to long and slow to be practical or post in the forums.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Congestion area
Posted: Thursday, July 27, 2017 9:38:08 AM

You&#39;re welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Bollinger Band Squeeze or Pinch
Posted: Wednesday, July 26, 2017 4:44:39 PM

Those formulas have 26 period Bollinger Bands and 20 period Keltner Channels as mentioned in the post (because you seemed concerned about both the Keltner Channel period and average type).

If you are going to have exponential Bollinger Bands 26, 2.00 and exponential Keltner Channels 26, 1.50, then (in order of complexity of calculation):

Bollinger Bands narrower than Keltner Channels:

4 * STDDEV26 < 3 * XAVG(ATR, 26)

Both Bollinger Bands inside Keltner Channels:

XAVG((H + L + C) / 3 - 1.5 * ATR, 26) <= XAVGC26 - 2 * STDDEV26 AND XAVGC26 + 2 * STDDEV26 <= XAVG((H + L + C) / 3 + 1.5 * ATR, 26)

At least one Bollinger Band inside the Keltner Channels:

(XAVG((H + L + C) / 3 - 1.5 * ATR, 26) <= XAVGC26 - 2 * STDDEV26 AND XAVGC26 - 2 * STDDEV26 <= XAVG((H + L + C) / 3 + 1.5 * ATR, 26)) OR (XAVG((H + L + C) / 3 - 1.5 * ATR, 26) <= XAVGC26 + 2 * STDDEV26 AND XAVGC26 + 2 * STDDEV26 <= XAVG((H + L + C) / 3 + 1.5 * ATR, 26))

You can CountTrue() or TrueInRow() these formulas as desired.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles