530692 Get stock prices in Excel for mac

I use Excel for mac 2011. I currently download share price data/information into my spreadsheet via the standard query "MSN Moneycentral stock quotes". However there have been problems with the quality of the data recently. I would like a query that pulls stock data off Yahoo Finance (my preference) or Google Finance. I need data only for the US & Canada. The query must download the data into a workbook where I have already entered the stock codes. The stock prices do not need to be real-time. The standard 15 min delay data that is freely provided is sufficient. See attachment for sample spreadsheet.