Blog

July 31, 2006

Getting Stock Prices into Excel

Yahoo Finance (http://finance.yahoo.com/) has a link on each summary page that allows the user to download the stock information in CSV format.


What is less well known is that there is a URL which allows direct access to stock information without having to parse any HTML or even XML.


The format is http://finance.yahoo.com/d/quotes.csv?s=STOCK_SYMBOL&f=FORMAT_STRINGso to get Vodafone's ask price the URL would be http://finance.yahoo.com/d/quotes.csv?s=VOD.L&f=aA full description is available at http://www.gummy-stuff.org/Yahoo-data.htm You can then import this data automatically into Excel. More... Via Frans King
  • Share/Save/Bookmark

Posted By David Teten
On July 31st, 2006
« Seeking power outlets in airports


How to be an expert »

Comments are closed.