create account

A Nerd Guide to Splinterlands by beelzael

View this thread on: hive.blog |  peakd.com |  ecency.com
hive-13323 · @beelzael · (edited)
$22.46
A Nerd Guide to Splinterlands
![I started so young and optimistic...](https://files.peakd.com/file/peakd-hive/beelzael/Ep3hdpHbzsjcyS2oz9UTwPZrcSpE66Z7Fd2wtqTL2QXtGDn8rML3zztveUcKBMdLupv.jpg)


![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)

##### First things first

It's all @azircon 's fault. Just to be clear. This will take a long time to write and explain and yes - I'll try to be as concise as possible. I write this before I even start. It's Friday, 30th of May 2025, 14.43pm. I can here the drums. They're coming. 

![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)

##### Prologue

Splinterlands is an amazing game and I'm falling more and more in love with it and the community. It's not an investment to me, but a hobby, and when I see what others spend on their hobbies, I'm still low balling.

But it is an important sales point that you can actually earn money with the game. But... how much? Those who read through my nerd posts know that I like ROI calculations, so this is what you're going to get:

0. <a href="#conclusion">Conclusion</a> - Das Pferd von hinten aufzäumen
1. <a href="#spending">Spendthrift?</a> - How much I put into Splinterlands
2. <a href="#SPS">King of Shards</a> - Summary of SPS earned
3. <a href="#DEC">Crystal Queen</a> - Summary of DEC earned
4. <a href="#Assets">Gold Standard</a> - Current Asset Value
5. <a href="#Projection">Conquest</a> - Projection for 2025
6. <a href="#Data">Let's get nerdy!</a> - How find your personal data
7. <a href="#Excel">Geek it out</a> - How to use Excel to excavate your stats.
8.1 <a href="#battle">Brawls & Battles</a> - How to extract Ranked/Brawls/Land
8.2 <a href="#rent">DEC</a> - How to extract DEC earnings
9. <a href="#final">Final Conclusion</a>

I'm scared. It's SO many excel sheets. SO many lines. And excited. So much to learn. Let's get to it!

![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)

#### <div id="conclusion"> Putting the cart before the horse </div>

Numbers are not everyone's favorite. So I'll present the summary first. Although I must say that there are quite a few hidden gems in the whole article. It might be worth reading it all.

I spent $7330 on Splinterlands in total.
My current assets are worth $7,465 (not counting a BF Arcana 1/20). That's a 1,8% increase 🤑 
I earned $14.57 in DEC through renting and vouchers.
I earned $330 in SPS through all those ways you can make SPS.

The total earnings of $347,57 mean that I made a dividend of 4,7% - that's shitty for 5 years. Total ROI would be 6,5%. But now, look at this:


![It's kind of visible when I started playing and buying again...](https://files.peakd.com/file/peakd-hive/beelzael/Eo8ZeGF6QECamPUcdefVYFSAq5nABArYKck53xH9PUW8xfCLattKo3ejCKgN6mi7hcR.png)

But now we have to consider one thing - of the total money spent, only $270 was spent before 2024, and 60% of it was spent in 2025 ( #conclavearcana ).

If we take only 2024, which was the year that I came back and spent quite a bit, it would be $147 income on $2625 spending, so 5,6% yearly dividend. That's a little better.


#####  I'm still spending, more than I ever did.
*Great, now I have Elton John in my head. Why do I have to do those bad puns?*

I still buy packs here and there to get my CA-Deck to Gold level, as well as some selected Rebellion Cards. So the ROI will stay down. If I ever stop buying, it might go up substantially - because then the SPS-Price will also have skyrocketed, naturally 😝

SPS is at 0,0095$ as I'm writing this. When it was 0,014$, my ROI was: 35,579 SPS x 0,014$ = $498  ($150 / 42% more) , leading to 6,9% - that's already 2,2% more.

*Let the wheel fly...*

Also, with time, I will be able to finance more and more of my dirty pleasures from within the chain (e.g. HIVE), that will also help the ROI.

![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)

### <div id="spending"> Money spent </div>

This one is kind of easy. I funneled money into Splinterlands through Credits, direct PayPal to a friend who gave me SPS for that, and through a Crypto-App when DEC was way under peg and it made sense to buy it on the secondary market instead of using PayPal & Credits.

Credits: 6,255.10$ 

PayPal to a pal: $675

Kraken App: $400

<u>**Total spent on Splinterlands: $7,330 aka 7,330,000 DEC at peg.**</u>

Wow. I could get a car for that. But I don't enjoy cars.



![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)



#### <div id="SPS"> SPS earned </div>

Okay, this one was a huge surprise. Just by tournaments, I made:


![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23viTbagtEjQ99G7B6rW8wzxBV8MphmT1hnupHDbB9PLBcowsr6jmp9VJvR1qYkgGN8Vy.png)

Note that German Excel and the Splinterland CSV do not cooperate well on numbers, so it's actually **14,097.733 SPS**. It took me one hour (no, not exagerrated) to figure out how to set Excel to the System that was in the CSV.

SPS Airdrop: **222.732 SPS**

Staking Rewards was very nice, too: **5,841 SPS**

Pool Rewards from UniSwap: **101 SPS**

##### Ranked and Brawls

This data took a while to excavate. Recently, since February 20th, it's possible to at least identify how much of the staked SPS was claimed with a simple drop down. Long story short, I finally figured out how to extract the data, more or less exact, from the CSV. This took me a couple of hours.

Brawls & Battles: **15,541 SPS**

<u>**TOTAL: 35,579 SPS or 330,000 DEC**</u>

![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)

#### <div id="DEC"> DEC earned </div>

Rewards (that was a 2022 thing): **110 DEC**
Rentals & Tournis: **5,469 DEC**

Vouchers in DEC: **8,991 DEC**

<u>**TOTAL: 14.570 DEC**</u>

![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)

#### <div id="Assets"> Current Assets </div>

Staked on Land: **67,602 DEC**
Worth of cards: **5,867,850 DEC**
Land: 2x Land ($52), 1x Wood ($15), 1x Stone ($18), 1xIron ($18), 5xPower Core ($25) = $128 = **128,000 DEC**
Liquid DEC: **4,000**
Liquid Credits: **25,000**
Staked SPS: **145,451 SPS aka 1,373,000 DEC** (almost forgot this one)

<u>**TOTAL: 7,465,452 DEC**</u> This does NOT include my 1/20 BF Arcane Edition of the Ashen Cindergrim. That might be worth quite something.




![IMG_20250531_105715.jpg](https://files.peakd.com/file/peakd-hive/beelzael/Eq7RmkxL6ERYHcU4DvXN67NkexzPjuD2sZ47V1NwuLWnuw1d829XzPB7qavuFsGKJiB.jpg)

>Worked until 11pm yesterday. I should be in bed by 9pm to keep up with Lily. It's 7am now, she's eating pancakes, I'm drinking coffee and working out HTML codes. Huge thanks to Bravetofu for teaching me that!

![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)

#### <div id="Projection"> 2025 Projection </div>

We're 5 months in now. And a lot has changed during those 5 months.



![Yes, I cleaned the sheets to make the numbers be realistic.](https://files.peakd.com/file/peakd-hive/beelzael/23tmjgGNFP5M3aBAmu9Wokcc9bKfzC56YP9ZdCBmaZwuz3QL5Ssz2zXrKq6E3PRUQwRvN.png)


We have a median of $39 of income each month. If I keep on playing like I do, that would lead me to around $470 income this year, around 6,3% ROI.

But I also think that May was an outlier, as CA was launched and I was very hesitant to go into Modern. Also, there just weren't as many tournaments. So, I asked Excel to kindly do a log prediction of what my monthly income could be like until the end of the year:



![image.png](https://files.peakd.com/file/peakd-hive/beelzael/Eo4Js77WsCqXAcFEd5fSFaFzgYq1bbAQfHyasAhH4AKsEeTFADJMFjR9mfTPzij1hYH.png)


### New Goal: Making $55 income in November.

I'll be with my family in December/January, so maybe not much play time.


![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)



The tutorial section starts here. I hope you enjoy it! If you find flaws or have better ways to calculate (or want to build a tool to automatically analyze your CSB... Beaker?)

#### <div id="Data ">Where's my data?</div>

I asked my master if he knew of any page that stored the data of earnings and spendings in Splinterlands, but he said that would be too much data to store - but Splinterlands does!

If you're logged in, [just click here](https://splinterlands.com/user/currency-activity) and you'll get to your activity page. If you play on another browser, go to your SPS page and click on "Activity"


![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23t7BUoBkLAx9VQoFgAj4k2uwKehsr5bSX7enPKKRhYgHKkU2qiimqeauTGZMq3Cip81Y.png)


Magically, you'll land on a very, very confusing page with trillions of transactions - your transactions. Go to the little download symbol.


![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tGVGFcE5viDn5jByV7Pk9pCaCc5RHJx1cmAGSJSi4D8arSjLVABM5bXZcBKq99hTmZy.png)

You'll land on a page where you can download .csv files from each year. Of course you can also select which token you want, but I just downloaded all of them. 5 years worth of data. This will be so much fun!


![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23swdzykx3VCgAeyyTQtUEQNvRv7tNwLLEnrZDUHD5C1FTtnCNvhCT8R2wu8ugXFbxE1Q.png)


![IMG_20250531_105722(1).jpg](https://files.peakd.com/file/peakd-hive/beelzael/EqBg29r2j3Sawg3av7jNya2nzFH6GH7nq8RUGg6Sy3VMEg411FjpJJgoHTQ19cbKjWT.jpg)

>1.030.000am. Did a 30.000min break to eat 2.000 pancakes and bring my daughter to a dance lesson. I feel weird. I think it's affecting me.

![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)

#### <div id="Excel"> Excel in Excel</div>

Who doesn't love Excel? Please leave now. Just kidding, you can use Google Sheets and other programs that support the CSV format.

This is what it initially looks like:


![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23sxhmQ9sCMr4xhfAunB16ks4DJGpHppmFcVioHrqnYLfUrCSb3jFptXKFPrTrff73fxg.png)

A freakishly beautiful mess. If you don't know how to turn that into something beautiful: Mark the first column (A). Go to "Data", and click on "Text in columns". 

First step: Mark the first option.
Second step: Mark "Comma". 
Third step: Mark Standard. 
Click on "Complete. Done. It now looks like this:


![image.png](https://files.peakd.com/file/peakd-hive/beelzael/Eo4HoWC6WbYo9G4hQ8eEV3QbdNwTroJitE2Pp9w8PyTcJbbwNEZdfzNd5v7Mbzee1mw.png)

Way better. If you want to do it like me, and do it for all of your years in the Splinterverse, you have to do that with every csv file and combine them together in a single Excel file. Mine is only 39,471 rows long as I was inactive for 2 years. Lucky me...

Two more things: Mark the first row, go to Data again, and click on "Filter". A little dropdown symbol will appear next to each topic, and that is very, very important to nerd on.


![image.png](https://files.peakd.com/file/peakd-hive/beelzael/244UqVjJbSxwptC6d71j82KeKv91UBSt68wjq4MyQ62CzCTWBX56YyjywpoTLWSy1ptgR.png)

With that, you can select groups of transactions, for example all DEC or Credits. And don't worry, yours will be in your language. You did not get the worst virus of all by reading here, which is Excel in German.

Then, second recommendation: Create a Subtotal function to make a sum. Mine would look like this in English: =SUBTOTAL(9;D2:D39742) In Column D are all the incomes and outgoings, and to get totals, that is important.


![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tHUsG7zrP4gYrCque6NzghZBb2Z7u76wQC6WCtk263CJfnjCyDCvhKme1MLRwFuMzaS.png)

As you can see, the values are separated weirdly. That will cause confusion, I guarantee. 100.000.000 For example is actually 100,000.000 in English counting punctuation. You might have to change that in your Excel Settings --> advanced --> kind of in the middle.


![I know, that Virus again. Change both to a dot, that should fix the punctuation problem.](https://files.peakd.com/file/peakd-hive/beelzael/23swkNnC1Kt3x3JwjT8794Sao5o9UMecW58H53u3RguyQ1Df2TYQpY7FJswon5dMgztdx.png)

If that doesn't work, sometimes it helps to convert the number into text, and then back into the correct number system. It's a bit tricky, but I hope your Excel won't make the same problems as mine. 


![IMG_20250531_105552.jpg](https://files.peakd.com/file/peakd-hive/beelzael/EqBfVbHknBxEvBgU8MFfFTfdfwL9AwxGHNCiWPL4twYuNjwBpYnoxeAF79xs8WzNJ1N.jpg)


>The fridge is broken. I'm tipping on the door handle, but it won't show the list of the selectable items. It was working fine yesterday. Hopefully I just have to restart it.


![](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)

## Welcome to... whatever this is.
You made it! This is great! Now you just have to select the right items in the drop-down menus, and you'll be able to extract your data. Only 2 more days! 😵

*RUN!*

#### <div id="battle"> SPS-P Income (Brawls, battles, land,...) </div>

This one is a little more complicated. With the update on February 18th, a lot of the naming has changed and it's now easier to see which parts of the Staked SPS (SPSP in the first column) comes from those rewards.

![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23swe9iiNhmnhE5p3uvpGVK8GgP8mcjXfLjVWMhTgqejGjuGLSFetPQrCq6C37T5yDZFk.png)

Compare these two, and you will see that SPSP "stake_tokens_multi" refers to the SPS I earned in Brawls, Modern and Wild. The 6,5 SPS that I delegated to the XBot are not in this selection of the CSV file.

![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tw7k2M1sm287kPpLtaAb7q1GdnBpuR8iHnwFCUeTjTvrzy5aQu2bvkkWZiuu1SqmGME.png)


For data before that, we have to use logic. Battles & Brawls are always directly staked, minus the part that you delegate, for example for using a bot. They do not appear as regular SPS as long as you don't unstake. Regular SPS on the other hand is converted into SPSP when you stake it. Meaning, Staking rewards, bought SPS, or wherever you got it as liquid SPS, will appear first as positive in the SPS balance, and when you stake it, it will be negative in the SPS balance. If you compare that to the SPSP, you will have the difference between the two, which is the Battle/Brawl/Land Earnings.



<div class="pull-right">https://files.peakd.com/file/peakd-hive/beelzael/23tSxBXxmiVFbbiaCxRZCLEHDbaVuQNpCqC4n75z4TRbVMzbq4jRQnH3MkHnwjRLCifbs.png</div>

First Column: Select SPS and SPSP

Second Column: leave it be

Third Column: Select $TOKEN_STAKING


With that, you have all the Token Staking - meaning, you have the SPS that went to Staking as liquid, the same as negative, and then all the SPS that went directly to staking without being liquid. Dang, that kind of sounds more complicated than it is. Sorry. Hope you understood!

It'll look like this:


![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tw7xakoRo7rN6Y7Va9mi7TzcpTcgJVd5gM9pvrYFWs53ut8S26Jp96YHzMbzZCoTnpU.png)

You can see that $Token_Staking is taken away from SPS as a negative and added to SPSP as positive. The two equal each other out, so there's only the direct staking left: Line 3 for example: 51.128 SPSP.

![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)


![IMG_20250531_123058.jpg](https://files.peakd.com/file/peakd-hive/beelzael/23zS5K99MuVgPLmqdV3bip12TmADxWe5vcz9v75nWZ7dMa2Zd18fSPrrNhRZxFLMjzmra.jpg)


>01001001 01101110 01110110 01100001 01101100 01101001 01100100 00100000 01000010 01110010 01100001 01101001 01101110 00100000 01000101 01110010 01110010 01101111 01110010

#### <div id="rent">DEC Income </div>

<div class="pull-right">https://files.peakd.com/file/peakd-hive/beelzael/23uRHrs9u34gpK5AYEcLkppjo5zptREvR3Ka6tbWjEig1wjyyXsUeXkn4JyY1KfRPS1ey.png</div>

First Column: Select DEC

Second Column: Select rental_payment, rental_payment_burn_fees and rental_payment_fees, tournament_prize

That gives you the total of your rental income, already discounted the burn and fees. 

This does not count sold cards. Those are marked as "market_purchase", but that goes both ways - the ones that you sold, and the ones that you bought. You can use that to calculate trading, but for ROI it's not really good. You don't really need it, though, as it is included in our current asset value, either as DEC or in the new cards we bought.

*So let's not count the $300 I got for a BF rare...* Yeah, a little flexing, I'm getting tired here. Thinking of that motivates me!


![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)

#### Congratulations!

You're a bit more nerdy now, and can dig through a lot of data in order to bend their information to your will. You now have a power that few posses, and yes, you're allowed to go mad with that power now. Because going mad without power is boring, nobody listens to you. (Russel "Russ" Cargill)


![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)

#### <div id="final"> Final Conclusion </div>

Wow. This took me a total of 12h to get through all of it. I had to re-write and re-calculate several times do to reasoning-errors. Was it worth it? You decide! It sure was a lot of fun and definitely a challenge to my Excel, logic and search skills.

I'm very grateful that Splinterlands is saving all that data on a server, although they could enhance the CSV-files a little by including the "Unclaimed" section of the Activity-Log, specifying Ranked, Brawls, Land, and so on. The game code can do it, so it must be lying around somewhere already.

But I have a new skill now - if you don't want to go crazy doing all this analysis, but don't want to wait for one of the really smart people to build a tool to upload and analyze the CSV automatically, I'm sure we can come to an agreement. I always need more Alchemy Packs, or summoners... Would depend on how much data there is to analyze, though.

The return is higher than I had expected - I mean, playing Splinterlands gives you more ROI than a savings account, and more than treasuries. Won't beat my stock performance (yet), but still. 

### Who can else can claim that they get 5,6 - 6,3% ROI from their hobby?

![image.png](https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png)

>Please do not tell me that there already is a tool for all that. I rather live in the illusion of having figured out something that is not a few clicks away. Thank you for your comprehension.
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 232 others
👎  
properties (23)
authorbeelzael
permlinka-nerd-guide-to-splinterlands
categoryhive-13323
json_metadata"{"app":"peakd/2025.5.9","description":"Want to know how much you make in Splinterlands? Here's your guide! Sprinkled with German humor and despair.","format":"markdown","image":["https://files.peakd.com/file/peakd-hive/beelzael/Ep3hdpHbzsjcyS2oz9UTwPZrcSpE66Z7Fd2wtqTL2QXtGDn8rML3zztveUcKBMdLupv.jpg","https://files.peakd.com/file/peakd-hive/beelzael/23tbMAzMLsxALKcrsVxWhKjQivrqty8Jkhi1ZRYrPH28K1XSCftX9hqBPBEh7qnW3R6Yw.png","https://files.peakd.com/file/peakd-hive/beelzael/Eo8ZeGF6QECamPUcdefVYFSAq5nABArYKck53xH9PUW8xfCLattKo3ejCKgN6mi7hcR.png","https://files.peakd.com/file/peakd-hive/beelzael/23viTbagtEjQ99G7B6rW8wzxBV8MphmT1hnupHDbB9PLBcowsr6jmp9VJvR1qYkgGN8Vy.png","https://files.peakd.com/file/peakd-hive/beelzael/Eq7RmkxL6ERYHcU4DvXN67NkexzPjuD2sZ47V1NwuLWnuw1d829XzPB7qavuFsGKJiB.jpg","https://files.peakd.com/file/peakd-hive/beelzael/23tmjgGNFP5M3aBAmu9Wokcc9bKfzC56YP9ZdCBmaZwuz3QL5Ssz2zXrKq6E3PRUQwRvN.png","https://files.peakd.com/file/peakd-hive/beelzael/Eo4Js77WsCqXAcFEd5fSFaFzgYq1bbAQfHyasAhH4AKsEeTFADJMFjR9mfTPzij1hYH.png","https://files.peakd.com/file/peakd-hive/beelzael/23t7BUoBkLAx9VQoFgAj4k2uwKehsr5bSX7enPKKRhYgHKkU2qiimqeauTGZMq3Cip81Y.png","https://files.peakd.com/file/peakd-hive/beelzael/23tGVGFcE5viDn5jByV7Pk9pCaCc5RHJx1cmAGSJSi4D8arSjLVABM5bXZcBKq99hTmZy.png","https://files.peakd.com/file/peakd-hive/beelzael/23swdzykx3VCgAeyyTQtUEQNvRv7tNwLLEnrZDUHD5C1FTtnCNvhCT8R2wu8ugXFbxE1Q.png","https://files.peakd.com/file/peakd-hive/beelzael/EqBg29r2j3Sawg3av7jNya2nzFH6GH7nq8RUGg6Sy3VMEg411FjpJJgoHTQ19cbKjWT.jpg","https://files.peakd.com/file/peakd-hive/beelzael/23sxhmQ9sCMr4xhfAunB16ks4DJGpHppmFcVioHrqnYLfUrCSb3jFptXKFPrTrff73fxg.png","https://files.peakd.com/file/peakd-hive/beelzael/Eo4HoWC6WbYo9G4hQ8eEV3QbdNwTroJitE2Pp9w8PyTcJbbwNEZdfzNd5v7Mbzee1mw.png","https://files.peakd.com/file/peakd-hive/beelzael/244UqVjJbSxwptC6d71j82KeKv91UBSt68wjq4MyQ62CzCTWBX56YyjywpoTLWSy1ptgR.png","https://files.peakd.com/file/peakd-hive/beelzael/23tHUsG7zrP4gYrCque6NzghZBb2Z7u76wQC6WCtk263CJfnjCyDCvhKme1MLRwFuMzaS.png"],"tags":["splinterlands","play2earn","sbt","spt","pepe","thgaming","oneup","neoxian","pgm","waivio"],"users":["azircon"]}"
created2025-05-31 19:48:33
last_update2025-05-31 19:51:00
depth0
children21
last_payout2025-06-07 19:48:33
cashout_time1969-12-31 23:59:59
total_payout_value11.244 HBD
curator_payout_value11.213 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length19,250
author_reputation157,593,690,320,632
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,086,594
net_rshares69,070,705,643,175
author_curate_reward""
vote details (297)
@azircon · (edited)
1. First, now you appreciate what are we, the data people, do exactly 

2. Second, ROI concept is completely flawed:)

Let me explain. Assume you are a German :) Should be easy :)

| Date       | Value of 1 US Dollar in Papiermarks |
|------------|-------------------------------------|
| Jan 1919   | 9 marks                             |
| Jan 1920   | 64 marks                            |
| Jan 1922   | 191 marks                           |
| Jan 1923   | 17,972 marks                        |
| July 1923  | 353,412 marks                       |
| Oct 1923   | 25.26 billion marks                 |
| Nov 1923   | 4.2 trillion marks                  |

Now assume you invested some money in German assets that is related to “cash” in Jan 1923. You calculate the ROI in German Papiermark and it will be Trillion percent:)

You see my point.

We assume here DEC is stable coin. Yes it try to make it. But it is soft pegged and can de-peg.

We then try to do ROI in USD, which it better but not without currency risk in today’s world.

That’s why ROI is a difficult game. A better approach is consider it as income and do mark-to-market.

Good post. But be imaginative with plot, and make them visually pleasing. A good plot is an art!
👍  
👎  , , , , , , , , , , , ,
properties (23)
authorazircon
permlinkre-beelzael-sx58on
categoryhive-13323
json_metadata{"tags":"hive-13323"}
created2025-05-31 20:53:12
last_update2025-05-31 20:53:42
depth1
children3
last_payout2025-06-07 20:53:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,238
author_reputation781,317,898,021,739
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,087,527
net_rshares-4,655,643,818
author_curate_reward""
vote details (14)
@beelzael · 
Yeah, the plotting is still difficult for me. Excel works sometimes, but I'm just not as advanced to really get it going. If you have any tips, I'll be all eyes :-)

Interesting what you say about DEC. I used DEC to make it more relatable, even though it's now "only" 5% below peg at the moment.

As it is a momentary picture, with the current situation of DEC/SPS/Voucher/USD relations - doesn't it make sense to use it as an image for "right now"? For the projection into the future, yes, that's complicated, influenced by too many inflation-matters and such. But as a status quo, doesn't it work out? 

The 2024 calculation still stands, no matter how I calculate it, based on the current value. That's why I did the simulation of SPS at 1,4 cents as well, to show the impact (in this case positive).
properties (22)
authorbeelzael
permlinkre-azircon-sx592q
categoryhive-13323
json_metadata{"tags":["hive-13323"],"app":"peakd/2025.5.9","image":[],"users":[]}
created2025-05-31 21:01:39
last_update2025-05-31 21:01:39
depth2
children2
last_payout2025-06-07 21:01:39
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length803
author_reputation157,593,690,320,632
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,087,637
net_rshares0
@azircon · (edited)
1. Get away from white background, most pro-data guys are blind looking at computer all day, they prefer dark mode.

2. Investigate python. These days python doesn't require any coding knowledge

https://github.com/h4pZ/rose-pine-matplotlib

For example, let us take this data

Here is the data presented in a Markdown table:

| Player           | Active Plots | LDE    | DEC/hr  | LCE     | LPE   |
|------------------|--------------|--------|---------|---------|-------|
| michealb         | 459          | 150.74 | 4982.45 | 5733.56 | 10.86 |
| jarvie           | 1409         | 660.25 | 4024.30 | 8597.09 | 2.86  |
| fighter4-freedom | 272          | 90.80  | 3498.94 | 5766.59 | 12.86 |
| cryptoeater      | 134          | 31.58  | 3078.93 | 8443.16 | 22.98 |
| cryptomancer     | 1138         | 849.63 | 2699.74 | 8278.57 | 2.37  |
| beelzael         | 5            | 649.71 | 4.34    | 8341.82 | 0.87  |


![chart (16).png](https://files.peakd.com/file/peakd-hive/azircon/23tbRLafJC4QKo6HxJnq2hW72nAvofJRPuUobRgDHSrjUhyWmJpJpyzGbgEvyGPpPru7e.png)


Took me almost no time :)

But, that is just practice...

https://jupyter.org/

Jupyter notebook! Hands down the preferred tool
👍  
👎  , , , , , , , , , , , ,
properties (23)
authorazircon
permlinkre-beelzael-sx5akf
categoryhive-13323
json_metadata{"app":"peakd/2025.5.9","tags":["hive-13323"]}
created2025-05-31 21:33:57
last_update2025-05-31 22:11:27
depth3
children1
last_payout2025-06-07 21:33:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,183
author_reputation781,317,898,021,739
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,088,054
net_rshares-3,865,183,451
author_curate_reward""
vote details (14)
@fallen.angels · 
https://images.hive.blog/0x0/https://files.peakd.com/file/peakd-hive/javivisan/23ynfVX4eULR6befXuozSNAbS94FivL8j2Vf252mwQM6KpBLeAD6kRVFjS8apvdkCjzxY.png<br/><center>This post has been supported by @fallen.angels guild!<br/>Delegate Tokens and HP to Fallen Angels to earn weekly rewards!<br/>[Delegate](https://fallenangels.pythonanywhere.com/curation/) | [Join to the guild](https://t.me/+we9-hXTnUBRlZDc0)</center>
properties (22)
authorfallen.angels
permlinkre-a-nerd-guide-to-splinterlands-20250531t220032z
categoryhive-13323
json_metadata"{"app": "beem/0.24.26"}"
created2025-05-31 22:00:33
last_update2025-05-31 22:00:33
depth1
children0
last_payout2025-06-07 22:00:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length415
author_reputation64,276,911,099,201
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,089,116
net_rshares0
@flummi97 · 
Super Blog, mal was etwas anderes. Rehived. :)
👍  
properties (23)
authorflummi97
permlinkre-beelzael-sx6p4g
categoryhive-13323
json_metadata{"tags":["hive-13323"],"app":"peakd/2025.5.9","image":[],"users":[]}
created2025-06-01 15:45:51
last_update2025-06-01 15:45:51
depth1
children1
last_payout2025-06-08 15:45:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length46
author_reputation66,263,115,999,321
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,102,255
net_rshares8,269,514,660
author_curate_reward""
vote details (1)
@beelzael · 
Dankeschön! 🙃
👍  
properties (23)
authorbeelzael
permlinkre-flummi97-sx6p5j
categoryhive-13323
json_metadata{"tags":["hive-13323"],"app":"peakd/2025.5.9","image":[],"users":[]}
created2025-06-01 15:46:33
last_update2025-06-01 15:46:33
depth2
children0
last_payout2025-06-08 15:46:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length14
author_reputation157,593,690,320,632
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,102,283
net_rshares94,450,021
author_curate_reward""
vote details (1)
@hivebuzz · 
Congratulations @beelzael! You have completed the following achievement on the Hive blockchain And have been rewarded with New badge(s)

<table><tr><td><img src="https://images.hive.blog/60x60/https://hivebuzz.me/badges/postallmonth.png"></td><td>You have been a buzzy bee and  published a post every day of the month.</td></tr>
</table>

<sub>_You can view your badges on [your board](https://hivebuzz.me/@beelzael) and compare yourself to others in the [Ranking](https://hivebuzz.me/ranking)_</sub>
<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>



**Check out our last posts:**
<table><tr><td><a href="/hive-122221/@hivebuzz/pum-202506"><img src="https://images.hive.blog/64x128/https://i.imgur.com/M9RD8KS.png"></a></td><td><a href="/hive-122221/@hivebuzz/pum-202506">Be ready for the June edition of the Hive Power Up Month!</a></td></tr><tr><td><a href="/hive-122221/@hivebuzz/pud-202506"><img src="https://images.hive.blog/64x128/https://i.imgur.com/805FIIt.jpg"></a></td><td><a href="/hive-122221/@hivebuzz/pud-202506">Hive Power Up Day - June 1st 2025</a></td></tr></table>
properties (22)
authorhivebuzz
permlinknotify-1748738737
categoryhive-13323
json_metadata{"image":["https://hivebuzz.me/notify.t6.png"]}
created2025-06-01 00:45:36
last_update2025-06-01 00:45:36
depth1
children0
last_payout2025-06-08 00:45:36
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,139
author_reputation369,197,277,533,997
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,091,021
net_rshares0
@hivebuzz · 
Congratulations @beelzael! You received a personal badge!

<table><tr><td>https://images.hive.blog/70x70/https://hivebuzz.me/badges/pud.png?202506011444</td><td>You powered-up at least 10 HIVE on Hive Power Up Day!<br>Wait until the end of Power Up Day to find out the size of your Power-Bee.<br>May the Hive Power be with you!
</td></tr></table>

<sub>_You can view your badges on [your board](https://hivebuzz.me/@beelzael) and compare yourself to others in the [Ranking](https://hivebuzz.me/ranking)_</sub>


**Check out our last posts:**
<table><tr><td><a href="/hive-122221/@hivebuzz/pum-202505-result"><img src="https://images.hive.blog/64x128/https://i.imgur.com/mzwqdSL.png"></a></td><td><a href="/hive-122221/@hivebuzz/pum-202505-result">Hive Power Up Month Challenge - May 2025 Winners List</a></td></tr><tr><td><a href="/hive-122221/@hivebuzz/pum-202506"><img src="https://images.hive.blog/64x128/https://i.imgur.com/M9RD8KS.png"></a></td><td><a href="/hive-122221/@hivebuzz/pum-202506">Be ready for the June edition of the Hive Power Up Month!</a></td></tr><tr><td><a href="/hive-122221/@hivebuzz/pud-202506"><img src="https://images.hive.blog/64x128/https://i.imgur.com/805FIIt.jpg"></a></td><td><a href="/hive-122221/@hivebuzz/pud-202506">Hive Power Up Day - June 1st 2025</a></td></tr></table>
properties (22)
authorhivebuzz
permlinknotify-1748789570
categoryhive-13323
json_metadata{"image":["https://hivebuzz.me/notify.t6.png"]}
created2025-06-01 14:52:51
last_update2025-06-01 14:52:51
depth1
children0
last_payout2025-06-08 14:52:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,309
author_reputation369,197,277,533,997
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,100,922
net_rshares0
@scion02b · 
I'm an ROI nerd as well, but I couldn't figure that out since my Splinterlands costs are all over the place.  Will try to check the downloadable earnings data some time. 

Thanks for sharing!
👍  
properties (23)
authorscion02b
permlinkre-beelzael-sx56kq
categoryhive-13323
json_metadata{"tags":["hive-13323"],"app":"peakd/2025.5.9","image":[],"users":[]}
created2025-05-31 20:07:42
last_update2025-05-31 20:07:42
depth1
children1
last_payout2025-06-07 20:07:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length191
author_reputation7,242,847,053,360
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,086,882
net_rshares8,363,836,461
author_curate_reward""
vote details (1)
@beelzael · 
Awesome! I'm very happy that this is actually helpful! Once you have it figured out, it's quite easy and fast to get it all together :-)
properties (22)
authorbeelzael
permlinkre-scion02b-sx578b
categoryhive-13323
json_metadata{"tags":["hive-13323"],"app":"peakd/2025.5.9","image":[],"users":[]}
created2025-05-31 20:21:48
last_update2025-05-31 20:21:48
depth2
children0
last_payout2025-06-07 20:21:48
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length136
author_reputation157,593,690,320,632
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,087,131
net_rshares0
@splinterboost · 
 <center> This post has been supported by @Splinterboost with a 5% upvote! Delagate HP to Splinterboost to Earn Daily HIVE rewards for supporting the @Splinterlands community!</center> 

 <center> [ Delegate HP ](https://peakd.com/@splinterboost)  | [Join Discord](https://discord.gg/RK4ZHKmgcX) </center>
properties (22)
authorsplinterboost
permlinka-nerd-guide-to-splinterlands
categoryhive-13323
json_metadata{"app":"splinterboost/0.1"}
created2025-05-31 19:48:48
last_update2025-05-31 19:48:48
depth1
children0
last_payout2025-06-07 19:48:48
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length305
author_reputation13,753,405,259,506
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,086,598
net_rshares0
@steemmonsters · 
**Thanks for sharing! - @clove71**
![](https://media.giphy.com/media/W4QD5qT1u6OJV1ENXU/giphy.gif)
properties (22)
authorsteemmonsters
permlinkre-a-nerd-guide-to-splinterlands-20250601t140045z
categoryhive-13323
json_metadata"{"app": "beem/0.24.26"}"
created2025-06-01 14:00:45
last_update2025-06-01 14:00:45
depth1
children0
last_payout2025-06-08 14:00:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length100
author_reputation421,505,852,060,639
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,100,134
net_rshares0
@uwelang · 
Starker Post - jetzt hab ich sogar als früherer OG einiges mehr verstanden - Danke dafür!
👍  
properties (23)
authoruwelang
permlinkre-beelzael-sx6875
categoryhive-13323
json_metadata{"tags":["hive-13323"],"app":"peakd/2025.5.9","image":[],"users":[]}
created2025-06-01 09:40:18
last_update2025-06-01 09:40:18
depth1
children7
last_payout2025-06-08 09:40:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length89
author_reputation820,967,108,388,339
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,096,644
net_rshares8,355,989,383
author_curate_reward""
vote details (1)
@beelzael ·
$0.22
Freut mich, dass er dir gefallen hat! Gerade weil du ein OG bist, dann ist das Kompliment noch schöner 🙃 

Es gabe einige Frustrationen (besonders dieser 1.000.000 Mist und herauszufinden, wie genau ich die Battle & Brawls errechnen kann), aber es hat echt viel Spaß gemacht, mal wieder etwas neues zu lernen. Als nächstes geht es dann daran, die trockenen Daten besser darzustellen - wie azircon schreibt, bessere plots und diagramme :-)

Dieses mal habe ich versucht, es mit den Bildern und ein bisschen Humor aufzufrischen. Auch ein bisschen HTML habe ich schon einbinden können. Aber es visuell besser zu gestalten ist das Ziel, weniger Wörter, aber gleiche oder sogar mehr Aussagekraft. Schritt für Schritt!
👍  
👎  
properties (23)
authorbeelzael
permlinkre-uwelang-sx6h7f
categoryhive-13323
json_metadata{"tags":["hive-13323"],"app":"peakd/2025.5.9","image":[],"users":[]}
created2025-06-01 12:55:00
last_update2025-06-01 12:55:00
depth2
children6
last_payout2025-06-08 12:55:00
cashout_time1969-12-31 23:59:59
total_payout_value0.108 HBD
curator_payout_value0.108 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length712
author_reputation157,593,690,320,632
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,099,026
net_rshares668,585,536,059
author_curate_reward""
vote details (2)
@uwelang · 
Schaut super aus und Daten sind auch mein "Business" - bei SPL war ich zu Alpha Zeiten drin, hatte alle Karten max bis inkl. Rebellion und dafür Hive Stake genutzt - nun aber leider - diverse Gründe, die ich nicht hier darlegen möchte, die Jungs die  ich kennen wissen warum - geh ich den Weg zurück aus packe alles in Hive wieder :-). Hab nur noch SB Karten und bisserl Rest CL / Rebellion und Land, von daher bin ich nicht weg aber kein SPL Wal mehr wenn man das so nennen kann. 

Ich finde Deine Lebensstory spannend, Migration Ecudaor - Bakery - klingt super interessant.
👍  
properties (23)
authoruwelang
permlinkre-beelzael-sx6hwd
categoryhive-13323
json_metadata{"tags":["hive-13323"],"app":"peakd/2025.5.9","image":[],"users":[]}
created2025-06-01 13:09:51
last_update2025-06-01 13:09:51
depth3
children3
last_payout2025-06-08 13:09:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length576
author_reputation820,967,108,388,339
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,099,248
net_rshares8,421,336,532
author_curate_reward""
vote details (1)
@uwelang · 
Habe es aber nie geschafft mal ne Saison zu gewinnen, sowohl Modern wie Wild war maximal Platz 2 drin, das ärgert mich noch immer (und wenn ich sehe, dass ich seit 7 Jahren im Spiel bin kommt fast Nostalgie auf :-)!)


![image.png](https://files.peakd.com/file/peakd-hive/uwelang/23tGXhPan9UTVHqW8PJrQjT5Jct9xCENvLiNxUKFvTSi13ouh9AQSys3P1mswqmtWEs8D.png)
👍  
properties (23)
authoruwelang
permlinkre-beelzael-sx6p51
categoryhive-13323
json_metadata{"tags":["hive-13323"],"app":"peakd/2025.5.9","image":["https://files.peakd.com/file/peakd-hive/uwelang/23tGXhPan9UTVHqW8PJrQjT5Jct9xCENvLiNxUKFvTSi13ouh9AQSys3P1mswqmtWEs8D.png"],"users":[]}
created2025-06-01 15:46:15
last_update2025-06-01 15:46:15
depth3
children1
last_payout2025-06-08 15:46:15
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length355
author_reputation820,967,108,388,339
root_title"A Nerd Guide to Splinterlands"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id143,102,270
net_rshares8,253,891,002
author_curate_reward""
vote details (1)
Help/Feedback