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: Wednesday, January 18, 2017 5:03:36 PM
Number of Posts: 57,902
[20.89% of all post / 12.90 posts per day]
Avatar
Last 10 Posts
Topic: Inverse Fisher Transform
Posted: Wednesday, January 18, 2017 3:08:47 PM

The v17 PCF can be written as follows.

TANH(FAVG(.1 * (WRSI5 - 50), 9))

Not sure if re-arranging it so the multiplication and subtraction is done after the averaging would make it any faster or not. It seems like it would, but the difference is probably marginal.

TANH(.1 * FAVG(WRSI5, 9) - 5)

It is possible to manually implement the front weighted moving average in StockFinder to create it as a single RealCode indicator, but I would probably do it exactly the same way you are already doing (except I would use WRSI instead of RSI in the RealCode).



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Stocks on the Move - Clenow
Posted: Wednesday, January 18, 2017 1:28:22 PM

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Dollar
Posted: Wednesday, January 18, 2017 11:36:40 AM

There really isn't a way to specify DXY0 in a formula. You would just need to use the condition on a weekly chart as a Custom Indicator. The following would be crossing up.

C > XAVGC7 AND C1 <= XAVGC7.1

And the following would be crossing down.

C < XAVGC7 AND C1 >= XAVGC7.1

If you want to create a Personal Criteria Formula to use in an EasyScan or as a WatchList Column, you would need to create a daily PCF to approximate the weekly results for TC2000 v7. The crossing up formula could be written as follows.

C > .25018828 * (C5 + .75 * (C10 + .75 * (C15 + .75 * (C20 + .75 * (C25 + .75 * (C30 + .75 * (C35 + .75 * (C40 + .75 * (C45 + .75 * (C50 + .75 * (C55 + .75 * (C60 + .75 * (C65 + .75 * (C70 + .75 * (C75 + .75 * (C80 + .75 * (C85 + .75 * (C90 + .75 * (C95 + .75 * (C100 + .75 * (C105 + .75 * (C110 + .75 * (C115 + .75 * (C120 + .75 * (C125))))))))))))))))))))))))) AND C5 <= .25018828 * (C10 + .75 * (C15 + .75 * (C20 + .75 * (C25 + .75 * (C30 + .75 * (C35 + .75 * (C40 + .75 * (C45 + .75 * (C50 + .75 * (C55 + .75 * (C60 + .75 * (C65 + .75 * (C70 + .75 * (C75 + .75 * (C80 + .75 * (C85 + .75 * (C90 + .75 * (C95 + .75 * (C100 + .75 * (C105 + .75 * (C110 + .75 * (C115 + .75 * (C120 + .75 * (C125 + .75 * (C130)))))))))))))))))))))))))

With the crossing down fomula being the following.

C < .25018828 * (C5 + .75 * (C10 + .75 * (C15 + .75 * (C20 + .75 * (C25 + .75 * (C30 + .75 * (C35 + .75 * (C40 + .75 * (C45 + .75 * (C50 + .75 * (C55 + .75 * (C60 + .75 * (C65 + .75 * (C70 + .75 * (C75 + .75 * (C80 + .75 * (C85 + .75 * (C90 + .75 * (C95 + .75 * (C100 + .75 * (C105 + .75 * (C110 + .75 * (C115 + .75 * (C120 + .75 * (C125))))))))))))))))))))))))) AND C5 >= .25018828 * (C10 + .75 * (C15 + .75 * (C20 + .75 * (C25 + .75 * (C30 + .75 * (C35 + .75 * (C40 + .75 * (C45 + .75 * (C50 + .75 * (C55 + .75 * (C60 + .75 * (C65 + .75 * (C70 + .75 * (C75 + .75 * (C80 + .75 * (C85 + .75 * (C90 + .75 * (C95 + .75 * (C100 + .75 * (C105 + .75 * (C110 + .75 * (C115 + .75 * (C120 + .75 * (C125 + .75 * (C130)))))))))))))))))))))))))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Dr. Alex Elder macd divergence scan
Posted: Wednesday, January 18, 2017 10:24:11 AM

I don&#39;t know what differentiates Dr. Alex Elder&#39;s MACD divergence from any other divergence in order to try and create a scan.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: TTM Squeeze Indicator
Posted: Wednesday, January 18, 2017 9:35:22 AM

I have sent you a TCMail with a chart containing the TTM Squeeze indicator.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: new scan
Posted: Wednesday, January 18, 2017 8:52:11 AM

(AVGC200 - MINL234) / (MAXH234 - MINL234) * 100 = 55.92 for DNOW on a 5-minute chart 130 bars ago and 52.63 140 bars ago.

The market hasn&#39;t opened yet, so we should be using the same data.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: Stocks on the Move - Clenow
Posted: Wednesday, January 18, 2017 8:43:42 AM

