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 |

Sector Rating Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Sunbird
Posted : Saturday, September 9, 2006 9:58:43 AM
Registered User
Joined: 10/7/2004
Posts: 45
Is there a way to write a formula that incorporates a mathematical value for the Sector a stock is in?

For example suppose I am using a stochastics formula and the value for JNJ is "X". The same stochastic gives a value of "Y" for Drugs, the sector that JNJ is in. Can I write a formula that automatically adds X and Y to produce a final rating of "Z" for JNJ?

I want to calculate "Z" for all stocks in a watch list.

Sunbird
diceman
Posted : Saturday, September 9, 2006 2:58:49 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
You can create a watchlist of Drug stocks and includes the drug sector
in it.

When you sort the watchlist by stochastics you can tell which stocks are
above it.

-------------------------------------------------------------------------------------------------------

You can also sort the sectors by STOC.

When you have found a sector you are interested in. (lets say
drugs). You can record its value. Lets say it is 35.14.

You can now sort the component watchlist with the equation:

STOC(for the stock)-35.14

The ones that are positive are above the index.

--------------------------------------------------------------------------------------------------

Realize that STOC may not be the best indicator for this.

Something like linear regression slope or percent change may be better.

You may be interested in this:

http://www.worden.com/training/default.aspx?g=posts&t=186

http://www.worden.com/training/default.aspx?g=posts&t=51

http://www.worden.com/training/default.aspx?g=posts&t=28


Thanks
diceman




Craig_S
Posted : Saturday, September 9, 2006 6:15:13 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
You can do this in SnapSheets.

For information, videos and to download SnapSheets (which uses the TeleChart data feed), please check out the <a href="http://www.snapsheets.com">SnapSheets Web Site</a>

- Craig
Here to Help!
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.