0

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 '19 at 0:21
0

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. – Adolfo Correa Aug 19 '20 at 0:46

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.