🍬 🤛🏼 🤦🏽 Google Finance has stopped broadcasting data on Russian stocks

Since June 5, 2021, the Google website, and most importantly, the Google tables, have stopped sending data from the Moscow Exchange.

When trying to get quotes with the MCX prefix, for example, for Sberbank, the formula from Google tables =GOOGLEFINANCE("MCX:SBER")

now always returns the result #N/A

.

And when searching for any Russian paper on the Google website, all markets are found , except for the Moscow Exchange:

An attempt to search for a Sberbank of Russia quote on the site https://www.google.com/finance/quote/MCX:SBER — Sberbank of Russia https://www.google.com/finance/quote/MCX:SBER

API .

-

, .

- , .

My table with an example of receiving data from the Moscow Exchange

, , !

Google .
.
" ".
.

, . .

Google table with examples of automatic name retrieval for different asset classes

. :

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

Google table with examples of automatic retrieval of stock and bond prices

. :

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

Google table with examples of automatic receipt of dates and values of dividends for shares

, . . :

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

Google table with examples of automatic receipt of coupon dates and values for bonds

, . . :

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

Google table with examples of automatic receipt of offer dates for bonds

, . . :

=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 .

Google Finance has stopped broadcasting data on Russian stocks - what to do?

-

More articles: