New version 18 available now

Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

 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
Registered User
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
Registered User
Joined: 7/25/2017
Posts: 3

That helped me, thanks.

donv98
 Posted : Wednesday, July 26, 2017 11:14:08 AM
Registered User
Joined: 7/29/2010
Posts: 398

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.