Guess Steem Price - Winners Announcement
The result is $0.796711
So the final result the market has given us is here, Close Price of Steem in term of USD on 4 Nov 2018(UTC time) = $0.796711 which can be verified under CMC Steem page.
Original contest post: https://steemit.com/steem/@fr3eze/i-m-a-dolphin-finally-giveaway-30-steem-as-celebration-or
Participant listing: https://steemit.com/contest/@fr3eze/guesssteempricecontestparticipantslisting-v7dum3cz5u
Sorting the winners out
This part would explain how the winners are being filtered and finalized:
1] Used SQLSteem to query the total entries under the original contest post using LINQPad5.
SELECT
last_update, author, body
FROM
Comments (NOLOCK)
WHERE
parent_permlink LIKE 'i-m-a-dolphin-finally-giveaway-30-steem-as-celebration-or' and
last_update < '11/2/2018 11:59:00 PM'
2] Export the result to Excel without formatting. Trimmed down excessive cells and rows in manually and produce 1 account align with 1 answer per row.
3] I was struggling finding a programmatic way to extract numbers(prediction) from the body of comment consists of string and numbers. This formula does help a lot:
=CONCATENATE("0.", SUMPRODUCT(MID(0&C26, LARGE(INDEX(ISNUMBER(--MID(C26, ROW(INDIRECT("1:"&LEN(C26))), 1)) * ROW(INDIRECT("1:"&LEN(C26))), 0), ROW(INDIRECT("1:"&LEN(C26))))+1, 1) * 10^ROW(INDIRECT("1:"&LEN(C26)))/10))
4] Once I got the numbers-only column, added one result row in anywhere and sorted everything in small to the big order. The closest 3 rows to the result row would be our winners.
5] Verification of the winners including objectively judging if their account is duplicate or bot or not, did they upvoted the post or not, and so on. Fortunately, although I do not know all the 3 winners before the contest, their entries are valid.
Congratulations to the winners!
The first prize winner was just $0.000291 away from the correct Steem price while the third prize winner was $0.001027 away. The prizes would go to the following winners:
- @divine-sound - First place(15 STEEM)
- @tonygreene113 - Second place(10 STEEM)
- @dernierdiaz - Third place(5 STEEM)
Prizes would be sent shortly after this post. Once again, thanks for the participants and let's keep each other active on the platform!
前几天举办的Steem 价竞猜游戏 已经落幕,成绩分别是:
- 首奖 - @divine-sound
- 二奖 - @tonygreene113
- 三奖 - @dernierdiaz
有点遗憾的是,并没有我熟悉的朋友在内。而值得庆幸的是,过程中发现了一些马甲号来参赛,但是这三位的参赛都没有问题。再一次,为大火的踊跃参与道谢咯。
Posted from my blog with SteemPress : https://fr3eze.vornix.blog/guess-steem-price-winners-announcement/
哎呀呀~就差一点点~
差一点点可就很远啦,这是六个小数位啊。
谢谢你的这项竞猜项目 :D
哈哈,没什么好谢的吧,玩的开心就好。
For the first time in my life I am feeling lucky enough. Thank you for this contest sir.
But sir I checked my wallet, I did not receive 15 steem.
Now you do, congratulations!
Thank you sir.
Thanks for allowing ne tho opportunity.
Posted using Partiko Android
Your are welcome. Congratulations!
Hi @fr3eze!
Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your UA account score is currently 4.045 which ranks you at #3437 across all Steem accounts.
Your rank has improved 36 places in the last three days (old rank 3473).
In our last Algorithmic Curation Round, consisting of 243 contributions, your post is ranked at #143.
Evaluation of your UA score:
Feel free to join our @steem-ua Discord server