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/
This page is synchronized from the post: ‘Guess Steem Price - Winners Announcement’