I am trying to set up 2 formalas that I can add in columns  that will show as checked when conditions are met

I am using daily charts  and want to identify the following after the close of each day

1) RSI using a period of 2 with a value of 0 and or 100

I tried the following     RSI ( RSI,2 ) = 0 or 100 I also tried 0 and 100 seperately

and

2 ) Moving average with a period of 5 with a value of 0 and or 100

Any help please

Also I enquired about being able to add different coloured flags to platform so can easily identify  after new scans options that I'm trading, not intersted in , have checked out, by there sectors etc, etc Your office was going to forward to your it people and was wondering if anything in the pipeline yet

Thanks

Jeff

Hi

I have worked out the RSI formulas but can not get the moving averages right. I have no results using US common stocks

One stock that should be showing up for example with a value of 0 is VHC with settings of Simple moving average period of 5

Thanks again

Jeff

TC2000 currently only has one type of flag and one Flagged Items WatchList. There is no way to create different flags for different requirements. While you could sort your various categories into their own Personal WatchLists, there is no way to create a WatchList Column which would indicate membership in a particular Personal WatchList (it is possible to do this in StockFinder).

The simplest way to write a Condition Formula for a 2-Period non-Wilder's Smoothed RSI being 0 would be:

RSI2 = 0

The simplest way to write a Condition Formula for a 2-Period non-Wilder's Smoothed RSI being 100 would be:

RSI2 = 100

Combining these formulas to check for either being true could be written as:

RSI2 = 0 OR RSI2 = 100

RSI in the Personal Criteria Formula Language has a built in Simple Moving Average parameter.

PCF Formula Descriptions

RSIx.y.z -> RSI (not Wilder's Smoothed)

Where x is the Period of the Indicator or Function.
Where y is a the Period of an additional Simple Moving Average.
Where z is the number of Periods Ago.
- z can also be a date. May 3, 2007 would be (single quotes required): '05/03/07'

The arguments in indicators are separated by periods.

We can use this to add the 5-Period Simple Moving Average. So checking for the moving average to be equal to 0 would be:

RSI2.5 = 0

Checking for the moving average to equal 100 would be:

RSI2.5 = 100

And checking for the moving average to equal either 0 or 100 would be:

RSI2.5 = 0 OR RSI2.5 = 100

Note that this is going to occur far less frequently than the base RSI equalling 0 or 100, because it requires the RSI to be 0 for 5-bars in a row or 100 for 5-bars in a row.

Personal Criteria Formula Conditions
Handy PCF example formulas to help you learn the syntax of PCFs!

Bruce

I had worked out the RSI formula

I am trying to set up a seperate condition from RSI for

Moving average with a period of 5 with a value of 0 and or 100 by itself to show up in different column after scan

I tried following for value of 0

AvgC5 = 0

AvgC (AvgC5) = 0

but got no results for either

One stock that should have shown yesterday up for example with a value of 0 is VHC with settings on chart of Simple moving average period of 5

Thanks again

Jeff

Please re-read my original reply. It already has formulas for checking for the 5-Period Simple Moving Average of a 2-Period RSI being equal to 0, 100 or either.

Note that RSI2.5 is not currently true for VHC. It was true yesterday, but it is not true today. It is currently true for 34 stocks in the US Common Stocks WatchList.

ACRX, ALXA, AMCN, AN, ARSD, BGMD, CLCT, CPBC, CPSL, CTBI, CVLY, DEJ, DGICB, DOVR, DRWI, GAIN, GTLS, HTGC, HWG, IDI, IKNX, INAP, LGP, MHGC, NWN, PFPT, PFS, PHMD, QBAK, SBLK, TEAR, TLM, TSRX & WPRT

Your AVGC5 formulas are for a 5-Period Simple Moving Average of Price, not a 5-Period Simple Moving Average of a 2-Period RSI. You cannot mean for price or its moving average to be equal to zero, as this cannot happen for an actively trading stock.

Thanks Bruce

Penny finally dropped after reading last bit after list of symbols in your last reply

All is working fine

Jeff

You're welcome.