Packer16 Posted October 27, 2017 Posted October 27, 2017 Has anyone pulled in currency values from Google Sheets? I have used the following syntax & got an error: =GoogleFinance("CURRENCY:NOK", "price") TIA. Packer
racemize Posted October 27, 2017 Posted October 27, 2017 Has anyone pulled in currency values from Google Sheets? I have used the following syntax & got an error: =GoogleFinance("CURRENCY:NOK", "price") TIA. Packer I'm not too sure what you are trying to do? Are you trying to convert between two currencies? Here's what I use for getting the CAD to USD currency exchange for FFH price conversions: =GoogleFinance("CURRENCY:CADUSD")
Lupo Lupus Posted October 27, 2017 Posted October 27, 2017 Can google sheets also do currency conversion at historical rates? I have now (bought) an excel add on for this, but would be happy to see a free possibility.
racemize Posted October 27, 2017 Posted October 27, 2017 Can google sheets also do currency conversion at historical rates? I have now (bought) an excel add on for this, but would be happy to see a free possibility. Yes: =index(GoogleFinance(J3,"price",K3,K3+1), 2, 2) Where J3 is currency conversion (e.g., HKDUSD) and K3 is a date value
Packer16 Posted October 27, 2017 Author Posted October 27, 2017 I am trying to get Googlefinance to return the currency exchange rate value. Packer
racemize Posted October 27, 2017 Posted October 27, 2017 I am trying to get Googlefinance to return the currency exchange rate value. Packer It needs both currencies to convert. so NOKUSD is probably what you want.
Packer16 Posted October 28, 2017 Author Posted October 28, 2017 Thanks. However, the following syntax still returns an error: =GoogleFinance("CURRENCY:NOKUSD", "price") Packer
frommi Posted October 28, 2017 Posted October 28, 2017 Thanks. However, the following syntax still returns an error: =GoogleFinance("CURRENCY:NOKUSD", "price") Packer =GoogleFinance("NOKUSD") works for me.
SafetyinNumbers Posted October 28, 2017 Posted October 28, 2017 Does anyone know how to get the gold price from Google Sheets? I’m asking under this forum because gold is a currency (probably).
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now