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


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Custom PCF Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
PBS
Posted : Sunday, February 3, 2019 9:59:34 AM
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

Bruce_L
Posted : Monday, February 4, 2019 10:32:58 AM


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
PBS
Posted : Monday, February 4, 2019 9:55:42 PM
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

Bruce_L
Posted : Tuesday, February 5, 2019 8:41:30 AM


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
ptaglia1
Posted : Tuesday, February 12, 2019 12:42:31 PM
Registered User
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

Bruce_L
Posted : Tuesday, February 12, 2019 12:56:52 PM


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
PBS
Posted : Saturday, March 9, 2019 10:23:52 PM
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.  

Bruce_L
Posted : Monday, March 11, 2019 9:12:51 AM


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
PBS
Posted : Monday, March 11, 2019 10:23:17 PM
Registered User
Joined: 2/3/2019
Posts: 7

Thanks Bruce, that worked very well!

PBS
Posted : Saturday, March 16, 2019 12:16:42 AM
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?

Bruce_L
Posted : Monday, March 18, 2019 9:02:51 AM


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
venezuela
Posted : Friday, March 22, 2019 3:44:03 PM
Registered User
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

 

Bruce_L
Posted : Friday, March 22, 2019 4:01:46 PM


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
venezuela
Posted : Friday, March 22, 2019 4:04:01 PM
Registered User
Joined: 4/22/2014
Posts: 2

Thank you

PBS
Posted : Friday, March 22, 2019 10:23:28 PM
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.  

PBS
Posted : Friday, March 22, 2019 10:33:53 PM
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.  

Bruce_L
Posted : Monday, March 25, 2019 10:02:30 AM


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
thomasjenkinsjr
Posted : Friday, March 29, 2019 1:38:47 PM
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.

Bruce_L
Posted : Friday, March 29, 2019 2:04:00 PM


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.

How to Overlay an Indicator (choose & Scale With)

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