Finance in Excel 2 - Import and Chart Historical Stock Prices in Excel

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Learn how to Import and quickly Chart historical stock prices in Microsoft Excel using data from Yahoo Finance. This is a great way to visualize the moves in a particular stock. This tutorial also shows you how to import data from the web and to quickly graph and chart information in Excel 2007.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• excel tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• charts and graphs
• finance tutorial in excel

[Yellowknight888]

How can you import multiple year of data into excel using this method? Since the data is too long, you have to click on next page to see historical data from a different period. But once you go to the next page, the previously checked green arrow is no longer recognized.

[ExcelisHell]

@Yellowknight888 do it in parts or copy by hand.

[manretify]

worst ever. there are free excel macro that pull 16 years worth of SPX data in 10 seconds. You want people to do this by hand? 16 years is at least 8 pages a year, 100 pages total! that will take hours for something that should take seconds!

[Thatmakessense356]

@ExcelisHell  Is there a way to get excel to make 1 day, 1 week, etc. charts using current data and then storing that data? Would there be a way to get moving averages, etc. from that?

[zaw92]

great help

[dovic3107]

thanks a lot for this video !! great job !!

[gqiq]

in excel 2003, the data is charted from most recent to earliest, the opposite of how it should be. 2007/2011 seems to recognize how time passes and adjust accordingly, regardless of how the data is arranged in the spreadsheet.

Because of this, I have to flip the data in Excel 2003. Do you know of a way to avoid this?

[StockTradingMaster]

Good video

[johnwhenry131]

Should this work in Excel 2011 for Mac? There does not seem to be get data 'From Web' option on the Data ribbon - only 'HTML'.