New answers tagged


try: =IMPORTXML("";"//span[@data-test='instrument-price-last']")


If you want to import the data from another sheet, the formula that you have given is for importing data from another sheet/URL. If I understand your question you are looking to update the currency automatically, for that you can select the cell where you want to update the currency and then type ==GOOGLEFINANCE("CURRENCY:EXAEXB") into it. You can ...

Top 50 recent answers are included