0

I am using GoogleFinance() function in Google Sheet for some stocks statistics, but I have problem with some tickers like Tesco (London). If I try GoogleFinance("TSCO", something), I get values of Tractor Supply Company (NASDAQ), because both are TSCO. Is there any possibility, to get Tesco (and other stocks with duplicate tickers)?

Thanks

same tickers

player0
  • 124,011
  • 12
  • 67
  • 124
Martin Galda
  • 3
  • 1

1 Answers1

0

try:

=IMPORTXML("https://www.marketwatch.com/investing/stock/tsco?countrycode=uk",
 "//span[@class='value']")

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124