Sparkline in Google Sheets shows errors with options

Question

I am trying to get some graphs via googlefinance in my sheets.

=SPARKLINE(GoogleFinance(A4; "price"; TODAY()-180; TODAY()))

works totally fine but

=SPARKLINE(GOOGLEFINANCE(A4,"price", TODAY()-30,TODAY()),{"charttype","line";"color","green"})

gives me parsing errors. If I try it in another sheet, it works.

Answer 1

your sheet is german so you need to use:

; insted of , in formulas

\ instead of , in arrays {}

so formula will be:

=SPARKLINE(GOOGLEFINANCE(A4; "price"; TODAY()-30; TODAY());
 {"charttype"\"line";"color"\"green"})