Thursday, June 26, 2008

Sources of 5-year stock prices in graphic format to insert into Powerpoint

Through email reference today, a student said she was having trouble inserting a five-year chart (graph) of Home Depot's stock prices into a Powerpoint slide. As I was working on it, Louise, doing chat reference, saw the question and we explored different ways that this could be accomplished.

The choices may depend on whether the student wants to generate a chart/graphical data from price data or simply copy and paste a graph. Some of the options below provide only the company's stock prices over 5 years, while other options allow you to create a graph/chart comparing that company's stock prices performance to other companies or to an index or indices.

Creating a chart of stock prices is one of the things learned in the Reuters workshops but that didn't seem a practical solution today, given that it was an email question. Plus neither of us had saved such a created chart and then emailed it to ourselves.

So here is the answer that I sent the student, in the event that it comes up again:

Here's some options:

1. Go to the Home Depot homepage, www.homedepot.com, and

Click on Investor Information, then stock information. You will see that a chart is available on the prices. You can change the chart to 5 years and select different stock prices...weekly, etc. Then, right click on the chart and you will have the option Copy Image. Open Powerpoint and select a slide in which the content is graphs and past the image.

2. You can also use three subscription databases available to Baruch students to copy and paste a chart. Why would you use these databases over Home Depot's free option? Standard & Poor's Net Advantage, Mergent, and Morningstar allow you to build a graphical chart with more options..you can select to compare HD's stock price to different indexes. This would provide more information than the chart of the stock price alone.

Both Mergent Online, Morningstar and Standard & Poor's Net Advantage are databases that can be located through databases on the Newman Library homepage.

3.) for Standard & Poor's NetAdvantage.

Once you log on to the database, look to do a Companies search (blue toolbar). Enter HD as the ticker and search.

On the left column, you will see chart listed among the selections. Click Chart. A chart will appear and you will have options to select. When you have created the chart you want,

right click and copy the image. As before, insert into Powerpoint.

4.) Now, for Mergent. Select Mergent Online from the database options. Either enter Home Depot as the company name or HD as the ticker symbol to search. Then, click on the tab Equity Pricing when the option appears. You will see a chart of HD's stock prices. As with Standard & Poor's NetAdvantage, you can select the time period and if you want to compare the HD stock performance to a different index, make the selections you want.

Scroll down and click Draw Chart, when you have made your selections. As before, right click to copy the image, and then open Powerpoint and insert the image.

5) I forgot to look at Morningstar when I was doing the email reference. But it too allows you to get a five year graph of a company's stock prices and allows a comparison to another company to be added. Right click to copy the image and then paste into Powerpoint.


Some free web sites that also allow you graphs that can be copied are:

www.Reuters.com. Do a search for the stock you want and look for the chart. Click on it, and you can create a chart with different options, including comparing the company to three other companies. Once again, right click to copy image and then insert the graph into a Powerpoint.

Google Finance also might be used. Enter HD as the stock quote that you are looking for. Click on the link Historical stock prices and select five years. You will then need to click download to a spreadsheet. Once you have saved the spreadsheet as an Excel file, you can create a chart using Excel. This will require a few more steps than the other options that allow you to copy a chart.

I also looked at Valueline but since this is a black and white chart for 10 years, I didn't recommend it.

No comments: