Guess Steem Price - Winners Announcement

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

chrome_2018-11-05_18-54-55.png

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!

EXCEL_2018-11-05_20-02-00.png

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’

Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×