Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Question for Michael or Julia from Sort Webinar Feb 29( Australia time)for Michael Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Skyla777
Posted : Tuesday, February 28, 2012 9:01:03 PM
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
vincectec1
Posted : Wednesday, February 29, 2012 4:57:37 PM
Gold Customer 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
Julia_O
Posted : Thursday, March 1, 2012 10:41:08 AM


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
Julia_O
Posted : Thursday, March 1, 2012 11:49:14 AM


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

jas0501
Posted : Sunday, March 4, 2012 12:07:08 AM
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)
Julia_O
Posted : Sunday, March 4, 2012 8:49:50 PM


Worden Trainer

Joined: 4/26/2007
Posts: 508
Thanks jas!

Julia
Jpetesmith
Posted : Monday, March 5, 2012 8:36:55 AM
Registered User
Joined: 5/9/2010
Posts: 144
Thank you Julia for sharing Mr. Michael started a club! Thanks Mr. Thompson for including me!
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.