Back to top

Voice of the People

This page is temporarily not available.  Please check later as it should be available shortly. If you have any questions, please email customer support at support@zacks.com or call 800-767-3771 ext.  9339.

Zacks' Voice of the People Highlights user  Vet67to82: "Data Mining - With Your OWN Spreadsheets" from the People & Picks community.

For more Voice of the People, visit http://at.zacks.com/?id=5851

Featured Post

Data Mining - With Your OWN Spreadsheets


April 22, 2010 - RELATED TICKERS: Citigroup ([url=http://www.zacks.com/stock/quote/c]C[/url]), Neuralstem ([url=http://www.zacks.com/stock/quote/cur]CUR[/url]), Primerica ([url=http://www.zacks.com/stock/quote/pri]PRI[/url]), PDL Biopharma ([url=http://www.zacks.com/stock/quote/pdli]PDLI[/url])

Based on Friday to Thursday period data closing prices, I knew today would be a down day!

Thanks to my OWN spreadsheets I can "data mine" the High, Low, Open, Close, Volume, etc. using columns and formlii to look for patterns and trends IN THE NUMBERS ... that can be put to the statistical test for "significance." The results can be charted ... a picture is worth a thousand words ... and the numbers further analyzed.

Take the fact that in 2010, we've had 50 "Up-days" in the DJIA and 25 "Down-days." The daily average upside, to date for the Up-days has been ( Previous DJIA closing price x 1.00349 ) and the daily average downside has been ( 1.00 minus 0.00235 or 0.99765 ). So for today, based on the daily average numbers, I had an expection of the DJIA close as between 11155.91 "Hi" and 11090.92 "lo." But, my call on the down-day came from the "weekly" section of the spreadsheet.

Fun with math ...

... the "downside" formula ( Previous DJIA closing price x 0.99765 ) would represent the "projected" average close on a "down" period for the Friday to Thursday period ending today.

Keep in mind, the close today, will change these numbers ... rendering a new data set for projecting the week thru next Thursday.

The average weekly Friday to Thursday, has an average gain of +48.11 points, despite the worst weekly loss (537.50) for the January 22, 2010 period. Just to keep the 48.11 point average, considering last Friday's 125.91 point decline .... we would have had to have a +260 point Up-day today. Statistical probability of that occuring ... ZERO.

The best weekly Friday to Thursday 2010 close, has been +258.15 points for the period ended Feb 19, 2010.

Would you like to know what I ALREADY know about closing prices for the DJIA for FRIDAY?

Raise your hands ... oops ... can't see that ... hmmmm! I have a target in mind for "recs" and if I hit my target I'll post the Monday to Friday stats and "outlook" next.

I will continue to post the ever changing weekly "Friday to Thursday" closing numbers here ... so you might want to follow this post.

About the Zacks Community

In 2008, Zacks Investment Research launched PeopleAndPicks.com, a stock-picking website where members of the Zacks community can test their strategies and share ideas with other members. Each user is scored on the accuracy of his or her picks, and top users are rewarded with free products from Zacks. Registration is free. To learn more visit http://www.PeopleAndPicks.com

Please login to Zacks.com or register to post a comment.

New to Zacks?

Start Here

Zacks Investment Research

Close

Are you a new Zacks Member or a visitor to Zacks.com?

Top Zacks Features

Learn more

Start for as little as $4.50 per trade.

My Portfolio Tracker

Is it Time to Sell?

One of the most important steps you can take today is to set up your portfolio tracker on Zacks.com. Once you do, you'll be notified of major events affecting your stocks and/or funds with daily email alerts.

More Zacks Resources

Zacks Rank Home - Evaluate your stocks and use the Zacks Rank to eliminate the losers and keep the winners.

Mutual Fund Rank Home - Evaluate your funds with the Mutual Fund Rank for both your personal and retirement funds.

Stock/Mutual Fund Screening - Find better stocks and mutual funds. The ones most likely to beat the market and provide a positive return.

My Portfolio - Track your Portfolio and find out where your stocks/mutual funds stack up with the Zacks Rank.

Zacks #1 Rank Top Movers for Zacks #1 Rank Top Movers

Company Symbol Price %Chg
LAKE SHORE G LSG 0.77 +6.05%
QUESTCOR PHA QCOR 80.07 +2.47%
VIPSHOP HOLD VIPS 156.35 +1.82%
ENLINK MIDST ENLC 36.29 +1.60%
BNC BANCORP BNCN 17.33 +1.58%