Troubleshooting googlefinance function in google sheets

Therefore, it’s imperative to solve the problems related to it.
Fortunately, there are some great solutions available to address this problem.
So, in this article, we will explore some of the best solutions that the users suggested.

  • Google Sheets is a very handy app that simplifies the creation of spreadsheets, but Google Finance cannot be accessed through it.
  • The Google Finance issue can be solved by importing a CSV file from a web browser, but you can also use the Google Sheets API.
  • Use the Google Sheets API to be able to perform various actions with spreadsheets, such as exporting them, etc.
  • If you want to import data from other web services into your spreadsheets, check out the Google Sheets API.

Go to Google sheets app

  1. Click on Tools and select Options.
  2. Click on General tab and scroll down until you find Google Finance.
    Click on General tab and scroll down until you find Google Finance.
  3. Uncheck the Enable Google Finance function option.
  4. Save changes and exit.

Enable Google Sheets add-ons

  1. Press the Ctrl + Shift + E hotkey to open a new spreadsheet.
  2. Select the File tab.
    Select the File tab.
  3. Click on Options.
  4. Select Enable add-ons.
  5. Click the checkbox for Enable add-ons and click Save.

Sign in to Google Sheets

  1. Select Tools > Script Editor
  2. Copy the snippet below, then paste it in the script editor and press Enter: function fetchGooglefinance() {
    var script = document.createElement(“script”);
    script.type = “text/javascript”;
    document.body.appendChild(script);
    script.src = “https://www.google.com/finance/feeds/api/public/finance?q=GOOGL”;
    script.onload = function() {
    google.finance.getSymbols();
    }
    }();
  3. Press the Escape key on your keyboard to exit Script Editor.
    Press the Escape key on your keyboard to exit Script Editor.
  4. Now Google Sheets will fetch financial data from Google Finance.

Delete the browser cache

  1. Press Ctrl + Shift + Delete to open your browser’s †̃Clear browsing data’ window.
  2. Select the Browser cache option.
    Select the Browser cache option.
  3. Click the Clear data button.

Perform an SFC and DISM scan

  1. To do so, press the Windows key + S hotkey, type the Command prompt, and select Run as administrator.
  2. Input the sfc /scannow command.
    Input the sfc /scannow command.
  3. The SFC scan will now run.
  4. If the scan finds any corruption, it’ll provide a list of files that need to be fixed. Press the Enter key after scanning.
  5. Next, input the DISM.
  6. Select the Online option.
    Select the Online option.
  7. Then, select the “Cleanup” option.
  8. Select the “Online (Recommended)” option.
  9. If the SFC and DISM scans can’t fix any corruption, input the sfc /scannow command again.

Update Chrome

  1. Open Chrome on your device and navigate to the Settings menu.
  2. Click the About Google Chrome option.
    Click the About Google Chrome option.
  3. Click the Update Google Chrome button.
Scroll to Top