Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 2/9/2010 Posts: 50
|
Michael and Julia , I noticed in tonight's webinar you had a workspace or watchlist for SECTOR ROTATION stocks. I would dearly love to know how you construct that watchlist with columns and conditions etc.The whole webinar was wonderful and, as usual, the devil is in the detail! Thanks so much, Shannon
|
|
Gold Customer
Joined: 5/13/2010 Posts: 146
|
Julia,
I am repeating the same message that I’ve seen posted by others, but no solution was forthcoming that I could find. Couldn't get the Kicker to work. Got the error message: insufficient data. I used what you posted:
(O3-C3)/((.001+(H3-L3))>0.6)AND(O2-C2)/((.001+(H2-L2))>0.6)AND(O1-C1)/((.001+(H1-L1))>0.6)AND(C3<O3)AND(C2<O2)AND(C1<O1)AND(C>O)AND(O2<C3)AND(O1<C2)AND(O>O1)AND(C-O)/((.001+(H-L))>0.6)
Hope you have a solution. The Kicker is the last of a set that I was trying to fill out.
Thanks,
Vince
|
|
Worden Trainer
Joined: 4/26/2007 Posts: 508
|
Shannon,
You can join Michael Thompson's club, which will ultimately add a button to your Main Toolbar that says "MT Training". Once you've joined the club and see the icon, if you click the button, you'll see Michael's published content. Under Workspaces, there's an item called "Sector Rotation"; if you choose it, the Workspace will open in your software.
That way you'll avoid trying to follow step by step construction instructions.
To join his club, visit this address: www.tc2000.com/workshops
Hope that helps,
Julia
|
|
Worden Trainer
Joined: 4/26/2007 Posts: 508
|
Vince,
I've made some changes to the formula, which should correct the problem. It will be uncommon for this to have a hit since it's pretty restrictive. Let us know when you get the first scan result that's a great one!
Try this formula:
(O3-C3)>.6*(H3-L3)AND(O2-C2)>.6*(H2-L2)AND(O1-C1)>0.6*(H1-L1)AND(C3<O3)AND(C2<O2)AND(C1<O1)AND(C>O)AND(O2<C3)AND(O1<C2)AND(O>O1)AND(C-O)>.6*(H-L)
Best,
Julia
|
|
Registered User Joined: 12/31/2005 Posts: 2,499
|
QUOTE (Julia_O)
Vince,
I've made some changes to the formula, which should correct the problem. It will be uncommon for this to have a hit since it's pretty restrictive. Let us know when you get the first scan result that's a great one!
Try this formula:
(O3-C3)>.6*(H3-L3)AND(O2-C2)>.6*(H2-L2)AND(O1-C1)>0.6*(H1-L1)AND(C3<O3)AND(C2<O2)AND(C1<O1)AND(C>O)AND(O2<C3)AND(O1<C2)AND(O>O1)AND(C-O)>.6*(H-L)
Best,
Julia
It would seem that this formula could be simplified. Since (H3-L3) is always 0 or greater, for (O3-C3) to be greater than 0.6*(H3-L3)then O3-C3 must be positive, therfore there is no need to check (C3<O3). The same follows for the other days.
So instead of
(O3-C3)>0.6*(H3-L3) AND
(O2-C2)>0.6*(H2-L2) AND
(O1-C1)>0.6*(H1-L1) AND
(C3<O3) AND
(C2<O2) AND
(C1<O1) AND
(C>O) AND
(O2<C3) AND
(O1<C2) AND
(O>O1) AND
(C-O)>.6*(H-L)
one can reduce it to:
(O2<C3) AND
(O1<C2) AND
(O>O1) AND
(O3-C3)>0.6*(H3-L3) AND
(O2-C2)>0.6*(H2-L2) AND
(O1-C1)>0.6*(H1-L1) AND
(C-O)>0.6*(H-L)
|
|
Worden Trainer
Joined: 4/26/2007 Posts: 508
|
Thanks jas!
Julia
|
|
Registered User Joined: 5/9/2010 Posts: 144
|
Thank you Julia for sharing Mr. Michael started a club! Thanks Mr. Thompson for including me!
|
|
Guest-1 |