Using Tickerdata Outside the US

The one thing to know

Spreadsheets in much of the world separate formula arguments with semicolons instead of commas. If your spreadsheet expects semicolons and a formula uses commas, the cell shows #ERROR! with the message Formula parse error. So =ROUND(A1, 2) in one sheet is =ROUND(A1; 2) in another.

The quick test: how does your spreadsheet write one and a half?

Your sheet writes	Separate arguments with	Common in
`1.5`	commas `,`	US, UK, Canada, Australia, India, Mexico
`1,5`	semicolons `;`	Most of Europe, Brazil, Argentina, Turkey

Tickerdata works the same either way. Only the punctuation changes:

=TICKERDATA("AAPL", "Revenue", 2025, "Q2")

=TICKERDATA("AAPL"; "Revenue"; 2025; "Q2")

=TICKERDATA.DATA("AAPL", "Revenue", 2025, "Q2")

=TICKERDATA.DATA("AAPL"; "Revenue"; 2025; "Q2")

Every formula on this site can match your sheet

Use the , ; switch at the top of any docs page and every formula in the docs is shown in your format, ready to copy. We pick a starting point from your browser's language and remember your choice.

Convert any formula

Paste a formula from a template, a forum post, or an older sheet, and get it back in the other format. Decimal numbers are converted too.

Paste any formula

With semicolons (;)

=TICKERDATA("AAPL"; "Revenue"; 2025)

Check your spreadsheet’s format

Google Sheets sets the format per spreadsheet, through its locale. New spreadsheets usually start with the locale for where you live, which is why a brand new sheet can behave differently from one of our templates.

Open the spreadsheet settings

In your spreadsheet, go to File > Settings.

Look at the Locale

On the General tab, Locale shows your sheet’s region. If it is a region from the semicolon list above, write formulas with semicolons.

Pick what suits you

You have two good options:

Keep your locale and use semicolons. Your dates, number formats and currency symbols stay the way you are used to. This is what we recommend.
Change the locale to United States and use commas. Formulas then match the US examples you find online, but dates and numbers switch to the US style too.

Why the templates work but a new sheet doesn't

The Tickerdata premium templates are set to the United States locale, so their formulas use commas and work out of the box. A new spreadsheet you create yourself uses your own locale, so type formulas there with semicolons, or change its locale to match the templates.

Excel takes its formula format from your region settings rather than from each workbook, so it applies to every workbook at once. If your region writes 1,5, write Tickerdata formulas with semicolons. That is usually easier than changing your region, which also changes how dates and numbers look everywhere else.

Decimal numbers inside formulas

When a formula includes a decimal number, write it with your decimal mark. In a semicolon sheet, 1.1 becomes 1,1:

=TICKERDATALIVE("SAP.DE", "Price") * 1.1

=TICKERDATALIVE("SAP.DE"; "Price") * 1,1

=TICKERDATA.LIVE("SAP.DE", "Price") * 1.1

=TICKERDATA.LIVE("SAP.DE"; "Price") * 1,1

The switch at the top of the page and the converter above both handle this for you.

International tickers

Stocks outside the US need their exchange suffix:

=TICKERDATALIVE("MC.PA", "Price")

=TICKERDATALIVE("MC.PA"; "Price")

=TICKERDATA.LIVE("MC.PA", "Price")

=TICKERDATA.LIVE("MC.PA"; "Price")

Exchange	Suffix	Example
London	.L	HSBA.L
Germany (XETRA)	.DE	SAP.DE
Euronext Paris	.PA	MC.PA
Euronext Amsterdam	.AS	ASML.AS
Madrid	.MC
Milan	.MI
Stockholm	.ST
Swiss Exchange	.SW	NESN.SW
Toronto	.TO	SHOP.TO
Tokyo	.T	7203.T

See Ticker Symbols for how tickers work and Supported Exchanges for all 70+ exchanges.

Currencies

Figures come back in the currency the stock trades in. To check which one, ask for its Currency:

=TICKERDATALIVE("MC.PA", "Currency")

=TICKERDATALIVE("MC.PA"; "Currency")

=TICKERDATA.LIVE("MC.PA", "Currency")

=TICKERDATA.LIVE("MC.PA"; "Currency")

Still seeing an error?

#ERROR! with Formula parse error is almost always the separator. Switch the format at the top of the page and copy the formula again, or run it through the converter above.
Any other error, see Common Errors.
Still stuck? Email help@tickerdata.com with a screenshot of the cell and your sheet’s locale, and we’ll sort it out.