Search code examples
web-scrapinggoogle-sheetsgoogle-sheets-formulagoogle-finance

What is the symbol for blockchain eos in googlefinance in EUR and GBP


My google sheet returns Na when I write


=GOOGLEFINANCE("EOSEUR")

# or

=GOOGLEFINANCE("EOSGBP")

However, when I introduce


=GOOGLEFINANCE("BTCEUR")

# or 

=GOOGLEFINANCE("EOS")

I got the right output.

Where can I find a list of symbols for all blockchains


Solution

  • try alternative:

    =INDEX(TO_TEXT(IMPORTXML("https://finance.yahoo.com/quote/EOS-EUR/"; 
     "//div[@data-reactid='32']")); 2; 1)
    

    =INDEX(TO_TEXT(IMPORTXML("https://finance.yahoo.com/quote/EOS-GBP/"; 
     "//div[@data-reactid='32']")); 2; 1)
    

    enter image description here