How can I create a cell in Google Spreadsheet that automatically updates its value when its respective value in the web (i.e. exchange rates) changes?

Is there any function that allows to retrieve the value for exchange rates from the web, so that I don't have to change that each day manually?


To update currency conversion rates on a daily basis, for the Euro to $US for example, do this:


That formula goes in the cell where you want the quote to appear. Instead of "price", you could use "close", if that's what you want for the day prior.

| improve this answer | |

You can use:

=GoogleFinance("ticker symbol","price")

It will pull USD, GBP, CAD, updating the daily quote.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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