Manage Your Cosmos Wallet for Excel

It has been nearly three months since the last time I copied the test (plagiarism + reference) Makzan made the "artifact of pretending to be a worker". This time, let me use the spirit of copying and try to reduce the balance of Uncle Xin's cryptocurrency wallet on Google Sheets. Program , turned into Excel Macros/Custom formula, I hope Uncle Xin doesn't mind if I copy too much.

I also warn everyone that it is risky to use Excel Macros from strangers. If you decide to use it, it is best to check the unencrypted program code in Excel first, or trust me as a Hong Kong uncle.

Cosmos Gadget https://arweave.net/175IU1biSK-YOEO7216e7H5TMmEtlxYv-cOxghde3iw

iscn://likecoin-chain/fZBI9Ypu2NFmYN9hKPXp0aefMvUWsJ0XClIceZTsBuw/1

Introduction of works

Friends who have read Uncle Xin's original text may have found that I almost copied it after seeing the screenshots below.

Let's talk about the last three columns JKL on the right, they are "Balance API", "Reward API" and "Delegation API". These three sets of APIs are actually the core parts, which are used to read the data in the wallet from the chain and display the results in JSON format. Uncle Xin was originally made with wallet address plus formula, I made it with Excel custom formula…

"Balance API" =CosmosAvailableAPI(wallet address, API entry URL)

"Reward API" =CosmosRewardAPI(wallet address, API entry URL)

"Delegated API" = CosmosStackAPI(wallet address, API entry URL)

For the convenience of input, I recorded 9 API entry URLs in the Settings on the second page of the Excel file, and used them as Named cells.

Balances, rewards, and orders obtained from the API, and their currency units, are generally different from what we see in the wallet, so we divide the result by the Column I currency unit factor. For convenience, I use Named cell to record in the Setting worksheet.

Column B "wallet" and Column H "wallet address" should not need me to explain more.

Column A "currency" I made a small modification, I replaced the abbreviation with the full name of CoinGecko currency, added Column G "price", and used custom formula = CoinGeckoPrice (currency name) to get the current online price.

Okay, here comes the point, this time I mainly made the following 3 custom formulas, which are obtained from each Cosmos chain to obtain Column C "Balance" (Available), Column D "Reward" and Column E " Delegate" (Stack):

=CosmosAvailable(wallet address, API entry URL, currency, currency unit factor)

=CosmosReward(wallet address, API entry URL, currency, currency unit factor)

=CosmosStack(wallet address, API entry URL, currency, currency unit factor)

Take the LikeCoin balance as an example, you can fill in the formula…

=CosmosAvailable(LikeCoin wallet address,URL_LIKECOIN,DENOM_LIKECOIN,DIVISOR_LIKECOIN)

LikeCoin reward formula Fill in…

=CosmosReward(LikeCoin wallet address,URL_LIKECOIN,DENOM_LIKECOIN,DIVISOR_LIKECOIN)

LikeCoin entrusts the formula to fill in…

=CosmosStack(LikeCoin wallet address,URL_LIKECOIN,DENOM_LIKECOIN,DIVISOR_LIKECOIN)

The actual use is as follows:

The currency (denom) used in Formula is not common, and for convenience, it is recorded in the Setting worksheet in Named cell type.

Below I will list how other Cosmos chains are used.

1. Cosmos/ATOM

=CosmosAvailable(Wallet address, URL_ATOM, DENOM_ATOM, DIVISOR_ATOM)

=CosmosReward(Wallet address, URL_ATOM, DENOM_ATOM, DIVISOR_ATOM)

=CosmosStack(Wallet address, URL_ATOM, DENOM_ATOM, DIVISOR_ATOM)

2. Osmosis/OSMO

=CosmosAvailable(Wallet address, URL_OSMO, DENOM_OSMO, DIVISOR_OSMO)

=CosmosReward(Wallet address, URL_OSMO, DENOM_OSMO, DIVISOR_OSMO)

=CosmosStack(Wallet address, URL_OSMO, DENOM_OSMO, DIVISOR_OSMO)

3. Desmos/DSM

=CosmosAvailable(Wallet address, URL_DSM, DENOM_DSM, DIVISOR_DSM)

=CosmosReward(Wallet address, URL_DSM, DENOM_DSM, DIVISOR_DSM)

=CosmosStack(Wallet address, URL_DSM, DENOM_DSM, DIVISOR_DSM)

4. Chihuahua/HUAHUA

=CosmosAvailable(Wallet address, URL_HUAHUA, DENOM_HUAHUA, DIVISOR_HUAHUA)

=CosmosReward(Wallet address, URL_HUAHUA, DENOM_HUAHUA, DIVISOR_HUAHUA)

=CosmosStack(Wallet address, URL_HUAHUA, DENOM_HUAHUA, DIVISOR_HUAHUA)

5. Terra/LUNA

=CosmosAvailable(Wallet address,URL_TERRA,DENOM_TERRA_LUNA,DIVISOR_TERRA)

=CosmosReward(Wallet address,URL_TERRA,DENOM_TERRA_LUNA,DIVISOR_TERRA)

=CosmosStack(Wallet address,URL_TERRA,DENOM_TERRA_LUNA,DIVISOR_TERRA)

6. Terra/UST

=CosmosAvailable(Wallet address, URL_TERRA, DENOM_TERRA_UST, DIVISOR_TERRA)

=CosmosReward(Wallet address,URL_TERRA,DENOM_TERRA_UST,DIVISOR_TERRA)

=CosmosStack(Wallet address,URL_TERRA,DENOM_TERRA_UST,DIVISOR_TERRA)

In addition to the above uses, CosmosAvailable() can also read Assets other than OSMO on the Osmosis chain.

For example, to read LikeCoin in Osmosis, you can modify the third parameter "currency" to be DENOM_OSMO_LIKECOIN, and the last parameter "currency unit coefficient" to use DIVISOR_LIKECOIN. The modified formula is as follows:

=CosmosAvailable(Osmo wallet address,URL_OSMO,DENOM_OSMO_LIKECOIN,DIVISOR_LIKECOIN)

Other Osmosis Assets tested by Hong Kong uncles are…

DSM within Osmosis:

=CosmosAvailable(Osmo wallet address,URL_OSMO,DENOM_OSMO_DSM,DIVISOR_DSM)

HUAHUA within Osmosis:

=CosmosAvailable(Osmo wallet address,URL_OSMO,DENOM_OSMO_HUAHUA,DIVISOR_HUAHUA)

LUNA within Osmosis:

=CosmosAvailable(Osmo wallet address,URL_OSMO,DENOM_OSMO_LUNA,DIVISOR_LUNA)

Since Cosmos is vast and rich in resources, my uncle does not have much time and funds. Sorry for not being able to join all the Keplr support chains, but I hope that the Cosmos Excel gadget shared this time will be used by everyone. If you have any questions, please leave a message and I will try to answer them; if you want to join other Cosmos chains, of course, you can let me know, but I dare not promise to join in a short time (of course, if there is a little practical support, I can have Other coins for testing, the production can also be a little faster :P)