How to Import Stock Prices into Excel from Google Finance (3 Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

how to import stock prices into excel from google finance (Copy Paste)


How to Import Stock Prices into Excel from Google Finance: 3 Methods

Method-1. Import Stock Prices from Google Finance on 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”.

Google Sheets: how to import stock prices into excel from google finance

  • 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”.

Publishing: how to import stock prices into excel from google finance

A dialog box will appear.

  • Secondly, click on the Publish button.

  • Finally, press CTRL + C to copy the link.

Link Sharing: how to import stock prices into excel from google finance

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.

Import Data from Web: how to import stock prices into excel from google finance

  • Thirdly, select Table 0 and press Transform Data.

how to import stock prices into excel from google finance

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.

Power Query: how to import stock prices into excel from google finance

  • Secondly, select “Use First Row as Headers” to get rid of the first row.

Our data of Stock Prices look much cleaner now.

how to import stock prices into excel from google finance Power Query

  • 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.

Imported how to import 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.

Data Refreshed how to import stock prices into excel from google finance

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


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.

how to import stock prices into excel from google finance Google Sheets

  • 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.

how to import stock prices into excel from google finance (Copy Paste)


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.

how to import stock prices into excel from google finance (Dowloaded as xlsx)

  • 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


Download Practice Workbook


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


<< Go Back to Stocks In Excel| Excel for Finance | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo