GOOGLEFINANCE won't work for 2 stocks (2024)

FAQs

How do I add multiple stocks to Google Finance? ›

Make sure you are using the FULL ticker code gained from the Google Finance website, and NOT from some other website or your own imagination. Check to make sure your formula is using the correct syntax as provided in the GOOGLEFINANCE function documentation.

Karolina (Google Finance team)

We do adjust prices for splits but not for dividends.

You can hold as many stocks and shares ISAs as you like across different providers.

To ensure that the founders can retain control of the company, Google divided its publicly traded stocks into two classes: Class A shares (GOOGL) and Class C shares (GOOG). The strategy behind this move is quite simple: owners of GOOGL shares have one vote per share, while owners of GOOG have no voting rights.

Stock Compare involves comparing key indicators such as market capitalization, price-to-earnings (P/E) ratio, price-to-book (P/B) ratio, dividend yield, return on equity (ROE), and more. This analysis enables investors to gauge the relative value and potential of various stocks within a given market or industry.

Investors commonly express a price multiple ratio in the following format: Price multiple = share price / per-share metric. The numerator in the ratio is the share price, which is the price a single share of a company's stock sells for at a specific time.

Google still offers financial data for use Google Sheets spreadsheets through the use of the GOOGLEFINANCE formula, but the API is no longer available to users. If you are interested in using Google's financial data, learning about the GOOGLEFINANCE formula is the best way to access this data.

What's better than GOOGLEFINANCE? ›

Some of the reasons why Excel formulas may not work are: Cells Formatted as Text. Accidentally Typed the keys CTRL + ` Values are Different & Result is Different.

Go to google.com/finance. Search for a security, like “Dow Jones Industrial Average.” Tap a security. Under the chart, select one of the recommended securities. To search for another security, select Compare.

Note: Widgets powered by spreadsheets using the GoogleFinance function refresh approx. every 15 minutes.

Google makes it easy to import data about stocks, mutual funds, and currencies with the versatile GOOGLEFINANCE formula. You can make custom tables, dashboards, and charts to follow your portfolio however you wish.

Investing in mutual funds is popular in part because they're a relatively hands-off way to invest in many different assets at once — within a single mutual fund, you could gain exposure to hundreds of stocks, bonds or other investments.