Monthly Archives: October 2014

Getting Yahoo! Finance data into Excel

Here’s a little VBA snippet that allows to retrieve Yahoo! Finance data into an Excel spreadsheet. Usage: =yfQuote(ticker, date, field), where ticker (required) is ticker symbol used by Yahoo! Finance. Examples: MSFT, ^GSPC, VXX. date (optional) is the date for which quotes … Continue reading

Posted in Finance and Investments, Technology | Leave a comment