(100 * (EXP(253 * (22 * LOG(C ) + 21 * LOG(C1) + 20 * LOG(C2) + 19 * LOG(C3) + 18 * LOG(C4) + 17 * LOG(C5) + 16 * LOG(C6) + 15 * LOG(C7) + 14 * LOG(C8) + 13 * LOG(C9) + 12 * LOG(C10) + 11 * LOG(C11) + 10 * LOG(C12) + 9 * LOG(C13) + 8 * LOG(C14) + 7 * LOG(C15) + 6 * LOG(C16) + 5 * LOG(C17) + 4 * LOG(C18) + 3 * LOG(C19) + 2 * LOG(C20) + LOG(C21) - LOG(C23) - 2 * LOG(C24) - 3 * LOG(C25) - 4 * LOG(C26) - 5 * LOG(C27) - 6 * LOG(C28) - 7 * LOG(C29) - 8 * LOG(C30) - 9 * LOG(C31) - 10 * LOG(C32) - 11 * LOG(C33) - 12 * LOG(C34) - 13 * LOG(C35) - 14 * LOG(C36) - 15 * LOG(C37) - 16 * LOG(C38) - 17 * LOG(C39) - 18 * LOG(C40) - 19 * LOG(C41) - 20 * LOG(C42) - 21 * LOG(C43) - 22 * LOG(C44)) / 7590) - 1))

*

(((((45 - 1) / 2) * AVGC45 - (C1 + 2 * C2 + 3 * C3 + 4 * C4 + 5 * C5 + 6 * C6 + 7 * C7 + 8 * C8 + 9 * C9 + 10 * C10 + 11 * C11 + 12 * C12 + 13 * C13 + 14 * C14 + 15 * C15 + 16 * C16 + 17 * C17 + 18 * C18 + 19 * C19 + 20 * C20 + 21 * C21 + 22 * C22 + 23 * C23 + 24 * C24 + 25 * C25 + 26 * C26 + 27 * C27 + 28 * C28 + 29 * C29 + 30 * C30 + 31 * C31 + 32 * C32 + 33 * C33 + 34 * C34 + 35 * C35 + 36 * C36 + 37 * C37 + 38 * C38 + 39 * C39 + 40 * C40 + 41 * C41 + 42 * C42 + 43 * C43 + 44 * C44) / 45) / SQR(((45 ^ 2 - 1) / 12) * ((C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 + C30 ^ 2 + C31 ^ 2 + C32 ^ 2 + C33 ^ 2 + C34 ^ 2 + C35 ^ 2 + C36 ^ 2 + C37 ^ 2 + C38 ^ 2 + C39 ^ 2 + C40 ^ 2 + C41 ^ 2 + C42 ^ 2 + C43 ^ 2 + C44 ^ 2) / 45 - AVGC45 ^ 2))) ^ 2)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: cross
Posted: Wednesday, January 18, 2017 8:24:46 AM

You&#39;re welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: R17 Beta PCF Capabilities
Posted: Wednesday, January 18, 2017 8:12:55 AM

You should be able to get a TC2000 v17 beta with an initial incarnation of the new Personal Criteria Formula Syntax here.

http://www.tc2000.com/download

A list of all of the syntax of which I am currently aware in this initial release is given below.

* -> Multiply (Mathematical Operator)

/ -> Divide or Ratio (Mathematical Operator)

+ -> Add (Mathematical Operator)

++ -> Add (Mathematical Operator)

-- -> Add (Mathematical Operator)

- -> Subtract or Difference (Mathematical Operator)

+- -> Subtract or Difference (Mathematical Operator)

-+ -> Subtract or Difference (Mathematical Operator)

\ -> Integer Divide (Mathematical Operator)

^ -> Power (Mathematical Operator)

> -> Greater Than (Boolean relational operator)

>= -> Greater Than or Equal To (Boolean relational operator)

< -> Less Than (Boolean relational operator)

<= -> Less Than or Equal To (Boolean relational operator)

= -> Equal To (Boolean relational operator)

<> -> Not Equal To (Boolean relational operator)

() -> Parentheses will force an operation to perform earlier in the order.

(b) -> returns -1 if b is true and 0 if b is false

ABS(b) -> returns 1 if b is true and 0 if b is false

ABS(w) -> Absolute Value - Calculates w. Returns a positive value of the same magnitude as w if w is negative. Otherwise returns w.

ADX(d, s, z) -> Average Directional Index (d = DI Period and s = Smooth Period)

ADXd.s.z -> Average Directional Index (d = DI Period and s = Smooth Period)

AND -> And (Boolean logical operator)

ARCCOS(w) -> Inverse cosine - returns the angle in radians whose cosine (adjacent / hypotenuse) is the specified number.

