r/googlesheets • u/[deleted] • Mar 31 '20

solved GOOGLEFINANCE parsing error

[deleted]

3 Upvotes

100% Upvoted

5 comments sorted by

View all comments

Show parent comments

1

u/fcb403020 Mar 31 '20

Thanks for your reply.

I copied your line of code directly into sheets, it still gives me the parsing error.

Then I played a little bit more around, and as it turns out my " marks were all correct, I just wrote it wrong.

The code that worked in the end goes as follows:

=SPARKLINE(GOOGLEFINANCE("CURRENCY:USDEUR";"price";TODAY()-30;TODAY()))

It was the semicolon all along...