Hey Steeminas, dear BEER lovers
today I got the fun to play again with some cool tools.
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 19th of October
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 week facts
We had again only a little grow, but this is fine as more and more people buy and sell
This week high in was 0.44 Steem for a
BEER and this week low 0.299 Steem for a
Trend is still a little up and let's see what next week brings
How to do this with any SE token
I copied the idea from @bluerobo, but as I mention him for his great work, he might be happy. ;-)
Just 4 steps to get the data
- This is the call I used for the above data: https://api.steem-engine.com/history/marketHistory?symbol=BEER
- 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.
- Than I did my Excel magic
Chart from 26th of Mai to 8th of October
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.
if you like fun and beer and blockchain,
have a look to the BEER token