Is getting a company's Friday close for 52 weeks a good indicator of how well it's doing?

Hey man, I think I can help out here. Go to google finance, find your company and on the left there's link that says "historical prices." Click that and then you can choose the date range you want (last year or whatever time frame you want). On the top right you'll see a little excel button, which will allow you to download the data to a spread sheet. It's going to give you date, open, volume, close, etc. All you need is the date and close price - delete the other columns. Since you're tying to figure out how the stock has moved over the last year (I assume in terms of a percentage growth/dealing), you'll want to re-sort from oldest to newest (it automatically pulled newest to oldest).

So, your columns should be: date (oldest to newest), close price, difference between yesterday's close price and today's close price, and then finally, the percentage change in today's close price against the first day you're analyzing.

Not sure if that made sense, but at least you can pull the stock data from excel and analyze in excel, which should save you some time.

/r/StockMarket Thread