=CURRENCYCONVERT(STOCK(“AAPL”)) If converting to another currency, just add a second argument, which is the standard ISO 4217 currency code. If I want Apple stock in Canadian dollars, I would use: =CURRENCYCONVERT(STOCK(“AAPL”),”CAD”) Note that both the stock price and the currency exchange rate will be based on the previous day’s …
