Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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
|
|
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!
|
|
Guest-1 |