In this article, we will show you 3 methods of how to import Stock Prices into Excel from Google Finance. We’ll use the data from NASDAQ for Microsoft Corporation (MSFT) to demonstrate our steps. This is what our final step will look like after importing it to Excel.
Download Practice Workbook
3 Methods to Import Stock Prices into Excel from Google Finance
Method-1. Import Stock Prices from Google Finance from Web
For the first method, we’re going to import Stock Prices data from Google Finance to Google Sheets using the GOOGLEFINANCE function. Then, we’ll import that into Excel using Power Query.
Step 1: Import Stock Prices from Google Finance to Google Sheets
Now, we’ll use Google Sheets to obtain Stock Prices from Google Finance.
- Firstly, from Google Sheets and open a new file.
- Secondly, type the following formula in cell A1.
=GOOGLEFINANCE("MSFT","all","5/8/2022","5/17/2022","Daily")
Formula Breakdown
- Firstly, “MSFT” stands for Microsoft Corp.
- Secondly, we’ve put “all” in the second argument. This will return the following things for the specified date range –
- Opening Prices.
- Closing Prices.
- High Prices.
- Low Prices.
- Share Volumes.
- Thirdly, we’ve specified the date range from “8-May-2022” to “17-May-2022”.
- Finally, we’ve defined the frequency as “Daily”.
- Thirdly, press ENTER.
Thus, we’ll import Stock Prices into Google Sheets.
Step 2: Publishing the Google Finance Stock Prices Data
In this step, we’ll share the file online using the Share feature.
- Firstly, from File >>> Share >>> select “Publish to web”.
A dialog box will appear.
- Secondly, click on the Publish button.
- Finally, press CTRL + C to copy the link.
Step 3: Importing the Stock Prices into Excel
In this step, we’ll import that dataset into our Excel file.
- Firstly, open an Excel file and from the Data tab >>> select From Web.
A dialog box will appear.
- Secondly, Paste the link address inside the URL box and press OK.
- Thirdly, select Table 0 and press Transform Data.
It will import our Stock Prices into Excel Power Query.
Step 4: Modifying the Stock Prices Inside Power Query
Now, we’ll format the imported dataset inside the Power Query Editor of Excel.
- Firstly, select the first two columns and select Remove Columns.
- Secondly, select “Use First Row as Headers” to get rid of the first row.
Our data of Stock Prices look much cleaner now.
- Finally, we’ll import this to Excel by pressing Close & Load from the Home tab.
This is what the final step should look like. Thus, we’ve successfully imported Stock Prices into Excel from Google Finance.
Step 5: Updating the Stock Prices
Here, we’ll update the values in Excel when we edit our online file. If we make any changes to the Google Sheets file, then our data will change too.
- Firstly, change the formula on cell A1 as follows.
=GOOGLEFINANCE("MSFT","all","5/8/2022","5/20/2022","Daily")
Here, we’ve added 3 new rows to the dataset.
- Secondly, select anywhere in the “Table0”.
- Finally, from the Query tab >>> select Refresh.
This will update our dataset. In conclusion, we’ve updated the dataset as per the original Google Sheets file.
Read More: How Do You Automatically Update Stock Prices in Excel (3 Easy Methods)
Method-2. Use of Copy and Paste Feature to Import Stock Prices into Excel from Google Finance
For this, we’ll copy the data from the original file and Paste it into our Excel file.
Steps:
- Firstly, follow the steps of Method-1 to import Stock Prices from Google Finance to Google Sheets.
- Secondly, select the cell range A1:F10.
- Thirdly, press CTRL + C to copy the dataset.
- Next, Right Click on cell B4 to bring up the Context Menu.
- Then, select “Match Destination Formatting” from Paste Options.
Thus, we’ll import Stock Prices into Excel.
Method-3. Using Download Option to Import Stock Prices from Google Finance
We can download the Google Sheets file as xlsx, and then import it into our Excel file to achieve our goal.
Steps:
- Firstly, follow the steps of Method-1 to import Stock Prices from Google Finance to Google Sheets
- Secondly, from File >>> Download >>> select “Microsoft Excel (.xlsx)”.
Then, we’ll download the file.
- Secondly, Open the file.
- Finally, import the dataset into our Excel file.
In conclusion, we’ve shown steps for importing Stock Prices into Excel.
Read More: How to Get Live Stock Prices in Excel (4 Easy Ways)
Conclusion
We’ve shown you 3 methods of how to import stock prices into Excel from Google Finance. If you have any questions, feel free to comment below. Moreover, you can visit Exceldemy for more Excel-related articles. Thanks for reading, keep excelling!
Related Articles
- How to Get Historical Data of NSE Stocks in Excel (2 Effective Ways)
- Stock return analysis using histograms & 4 skewness of histograms
- How to Get Stock Quotes in Excel (2 Easy Ways)
- How to Add Stock Data Type in Excel (2 Effective Methods)
- Get Stock Quote with Excel Add-in (With Easy Steps)
- How to Download Historical Stock Data into Excel (with Easy Steps)