As it happens, my chart posts cluttered up real fast. Admin is important but sparks no joy.
Therefore I decided to spin out the dreadful links into this separate post.
Helpful links to navigate SE tokens:
Look up transactions and orders of a particular token:
Look up the distribution of tokens between accounts:
Look up all tokens issued from one accout:
Yes. That's right. You can issue Banjo tokens in Discord!
If you want to make charts on your own, go ahead and do it. It only takes a few, easy steps. Basic Excel skills is all you need. Mainly formatting data and plotting.
harpagon made two posts on how to pull .json data from the API.
These are the steps to create your own charts:
- This is the call to get data: https://api.steem-engine.com/history/marketHistory?symbol=ONECENT
- Convert the raw .json data into .csv: https://json-csv.com/
- Convert the time stamp from Unix Time into human time in Excel with this formula:
=(((B2/60)/60)/24)+DATUM(1970;1;1)B2 is a placeholder for the cell to be converted
- Depending on your country settings you might have to convert the decimal format from '.' to ',' (from point to comma). It may be necessary to specify the format of date and numbers columns.
- Excel charting magic happens here
- ^help - provides a list of commands
- ^chart leo - creates chart
- ^chart7 leo - charts the last 7 days
- ^chart30 leo - charts the last 30 days
- ^chartlim leo 0.5 - caps the chart at 0.5 when spikes are too distorting
- ^buyers leo - lists top 10 buyers during the last 24 hours
- ^sellers leo - lists top 10 sellers during the last 24 Hours
- ^historycsv leo - returs history in a csv format
- ^compare leo - adds a token in a comparing queue. Add further tokens by repeating the command
- ^clearcompare - clears out the tokens.
@holger80 compiled a list of essential data about different tribes and also how much stake you need to be a Plankton, Minnow, Dolphin, Orca or Whale:
What is the amount of staked tokens to became a Minnow, Dolphin, Orca or Whale for a Scot Tribe - 2019-09-11?
Posted using Partiko Android