Problems with Google Finance in Google Sheets Regarding Currency Conversion Rates

Other Questions Google Sheets
1

I’m utilizing the GOOGLEFINANCE() function in Google Sheets to obtain exchange rates for my accounting expenses. However, I occasionally encounter a #N/A error displaying the following message:

While processing GOOGLEFINANCE, the query for the symbol: ‘PENUSD’ provided no results.

It’s puzzling because, after refreshing the page a few minutes later, some cells function correctly while others still indicate an error. I’m unable to determine the underlying issue. Additionally, relying on this method for currency rates appears ineffective since it only retrieves values for previous dates. Is there a way to fetch historical exchange rates as permanent values? I’m considering implementing a script that calculates and records the exchange rate for each new date added in the date column. Is this feasible? Are there better alternatives available? I appreciate your assistance.

2

Hey Claire29, yeah sometimes GOOGLEFINANCE function can be a bit unpredictable! If you’re after historical rates, consider using an API like ‘exchangeratesapi.io’. They have reliable data and it can be integrated into Sheets with some script work. Changed my workflow. give it a shot!