Список проголосовавших за комментарий "Гугл таблица может вот так брать название акции, для примера Газпром:<br/> <br/> = IMPORTxml ( «<a href="/r.php?u=https%3A%2F%2Fiss.moex.com%2Fiss%2Fengines%2Fstock%2Fmarkets%2Fshares%2Fboards%2FTQBR%2Fsecurities.xml%3Fiss.meta%3Doff%26iss.only%3Dsecurities%26securities.columns%3DSECID%2CSECNAME&s=3127503595">iss.moex.com/iss/engines/stock/markets/shares/boards/TQBR/securities.xml?iss.meta=off&iss.only=securities&securities.columns=SECID,SECNAME</a>», СЦЕПИТЬ ( "//row[@SECID='", GAZP, "']/@SECNAME" ) )<br/> <br/> А так котировку:<br/> =IMPORTXML(СЦЕПИТЬ(«<a href="/r.php?u=http%3A%2F%2Fiss.moex.com%2Fiss%2Fengines%2Fstock%2Fmarkets%2Fshares%2Fsecurities%2F&s=1431619404">iss.moex.com/iss/engines/stock/markets/shares/securities/</a>», GAZP, ".xml"), "/document/data[@id="«marketdata»"]/rows/row[@BOARDID="«TQBR»"]/@MARKETPRICE")"