Using their trading system, Zack's experts give you their prediction for COST in free RPT. Should you pass or buy Costco? Zacks experts tell all in a a new free Special Report.
- Top EV Stocks to Buy Now
5 EV Picks Better than Tesla
5 Stocks with Big Profit Potential
- 2024's Gold Rush is Here
Gold Prices Could Reach New Highs
See This Year's Top Gold Plays Free
- 3 Hottest Software Stocks
Top plays from a surging industry.
Free report names must-buy stocks.
- Top Clean Energy Stocks
How to profit from surging demand.
Free report reveals 5 hot stocks.
- The Top IPO Stock Plays
Could IPOs be the Key to Success?
Investing in IPOs is on the Rise
- Free: Invest Like Buffett
5 "Buffett stocks" to buy right now
New report names 5 wealth-builders
- Top EV Stocks to Buy Now
Search results
Google Finance provides real-time market quotes, international exchanges, up-to-date financial news, and analytics to help you make more informed trading and investment decisions.
- Stock Portfolio & Watchlist
Track your portfolio and watchlist with real-time market...
- Portfolio Tracker
Keep track of all your investments, get real time pricing...
- TSLA
Get the latest Tesla Inc (TSLA) real-time quote, historical...
- Sign in
Google Finance provides real-time market quotes,...
- Stock Portfolio & Watchlist
Keep track of all your investments, get real time pricing updates, and see your overall portfolio’s worth. Track your portfolio and watchlist with real-time market quotes, up-to-date financial...
Apr 25, 2024 · Google makes it easy to track stocks with Google Finance, a free set of tools to keep up with your portfolio. Although you might use the Google Finance dashboard to follow your...
- What Is Google Finance?
- The Google Finance Function
- Stock Tracking in Action
- Maximizing Google Sheets
- Converting Currency with Sheets
- The Best Tech Newsletter Around
Finance is Google's real-time tool that displays current market information and aggregates business news. It's currently integrated with Google Search, so if you look up the ticker symbol of a specific corporation on Google such as WMT for Walmart or AAPL for Apple, you will immediately see the current stock quote and historical data for that security. You can click one of these stocks to go to a company's Google Finance page, which shows the company's financials, related news, and allows you to compare it with other commodities.
While there are other, more robust tools you can use to track securities, Google Finance is the only one that can effectively integrate with Google Sheets. Whether you're a novice to stocks or an experienced trader, this integration is the easiest way to import and monitor stock data in a spreadsheet.
The function that pulls stock data is called "GOOGLEFINANCE." The syntax of the function is quite simple and uses five arguments, four of which are optional.
The first argument is the ticker symbol. These are codes that companies have when they're listed on the stock market, such as GOOG for Google or BAC for Bank of America. You can also specify the stock exchange that your chosen stock is listed in to avoid discrepancies. Since Bank of America is listed on the New York Stock Exchange, you'd type "NYSE:BAC."
To get the ticker codes and exchanges of your desired stocks, you'll have to do some research. You can look for them on Google Finance or your chosen portfolio management tool.
The second argument is the attribute you'd like to display. By default, it's set to "price" if you leave it blank. Here are a few of the attributes you can pull out using the function:
•price: The price of the specific stock in real-time.
•volume: The current trading volume.
For this example, let's say you want to look up the current price of a stock of Facebook. Facebook is listed on NASDAQ with the ticker code FB. In this case, you'll type down the first argument as "NASDAQ:FB" along with "price" as the attribute. So the formula for this would be.
If you want to view the daily closing prices for a particular week, such as the week of October 15, 2018, you will specify that date range in the third and fourth arguments. The code for that becomes. Take note that viewing historical data expands the generated information into array data, which takes up nearby cells.
You can also use the function to generate data for a list of stocks automatically. Just type out the tickers in a column, then use the cells in your first argument. Since our ticker code is in cell C4, you'd type out. Below is a list of stocks with their corresponding current prices.
If you want to track a list of attributes, you can type them out in separate cells like in the above image. Then, you can link the second argument to the cell with the attribute's name. For the price cell for NYSE:IBM in the example below, the formula would be.
The best part of having your stocks on Google Sheets is that you can use various data manipulation tools on them.
For example, let's say you want to use Google Sheets to keep track of the value of all of your financial assets, such as your stocks, savings accounts, time deposits, and more. Using Finance, the price of your stocks will update in real-time, so you get a full picture of your position at any given time.
Another great function of Google Sheets is that it can convert currencies in real-time. You can do this by typing the stock ticker "CURRENCY:" followed by the codes of the two currencies you want to convert, such as "USDGBP" or "EURJPY." You can also display historical currency data by specifying a date.
For example, if you're living in Europe and you want to convert some USD into the Euro, you'd typeand multiply that number with the amount of USD you're converting.
By subscribing, you agree to our Privacy Policy and may receive occasional deal communications; you can unsubscribe anytime.
Share Share Share Share Share
Copy
Email
Share
Share Share Share Share Share
Aug 22, 2023 · Google Sheets makes tracking stocks easy using a built-in function called GOOGLEFINANCE. The formula lets you track various metrics, including stock holding, cost of buying, current price, and profit or loss.
Track and understand the performance of your investments with Portfolios in Google Finance. See your overall investment’s value, compare your performance to other stocks and indexes, and see...
Sep 10, 2023 · Among its noteworthy features, the GOOGLEFINANCE function is worth checking out to track your preferred stock prices in real time. Instead of adding stock prices from the web, run the Google...
