Using The Relative Strength Score Spreadsheet
The spreadsheet is usable online, but it will be far better to download it and work with it locally. To download it, simply click on the “File” menu, go down to where is says “:download as”, and it will give you a choice of format to download it in, depending on which spreadsheet software to use. The most common format will be “.xls”, which is Excel format and readable by any spreadsheet program that I am familiar with. You want to download it in spreadsheet format rather than text format to preserve the formulas on page 2.
Page 1 of the spreadsheet contains raw data for the formulas on page 2 and by itself is not much use. The first 4 columns are from the price relative scores that I calculate on a weekly basis; the next two columns are from the breakouts spreadsheet that I update daily, and the last two are from the long term relative strength data that I calculate on the weekends.
Here is page two, this is where the searches and calculations are done. Input the ticker symbol in column A, columns B through E are where the formulas are for searching the data on page 1, and column F is where the total is calculated. I have the formulas for 100 stocks on this page, limiting it to keep the spreadsheet size small, but you can do as many stocks as you want simply by copying and pasting the formulas. When done, save this page as a text file (“.csv”) which will give you a single page of sortable results.The columns are “RS”, which is the old price relative score, “Diff” is the difference between this week’s score and last week’s,
“Momentum” is short term strength, and “200 d” is long term strength.
Page 3 is the old price relative score data: since I still use it to calculate the total relative strength score, I included it in this spreadsheet. Feel free to do modifications to this spreadsheet; if there is something that looks wrong to you, let me know. I am not a math whiz (anything more complicated than algebra makes my head spin), so I tried to keep this pretty simple. It is roughly analogous to the IBD RS rating, in that stocks in the top 10% of scores here will very likely have an RS score of 90 or higher. The difference is that this method is open while IBD’s is cloaked in secrecy, so you can evaluate my method while you have to blindly trust theirs.
Source: http://samuraitrader.blogspot.com/2013/09/using-relative-strength-score.html
Anyone can join.
Anyone can contribute.
Anyone can become informed about their world.
"United We Stand" Click Here To Create Your Personal Citizen Journalist Account Today, Be Sure To Invite Your Friends.
Please Help Support BeforeitsNews by trying our Natural Health Products below!
Order by Phone at 888-809-8385 or online at https://mitocopper.com M - F 9am to 5pm EST
Order by Phone at 866-388-7003 or online at https://www.herbanomic.com M - F 9am to 5pm EST
Order by Phone at 866-388-7003 or online at https://www.herbanomics.com M - F 9am to 5pm EST
Humic & Fulvic Trace Minerals Complex - Nature's most important supplement! Vivid Dreams again!
HNEX HydroNano EXtracellular Water - Improve immune system health and reduce inflammation.
Ultimate Clinical Potency Curcumin - Natural pain relief, reduce inflammation and so much more.
MitoCopper - Bioavailable Copper destroys pathogens and gives you more energy. (See Blood Video)
Oxy Powder - Natural Colon Cleanser! Cleans out toxic buildup with oxygen!
Nascent Iodine - Promotes detoxification, mental focus and thyroid health.
Smart Meter Cover - Reduces Smart Meter radiation by 96%! (See Video).