Guess Steem Price - Winners Announcement

in #contest5 years ago


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:

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 价竞猜游戏 已经落幕,成绩分别是:

有点遗憾的是,并没有我熟悉的朋友在内。而值得庆幸的是,过程中发现了一些马甲号来参赛,但是这三位的参赛都没有问题。再一次,为大火的踊跃参与道谢咯。


Posted from my blog with SteemPress : https://fr3eze.vornix.blog/guess-steem-price-winners-announcement/

Sort:  

哎呀呀~就差一点点~

差一点点可就很远啦,这是六个小数位啊。

谢谢你的这项竞猜项目 :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:
  • Some people are already following you, keep going!
  • The readers like your work!
  • Try to improve on your user engagement! The more interesting interaction in the comments of your post, the better!

Feel free to join our @steem-ua Discord server

Coin Marketplace

STEEM 0.35
TRX 0.12
JST 0.040
BTC 70797.92
ETH 3553.00
USDT 1.00
SBD 4.76