# Проверка баланса кошельков в Google Shits

By [Crypto Lefty](https://paragraph.com/@crypto-lefty) · 2022-12-09

---

Хороший способ для быстрой проверки балансов через таблицу + подсчета суммы. Из явных минусов - у ебучего **google shits** ограничение на ~50 запросов в минуту.

_Файл-Создать копию_. Пользуемся

[Таблица с формулами](https://docs.google.com/spreadsheets/d/1tclcUJTd6qAL_WgIz2kfR3x1-sGdqnx7ldTwLmOz4VE/edit?usp=sharing)

Формулы для проверки

### ARBITRUM

> \=VALUE(REGEXREPLACE(REGEXEXTRACT(IMPORTXML("[https://arbiscan.io/address/"&B2&"";"//](https://arbiscan.io/address/%22&B2&%22%22;%22//)_\[text()='ETH Value:'\]/following-sibling::div/text()");"\\d.?\\d+"); "^(\\d+)(?:.,._)?"; "$1,$2\\0"))

### ETHERIUM

> \=VALUE(REGEXREPLACE(REGEXEXTRACT(IMPORTXML("[https://etherscan.io/address/"&B2&"";"//\*\[text()='Value:'\]/following-sibling::div/text()");"\\d\\.?\\d+](https://etherscan.io/address/%22&B2&%22%22;%22//*%5Btext\(\)='Value:'%5D/following-sibling::div/text\(\)%22\);%22%5Cd%5C.?%5Cd+)"); "^(\\d+)(?:.,.\*)?"; "$1,$2\\0"))

### MATIC

> \=VALUE(REGEXREPLACE(REGEXEXTRACT(IMPORTXML("[https://polygonscan.com/address/"&B2&"";"//](https://polygonscan.com/address/%22&B2&%22%22;%22//)_\[text()='MATIC Value:'\]/following-sibling::div/text()");"\\d.?\\d+"); "^(\\d+)(?:.,._)?"; "$1,$2\\0"))

### OPTIMISM

> \=VALUE(REGEXREPLACE(REGEXEXTRACT(IMPORTXML("[https://optimistic.etherscan.io/address/"&B2&"";"//\*\[text()='Value:'\]/following-sibling::div/text()");"\\d\\.?\\d+](https://optimistic.etherscan.io/address/%22&B2&%22%22;%22//*%5Btext\(\)='Value:'%5D/following-sibling::div/text\(\)%22\);%22%5Cd%5C.?%5Cd+)"); "^(\\d+)(?:.,.\*)?"; "$1,$2\\0"))

### BSC

> \=VALUE(REGEXREPLACE(REGEXEXTRACT(IMPORTXML("[https://bscscan.com/address/"&B2&"";"//](https://bscscan.com/address/%22&B2&%22%22;%22//)_\[text()='BNB Value:'\]/following-sibling::div/text()");"\\d.?\\d+"); "^(\\d+)(?:.,._)?"; "$1,$2\\0"))

### AVAX

> \=VALUE(REGEXREPLACE(REGEXEXTRACT(IMPORTXML("[https://snowtrace.io/address/"&B2&"";"//](https://snowtrace.io/address/%22&B2&%22%22;%22//)_\[text()='AVAX Value:'\]/following-sibling::div/text()");"\\d.?\\d+"); "^(\\d+)(?:.,._)?"; "$1,$2\\0"))

Украдено у Thomasi

---

*Originally published on [Crypto Lefty](https://paragraph.com/@crypto-lefty/google-shits)*