Packer16 Posted October 27, 2017 Share 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 Link to comment Share on other sites More sharing options...
racemize Posted October 27, 2017 Share 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") Link to comment Share on other sites More sharing options...
Lupo Lupus Posted October 27, 2017 Share 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. Link to comment Share on other sites More sharing options...
racemize Posted October 27, 2017 Share 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 Link to comment Share on other sites More sharing options...
Lupo Lupus Posted October 27, 2017 Share Posted October 27, 2017 Thanks Link to comment Share on other sites More sharing options...
Packer16 Posted October 27, 2017 Author Share Posted October 27, 2017 I am trying to get Googlefinance to return the currency exchange rate value. Packer Link to comment Share on other sites More sharing options...
racemize Posted October 27, 2017 Share 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. Link to comment Share on other sites More sharing options...
Packer16 Posted October 28, 2017 Author Share Posted October 28, 2017 Thanks. However, the following syntax still returns an error: =GoogleFinance("CURRENCY:NOKUSD", "price") Packer Link to comment Share on other sites More sharing options...
frommi Posted October 28, 2017 Share Posted October 28, 2017 Thanks. However, the following syntax still returns an error: =GoogleFinance("CURRENCY:NOKUSD", "price") Packer =GoogleFinance("NOKUSD") works for me. Link to comment Share on other sites More sharing options...
Packer16 Posted October 28, 2017 Author Share Posted October 28, 2017 Thanks that work. Packer Link to comment Share on other sites More sharing options...
SafetyinNumbers Posted October 28, 2017 Share 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). Link to comment Share on other sites More sharing options...
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