Alternative to Excel Pulling Stock Quotes from MSN Money - Use Google Sheets

The Microsoft Excel stock quotes plug-in stopped working the way it was designed to. Maybe it is temporary or maybe it is here to stay. Regardless, here is a temporary or with a little effort you could make it a permanent solution.
Start using Google Spreadsheets. My only gripe about it years ago was that you were not able to take it offline or had to go through a number of hoops to take it offline. However, they've fixed it since and now you can save it to a Google Drive and access it offline. 

When you open Google Sheets, you can create a new sheet by clicking on the huge green plus sign on the bottom right corner. Next it will take you to a sheet that looks very much like Microsoft Excel. Like with Excel formulas, you can actually put in a stock formula that will pull delayed quotes from Google Finance. 

The formula is =GOOGLEFINANCE(ticker). This will default to the price of the stock. Similar to Excel, you are also able to select a cell with a ticker versus typing in the ticker. Your formula would look like =GOOGLEFINANCE(A1). Whereby A1 is the cell in which you have your ticker symbol. 

What is so great about Google Sheets is that you can do a lot more than you could in Excel. For example, if you are looking for the current day volume, just simply put "volume" after the ticker as the "[attribute]". It would look like this =GOOGLEFINANCE(NKE, "volume"). 

Another useful function of Google Sheets is that you can pull historical stock price data straight from Google's stock database. In the below example, when you specify the symbol, attribute, start_date, num_days or end_date, and 1 interval, Google will automatically pull that information into your sheet. 


You might decide to forgo Microsoft Excel stock plug-in and use Google Sheets. Google Sheets lets you import your old Excel sheets. That way you don't need to start from scratch. Just go to File -> Import and then select your Excel sheet.

What else can Google Sheets do? It can also pull quote and data for mutual funds and foreign exchange trends. 


A number of useful attributes for pulling stock information from Google Finance are all shown below. 

Syntax
GOOGLEFINANCE(ticker, [attribute], [start_date], [num_days|end_date], [interval])
Notes

Labels: ,