Using The New Spreadsheets

While there are myriads of sources to tell you what happened in the markets today, I find it better if you do it yourself. There are several reasons for that opinion but suffice it to say you will retain more and gain a confidence in yourself as well. So how do I do that and with a minimum of time spent on the task?

Monday the major averages were little changed but what about sectors? Go to Databases & Charts. Click on 31 Morningstar Sectors and download the spreadsheet. If you do not have Excel or a compatible spreadsheet, you can open the spreadsheet in Google documents. Do a Google search on how. Click picture for a full sized image.

Screen Shot 2014-06-17 at 10.12.05 AMFirst notice, only 6 of 31 sectors rose on the day. However most of the moves were minor. Exceptions 1% + moves: MG610 Aerospace/Defense, and MG630 -Materials & Construction. So let’s hide the rows above and look at those 2:

Screen Shot 2014-06-17 at 10.19.16 AMOn a longer term basis they seem to be fine. In fact if you look at the 52 week high for each we are still within a few percentage points of those highs. Just a pullback perhaps?

Let’s hit the tab to the right and get the relative strength and systems data. Again I’ll hide other rows:

Screen Shot 2014-06-17 at 10.24.23 AMBoth sectors still are rated overweight and both sectors remain on a Victor Sperandeo DTI buy. The relative strength ranks over remain steady and in the top third of sectors.

From here you can go back and download the Industry group data if you would like to see if there is a group within that is causing any problem. There are only two groups within Aerospace/Defense and both were down about 1 and 1/4 percent.

The materials and construction sector contains more groups I’ll take a picture for you from the relative strength tab:

Screen Shot 2014-06-17 at 10.43.11 AMAgain and for my purposes I see nothing here that worries me. Do you?

But do yourself a bit favor, learn to use spreadsheets they can a) save you oodles of time and b) allow you to perform studies of your own with relative ease.

Talking Points and How You’re Missing Out on $100K in Your 401(k):

No, War Doesn’t Boost Economic Growth (The Week)
Bubble Thinking In Real Estate….Again (Sigmund Holmes)
Teens politely inform bank they can crack all its ATMs (DailyDot)
Amazon Is Not Invincible (HBR)
Why the euro crisis still isn’t over, in 1 chart (Wonkblog)
Five ways the American health care system is literally the worst (Vox)
Food Stamp Usage is Cratering and that Might be a Bad Sign( (Prag Cap)
The Fed’s Unemployment Conundrum (WonkBlog)
Housing in the twenty-first century (Economist)
9 money habits that can help you get wealthy (MSN)
10 Lazy Ways to Appear Smarter (PsyBlog)
Big Freeze on Hiring (Washington Post)
Don’t Do What You Love; Do What You Do (HBR)
You Know Piketty Is Onto Something When Everyone’s Trying to Prove Him Wrong (Quartz)
Cries of American Weakness by the People Who Weakened America (Washington Monthly

How You’re Missing Out on $100K in Your 401(k)