Linear Programming to balance Cryptocurrency stakes

Let's say you are staking an asset ($ANC), both in single-stake, because you believe in it, and in an LP (because ... you ... don't? Anybody who puts an asset into an LP and watches the asset's PRICE is cray, IMO), and you want those two positions always in synch? WAT DO?

LINEAR PROGRAMMING TO THE RESCUE! And how do I do LINEAR PROGRAMMING (all caps, obvie): SPREADSHEETS! 

BECAUSE I'M ME! 

AND I GOTS TA BE ME!

Let's walk through an example.

n.b.: It's not something you can just plug a few numbers into, however: this requires work.

So, let's to this.

Exercise:

• STEP 1: enter your singled-staked asset amount (A6)

• STEP 2: enter the asset's portion of your LP (cell B6)

The system computes the Average for you, so skip that cell, so, next

• STEP 3: enter the amount of the asset to be distributed (cell D6)

• STEP 4: enter the quoted price of the asset (cell E6)

So, we have a row #. Go to that row in the linear program.

1. HIGHLIGHT that row in GREEN.
• note: the staked (L) and LP (M) positions should be the same-...ish number
2. HIGHLIGHT the to_cells (H, I, J) in RED 

THOSE are your distribution amounts. So: go invest those

... and that's what I do, every day I distribute my yields to various investments that I want to keep in balance using LINEAR PROGRAMMING! and SPREADSHEETS! YAY!

Here is the crypto linear program spreadsheet.

Daily Cryptocurrency Income Report, 2022-03-13

 Daily #cryptocurrency income report for 2022-03-13: $5.99

So, I rested from yield-farming yesterday. I'm only human.

Narrator: "...says the space alien."
Me: "Shut up, Narrator!"
Narrator: "YUR NOT MY MOM!"

Narrator and I have a ...'special' relationship. 🙄 

TERRA: PRISM arbitration

🚨🚨🚨 ARBITRAGE opportunity on Terra 🚨🚨🚨

This is a new arb: $xPRISM -> $PRISM, so we'll walk through the process step-by-step this first time.

n.b.: $xPRISM == $PRISM + stake-gains, so $xPRISM is worth MORE than $PRISM, ALWAYS. Keep that in mind.

Do you see the arb?

$xPRISM is currently trading at a LOWER price than $PRISM. When I did the arb, 50 $UST swapped for:

• 94 $PRISM or 97 $xPRISM

Then it corrected itself as I was doing it. You have trade quickly with these arbs, it seems.

1. SWAP 50 $UST to 97 $xPRISM on @prism_protocol 

Now, go to @prism_protocol Governance page, select the 'Unstake'-tab, and

1. 21-day BURN 97 $xPRISM to 100 $PRISM

98.31% annualized gain.

Arbitrage computation

And, returning to the @prism_protocol Governance page, you see your $xPRISM slow-burning to those sweet, sweet gains.

The question is, however, do you want to do the burn at all? $PRISM is valuable for pairing, but $xPRISM has a secret weapon that makes it valuable...

THIS was the special sweet and spicy sauce I was looking for! THIS is what makes the whole refracting and staking $yLUNA worthwhile. THIS is why I want to keep my $xPRISM, and not burn it: to generate AMPS.

So, we have a conundrum: 

• arb good; 
• staking good.

Wat do?

Any of you who follow my work know what I do when given a choice between two equally good options:

I choose both.

I'm already burning the swapped $xPRISM, so now I buy an equivalent amount of $xPRISM to stake for the AMPS-farming.

I set up the win on both sides.

HARMONY: Parrot defi arbitration

Market ... 'inefficiency' (?) on Harmony.

I can't call it an arb.

1. SWAP 587.4 $PEGG for 632.6 $BPEGG

Since you normally burn 2 $PEGG per 1 $BPEGG in the @parrotdefinews incubator, this makes you ~338 $BPEGG more

Or absolutely nothing, as you see from my protocol balance. 😭

Daily Cryptocurrency Income Report, 2022-03-11

Income: $146.69

One day instead of writing reports and HOWTOs, I'll actually harvest all my daily yields ... haha, no, not today. 😅

Also, is @finance_unite just going to yield 1% PER DAY, ... forever? I might have to look into this.

DefiKingdoms Quest haul, 2022-03-11

