Desde el 5 de junio de 2021, el sitio web de Google y, lo que es más importante, las tablas de Google, dejaron de enviar datos desde la Bolsa de Moscú.
Al intentar obtener cotizaciones con el prefijo MCX, por ejemplo, para Sberbank, la fórmula de las tablas de Google =GOOGLEFINANCE("MCX:SBER")
ahora siempre devuelve el resultado #N/A
.
Y al buscar cualquier periódico ruso en el sitio web de Google, se encuentran todos los mercados , excepto el Exchange de Moscú:
API .
-
, , !
:
Google .
.
" ".
.
, . .
=IMPORTxml(
"https://iss.moex.com/iss/engines/stock/markets/" & IFS(
or(
B3 = "TQOB",
B3 = "EQOB",
B3 = "TQOD",
B3 = "TQCB",
B3 = "EQQI",
B3 = "TQIR"
),
"bonds",
or(
B3 = "TQTF",
B3 = "TQBR",
B3 = "SNDX",
B3 = "TQIF"
),
"shares"
) & "/boards/" & B3 & "/securities.xml?iss.meta=off&iss.only=securities&securities.columns=SECID,SECNAME",
"//row[@SECID='" & A3 & "']/@SECNAME"
)
=IMPORTxml(
"https://iss.moex.com/iss/engines/stock/markets/" & IFS(
or(
B10 = "TQOB",
B10 = "EQOB",
B10 = "TQOD",
B10 = "TQCB",
B10 = "EQQI",
B10 = "TQIR"
),
"bonds",
or(
B10 = "TQTF",
B10 = "TQBR",
B10 = "SNDX",
B10 = "TQIF"
),
"shares"
) & "/boards/" & B10 & "/securities.xml?iss.meta=off&iss.only=securities&securities.columns=SECID,PREVADMITTEDQUOTE",
"//row[@SECID='" & A10 & "']/@PREVADMITTEDQUOTE"
)
, . . :
=iferror(
INDEX(
IMPORTxml(
"http://iss.moex.com/iss/securities/" & A22 & "/dividends.xml?iss.meta=off",
"//row[@secid='" & A22 & "']/@value"
) ,
ROWS(
IMPORTxml(
"http://iss.moex.com/iss/securities/" & A22 & "/dividends.xml?iss.meta=off",
"//row[@secid='" & A22 & "']/@value"
)
) ,
1
) ,
""
)
, . . :
=IMPORTxml(
"https://iss.moex.com/iss/engines/stock/markets/" & IFS(
or(
B12 = "TQOB",
B12 = "EQOB",
B12 = "TQOD",
B12 = "TQCB",
B12 = "EQQI",
B12 = "TQIR"
),
"bonds",
or(
B12 = "TQTF",
B12 = "TQBR",
B12 = "SNDX",
B12 = "TQIF"
),
"shares"
) & "/boards/" & B12 & "/securities.xml?iss.meta=off&iss.only=securities&securities.columns=SECID,NEXTCOUPON,COUPONVALUE",
"//row[@SECID='" & A17 & "']/@COUPONVALUE"
)
, . . :
=IFNA(
IMPORTxml(
"https://iss.moex.com/iss/engines/stock/markets/" & IFS(
or(
B27 = "TQOB",
B27 = "EQOB",
B27 = "TQOD",
B27 = "TQCB",
B27 = "EQQI",
B27 = "TQIR"
),
"bonds",
or(
B27 = "TQTF",
B27 = "TQBR",
B27 = "SNDX",
B27 = "TQIF"
),
"shares"
) & "/boards/" & B27 & "/securities.xml?iss.meta=off&iss.only=securities&securities.columns=SECID,OFFERDATE",
"//row[@SECID='" & A27 & "']/@OFFERDATE"
) ,
""
)
- , , - ( / ISS). , , , , .
, ! , , .
c «Google », API , .
API , . .
15 2021 .