Worden Trainer
Joined: 10/1/2004 Posts: 18,819

If you prefer, you can download the video and watch it offline. Choose the Save option and save it to your hard drive. Extract the files to a location on your hard drive and double click on the .html file to launch the video. You must extract the files to your hard drive. You cannot play the video from the .zip file.
linear regression divergence sort sorting by price
 Craig Here to Help!
To view this video you must have Macromedia Flash Player and Microsoft Internet Explorer 5+


Registered User Joined: 10/7/2004 Posts: 799 Location: Duluth, GA

Excellent video, Craig!
Some other nuances about divergence searches can be found in this thread:
Finding and Ranking Divergences, Visually


Worden Trainer
Joined: 10/1/2004 Posts: 18,819

Thanks!
 Craig Here to Help!


Registered User Joined: 3/11/2005 Posts: 4

LINEAR REGRESSION DIVERGENCE SORT, EXCELLENT VIDEO.
THANK YOU


Worden Trainer
Joined: 10/1/2004 Posts: 4,308

Glad you liked it, TOPGUN!
 Doug Teaching Online!


Registered User Joined: 11/21/2004 Posts: 13

Is there a way to build price/TSV regressions as PCFs?


Worden Trainer
Joined: 10/1/2004 Posts: 18,819

What periods would you like the LRs and what period is the TSV?
 Craig Here to Help!


Registered User Joined: 11/21/2004 Posts: 13

More days are better on any regression, however given that I'm looking for divergences, I'd suspect that another over 50 days would probably be less useful. As far as TSV periodicity, I'm not sure what would be appropriate. I'm still new to the TSV calculations so if there's a min/max range that is necessary, I'd work within that. My gut says use 21day TSV, but I'm very much open to suggestions.


Worden Trainer
Joined: 10/1/2004 Posts: 18,819

They are pretty hefty formulas.
Do me a favor. Play with the method taught here until you find a TSV and LR period you love. Come back and I will be happy to try and put something together for you.
Is that fair?
One thing that is nice about this method is you can change your settings on the fly without creating and calculating long formulas each time.
 Craig Here to Help!


Registered User Joined: 11/21/2004 Posts: 13

Is there a way to send you a private message? I've played w. the video instruction and set up a couple of PCFs but would like to discuss w. you offforum if possible. TIA


Worden Trainer
Joined: 10/1/2004 Posts: 18,819

You are welcome to send me an email. Email support@worden.com and put ATTN: Craig Shipman in the subject line.
 Craig Here to Help!


Registered User Joined: 11/21/2004 Posts: 13

