Splinterlands Statistics v0.3.1 (Generate season hive blog)

Words
1031
Reading
5 min
Listen
Play
3y

Introduction

Just released a new version of the splinterlands statistics v0.3.0. In this version the major update is that you can generate a hive blog from your last season.

Previous post was about the new filter feature that was added.


On the last post I got a comment why not make the tool available in the cloud. Currently there're two main reasons why not.
  • First, the tool needs to be updated with account management, this is achievable.
  • Secondly this offline method is an way I can keep it free. When it is in the cloud I might need to charge a fee to be able to use it.

For now I keep it like this, I might try to implement something in future or think of an hybrid solution to keep it free.


Main features of this splinterlands statistics tools are:

  • Capture battle history Win and Loss matched
    • What are your best cards
    • What are the cards you lose the most against.
  • Tracking your season results in playing and earnings
    • Generate hive blog of last season
  • Tracking your portfolio, investment and value
  • Your nemesis (fun statistic)
  • Rating over time

What is new...

  • Fix crash when no battles are played for a day
  • Separated market_purchases in buy_market_purchases and sell_market_purchases
    • Necessary to reload all seasonal data this can be done by delete all csv files that start with season_
    • restart application
    • Update season information again
  • Add generate hive blog
  • Add option to use environment variables STORE and DEBUG
    • Store is create a separate store e.g. one for main account one for alt accounts
    • Debug is used to switch between development and production more easily without code modification (debug of flask, auto reload code)

Lets elaborate a bit on the new features

Separated market_purchases in buy_market_purchases and sell_market_purchases

If you already used the tool and have a store you might consider removing all season files and collect them again.
⚠️ To fully benefit of this new data collection method remove old season_* files.
Then start the application and on the season page press update season

image.png

⚠️ Because the removal of the season files it need to recollect all historical data this will take a while.

Result:

image.png


Main new feature of this release is the generate hive blog

The intention is that you generate a default report you can copy it to you favorite blog platform and paste it there. Then adjust/modify/add images make it your own creative post.

image.png
First select for which accounts you would like to generate an report.
When you press the "Generate" button it will retrieve some extra information like which tournaments you have played/last earnings packs potions and which card purchased sold.

image.png

image.png

image.png

image.png

Complete example report Tracking my result for season 113 : beaker007, shinoumonk, beakerr

You could also decide to only use some tables you like e.g.:

Season statistics table
Statistic
     Wild

     Modern
BattlesNA363
RankNA61
RatingNA - NA3699 - DIAMOND_I
Rating HighNA3753
Ratio (Win/Loss)NA (NA/NA)1.07 (188/175)
Win PCT (Wins/battles * 100)NA (NA/NA)51.79 (188/363)
Longest StreakNA13
Earning table
Earnings#
DEC market selldec.png 6164.975
SPS staking rewardsps.png 175.933
SPS token award (pools)sps.png 35.646
SPS ranked battle (modern)sps.png 310.229
SPS daily focussps.png 356.784
SPS seasonsps.png 83.412
SPS nightmare (TD)sps.png 3.738
SPS brawlsps.png 72.314
MERITS quest rewardmerits.png 5841.0
MERITS season rewardsmerits.png 3021.0
MERITS brawl prizesmerits.png 5900.0
VOUCHER earnedvoucher.png 14.268
Legendary potionslegendary.png 379
Gold potionsalchemy.png 314
CL PackschaosPack.png 6.0

Showcase some other features...

Tracking your complete portfolio value and view how your editions are valued:

image.png

View you staked SPS value over time and zoom in:
image.png

Summarized seasonal earning:
eos-earnings.png

Seasonal battle statistics:

image.png

What is next...

Update portfolio page:

  • separate values and quantities
  • add tracking of card edition values/bcx/number of cards.
  • make main chart selectable display widgets with:
    • card
    • dec
    • sps / staked sps
    • land
    • others

Future updates ideas:

  • Update season page, also separate value and quantities
  • Create specific card page with detail battle history for a single card you own

How to use splinterlands statistics

⚠️When this tool is used for the first time and you are collecting seasonal data it has to retrieve all historical data, this can take a very long time, depnding on how long you have played the game and how many transaction are done. Especially when a renting bot is used it probably has many small DEC transaction.

With windows executable

With linux executable

With Docker

docker login ghcr.io --username your_github_username
docker pull ghcr.io/gamerbeaker007/splinterlands-stats-v2:latest

Windows (docker):

docker run -p 8050:8050 -e "HOST=0.0.0.0" -it -v C:\Temp:/app/store ghcr.io/gamerbeaker007/splinterlands-stats-v2:latest

Linux (docker):

docker run -p 8050:8050 -e "HOST=0.0.0.0" -it -v \tmp:/app/store ghcr.io/gamerbeaker007/splinterlands-stats-v2:latest

With python development or local execution

Download source and unpack, source link.
Use python 3.8 or higher.
pip install -r requirements.txt
python src/main.py

When installing on a window machine and encounter this error message:
scrypt-1.2.1/libcperciva/crypto/crypto_aes.c(6): fatal error C1083: Cannot open include file: 'openssl/aes.h': No such file or directory
Then install Win64 OpenSSL (not the light version)

Disclaimer

This is an hobby project that I do in my spare time.
Why:

  • I love to dive into data for a game I love to play. In the future hope to see nice improvements in my playstyle because of the data analysis.
  • Secondly practice my programming skills and keep it up to date.

In the future I will try to migrate data with newer updates but expect that sometimes you got to start over with collecting data, I cannot/will not make any promises. I just add stuff I like to view and hope others can appreciate it.

Big caveat, not sure yet how it will perform with large datasets.

Everybody can start using this, since it is a new project expect some crashes or things that are not working for your situation.
As normal when you run into problems send me a message and I will try to help solving the issue.

Any suggestions/remarks/improvements or bugs please leave a comment or send me a message

That's all for this week hope you enjoyed reading and all start tracking data to get more insights.
See you all on the battlefield.

Not a splinterlands player yet, consider using my refferal link.

Splinterlands Statistics v0.3.1 (Generate season hive blog) | Ecency