stephanakkerman/axie-scholar-stats

Uses Google Spreadsheets to always keep track of historical data of your scholars in Axie Infinity. Includes tons of information and a clear overview of what your scholars are up to.

Scholar Stats

This is a simple python script for saving the historical data of your scholars.

Features

Overview of:

• Daily SLP
• Daily $
• Daily Average SLP
• Total SLP
• Total $
• Manager Share SLP
• Manager Share $
• Scholar Share SLP
• Scholar Share $
• SLP Price
• Daily overview of SLP on scholars accounts
• Specific overview of every scholar For more see the screenshots below.

Dependencies

The required packages to run this code can be found in the requirements.txt file. To run this file, execute the following code block:

$ pip install -r requirements.txt 

Alternatively, you can install the required packages manually like this:

$ pip install <package>

Setup

Start by cloning the repository.

Next, get your authentication.json file, by following the steps below carefully. Or follow the instructions from this (starts from 1:58) video

If you prefer written instructions follow the instructions below:

• Enable API access for the new project instructions.
• Creating the authentication.json file instructions.

After follow the instructions above, last things you need to do is this:

• Save your authentication.json file in the same folder as you saved the files for this script.
• Open authentication.json and copy the email behind "client_email":
• Open Google Drive and go to the folder that you want the bot to make the spreadsheets in, right click on that folder and press share
• Share the folder with the client email out of authentication.json

Then after that is done, go to the folder where this repository is stored and execute the following code block:

python src/setup.py

This will setup the Spreadsheet and worksheet for you in Google Drive. After doing that you will need to fill in the information of your scholars. If you are not sure what you should fill in here, check the examples below.

If you filled out the information you are done and at last you need to execute this code:

python src/main.py

Note

The same method as described here is also used for setting up our Discord bot. So if you would like to have a Discord bot to manage your scholars, be sure to check out that repository.

Examples

This is how your "Scholars" worksheet should look like if you want the basic functioning:

After running this the code this is how your spreadsheet should look like:

axie-scholar-stats's Issues

Improve readme

Fix SLP today

Improve dataframe data handling

• Remove the loop
• Remove dictionary for manager and instead filter based on manager
• Do calculations using pandas

Implement automatic payments

Use xyz's code for automatic payments and run it every once in a month

Automatically create a new spreadsheet for new managers

Drop existing for scholar if in_game_slp < last existing in_game_slp

Add Energy, PVP wins, PVE wins PVE SLP, Quest (bool) to overview

Check image below as reference
https://media.discordapp.net/attachments/895277748745019442/899284708263854130/summary1634474064.png

Fix this

Exception in thread Thread-18:
Traceback (most recent call last):
File "/usr/lib/python3.7/threading.py", line 917, in _bootstrap_inner
self.run()
File "/usr/lib/python3.7/threading.py", line 1166, in run
self.function(*self.args, **self.kwargs)
File "Scholar_Stats.py", line 48, in get_stats
updated_on = datetime.datetime.utcfromtimestamp(wallet_data["cache_last_updated"]/1000).strftime('%m-%d, %H:%M')
KeyError: 'cache_last_updated'

Add column for lifetime slp to scholar and overview