New answers tagged

0

try: =IMPORTXML("https://tr.investing.com/currencies/gau-try";"//span[@data-test='instrument-price-last']")


-1

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