A first chart of the BEER token

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://goldvoice.club/steem/@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

Comments 15

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

08.10.2019 20:57

Fully agree and count on my beery support.

Prost with a Jupiler in my hand

08.10.2019 21:03

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

08.10.2019 21:14

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

Would be lovely!

08.10.2019 21:38

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

BDvoter Team

08.10.2019 21:15

BEER to the moon?

08.10.2019 21:22

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

08.10.2019 22:24

View or trade BEER.

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

08.10.2019 22:24

passendes Lied für dich

08.10.2019 22:44

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

09.10.2019 16:00

This post deserves !BEER. Keep going!

09.10.2019 19:40

View or trade BEER.

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

09.10.2019 19:40

Beer price is getting back on track and it has an uptrend which I hope it will keep going on that way. Ensuring the beer price from crypto as a phenomenal idea and I hope to enjoy that someday!

Always cheers with !BEER

12.10.2019 11:38

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

12.10.2019 11:39