Here are several VBA functions to pull financial information into Excel:
Current information from Yahoo
Philadelphia Reflections: Exchange Quotes from XML using Excel (Yahoo Finance)
Current information from Google
Philadelphia Reflections: Exchange Quotes from XML using Excel (Google Finance)...