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

see more than one %True indicator when sorting Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Gaeagjf
Posted : Tuesday, December 28, 2004 12:33:20 PM
Registered User
Joined: 12/28/2004
Posts: 11
Hi:
How do I get to see more than one %true type indicator when I am sorting? I have three such indicators that I want to track at once in the upper pane of my chart. However they do not appear on the insert column list, so I can only view the one I am sorting by at any given time.
Thanks
Georgia
Doug_H
Posted : Tuesday, December 28, 2004 12:51:07 PM


Worden Trainer

Joined: 10/1/2004
Posts: 4,308
Unfortunately, you can't currently add the custom indicators as additional columns in your WatchList section. This suggestion has previously been sent to the Development Team for their review and consideration.

- Doug
Teaching Online!
Gaeagjf
Posted : Tuesday, December 28, 2004 1:18:02 PM
Registered User
Joined: 12/28/2004
Posts: 11
Doug:
I am trying several other ways to skin this cat. My first thought is to try to sort by the comparison % difference between two %true indicators, namely the "set-up" function and the "set-up with positive outcome" function. That way I am directly seeing what % of the times I have the set-up I get the positive outcome. Unfortunately, for some reason this is not calculating properly and displaying in the sort value. I have the % true indicators visible in the top window and can see the values so I know what the outcome should be--say 28 for the set up averaged over 250 days and 18 for the set-up with follow-through also over 250 days so I would expectto see % difference as 100 - (25/38). Unfortuantely that is not what is coming up.
I then tried to generate a function that was the average of the Boolean function using AVG(boolean fucntion,250) syntax, but that didn't work--it gave me an error message. seems to me that would be a useful thing to be able to do.)
Any ideas on what is going wrong with the first method?
Georgia
Doug_H
Posted : Tuesday, December 28, 2004 1:25:53 PM


Worden Trainer

Joined: 10/1/2004
Posts: 4,308
I'm a very visual person, Georgia. If you could give me the two % True formulas you're plotting, I'll duplicate it here and see if I can figure out what's going on.

- Doug
Teaching Online!
Gaeagjf
Posted : Tuesday, December 28, 2004 1:38:12 PM
Registered User
Joined: 12/28/2004
Posts: 11
Here is my set-up function
AVGC50.40 > 5 AND AVGV50.40 > 2500 AND C40 > AVGC50.40 AND AVGC50.40 > AVGC200.40 AND AVGC50.40 > AVGC50.41 AND AVGC200.40 > AVGC200.41 AND 100 * (MAXH10.40 - MINL10.40 ) / (10 * (AVGH10.40 - AVGL10.40 ))<=30
this function tests that stocks have prices above $5 and good volume, that they are uptrending, and that they have been in a consolidation as of 40 days ago.
Here is my set-up and follow through function
AVGC50.40 > 5 AND AVGV50.40 > 2500 AND C40 > AVGC50.40 AND AVGC50.40 > AVGC200.40 AND AVGC50.40 > AVGC50.41 AND AVGC200.40 > AVGC200.41 AND 100 * (MAXH10.40 - MINL10.40 ) / (10 * (AVGH10.40 - AVGL10.40 ))<=30 AND (maxh40 - c40)>2*(c40-minl40)
This function does all of the above and checks to see that the most favorable excursion in the next 2 months is at least twice as big as the maximum adverse excursion. In other words reward beat risk by 2 to 1.
I take a simple average of both of these over 250 days.
If I could see the % difference of the set-up plus followthrough versus the set-up alone then I would be testing the % of the time that the set-up was a good predictor of positive price action.
thank you for looking at my problem!
Georgia
Doug_H
Posted : Tuesday, December 28, 2004 2:53:43 PM


Worden Trainer

Joined: 10/1/2004
Posts: 4,308
Georgia:

Thanks for being so specific about what you wanted. That helped.

I copied and pasted your two PCF's, updated them, and then plotted them both as % True indicators in the top window (using 250 day simple smoothing averages). I sorted the setup compared to the setup with follow thru, and after several attempts, I was getting erroneous results...stuff I couldn't figure out. At first I thought maybe you had accidentally sorted one indicator by itself...easy to do, since you can't name them and they look identical in the compared to pull-down menu. However, I think something else is going on.

I'm going to need to refer you to the tech agents so that they can re-create your scenario (as I did) and try to figure out what's happening. I don't think it's an error on my part or your part...the data results really did look funky. I could be wrong, but the best place to investigate further would be with tech support.

Email them at support@worden.com. I would suggest that you copy and paste your last post to include in your email. Also, I found that your explanation of your strategy served to muddy the waters a little as I was trying to figure out the problem (even though I eventually figured out what you were trying to do). Perhaps when you email support, you could refer to "my first indicator formula" and "my second indicator formula". I would just tell them that you've got these two % true indicators, and you're trying to sort one compared to the other to get a percent difference calculation.

Sorry I couldn't come up with an answer here in the forum for you.

- Doug
Teaching Online!
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.