I'm developing a personal finance template in Numbers, and I need the current exchange rate to update automatically in a specific cell. My goal is for the user to enter an amount in one currency (e.g., COP) and have the template automatically calculate the converted value in another currency (e.g., USD). Is there a built-in formula to pull live exchange rates into my spreadsheet? Thanks for your help!
MacBook Air 13″, macOS 26.3
You could use the CURRENCY or CURRENCYCONVERT functions. They both use exchange rate data from the previous market day’s close, retrieved remotely via the internet.
You could use the CURRENCY or CURRENCYCONVERT functions. They both use exchange rate data from the previous market day’s close, retrieved remotely via the internet.
There is no live lookup option. The best Numbers can do is work off the previous day's close rate. That may or may not be enough for you, but it won't reflect the current exchange rate on a minute-by-minute (or hour-by-hour) basis.
Automatically update live exchange rates in Numbers