Craig,
Here are the formulas I'm using. I've decided to calculate 10day slopes for both price and TSV and have set up PCF for price slope as follows:
((((C + (C1 * 2) + (C2 * 3) + (C3 * 4) + (C4 * 5) + (C5 * 6) + (C6 * 7) + (C7 * 8) + (C8 * 9) + (C9 * 10)) * 10)  (55 * (C + C1 + C2 + C3 + C4 + C5 + C6 + C7 + C8 + C9))) / ((((1 * 1) + (2 * 2) + (3 * 3) + (4 * 4) + (5 * 5) + (6 * 6) + (7 * 7) + (8 * 8) + (9 * 9) + (10 * 10)) * 10)  (55 * 55)))
I then took this formula and added a subtraction of the TSV slope as follows:
((((TSV10 + (TSV10.1 * 2) + (TSV10.2 * 3) + (TSV10.3 * 4) + (TSV10.4 * 5) + (TSV10.5 * 6) + (TSV10.6 * 7) + (TSV10.7 * 8) + (TSV10.8 * 9) + (TSV10.9 * 10)) * 10)  (55 * (TSV10 + TSV10.1 + TSV10.2 + TSV10.3 + TSV10.4 + TSV10.5 + TSV10.6 + TSV10.7 + TSV10.8 + TSV10.9))) / ((((1 * 1) + (2 * 2) + (3 * 3) + (4 * 4) + (5 * 5) + (6 * 6) + (7 * 7) + (8 * 8) + (9 * 9) + (10 * 10)) * 10)  (55 * 55)))
When I combine the 2, I should get a solution of the slope of price less the slope of TSV:
((((C + (C1 * 2) + (C2 * 3) + (C3 * 4) + (C4 * 5) + (C5 * 6) + (C6 * 7) + (C7 * 8) + (C8 * 9) + (C9 * 10)) * 10)  (55 * (C + C1 + C2 + C3 + C4 + C5 + C6 + C7 + C8 + C9))) / ((((1 * 1) + (2 * 2) + (3 * 3) + (4 * 4) + (5 * 5) + (6 * 6) + (7 * 7) + (8 * 8) + (9 * 9) + (10 * 10)) * 10)  (55 * 55)))  ((((TSV10 + (TSV10.1 * 2) + (TSV10.2 * 3) + (TSV10.3 * 4) + (TSV10.4 * 5) + (TSV10.5 * 6) + (TSV10.6 * 7) + (TSV10.7 * 8) + (TSV10.8 * 9) + (TSV10.9 * 10)) * 10)  (55 * (TSV10 + TSV10.1 + TSV10.2 + TSV10.3 + TSV10.4 + TSV10.5 + TSV10.6 + TSV10.7 + TSV10.8 + TSV10.9))) / ((((1 * 1) + (2 * 2) + (3 * 3) + (4 * 4) + (5 * 5) + (6 * 6) + (7 * 7) + (8 * 8) + (9 * 9) + (10 * 10)) * 10)  (55 * 55)))
The problem I'm having is that I want to find companies where the 2 metrics' slopes are diverging, so I need to look at the change from yesterday to today. I've calculated that PCF as well, but started to realize that unless I can get them into an Easyscan, I'm wasting my time. What I'm attempting to do is identify on at least a daily basis (I'd love to do real time, perhaps 2x/day), companies where the relationship between price and TSV is improving (long) or eroding (short). I can add other variables to get the list smaller if I end up w. too many companies, but I'm really interesting in monitoring closely those names were TSV is doing something opposite of price.
Any suggestions you can provide regarding creating this type of model into an Easyscan would be greatly appreciated.


Worden Trainer
Joined: 10/1/2004 Posts: 18,819

Here is how I would do it.
Create the following PCF:
(AVGC5AVGC5.5)*(AVG(TSV10,5)AVG(TSV10.5,5))
When this returns a POSITIVE number, the price LR and TSV LR are "in step" with each other. WHen this returns a NEGATIVE number, the two are diverging (one sloped positive, one negative).
Create the PCF and then sort some WatchLists by them. You will get a clear sense between the values it returns and what you are seeing on the chart.
I am simplifying things greatly here but I bet you will find this more than gets the job done. Try it!
Once you get a sense of the valuestochart relationship by sorting, you can easily limit the values when you use it in EasyScan.
 Craig Here to Help!


Registered User Joined: 11/21/2004 Posts: 13

It seems to work well in sorts and turns up some interesting charts in EasyScan. My next question regards your thoughts regarding "optimal" periodicity (as if there is such a thing). Obviously with data, more is better, however I'm looking to get a sense for the shortterm flow of funds that could signal institutional movement. Is there a minimal # of data points below which you'd conclude that the TSV LS is meaningless? I'm asking b/c you've seen a lot more of the raw TSV calcs than I ever will and I'm attempting to determine if 10 days is sufficient to get a valid TSV calc. Perhaps to reask the question, what's the mininum # of days required to calculate a TSV that is valid (I'm assuming it's probably more than 2 and less than 100). TIA


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

Darkrider, I'm not in a position to give you "optimal" settings for TSV (or even a minimum period). The following forum topic may be of interest:
Peter Worden's TSV
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 11/21/2004 Posts: 13

Allow me to rephrase the question then...does a TSV1 provide the same data regarding money flows as a TSV10? Perhaps if you can provide a link to the TSV calc, I can judge for myself if you'd prefer. Thx


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

The calculation of Time Segmented Volume is proprietary, so I can’t provide the formula, but TSV10 is a 10Period Simple Moving Average of TSV1. The following videos should help you judge for yourself how TSV1 relates to TSV10:
Understanding Moving Averages  Part I, The Basics Understanding Moving Averages  Part II, Using Multiple Averages
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 11/21/2004 Posts: 13

Thanks. So if I'm comparing a 10day LR of price and want a comparable LR of TSV, I should merely use TSV rather than TSV10 correct? By doing it my original way (10day LR of price vs 10day LR of TSV10), I'm using 10 days of price data and 20 days of TSV data, isn't that correct?


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

