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 21-day 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 off-forum 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 10-day 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:
(AVGC5-AVGC5.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 values-to-chart 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 short-term 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 re-ask 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 10-Period 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 10-day 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 10-Period 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:
(AVGC5-AVGC5.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 values-to-chart 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:
(AVGC5-AVGC5.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 values-to-chart 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
|
|
Guest-1 |