Registered User Joined: 2/3/2019 Posts: 7

I' new to TC2000 and I need help writing the PCF below:
Price is greater than 10 day expontential moving average, but lest than 8 day expontential moving average, and average is above normal, and the BOP is increasing


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

I am not quite sure what you mean by the average (or which average even) is "above normal". I guess it could be above a moving average of that moving average, but I am not sure if this is what you mean or not.
The rest of the requirements can be expressed as follows (assuming BOP increasing is just from the previous bar to the current bar).
XAVGC10 < C AND C < XAVGC8 AND BOP > BOP1.1
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 2/3/2019 Posts: 7

stupid me....I was in a rush
Price is greater than 10 day expontential moving average, but less than 8 day expontential moving average, and volume is above average, and the BOP is increasing


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

The following uses a 50 period simple moving average of volume, but you can adjust this as desired.
XAVGC10 < C AND C < XAVGC8 AND BOP > BOP1.1 AND V > AVGV50
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 10/7/2004 Posts: 9

Hi Bruce,
When you have a moment, can you please help me with a scan?
Daily Charts:
1. Price above 50ma
2. 50ma > 200 ma
3. Average volume for previous 20 days > 100,000 shares
4. Volume today is 1.5x greater than the average volume for previous 20 days
5. Price > 5 per share
Thank you!
Paul


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

Please try the following condition formula.
C > 5 AND V >= 1.5 * AVGV20.1 AND AVGV20.1 > 100000 AND C > AVGC50 AND AVGC50 > AVGC200
Note that the above assumes simple moving averages and is for TC2000 v18+. If you are using this in TC2000 v7, you will need to adjust the volume portion of the formula.
C > 5 AND V >= 1.5 * AVGV20.1 AND AVGV20.1 > 1000 AND C > AVGC50 AND AVGC50 > AVGC200
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 2/3/2019 Posts: 7

Bruce thanks for all of the help. I really appreciate it!
This scan has been working very well C > XAVGC10 AND V > AVGV100 AND BOP > BOP1.1.
However, it produces to many results, so I want to add the following step to it: identify stocks that are within +/ $3 of the 10 day expontential moving average.


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

Please try the following condition formula.
XAVGC10 + 3 >= C AND C > XAVGC10 AND V > AVGV100 AND BOP > BOP1.1
It only checks for + $3 or less of the EMA because the original formula requires price to be above the the EMA. If you want to replice this requirement instead, then please try the following.
ABS(C  XAVGC10) <= 3 AND V > AVGV100 AND BOP > BOP1.1
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 2/3/2019 Posts: 7

Thanks Bruce, that worked very well!


Registered User Joined: 2/3/2019 Posts: 7

How can I write a PCF that will identify stocks where the 3 Exp Moving Average crosses above the 9 Exp Moving Average during the last session? The PCF you wrote above (XAVGC10 + 3 >= C AND C > XAVGC10) works,but it lists to many stocks and I don't have to review all of them.
Also, I want to identify where the MACD is increasing from the prior session, so is this correct: MACD > MACD1.1?


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

You should be able to change the C > XAVGC10 to XUP(C, XAVGC10) instead.
XAVGC10 + 3 >= C AND XUP(C, XAVGC10)
The exact formula used for the MACD formula will depend on the MACD settings. So if it is an exponential MACD 12, 26, it would be the following,
MACD12.26 > MACD12.26.1
But other settings would require different formulas.
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 4/22/2014 Posts: 2

Hello I'm looking for to create a high iplied volatility and historical volatility indicator and I need a guide of how to do it


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

There isn't any way I can think of to combine implied volatility and historical volatility into a single indicator.
The Options Implied Volatility indicator is going to be option specific (and is a fundamental which can't be referenced in a formula).
The Historical Volatility indicator (not built into TC2000) is generally going to be based on the stock (at least if it going to be calculated on a decent amount of history).
I really can't think of a way to create something which would even be a remotely close workaround.
If you are plotting both the stock and the option, you could plot historical volatility for the stock and implied volatility for the option, but that is about as close as you could get.
Bruce Personal Criteria Formulas TC2000 Support Articles


Gold Customer
Joined: 4/22/2014 Posts: 2

Thank you


Registered User Joined: 2/3/2019 Posts: 7

Bruce you are the best! The scan worked just as designed. The bad part is that market sold off on friday, so I need to change strategies. Plan is to daytrade spy calls or puts. Does TC2000 have TTM Squeeze? If not, then do you know of a way to create it in TC2000.


Registered User Joined: 2/3/2019 Posts: 7

One more question, how do I get the charts on my Iphone to look like the ones on my computer? On the Iphone I can't change the indicators. The Iphone has moving averages, but I don't even know which ones.


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

You can use TC2000 Anywhere to run a full version of TC2000 using iOS.
I have sent you a copy of the most recent version I have made of the TTM Squeeze indicator via TCMail.
How to Receive Messages with TC Mail
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 4/1/2011 Posts: 90

Hi Bruce,,
I read that an option is overpriced when it's implied Volatility is greater than it's Historical Volatility.
Is there any way to have those two values (with the same if not similar criteria) as columns on the option chain so they can be compared againgst each other?
Thanks in advance.


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

You are generally going to calculate historical volatility for the underlying stock while the Options Implied Volatily indicator is for an individual option.
You can plot these in the same pane and scale on a chart set to plot the underlying stock and option.
You can have a Personal WatchList containing both the underlying stock and all of the options in its option chain. You can have a WatchList column which will display the historical volatility for the underlying stock (although it will also attempt to calculate for the option but probably won't have enough data) and a different column for the Options Implied Volatility which will only display for the options.
I do not know of any way to get the HV for the underlying stock to display as a WL column for the option however.
Bruce Personal Criteria Formulas TC2000 Support Articles


Guest1 