## New version 17 available now

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

New account application Trading resources
Margin rates Stock & option commissions

 Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

 Intro to Writing TC2000 Formulas Rate this Topic:
 Previous Topic · Next Topic Watch this topic · Print this topic ·
morink27
 Posted : Monday, July 04, 2016 10:32:26 PM
Gold Customer

Joined: 6/18/2016
Posts: 7

As a new user, it took me a long time to figure out how to create and manage my custom formulas. I use Version 12.5 on a Mac via the web, and some features are rather different from what is described in the TC2000 12.4 User Guide (which I discovered by accident a week after I joined). Below are my notes, in the hope that they might help others.

Intro to Creating and Managing Formulas:

1. A formula can yield either a true /false (Boolean) result or a Numeric result.
2. In TC2000 a true /false (Boolean) formula is sometimes called a Condition, and a numeric formula may be called an Indicator or a condition. The terminology is not consistent and may create some confusion.
3. There are different ways you can create, access, edit and delete formulas. Some of these ways are described below, but see the Hint near the end!
4. Formulas can be created at New (top left). You can click on either Condition or Indicator but which you choose doesn't matter much. What does matter is whether its a Boolean or a Numeric formula and this over-rides your starting point. They cannot be edited here.
5. Formulas can also be created at the big green + (Add Plot) in front of the ticker at the top left of the chart area, under the Formulas tab.
6. Your numeric and boolean formulas can both be accessed at New EasyScan to add them to a scan. (Here, they are all called Conditions). For the numeric formulas, you need to specify min and max values. They cannot be edited here.
7. Your Numeric and Boolean formulas can be accessed via the big green + (Add Plot) window via the Formulas. This is intended to add them to your chart, but they can also be Edited and Deleted here. Note: A similar Add Plot window can be accessed at Library, but it provides access to only the Numeric formulas.
8. Your Boolean formulas (only) can be accessed at Library / Conditions under either All or My Formulas. They can also be Edited and Deleted here. (They are not displayed at My Conditions, which seems strange.)
9. Formulas can also be created at Library / Conditions by clicking New Condition Formula. Curiously they do not appear under the My Conditions tab! (although they appear under the All and the My Formulas tabs).
10. Hint: The big green &ldquo;+&rdquo; (Add Plot) / Formulas can be used to Create, Edit and Delete both Boolean and Numeric formulas. This is where I usually go to do anything with formulas.
11. When you click the Orange + to add a column to a scan result, your Booleans and Numerics are displayed in separate columns (My Conditions and My Indicators). This makes it easier to find your personal formulas.
12. If you Edit a formula, you need to add it again to any Scan that uses it. TC2000 copies the formula into each scan.
13. I prefix my formula names with k.bool or k.260.20 etc. to indicate their type. (The k is my initial.)
14. When you add a Plot with one of your custom indicators, the formula shows but not the name. I prefix each indicator with an ID code, eg 260.20, and put this in both the Name and in the Formula (followed by *0+). Can I get the name to show instead? There is No comment feature in the language.
fredericf
 Posted : Wednesday, July 26, 2017 4:11:58 AM
Gold Customer

Joined: 7/25/2017
Posts: 3

That helped me, thanks.

donv98
 Posted : Wednesday, July 26, 2017 11:14:08 AM
Gold Customer

Joined: 7/29/2010
Posts: 390

QUOTE (morink27)

As a new user, it took me a long time to figure out how to create and manage my custom formulas. I use Version 12.5 on a Mac via the web, and some features are rather different from what is described in the TC2000 12.4 User Guide (which I discovered by accident a week after I joined). Below are my notes, in the hope that they might help others.

Intro to Creating and Managing Formulas:

1. A formula can yield either a true /false (Boolean) result or a Numeric result.
2. In TC2000 a true /false (Boolean) formula is sometimes called a Condition, and a numeric formula may be called an Indicator or a condition. The terminology is not consistent and may create some confusion.
3. There are different ways you can create, access, edit and delete formulas. Some of these ways are described below, but see the Hint near the end!
4. Formulas can be created at New (top left). You can click on either Condition or Indicator but which you choose doesn't matter much. What does matter is whether its a Boolean or a Numeric formula and this over-rides your starting point. They cannot be edited here.
5. Formulas can also be created at the big green + (Add Plot) in front of the ticker at the top left of the chart area, under the Formulas tab.
6. Your numeric and boolean formulas can both be accessed at New EasyScan to add them to a scan. (Here, they are all called Conditions). For the numeric formulas, you need to specify min and max values. They cannot be edited here.
7. Your Numeric and Boolean formulas can be accessed via the big green + (Add Plot) window via the Formulas. This is intended to add them to your chart, but they can also be Edited and Deleted here. Note: A similar Add Plot window can be accessed at Library, but it provides access to only the Numeric formulas.
8. Your Boolean formulas (only) can be accessed at Library / Conditions under either All or My Formulas. They can also be Edited and Deleted here. (They are not displayed at My Conditions, which seems strange.)
9. Formulas can also be created at Library / Conditions by clicking New Condition Formula. Curiously they do not appear under the My Conditions tab! (although they appear under the All and the My Formulas tabs).
10. Hint: The big green &ldquo;+&rdquo; (Add Plot) / Formulas can be used to Create, Edit and Delete both Boolean and Numeric formulas. This is where I usually go to do anything with formulas.
11. When you click the Orange + to add a column to a scan result, your Booleans and Numerics are displayed in separate columns (My Conditions and My Indicators). This makes it easier to find your personal formulas.
12. If you Edit a formula, you need to add it again to any Scan that uses it. TC2000 copies the formula into each scan.
13. I prefix my formula names with k.bool or k.260.20 etc. to indicate their type. (The k is my initial.)
14. When you add a Plot with one of your custom indicators, the formula shows but not the name. I prefix each indicator with an ID code, eg 260.20, and put this in both the Name and in the Formula (followed by *0+). Can I get the name to show instead? There is No comment feature in the language.

Many thanks for taking the time to write this out.

I appreciate your efforts.

Don

Users browsing this topic
Guest-1

 Forum Jump Customer Training & Support - Ask a Trainer - TC2000 version 12/17 - Ask a Trainer - TC2000 version 7 - Ask a Trainer - StockFinder 5.0 - PCFs, EasyScan and Custom Indicators General Discussions - Stock and Market Talk - TC2000 version 12 or 17 - TC2000 version 7 - StockFinder 5.0 - RealCode for StockFinder 5.0 Tutorial Videos - TC2000 version 12 tutorial videos - TC2000 version 7 tutorial videos 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.