ETF Range Projections 2.1.12
Experience: that most brutal of teachers. But you learn, my God do you learn.
- C. S. Lewis
Current World Markets:
trade safe and
have a great day!
S&P 500 Fundamentals by Company
I’ve put together for your perusal, a Microsoft Excel Spreadsheet containing all 500 component issues of the S&P 500 index. What are you looking for; Growth? Value? Dividends? Volatility?
The spreadsheet contains: Sector, Morningstar Industry Group, Beta,Alpha R Sqr, Historical Volatility 50 average, EBITDA/Share, EPS, PEG, BookValue/Share,ProfitMgn, OperatingMrgn, ROA, ROE, QtrlyRevGrowth, GrossPrft/Share, SlsPerShr, QtrlyErnGrwth, FrwrdDivPerShare, Yield, OperCashFlow, LvrgedFreeCashFlw SharesOut, Share Float,Insider Hld,InstitutionHld, Short ShortPrevMnth, DivPayDate,ExDivDate,LstSpltRtio,SplitDate
Sort the spreadsheet by Morningstar Sector and/or Industry Group. If dividends are your interest sort the spreadsheet by dividend yield; notice the sectors and industry groups that appear near the top. Do further looking within that sector or industry group for a better investment. Interested in growth or value, well then sort by the criteria you believe signifies growth and/or value. Looking for volatility or a lack of volatility sort the data by beta. What are you looking for?
Download: S&P Fundamentals (Data compiled from Yahoo Finance)
Note: this is a Microsoft Excel 2007 (.xlsx) file. Do Not use I.E. to download, use any other browser.