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 |

Personal Formula Criterion Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Luke Madsen
Posted : Monday, August 29, 2011 9:00:41 PM
Registered User
Joined: 4/29/2011
Posts: 10
I'm wanting to run a somewhat complex formula and having trouble setting it up.

1. Today's closing volume higher than yesterday's closing volume
2. Price is crossing the 10 day AM (lower or equal to the MA before today and today is now above the MA)
3. Stochastic is below 20 before today but has crossed over 20 today
4. Stochastic period is crossing over or above %D
5. MACD is crossing over or has crossed over the 0 line

Then I want a second formula that is the exact oposite (80 instead of the 20 for stochastics, the price crossing below the 10 day ma, and MACD below the 0 line)
Bruce_L
Posted : Tuesday, August 30, 2011 9:03:34 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
It is not possible to create a formula using just the information provided as we do not know the type of Moving Average or any of the settings for the Stochastic or MACD (or if you are interested in the raw MACD, its Moving Average Trigger or the MACD Histogram). That said, we can still make a Scan in TC2000 version 12 if all of the components are on the chart.

- Click on Volume and select Create Condition.
- Select Moving Up Net from the Condition drop-down menu.
-- Period: 1
-- Net Change >: 0
-- Time Frame: Daily
- Give the Condition a name and save the Condition.

- Click on Price History and select Create Condition.
- Select Crossing Up Moving Average 10 from the Condition drop-down menu.
-- Time Frame: Daily
- Give the Condition a name and save the Condition.

- Click on Stochastics and select Create Condition.
- Select Crossing Up Value.
-- Crossing Up Through: 20
-- Time Frame: Daily
- Give the Condition a name and save the Condition.

- Click on Stochastics and select Create Condition.
- Select Crossing Up %D from the Condition drop-down menu.
-- Time Frame: Daily
- Give the Condition a name and save the Condition.

- Click on MACD and select Create Condition.
- Select Crossing Up Value.
-- Crossing Up Through: 0
-- Time Frame: Daily
- Give the Condition a name and save the Condition.

- Select Scans | Create New Scan.
- Select Add Condition for each of the Conditions created above to add them to the Scan.
- Give the Scan a name and save the Scan.
- Select Scan to run the Scan.

Creating your other Scan is done essentially the same way, except that you will choose the opposite settings from the Condition drop-down menu.

Indicators, Sorting & Scanning

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Luke Madsen
Posted : Thursday, September 1, 2011 9:53:27 AM
Registered User
Joined: 4/29/2011
Posts: 10
I'm using TC2007. I'm not sure I understand what you mean by "click on" when asking me to click on volume etc. to create a condition.
Bruce_L
Posted : Thursday, September 1, 2011 10:00:31 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
The technique described will not work in TeleChart 2007. It will only work in TC2000 version 12.

To create a Personal Criteria Formula in TeleChart 2007, we would need to know the missing information.

Is the 10-Period Moving Average Simple or Exponential?

Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"

What are the settings of the Stochastic?

Understanding Stochastics

- Period: ?
- SK Period: ?
- SD Period: ?
- Average Type: Simple or Exponential?

What are the settings of the MACD?

Understanding MACD

- Short: ?
- Long: ?
- Period: ?
- Average Type: Simple or Exponential?

Are you interested in the raw MACD, its Moving Average Signal Line or the MACD Histogram being above zero?

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Luke Madsen
Posted : Friday, September 2, 2011 2:51:55 PM
Registered User
Joined: 4/29/2011
Posts: 10
Ok, I downloaded TC 2000. And I understand most of the settings. However, for volume, I don't see where or how I can scan for volume that was higher than the day before. I'd like to be able to scan for vol over 500K, and 50% higher than yesterday.

Or, if possible50% higher than the MA

Thanks
Bruce_L
Posted : Friday, September 2, 2011 3:20:40 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (Luke Madsen)
I don't see where or how I can scan for volume that was higher than the day before.

Have you checked out the Indicators, Sorting & Scanning video referenced in my first response? To use the technique, the indicators just need to be on the chart. You could create a Condition for this to use as part of a Scan by doing the following:

- Click on Volume and select Create Condition.
- Select Moving Up Net from the Condition drop-down menu.
-- Period: 1
-- Net Change >: 0
-- Time Frame: Daily
- Give the Condition a name and save the Condition.

QUOTE (Luke Madsen)
I'd like to be able to scan for vol over 500K...

- Click on Volume and select Create Condition.
- Select Greater Than from the Condition drop-down menu.
-- Greater Than: 500000
-- Time Frame: Daily
- Give the Condition a name and save the Condition.

QUOTE (Luke Madsen)
...and 50% higher than yesterday.

There isn't a built in Condition for this available when clicking on Volume and selecting Create Condition. You can create a Condition Formula for this however.

- Select Conditions | New Condition Formula.
- Use the following formula:

V >= 1.5 * V1

- Give the Condition Formula a name and select OK.

You could create a single Condition Formula for both requirements using the following formula instead:

V > 500000 AND V >= 1.5 * V1

QUOTE (Luke Madsen)
Or, if possible50% higher than the MA

While you could click on Volume and select Create Condition to check if it is higher than its Moving Average, you could not check for it to be 50% higher. So you would need to create another Condition Formula. If the Moving Average is a 50-Period Simple Moving Average of Volume, the formula would be:

V >= 1.5 * AVGV50

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Luke Madsen
Posted : Saturday, September 3, 2011 11:44:11 AM
Registered User
Joined: 4/29/2011
Posts: 10
Bruce,

Thanks so much. I did watch the video and it helped a lot. What it didn't answer you answered here. Now that I know I can create my own formula, I'll be in pretty good shape.

Thanks again!
Bruce_L
Posted : Tuesday, September 6, 2011 8:19:24 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

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