0x Staking Info
Web3 Sheets Demo: 0x Staking Info
Example Explanation
This demonstration features two simple custom functions to pull the total stake delegated per pool using the staking proxy address.
A1
=CALLINT("2",$B$1,$C$1,CONCAT("0x000000000000000000000000000000000000000000000000000000000000000",DEC2HEX(A7)))*10^-18
- to find the delegated stake while converting the pool ID from a decimal to a hex figure that Web3 Sheets API can call.getTotalStakeDelegatedToPool(bytes32)
- is used above in$C$1
in order to call for the total stake delegated to X pool.