How to Get Stock Quotes into a Spreadsheet
Here’s a quick and easy way to get stock market quotes from Google, Yahoo, and Yahoo Japan into a spreadsheet. You just type=gq(”IBM”) for example, and the function goes out to google finance and pulls down the most recent quote.
Here are the functions are in the file:
Google
Name: =gname(”IBM”) returns the name of the company
Quotes: =gq(”IBM”) returns the most recent quote, from Google
Shares: =gshares(”IBM”) returns the number of shares outstanding
Market Cap: =gmc(”IBM”) returns the current market capitalization of the company
Yahoo
Quotes: =yq(”IBM”) returns the most recent quote, from Yahoo
Shares: =yshares(”IBM”) returns the number of shares outstanding
Market Cap: =ymc(”IBM”) returns the current market capitalization of the company
Yahoo Japan
Quotes: =yjq(”4689″) returns the most recent quote, from Yahoo Japan
Market Cap: =yjmc(”4689″) returns the current market capitalization of the company
Full disclosure - I learned the methods used in these functions from Randy Harmelink’s stock market functions. His are much more complete, and can pull thousands of different types of financial data from all over the web. I wrote these functions because I wanted simple, easy to remember and easy to use functions.
One More Thing - Though Office for Mac 2004 supports Visual Basic, which is what these functions are written in, I couldn’t get this to work on my Mac with Office 2004. The file requires a Microsoft XML add in which I didn’t see in the Mac version of Office.