Answer the question
In order to leave comments, you need to log in
How to fix import to Google Spreadsheets from the Moscow Exchange?
I am importing the cost data of two ETFs - FXIT and FXCN.
The FXIT cost is imported correctly, and instead of the FXCN cost, it gives out some figure from the ceiling.
What am I doing wrong?
The following formulas are substituted into a Google spreadsheet cell ↓
Import FXIT
=IMPORTXML("https://iss.moex.com/iss/engines/stock/markets/shares/boards/TQTF/securities.xml?iss.meta=off&iss.only=securities&securities.columns=SECID,PREVADMITTEDQUOTE"; СЦЕПИТЬ("//row[@SECID='";"FXIT";"']/@PREVADMITTEDQUOTE"))
=IMPORTXML("https://iss.moex.com/iss/engines/stock/markets/shares/boards/TQTF/securities.xml?iss.meta=off&iss.only=securities&securities.columns=SECID,PREVADMITTEDQUOTE"; СЦЕПИТЬ("//row[@SECID='";"FXCN";"']/@PREVADMITTEDQUOTE"))
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question