Spreadsheets have come a great distance and gotten extra highly effective because the days of Lotus 123 (one of many early spreadsheet software program packages launched in 1983).
Right now, we are going to present the right way to import inventory costs into Google Sheets.
Contents
Google Sheets is free to anybody with a Google account.
Anybody who has Gmail has a Google account.
We will likely be operating our instance utilizing a smartphone to reveal that we will.
We enter the next system right into a cell in a brand new Google Sheet:
The system in spreadsheets begins with an equal signal.
We’re utilizing the googlefinance system that’s accessible in Google Sheets.
It won’t work in Excel as a result of Excel was created by Microsoft and isn’t possible to make use of one thing created by Google.
Nonetheless, it’s attainable so that you can additionally pull inventory knowledge into Excel – however with a special perform and technique (which isn’t a part of this tutorial).
In our instance, we handed the ticker image “SPY” into the googlefinance perform.
Be sure that it’s in quotes.
SPY is the S&P 500 exchange-traded fund.
After we enter the system, the quantity 597 magically seems:
That’s the present worth of SPY, probably delayed as much as 20 minutes (because the above disclaimer says).
Since we all know that the knowledge thus supplied is “as-is” for informational functions and never for buying and selling or recommendation, we are going to shut the disclaimer for the rest of the instance.
To verify this quantity, we pulled up tradingview.com and noticed that, certainly, SPY closed precisely at $597 on Friday, June 13, 2025.
Though this instance will not be meant to show you the right way to use a spreadsheet on a cellphone, we will format that quantity in foreign money format with as much as two decimal locations of accuracy in our Google Sheet:
Be part of the 5 Day Choices Buying and selling Bootcamp
Suppose we wish to get the costs for a listing of shares, say the Magnificent Seven shares listed right here in alphabetical order by image:
We begin by getting into the googlefinance perform in cell B1 (simply to the suitable of the AAPL image).
This time, as a substitute of placing the inventory image into the googlefinance perform, we now have it reference the cell to its left (on this case, the A1 cell).
See the above screenshot and word that A1 will not be in quotes after we go the cell reference to the perform.
We see that it retrieved the inventory worth of Apple (AAPL) to be $196.45 on the time.
To get the inventory costs for the remainder of the record, we will copy the cell B1 and paste that system down like so:
If we have a look at the person system, we see that it routinely references the cell to its left.
If we click on on cell B5, for instance, we will see that the system for Microsoft references the image on cell A5.
The googlefinance perform in Google Sheets is a strong instrument that permits customers to retrieve monetary knowledge instantly right into a spreadsheet.
With a easy system, traders, analysts, and on a regular basis customers can entry inventory costs and a few firm fundamentals while not having third-party plugins.
Nothing to obtain and set up.
Every part is within the cloud.
This perform can be utilized for portfolio monitoring, backtesting methods, and monetary evaluation.
That is only a fundamental instance to get you began.
The googleFinance perform has further parameters that may be equipped to question historic closing costs, the beta of a inventory, market cap, P/E ratio, and extra.
The reader is inspired to discover extra on their very own by studying the documentation of the googefinance perform.
We hope you loved this text on the right way to pull inventory costs right into a spreadsheet.
When you have any questions, ship an e-mail or depart a remark under.
Commerce protected!
Disclaimer: The knowledge above is for instructional functions solely and shouldn’t be handled as funding recommendation. The technique introduced wouldn’t be appropriate for traders who are usually not aware of change traded choices. Any readers on this technique ought to do their very own analysis and search recommendation from a licensed monetary adviser.
