Rust pop-quiz: transpose spreadsheet

#Rust / #Elixir pop-quiz

The spreadsheet 'transpose'-function takes a set of rows and transposes them to a set of columns (or vice versa).

Take the SPREADSHEETZORXEN generated by ./cmc:

and output, instead, the single row of token-prices.

• (answer)

Liquid Staking Derivatives

All, I have published information on LSDs I follow ('liquid staking derivatives'), including their burn- and exchange rates.

Available here.

The raw-CSV is here.

Imagine the automation facilitated by the SPREADSHEETSZORXEN!

I do

Update

LSD-SPREADSHEETSZORXEN! v. 1.1:

• added blockchain-column (the idea: where you burn the LSD back to the base token)
• removed the st-LSDs: I'm moving the management of those to ./lsd (forthcoming.)

Next, iterative, improvement.

I've extracted the burn-information – rates and URLs – from this spreadsheetszorxen. 

Burn information will be moved to its own application: ./unbound

ETHBTC EMA-20 Spreadsheet

NEW SPREADSHEETSZORXEN!

This spreadsheet uses the EMA-20 to make BTC/ETH swap determinations.

It's available for you to copy and to use as a #cryptocurrency resource on my Crypto-page. 

Day 1

Okay, my SPREADSHEETSZORXEN! says to swap 0.1828 $ETH, so:

• I withdraw that amount from my Ghost-lend

• I bridge the $ETH to @osmosiszone 

• then swap the $ETH to $BTC 

• I then bridge the $BTC back to @TeamKujira 

• then lend that $BTC to Ghost

I track the $ETH and $BTC bags and their gains (or losses) on the SPREADSHEETSZORXEN!

Spreadsheet for reinvesting $QI

The second part of the bonus for the pop-quiz, I brute-force it with a spreadsheet, reinvesting the $QI each day and recomputing the yields based on the new $QI balance.

The new total value? $26,198.82, or $400 more than the previous answer that did not reinvest $QI.

NEAT: Hard work pays!

But here's the thingamabob about this SPREADSHEET!

It may horrify my mathematician-friends, ...

Elena Marie: Papa, you have friends? 🥺

Me, curtly: yes.

But you can use it with any asset that produces itself and another asset.

You can run these kinds of scenarios yourselves.

The link to this spreadsheet is here.

Have at it!