How to import stock information into GoogleDocs

This article shows how to import stock information into your GoogleDocs Spreadsheet.

Step 1: Create a spreadsheet

1. Go to your Google Drive
2. Click on New > Google Sheets

Step 2: Type a googlefinance Formula to fetch a stock price

Type the following code in any random cell in the spreadsheet and press enter.

=googlefinance("AAPL","price")

This should show you the current stock price of Apple stock. AAPL is the stock symbol of Apple. price is the attribute that tells the function to fetch the stock price.

Step 3: Browse through the googlefinance function guide

At the time that I am writing this article, the guide is located here. In the event the location changes by the time you read this article, simple search for googlefinance function guide in Google search.

Step 4: Step up the spreadsheet to fetch multiple values for multiple stocks

Fill in the spreadsheet as follows

In cell B2, type the following formula

=googlefinance($A$2, B1)

Drag the cell across horizontally to create formula for the remaining attributes. You should see the following:

Then drag B2 downwards. Then edit B3 as follows:

=googlefinance($A$3, B1)

and B4 as follows

=googlefinance($A$4, B1)

Then drag the dot on bottom-right to create formulas for the remaining attributes. You should see the following: