All geek questions in one place

Issue with Google Finance in Google Sheets for exchange rates

I use the function GOOGLEFINANCE()in google sheets to get the exchange rate for the expenses that I enter for accounting.

The problem is that sometimes I get an error message #N/Awith a message

When evaluating GOOGLEFINANCE, the query for the character: "PENUSD" does not return data.

The confusing part is that sometimes, perhaps with a page refresh after 5 minutes, some cells actually start working, while others get an error. I can not solve the problem.

On the other hand, it is obvious that this is a bad way to make a currency exchange, because it constantly calculates the rate for the last day. Is there a way to get historical exchange rates as a value, once? I think the script is that for each new "date" entered in the date column, the exchange rate for that day is calculated and a number is entered in the cell next to it.

Is it possible? Are there any better solutions? thanks for the help

+4
source share
2 answers

Yes, really very shaky. Formulas sometimes stop working when I switch to another tab and then return. What helps me:

  • Close the tab and reopen (Ctrl-Shift-T). This usually makes the formulas work again for some time.
  • , " ". , , .
+2

, CURRENCY:. CURRENCY:PENUSD.

0

Source: https://habr.com/ru/post/1589263/

More articles:


All Articles