Список проголосовавших за комментарий "Все разобрался. Спасибо за скрипт.<br/> <br/> <pre>function getAA(ticker) { var response2 = UrlFetchApp.fetch("https://iss.moex.com/iss/securities/HYDR.json" ); var tt = JSON.parse(response2.getContentText()); var data2 =tt.boards.data for (var t = 0; t < data2.length; t++) { if (data2[t][0] == "HYDR") { var data2 = data2[t][1] } } var bn = "bonds"; var sr ="shares"; if (data2=="TQOB"){ var pr = bn} else if(data2=="EQOB"){ var pr = bn} else if(data2=="TQOD"){ var pr = bn} else if(data2=="TQCB"){ var pr = bn} else if(data2=="EQQI"){ var pr = bn} else if(data2=="TQIR"){ var pr = bn} else if(data2=="TQTF"){ var pr = sr} else if(data2=="TQBR"){ var pr = sr} else if(data2=="SNDX"){ var pr = sr} else if(data2=="TQIF"){ var pr = sr} else if(data2=="TQTD"){ var pr = sr}; var response = UrlFetchApp.fetch("https://iss.moex.com/iss/engines/stock/markets/"+pr+"/securities/"+ticker+".json" ); var w = JSON.parse(response.getContentText()); data =w.securities.data for (var i = 0; i < data.length; i++) { if (data[i][1] == data2) { return data[i][3] } } return 0 } </pre>"