| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 7
|
Hi,
I would like to do some scanning and sorting with TSV - similar to that shown on your Moneystream Scanning and Sorting CD. There are not standard PCF's for TSV 3 month range, etc. I guess I would need to create PCF's for TSV 3 month range, 1 year and 3 year. Would this be the best way to approach this? Also, please help with the PCF's on these, and I can take it from there. Thanks much!
Dano
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
I'll do some work on the PCF's for you. In the meantime, check out this video on Visual Change sorts.
http://www.worden.com/training/default.aspx?g=posts&t=141
Visual change sorting can help you identify stocks where TSV (or any indicator)has made the biggest move up or down over a particular period. Lots easier than PCF's, if that's what you're looking for.
- Doug
Teaching Online!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Also, if you sort TSV by the VISUAL VALUE it will sort the indicator visually relative to the highest higher or lowest low as seen on the chart. I too recomend exploring the visual sorting. You will find it far more flexible and intuitive than Personal Criteria Formulas.
Here is another video to help:
http://www.worden.com/training/default.aspx?g=posts&t=134
- Craig
Here to Help!
|
|
Registered User
Joined: 10/7/2004
Posts: 7
|
Excellent,thanks for the help! I like your Worden Studio, feel it really adds alot to the service. Looking forward to figuring out all it offers.
Dano
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
Dano:
We've been working on a PCF for you, and this is one that Craig came up with.
(TSV19 - MIN(TSV19,63)) / (MAX(TSV19,63) - MIN(TSV19,63)) * 100
When you use this PCF to sort a WatchList, the calculated values will range from 0 - 100. Stocks that return a value of 100 will be those where TSV is at a 63 day (3 month) high. Stocks that return a value of 0 will be those where TSV is at a 63 day (3 month) low. Stocks returning a value of 50 would be those where TSV today is exactly in the middle of its 3 month range.
The 19 after TSV refers to the TSV period, so if you like to plot TSV with a period of 28, for instance, then you would change the 19's in Craig's PCF to 28's. Also, the 63 after each comma refers to the period of time over which you are measuring TSV's range of values. If you want to find stocks hitting a high or low for a one year period instead of three months, just change each 63 in the formula to a 250.
One more thing. When you plot TSV, the dialog box gives you the choice between simple and exponential. Make sure your TSV is set to simple.
Hope this helps!
- Doug
Teaching Online!
|
|
|
Guest-1 |