My latest haul from @DefiKingdoms quests. Time to convert these puppies to $DFKGOLD and from thence to $JEWEL and see how my "Hero self-funding"-project is coming along.

These are the raw data of the trades by profession for 2022-03-11:

• Fishing: 43 items, 270 $DFKGOLD, 0.25 $JEWEL
• Foraging: 86 items, 686.5 $DFKGOLD, 0.72 $JEWEL
• Gardening: 2 items, 20 $DFKGOLD, 0.02 $JEWEL

SWAP 982.5 $DFKGOLD for 1.027 $JEWEL

*ahem* Raw data, like I said *cough*

"Wen @DefiKingdoms Heroes self-funded, ser?"

Day 3:

Hero cost, adj: 614.377 $JEWEL

items yield, today: 1.027 $JEWEL

items yield, total: 12.72 $JEWEL

remaining: 601.7 $JEWEL

dis eez ... gonna take a while. 

G'nite, fam!

Bank your earnings

p.s.: $xJEWEL is heading toward a 2.0 multiplier.

Friendly reminder: STAKE your $JEWEL at the BANK.

(stupid name: 'jeweler.' It's the bank. It has a MANAGER. It's THE BANK.)

(sheesh).

#PSA

Oh, and: #Bank. 

Terra: Team Kujira Liquidation fulfillment bids

Did you know that you can earn interest on @TeamKujira $aUST bids?

First of all, what's @TeamKujira ?

@TeamKujira is several things, but I'll focus on its liquidation fulfillment system today, and how you can earn interest bidding on liquidation fulfillments.

So! Liquidations occur on @anchor_protocol when loans exceed maximum LTV. How are these loan liquidations fulfilled? Before it used to be whales that would snipe in and buy the liquidated $LUNA or $bETH at a high premium. @TeamKujira has an alternative.

What @TeamKujira offers is a bidding system, where anyone can make a bid on a liquidation fulfillment, and when your bid satisfies the requirements – TADA! – you just fulfilled a loan liquidation: here's your $LUNA or $bETH! 

I like this system. I like it a lot. Why? It allows you and me, the little guys in crypto, to buy $LUNA or $bETH at a discount AND when it's at a low, too!

SWEET!

But what's not so sweet about it, is you bid your $UST and you wait. And wait. It's just sitting there.

So, @TeamKujira came up with a plan that fixes this issue. Instead of bidding with $UST, they now have an option to bid with $aUST.

"So what?" sez you.

I'm glad you asked that question, but first, let's load up our @anchor_protocol EARN to have some $aUST on hand.

Side note: you see I load my @anchor_protocol EARN on @TeamKujira $aUST tab. Why? The fees are much lower via @TeamKujira, that's all. You can deposit in either place: the money still ends up in @anchor_protocol EARN. #PSA 

BUT NOW THAT WE HAVE DA MONAY TO BID! ...

... let's bid. Obvie.

How does bidding work? It's really easy, actually. You select a premium rate you're willing to bid on, you select $aUST, and fill in how much you want to bid.

TADA! YOU'RE A LIQUIDATOR-FULFILLER!

Now, when you place your bid, you're asked which tier you want to place it, depending on the riskiness of the loan. It defaults to high-risk loans, which is cool (I'm all about liquidating high-risk loans), but you can change that value, if you wish.

That was a bid on bonded $LUNA, but you can also bid on $bETH, by selecting that collateral-type. Let's bid on $bETH liquidation fulfillments, too.

Okay, so now you have bids (we can talk bidding strategies later), which brings us back to your "So what?"-question.

The 'So what?' is that if you scroll down to the next panel, you see that these bids are 'Interest Earning'-bids. What does this mean?

So, this 'Interest Earning' is a double-happiness:

1. When the bid is fulfilled, you get discounted $LUNA or $bETH! YAY! 
2. But when not, your bid is EARNING INTEREST NOW! WOOT!

It's the bank, but ACTIVE, baybee! 😎

You can check all your bids in the aUST-tab.

That's it. Yay!

Now, a note on sniping strategy. I'll tell you mine:

I need more $LUNA.

That's my strategy. So I bid *under* everybody else's bid, because I need more $LUNA: which I get at low price (because that's when liquidations occur) and a discount.

Oh, and p.s.: while writing this, my bid fulfilled another $LUNA liquidation, because @TeamKujira is awesome!

The. End.