The usual 21 st century disclaimers, use at your own risk etc. There’s an autocomplete in the function entry line and you can copy then paste to fill cells too.Įxtra: you can view only the Sheet that Peter Deegan made for these examples at It’s a READ ONLY worksheet with editing not available, for obvious reasons.

Sheets works similarly to Excel for these operations. We’ve added another column with the vital currency detail as well eg GoogleFinance(A3,’currency’) For simplicity we’ll just lookup the price. Go to Google Drive and make a new sheet.Īdd to the sheet codes you want to look up, then a column with calls to GoogleFinance() to lookup those codes. To make this work, create a new Google Sheets from the online service (not the downloadable software). 18 different ‘attributes’ for each stock or index – too many to show in a single screen image (they’re listed later in this article). Google’s GoogleFinance() function returns a lot of information about many global stocks and indexes. Once you get the data into a Google Sheet, it can be automatically exported and grabbed by Excel. Google’s version of Excel is Sheets and that has a nifty function that grabs stock prices right into the worksheet. It’s a sad indictment of Microsoft Office that the best place to get stock data is Google.

This time we’ll use the improved Query system in recent versions of Excel combined with data from Google Finance. It’s part of a series: introduction and using MSN Money in Excel. Here’s another method of getting stock prices into Excel.

Download stock quotes into excel