Jump to content

Recommended Posts

Posted

Has anyone pulled in currency values from Google Sheets?  I have used the following syntax & got an error:

 

=GoogleFinance("CURRENCY:NOK", "price")

 

TIA.

 

Packer

Posted

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")

Posted

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

Posted

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.

Posted

Thanks.  However, the following syntax still returns an error:

 

=GoogleFinance("CURRENCY:NOKUSD", "price")

 

Packer

 

=GoogleFinance("NOKUSD")

 

works for me.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...