N
N
n_konovalov2021-03-11 17:52:05
XPath
n_konovalov, 2021-03-11 17:52:05

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"))


Import FXCN
=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 question

Ask a Question

731 491 924 answers to any question