Spreadsheets have come a good distance and gotten extra highly effective for the reason that days of Lotus 123 (one of many early spreadsheet software program applications launched in 1983).
At this time, we’ll present methods 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 show that we are able to.
We enter the next formulation right into a cell in a brand new Google Sheet:
The formulation in spreadsheets begins with an equal signal.
We’re utilizing the googlefinance formulation that’s obtainable in Google Sheets.
It won’t work in Excel as a result of Excel was created by Microsoft and isn’t probably to make use of one thing created by Google.
Nonetheless, it’s attainable so that you can additionally pull inventory information into Excel – however with a distinct perform and methodology (which isn’t a part of this tutorial).
In our instance, we handed the ticker image “SPY” into the googlefinance perform.
Make sure that it’s in quotes.
SPY is the S&P 500 exchange-traded fund.
After we enter the formulation, 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 data thus supplied is “as-is” for informational functions and never for buying and selling or recommendation, we’ll shut the disclaimer for the rest of the instance.
To substantiate this quantity, we pulled up tradingview.com and noticed that, certainly, SPY closed precisely at $597 on Friday, June 13, 2025.
Though this instance isn’t meant to show you methods to use a spreadsheet on a cellphone, we are able to format that quantity in forex 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 need to get the costs for an inventory 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 proper 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 be aware that A1 isn’t in quotes once we cross 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 listing, we are able to copy the cell B1 and paste that formulation down like so:
If we have a look at the person formulation, we see that it mechanically references the cell to its left.
If we click on on cell B5, for instance, we are able to see that the formulation for Microsoft references the image on cell A5.
The googlefinance perform in Google Sheets is a strong device that permits customers to retrieve monetary information immediately right into a spreadsheet.
With a easy formulation, 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 thing is within the cloud.
This perform can be utilized for portfolio monitoring, backtesting methods, and monetary evaluation.
That is only a primary instance to get you began.
The googleFinance perform has further parameters that may be provided 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 methods to pull inventory costs right into a spreadsheet.
You probably have any questions, ship an electronic mail or go away a remark under.
Commerce protected!
Disclaimer: The knowledge above is for instructional functions solely and shouldn’t be handled as funding recommendation. The technique offered wouldn’t be appropriate for traders who should not accustomed to trade traded choices. Any readers on this technique ought to do their very own analysis and search recommendation from a licensed monetary adviser.
