Here are a few of the attributes you can pull out using the function: By default, it’s set to “price” if you leave it blank. The second argument is the attribute you’d like to display. You can look for them on Google Finance or your chosen portfolio management tool. To get the ticker codes and exchanges of your desired stocks, you’ll have to do some research.

Since Bank of America is listed on the New York Stock Exchange, you’d type “NYSE:BAC.” You can also specify the stock exchange that your chosen stock is listed in to avoid discrepancies. 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. 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. So if you want to transact on Asian or European exchanges, this may not be the best option for you. 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.īy the way, Google Finance’s sheets integration is only available in English and doesn’t include most international exchanges yet. 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. 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. 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.

Finance is Google’s real-time tool that displays current market information and aggregates business news.

Linkedin stock price history