ARCCOSH(w) -> Inverse hyperbolic cosine - returns LOG(w + SQR(w ^ 2 - 1))

ARCCOT(w) -> Inverse cotangent - returns the angle in radians whose cotangent (adjacent / opposite) is the specified number.

ARCCOTH(w) -> Inverse hyperbolic cotangent - returns LOG((w + 1) / (w - 1)) / 2

ARCCSC(w) -> Inverse cosecant - returns the angle in radians whose cosecant (hypotenuse / opposite) is the specified number.

ARCCSCH(w) -> Inverse hyperbolic cosecant - returns LOG((1 + SQR(1 + w ^ 2)) / w)

ARCSEC(w) -> Inverse secant - returns the angle in radians whose secant (hypotenuse / adjacent) is the specified number.

ARCSECH(w) -> Inverse hyperbolic cosceant - returns LOG(1 + SQR(1 + SQR(1 - w ^ 2)) / w)

ARCSIN(w) -> Inverse sine - returns the angle in radians whose sine (opposite / hypotenuse) is the specified number.

ARCSINH(w) -> Inverse hyperbolic sine - returns LOG(w + SQR(w ^ 2 - 1))

ARCTAN(w) -> Inverse tangent - returns the angle in radians whose tangent (opposite / adjacent) is the specified number.

ARCTANH(w) -> Inverse hyperbolic tangent - returns LOG((1 + w) / (1 - w)) / 2

AROONDOWN(xz) -> Aroon Down portion of Aroon Indicator

AROONDOWNx.z -> Aroon Down portion of Aroon Indicator

AROONUP(xz) -> Aroon Up portion of Aroon Indicator

AROONUPx.z -> Aroon Up portion of Aroon Indicator

ATN(w) -> Returns the angle in radians whose tangent (opposite / adjacent) is the specified number.

ATR(xz) -> Average True Range (uses simple moving average for smoothing)

ATRx.z -> Average True Range (uses simple moving average for smoothing)

AVG(wx) -> Simple Moving Average - Returns the x period simple moving average of w.

AVGwx.z -> Simple Moving Average of Price Component or Volume over a specified span of bars ending on the specified bar (w must be O, H, L, C or V).

BBBOT(dxz) -> Bottom Bollinger Band (d = width in standard deviations +/- centerline)

BBBOTd.x.z -> Bottom Bollinger Band (d = whole number width in standard deviations +/- centerline)

BBTOP(dxz) -> Top Bollinger Band (d = width in standard deviations +/- centerline)

BBTOPd.x.z -> Top Bollinger Band (d = whole number width in standard deviations +/- centerline)

BOP(yz) -> Balance of Power (Green>30,Red<-30,Yellow30to&ndash;30)

BOPy.z -> Balance of Power (Green>30,Red<-30,Yellow30to&ndash;30)

C(z) -> Close/Current Price of the specified bar

Cz -> Close/Current Price of the specified bar

CCI(xz) -> Commodity Channel Index

CCIx.z -> Commodity Channel Index

CLG(w) -> Log Base 10

COS(w) -> Returns the cosine (adjacent / hypotenuse) of the specified angle in radians.

COTH(w) -> Hyperbolic cotangent - returns (e ^ w + e ^ -w) / 2

CountTrue(bx) -> Will return the number of times Boolean formula was true in the period

CSC(w) -> Returns the cosecant (hypotenuse / opposite) of the specified angle in radians.

CSCH(w) -> Hyperbolic cosecant - returns 2 / (e ^ w - e ^ -w)

DIMINUS(xz) -> Directional Movement DI- component

DIMINUSx.z -> Directional Movement DI- component

DIPLUS(xz) -> Directional Movement DI+ component

DIPLUSx.z -> Directional Movement DI+ component

EXP(w) -> Natural Exponent

FAVGwx.z -> Front Weighted Moving Average of Price Component or Volume over a specified span of bars ending on the specified bar (w must be O, H, L, C or V).

FAVG(wx) - > Front Weighted Moving Average - Returns the x period front weighted moving average of w.

GREATEST(v, w) -> Allows an unlimited number of arguments separated by commas and returns the argument with the highest value.

H(z) -> High Price of the specified bar

Hz -> High Price of the specified bar

HAVG(wx) - > Hull Moving Average - Returns the x period Hull moving average of w.

HAVGwx.z -> Hull Moving Average of Price Component or Volume with the specified period ending on the specified bar (w must be O, H, L, C or V).

IIF(btf) -> returns t if b is true and f if b is false

L(z) -> Low Price of the specified bar

Lz -> Low Price of the specified bar

LEAST(v, w) -> Allows an unlimited number of arguments separated by commas and returns the argument with the lowest value.

