A currency conversation formula for example:


Will display the closing price by default under "price". There is no option for the Average price. Hence going on to https://www1.oanda.com/currency/converter/ will return a different currency conversion than Google Sheets.

Is there a way to get Oanda's average price rather than using the closing price?

1 Answer 1


It depends... If you pay $400+/month you can use their API to get exactly what you need. Otherwise, it's not possible, because as you can see upon disabling JavaScript the required fields are empty. The reason is that Google Sheets can't import stuff that is under JS control. This can be simply checked by disabling JS for a given site like:


Your next best option is to find some other source website.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.