2

I have shares in different currencies that I want to track in only a single currency. I currently have a cell that returns the currency and one that returns the price, I then multiply them. However, I'm trying to make the sheet fully automated so I was wondering if it is possible to have something like

=googlefinance("RIO","price","CAD")?
1
  • can you share a copy of your sheet?
    – user0
    Mar 20, 2019 at 0:21

1 Answer 1

2

Welcome, Eric! Google Finance tracks exchange rates. The syntax is:
=GOOGLEFINANCE("CURRENCY:BRLCAD")
where BRLCAD is the two currencies, in this case Brazilian Real to Canadian Dollar, in ISO 4217 format.

Use that as your multiplier to convert from source shares to their value in the new currency. For example, if your price is in A2,
= A2 * GOOGLEFINANCE("CURRENCY:BRLCAD")

1
  • Additionally you can use =googlefinance("RIO", "currency") to know on what currency is traded the share of your interess. Aug 19, 2020 at 0:46

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.