Follow me

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

Subscribe to my newsletter