Historical Currency In Numbers Not Working Correctly For Some Currencies

I am using a very simple formula which returns historical data on the exchange rate between two currencies for a given date: CURRENCYH("EUR","USD",0,"12/31/2024"). Nothing out of the ordinary. It's been working great for years and it has recently given me errors for 2 currencies: Costa Rican Colón and Mexican Dollar. It works just fine with Euros. Total head scratcher. Hope someone can shine a light on this issue.