Registered User Joined: 3/19/2011 Posts: 19
|
Hi Bruce,
When I am monitoring my indicators on columns in a watchlist (ex. Moving Average 9) I would like to make several columns with the condition that will indicate "% change between" less than 1% moves. Examples 0.25% to .35%, 0.50% to 0.60%, and 0.75% to 0.85%.
The lowest % indicated by the "% change between" condition is 1.00%. Incidently 1.00% is shown as 0.01 in the "% change between" condition entry field.
If you could add 1 space that would be fine, but 2 spaces would be ideal. Examples 0.0025, 0.005, 0.0075 to get the partial %'s I listed above.
Thanks a million for your help.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Thank you for your suggestion.
Note that it might be possible to just write formulas for what you want to use as WatchList columns.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 3/19/2011 Posts: 19
|
When I enter the numbers above to try to get less than 1% like .0025% (quarter %) the software just reverts it back to 1% as that is it's current lowest ability to calculate.
Unless I'm missing something?
Could you give me an example "Formula" for the quarter% listed above?
Thank You,
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The calculations use single precision floating point math. This amounts to about seven correct significant digits (be they before or after the decimal). The display can get rounded however (usually to two digits past the decimal).
Let's say you wanted to create a condition for the the absolute % change between the current and previous value of the 9% exponential moving average being less than 0.25%:
100 * ABS(XAVGC9 / XAVGC9.1 - 1) < .25
Now if the issue is that you want to display the value of the % change in a WatchList column and the WatchList column is getting rounded off to two digits past the decimal, you can right click on the name of the WatchList column at the top of the WatchList and select Edit. Not all WatchList columns will have this, but there will usually be a Decimal Places setting in either the main tab of the Properties tab of the Edit Column window.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|