Darkrider, You are a little off on the number of days when doing 10Period Linear Regressions of Price (10 days) and TSV10 (19 days of TSV1, although it might require more days of data). I'm not sure if comparing the same number of days is all that important, but as a Trainer I can't tell you what settings to use or how to interpret an indicator.
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 1/1/2005 Posts: 2,645

QUOTE (Darkrider) Allow me to rephrase the question then...does a TSV1 provide the same data regarding money flows as a TSV10? Perhaps if you can provide a link to the TSV calc, I can judge for myself if you'd prefer. Thx
Darkrider,
Bruce has already stated that TSV10 = AVG(TSV1,10).
It may be helpful for you to know that the values of
(TSV1.0,TSV1.1,TSV1.2,TSV1.3,TSV1.4,TSV1.5,TSV1.6,TSV1.7,TSV1.8)
convey no information whatsoever about the values of
(TSV10.0,TSV10.1,TSV10.2,TSV10.3,TSV10.4,TSV10.5,TSV10.6,TSV10.7,TSV10.8)
and conversely. We can construct charts for which each of the above two sequences can assume any two preassigned sequence values whatever.
Please notice that we stopped the sequences at 9 values, just short of the period of TSV10, in order to make this statement. This is a property of Simple Moving Averages and has nothing to do with TSV per se. Please see:
A Property of Simple Moving Averages
TSV10 Simple is superb at telling you whether there is Net Share Accumulation or Distribution, as measured by TSV, over any interval whose length is a multiple of 10. It cannot with certainty convey such information for any other interval lengths. For example, if you want to know whether there is Net Share Accumulation over some interval of length 15, TSV1, TSV3 Simple, TSV5 Simple, or TSV15 Simple can tell you, but no other TSV Simple can including TSV10 Simple.
If Craig had illustrated his fine approach with MS instead of TSV these problems would not have arisen here.
Thanks, Jim Murphy


Registered User Joined: 9/28/2006 Posts: 1

thank all >>


Registered User Joined: 2/5/2006 Posts: 1,148

QUOTE (Craig_S) Here is how I would do it.
Create the following PCF:
(AVGC5AVGC5.5)*(AVG(TSV10,5)AVG(TSV10.5,5))
When this returns a POSITIVE number, the price LR and TSV LR are "in step" with each other. WHen this returns a NEGATIVE number, the two are diverging (one sloped positive, one negative).
Create the PCF and then sort some WatchLists by them. You will get a clear sense between the values it returns and what you are seeing on the chart.
I am simplifying things greatly here but I bet you will find this more than gets the job done. Try it!
Once you get a sense of the valuestochart relationship by sorting, you can easily limit the values when you use it in EasyScan.
i assume the formula above is for a 10 day period. if i want change the formula to analyze 25 days do i just change to 10's to 25's? not really sure what the 5's represent in your formula.


Registered User Joined: 3/10/2005 Posts: 3

How can I save training video to my computer


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

malinbeg,
We've added an option to download the video to the original post.
Bruce Personal Criteria Formulas TC2000 Support Articles


Registered User Joined: 10/31/2004 Posts: 12 Location: deerfeild breach Fl.

QUOTE (Craig_S) Here is how I would do it.
Create the following PCF:
(AVGC5AVGC5.5)*(AVG(TSV10,5)AVG(TSV10.5,5))
When this returns a POSITIVE number, the price LR and TSV LR are "in step" with each other. WHen this returns a NEGATIVE number, the two are diverging (one sloped positive, one negative).
Create the PCF and then sort some WatchLists by them. You will get a clear sense between the values it returns and what you are seeing on the chart.
I am simplifying things greatly here but I bet you will find this more than gets the job done. Try it!
Once you get a sense of the valuestochart relationship by sorting, you can easily limit the values when you use it in EasyScan.


Registered User Joined: 10/31/2004 Posts: 12 Location: deerfeild breach Fl.

I copied the PCF but how do I test it? or what do I do next? mussie


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

mussie,
You would test the Personal Criteria Formula by selecting Test in the Editing Formula window for the PCF. The How to create a Personal Criteria Forumula (PCF) covers this in more detail. Craig suggested sorting by the PCF. The Create your own stock rankings using WatchLists and Sort conditions topic explains how to do so.
Bruce Personal Criteria Formulas TC2000 Support Articles


Guest1 