A first chart of the BEER token

in #beer4 years ago

Hey Steeminas, dear BEER lovers

today I got the fun to play with some cool steem functions.

The wonderful @bluerobo explained in his post https://steemit.com/chart/@bluerobo/se-charts-beer ho to handel the source informations and I did a bit Excel around this.

Chart from 26th of Mai to 8th of October

chart of BEER 20191008 221819.png

Here you see
Daily High - the green line with red dots
Daily Low - the blue line
Daily Trade Volume of Steem - the grey graph
Trendline of Daily High the red doted line

This is the first version

This is the first try and we will find a way to optimize the graph and all the related information.
If anybody like to have the source of my excel, please contact me


Yes, you might do this with any other token as https://steemit.com/@bluerobo shows in his blog. Go there and follow him!

How to do this

actually, I feel a bit bad, as I copied all this from @bluerobo, but as I mention him for his great work, he might be not to angry. ;-)

Just 4 steps to get the data

  1. This is the call I used for the above data: https://api.steem-engine.com/history/marketHistory?symbol=BEER
  2. 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
  3. 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.
  4. Than I did my Excel magic

Another graph from @bluerobo

Stay tuned for more information

The team behind this - mainly fun and community orientated - token is working on some tools and will be ready soon.

Prost Santé! Cin cin! Proost! Cheers! Kippis! Kanpai! Kanpai!! Kanpai

This is Not an Investment Advice only some information about a fun token we like to grow to a price of a real beer. Nobody knows if this will work - but it would be damn f#cking cool!

if you like fun and beer and blockchain,
have a look to the BEER token

Enjoy the BEER token


Your thirsty @BeerLover


I appreciate you quoting the steps.
We need charts of SE tokens in order to make decisions.
That's why I tried to make it as easy as possible for everybody to do it on their own.

Posted using Partiko Android

Fully agree and count on my beery support.

Prost with a Jupiler in my hand

you should show @aggroed ... wonderful tool.. would be great if steem engine could do this automatically

Hi @aggroed, this is something we like to add to the Steem-Engine.

Would be lovely!

This post deserves !BEER. Keep going!

This post has been included in the latest edition of The Steem News - a compilation of the key news stories on the Steem blockchain.

Love this. I've been pushing !BEER hard for supporting commentors on posts.

You post has been manually curated by BDvoter Team! To know more about us please visit our website or join our Discord.

BDvoter Team

passendes Lied für dich

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

Congratulations @beerlover! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

You made more than 30000 comments. Your next target is to reach 31000 comments.

You can view your badges on your Steem Board and compare to others on the Steem Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

To support your work, I also upvoted your post!

Do not miss the last post from @steemitboard:

The new SteemFest⁴ badge is ready

You can upvote this notification to help all Steem users. Learn how here!

Coin Marketplace

STEEM 0.25
TRX 0.14
JST 0.033
BTC 51299.48
ETH 3087.33
USDT 1.00
SBD 4.11