Finance in Excel 1 - Live Stock Quotes in Microsoft Excel - MSN MoneyCentral Investor Stock Quotes

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

Learn how to view Live Stock Quotes in Microsoft Excel. This tutorial shows you how to view stock quotes through Excel and how to automatically update those stock quotes. This tutorial will show you how to view and therefore better manage your portfolio through Excel. This is a great tutorial for anyone who owns stocks and would like to view how their stocks are doing through Excel. This tutorial shows you how to view stock quotes through the MSN MoneyCentral Investor Stock Quotes existing connection 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 tutorials
• excel help and guides
• excel consulting
• finance in excel
• financial functions for excel
• importing data into excel
• live stock quotes in excel
• manage portfolio with excel
• stock and bonds
• market activity in excel
• existing connections

[pavXX]

fwiw, I absolutely HATE this function in Excel 2010!! I just want the price, and it inserts this entire table, with crap that I don't want or need..

[ExcelisHell]

@pavXX I agree. Check out financial symbol smart tags - this might do what you want.

[greatbeachhouse]

Really informative video!! Thanks!!

[TheBilliejones]

How do I use "financial symbol smart tags"? Sorry if this is a stupid question, but as a previous user noted.........I just need the current price not all the other junk that comes with a huge table that ruins the layout of the rest of my spreadsheet. Thanks for any help.

[MegaBhatti1987]

ExcelisHell!! Dude i Love u!!!!!!! If u ever come to Lahore....i will give u a big fat kiss..i promise!!

[pschaars]

Microsoft got rid of the easy way of doing this and made it hard, and for what end? to advertise MSN? Not all publicity is good publicity Microsoft!

Thanks for the video, though. Super informative. I will have to set-up my parents spreadsheets like this because remaking them would be way too time consuming. Maybe after I show my Dad the process he will begin switching.

For me, Google Spreadsheets:

=GoogleFinance("GOOG"; "price")

[StockTradingMaster]

Keep the videos coming man

[StreetwiseReports1]

great video..thanks

[pavXX]

@ExcelisHell

Yep tried that a while ago. They don't pick up a lot of the symbols I'm trying to track. I think Google spreadsheets do what I want--problem is that's blocked at work.

[vt1875]

thanks! :)