LOG(w) -> Natural Log

MACD(slz) -> Exponential Moving Average Convergence Divergence Oscillator (s = short period, l = long period)

MACDs.l.z -> Exponential Moving Average Convergence Divergence Oscillator (s = short period, l = long period)

MAX(wx) -> Maximum - Returns the highest value of w over the most recent x bars.

MAXwx.z -> Maximum Value of Price Component or Volume over a specified span of bars ending on the specified bar (w must be O, H, L, C or V).

MIN(wx) -> Minimum - Returns the lowest value of w over the most recent x bars.

MINwx.z -> Minimum Value of Price Component or Volume over a specified span of bars ending on the specified bar (w must be O, H, L, C or V).

MOD -> Modulo (Mathematical Operator)

MS(yz) -> Cumulative MoneyStream

MSy.z -> Cumulative MoneyStream

NAND -> Not And (Boolean)

NOR -> Not Or (Boolean)

NOT(b) -> Not (turns true to false and turns false to true)

O(z) -> Open Price of the specified bar

Oz -> Open Price of the specified bar

OBV(yz) -> On Balance Volume

OBVy.z -> On Balance Volume

OR -> Or (Boolean logical operator)

RSI(xyz) -> RSI (not Wilder&#39;s Smoothed)

RSIx.y.z -> RSI (not Wilder&#39;s Smoothed)

SEC(w) -> Returns the secant (hypotenuse / adjacent) of the specified angle in radians.

SECH(w) -> Hyperbolic secant - returns 2 / (e ^ w + e ^ w)

SGN(w) -> Sign (-1, 0 or 1) - Returns -1 if w is negative, 0 if w is zero and 1 if w is positive.

SIN(w) -> Returns the sine (opposite / hypotenuse) of the specified angle in radians.

SinceTrue(bx) -> returns -1 if Boolean Formula was not true in period, or bars since it was true, 0 being the current bar, and period-1 the max it will return

SINH(w) -> Hyperbolic sine - returns (e ^ w - e ^ -w) / 2

SQR(w) -> Square Root

STDDEV(xz) -> Standard Deviation

STDDEVx.z -> Standard Deviation

STOC(xyz) -> Simple Stochastic

STOCx.y.z -> Simple Stochastic

SUM(wx) - > Sum - Adds together the value of w over the most recent x bars.

TAN(w) -> Returns the tangent (opposite / adjacent) of the specified angle in radians.

TANH(w) -> Hyperbolic tangent - returns (e ^ w - e ^ -w) / 2

TrueInRow(bx) -> Will return a value between 0 and period that is how many times the Boolean formula was true in a row

TSV(yz) -> Time Segmented Volume

TSVy.z -> Time Segmented Volume

V(z) -> Volume of the specified bar

Vz -> Volume of the specified bar

WRSI(xz) -> Wilder&#39;s RSI (Wilder&#39;s Smoothed)

WRSIx.z -> Wilder&#39;s RSI (Wilder&#39;s Smoothed)

WSTOC(xyz) -> Worden Stochastic

WSTOCx.y.z -> Worden Stochastic

XAVG(wx) -> Exponential Moving Average - Returns the x period exponential moving average of w.

XAVGwx.z -> Exponential Moving Average of Price Component or Volume with the specified period ending on the specified bar (w must be O, H, L, C or V).

XDOWN(v, w, x) -> Returns true when v is greater than w at x bars ago and v is less than or equal to w now. x defaults to 1 if not supplied.

XNOR -> Not Exclusive Or (Boolean)

XOR -> Excusive Or (Boolean)

XUP(v, w, x) -> Returns true when v is less than w at x bars ago and v is greater than or equal to w now. x defaults to 1 if not supplied.

The first numeric parameter of in indicator is not separated from the indicator. The numeric parameters in indicators are separated from each other with periods.

Functions have the arguments inside parentheses. The arguments in functions are separated by commas.

Where b can be any formula which returns a true or false result

Where f is a formula returning a numeric result

Where t is a formula returning a numeric result

Where v can be any formula which returns a numeric value

Where w can be any formula which returns a numeric value

Where x is the Period of the Indicator

Where y is a the Period of an additional Simple Moving Average

Where z is the number of Bars Ago. z can also be a date. May 4, 2015 would be (single quotes required): &#39;05/04/2015&#39;



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Topic: cross
Posted: Tuesday, January 17, 2017 3:21:46 PM

Hull 9 should cross its Hull 3 on the current bar when C equals the following.

(98 * C2 + 65 * C3 + 2 * C4 - 24 * C1 - 19 * C5 - 22 * C6 - 16 * C7 - 10 * C8 - 4 * C9 - C10) / 69



-Bruce
Personal Criteria Formulas
TC2000 Support Articles