Marie Kondo is making SE Charts joyful again

in chart •  4 months ago  (edited)

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:

https://steem-engine.rocks/transactions?symbol=ONECENT

Look up the distribution of tokens between accounts:

https://steem-engine.rocks/tokens/ONECENT/richlist?sort_field=balance&sort_order=desc

Look up all tokens issued from one accout:

https://steem-engine.rocks/@banjo

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.

Here is post 1 and post 2.

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

@gerber helps to feed your Instant Gratification Monkey with a Discord bot on the Steemleo server for Steem-Engine tokens.
gerber is costatly adding new useful commands:

  • ^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

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Hi @bluerobo, a small upvote and a tip.
$trendotoken
Thanks for playing the ADDAX trading game!

Congratulations @addax, you are successfuly trended the post that shared by @bluerobo!
@bluerobo got 0.54761400 TRDO & @addax got 0.36507600 TRDO!

"Call TRDO, Your Comment Worth Something!"

To view or trade TRDO go to steem-engine.com
Join TRDO Discord Channel or Join TRDO Web Site

Thank you so much for being an awesome Partiko user! We have just given you a free upvote!

The more Partiko Points you have, the more likely you will get a free upvote from us! You can earn 30 Partiko Points for each post made using Partiko, and you can make 10 Points per comment.

One easy way to earn Partiko Point fast is to look at posts under the #introduceyourself tag and welcome new Steem users by commenting under their posts using Partiko!

If you have questions, don't feel hesitant to reach out to us by sending us a Partiko Message, or leaving a comment under our post!

Thank you so much for being an awesome Partiko user! You have received a 34.92% upvote from us for your 3435 Partiko Points! Together, let's change the world!

Have a non cluttering !BEER



Hey @bluerobo, here is a little bit of BEER for you. Enjoy it!

I had to search for it, but it is an interesting Lifehack story:
https://en.wikipedia.org/wiki/Marie_Kondo

Marie Kondo
Marie Kondo (近藤 麻理恵, Kondō Marie, born 9 October 1984), also known as Konmari (こんまり), is a Japanese organising consultant and author.Kondo has written four books on organising, which have collectively sold millions of copies and have been translated from Japanese into several languages including Korean, Chinese, Spanish, Indonesian, Italian, French, German, Swedish, Portuguese, Catalan and English. In particular, her book The Life-Changing Magic of Tidying Up (2011) has been published in more than 30 countries. It was a best-seller in Japan and in Europe, and was published in the United States in 2014.In the United States and United Kingdom the profile of Kondo and her methods were greatly raised by the success of Netflix series Tidying Up with Marie Kondo, released in 2019 for which Kondo was nominated for the Primetime Emmy Award for Outstanding Host for a Reality or Competition Program.She was listed as one of Time's "100 most influential people" in 2015.

Drink a !BEER while hacking your life

Posted using Partiko Android

You try to disable your charting competitors with all this beer. :)
It's cold out there, any !WINE ? Or !SCHNAPS with the !BEER ?

I see !BEER as an incentive. After all, I'm doing this because I shouldn't need to. Steem Engine should have a button for that.
But please no TA! We already have enough of that.

Posted using Partiko Android



Hey @deathcross, here is a little bit of BEER for you. Enjoy it!

Sorry, you don't have enough staked BEER in your account. You need 6 BEER in your virtual fridge to give some of your BEER to others. To view or trade BEER go to steem-engine.com



Hey @deathcross, here is a little bit of BEER for you. Enjoy it!