1

The googlefinance integration, documented here, in google spreadsheets does not seem to work for me:

Example:

GOOGLEFINANCE("GOOG","price",TODAY()-30,TODAY())

Google spreadsheets gives the cell a red corner and prints the following message: Fel i formeltolkning. which in english means something along the lines of Error in formatting.

The following does however work: =GOOGLEFINANCE("GOOG").

Also I can open other spreadsheets from links where the exakt same syntax seem to work. What can cause this?

David Karlsson
  • 9,396
  • 9
  • 58
  • 103

1 Answers1

2

Change comma to a semicolon.

GOOGLEFINANCE("GOOG";"price";TODAY()-30;TODAY())

Some regions (Norway!) use a comma for decimals. The other option is to change settings:

File > Spreadsheet Settings > Locale...

Max Makhrov
  • 17,309
  • 5
  • 55
  • 81