ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBH
1
https://medium.com/coinmonks/how-to-value-balancer-v2-matic-smart-chain-wallet-in-google-sheets-fb2934f231c
2
Press this link to Copy this sheet to your personal Google Drive
3
Balancer V2 Wallet - >
0xBA12222222228d8Ba445958a75a0704d566BF2C8
4
5
Global Portfolio Valuation
Global Portfolio Valuation All Chains
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
CoinTickerContract AddressWallet AddressQuantityClose Price (€)Total ($)
23
MATICMATIC
0xBA12222222228d8Ba445958a75a0704d566BF2C8
#ERROR!
24
BALANCERBAL
0x9a71012b13ca4d3d0cdc72a177df3ef03b0e76a3
0xBA12222222228d8Ba445958a75a0704d566BF2C8
$0.00
25
WRAPPED ETHERWETH
0x7ceb23fd6bc0add59e62ac25578270cff1b9f619
0xBA12222222228d8Ba445958a75a0704d566BF2C8
$0.00
26
USD COINUSDC
0x2791bca1f2de4661ed88a30c99a7a9449aa84174
0xBA12222222228d8Ba445958a75a0704d566BF2C8
$0.00
27
WRAPPED BTCWBTC
0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6
0xBA12222222228d8Ba445958a75a0704d566BF2C8
$0.00
28
WRAPPED MATICWMATIC
0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270
0xBA12222222228d8Ba445958a75a0704d566BF2C8
$0.00
29
AAVEAAVE
0xd6df932a45c0f255f85145f286ea0b292b21c90b
0xBA12222222228d8Ba445958a75a0704d566BF2C8
$0.00
30
CHAINLINKLINK
0x53e0bca35ec356bd5dddfebbd1fc0fd03fabad39
0xBA12222222228d8Ba445958a75a0704d566BF2C8
$0.00
31
....$0.00
32
....$0.00
Get your wallet Balances
Returns cryptocurrencies balances for over 400+ cryptocurrencies.

@param {"CURRENCY TICKER"} The cryptocurrency TICKER/SYMBOL data to fetch, for example the symbol of Bitcoin is BTC.
@param {"PUBLIC WALLET ADDRESS"} associated to the cryptocurrency you want the balance from. Please pay attention, DO NOT TO ENTER your private wallet address.
@param {"EMPTY CELL REFERENCE"} refresh_cell ONLY on 3rd argument. Reference an empty cell and change its content to force refresh the balances.
@return The current amount of cryptocurrency on the searched public address.

In your CRYPTOBALANCE function, add a 3rd argument to a locked reference cell, like A1.
From now on every time you change the content of the cell A1, your data will be updated.

Get the amount of BTC on the following wallet:
Example:
=CRYPTOBALANCE("BTC","35hK24tcLEWcgNA4JxpvbkNkoAcDGqQPsP",$A$1)
33
....$0.00
34
....
35
....
36
....
37
38
https://t.me/TheCryptoCurious
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100