Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
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")?
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")
=googlefinance("RIO", "currency") to know on what currency is traded the share of your interess.
Aug 19, 2020 at 0:46