Finance in Excel 9 - View Live News and Headlines for Publicly Traded Companies and Stocks in Excel

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

This Excel Video Tutorial shows you how to import live headlines for stock and publicly traded companies into Excel. You will learn how to have the headlines update every minute so that the most recent information is available to you. This tutorial uses Yahoo finance to get the updated headlines.

The useful feature of this tutorial on importing data into Excel is that the links to the actual articles will also import with the headlines. This means that if you want to learn more about the headline you can click a link in Excel and be taken to the actual article for that headline. This is a great tutorial to round out your abilities to track your stocks and portfolio in Excel.

For Excel consulting, classes, 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
• headlines
• company information
• stock prices
• stocks
• publicly traded companies
• import news
• view headlines
• live
• refresh

[johnsma1]

This was very helpful, however, Yahoo appears to have changed the architecture of thier web pages and you can no longer get the headlines this way because the "yellow checkbox" does not come up beside the headlines.

[ExcelisHell]

@johnsma1 Wow, that is very annoying. Though, this can still be accomplished using XML but it is a little bit more complicated.

[karthikganeshbabu]

Thank You. Your tutorials are great.