Currency Value from Google Sheets

[Packer16]

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]

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]

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]

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

[Lupo Lupus]

Thanks

[Packer16]

I am trying to get Googlefinance to return the currency exchange rate value.

 

Packer

[racemize]

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]

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

 

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

 

Packer

[frommi]

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

 

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

 

Packer

 

=GoogleFinance("NOKUSD")

 

works for me.

[Packer16]

Thanks that work.

 

Packer

[SafetyinNumbers]

Does anyone know how to get the gold price from Google Sheets?

 

I’m asking under this forum because gold is a currency (probably).