a 9j@sldZddlZddlZddlZddlZddlZejddddlZ dZ dZ ddZ dd Z ed krhe dS) aHow often does a stranded 2-of-3 book get rescued in play? MOQSBA sold home 35c and away 33c pre-match, stranded on the draw, then the game stayed 0-0, the draw drifted to 52c, and our resting offer was lifted there -- 120c collected, +20c locked. The bar is lower than it looks. If home and away were sold at their touches, the book needs the draw to fetch roughly 1.015 - (h + a) ~= d_prematch - 0.005 so the draw only has to hold its own pre-match price, not appreciate. Since the maker now works books for 3 hours after kickoff, the question is simply: how often does the in-play draw reach its pre-match level? Measured on live_data, which carries both pre-kickoff and in-play snapshots. NzE:\soccer\mainzE:\soccer\live_datac CsHz*t|}d|krdkr&nn|ndWSttfyBYdS0dS)Nr)float TypeError ValueError)xvr $E:\soccer\research\mm_draw_rescue.py_fs "r c sRtddttDt d}tt}tt}|D]}ttj t|ddd}t |D]}| d}|dvrzqbz t|}WntyYqbYn0| d| d | d f}|d krt| d }|dur||||fqbt| d } | durb||| qbWdq:1s(0Yq:g} |D]|\} } | | } | r@t| dkrjq@t| tdd| D}tfddt| Dd}| |||kdq@t| }|dkrtd|ddStdd| D}t|dtd|d|dd||ddtdd| D}|rtd|t|dd d!|t|d"d d#|dt|d"d ttd$d%D]T\}tfd&d| D}|rtd'|d(d)|d*dd||d+dqtd,d| D}td'd-d(d)|d*dd||d+dtd.td/td0td1dS)2Ncss|]}|dr|VqdS)z.csvN)endswith).0fr r r $zmain..zutf-8replace)encodingerrorselapsed)NZ game_datehomeZawayrZkalshi_draw_midZkalshi_draw_askcss|]\}}|VqdSNr )r _mr r r rBrc3s|]\}}|kr|VqdSrr )r er)d0r r rDr)rpeakfirstreached2zonly z/ fixtures with both pre and in-play draw pricescss|]}|drdVqdS)rrNr r rr r r rLrz3 fixtures with pre-kickoff and in-play draw prices z- in-play draw reaches its pre-match price : /z (gY@z.1fz%)css"|]}|ddur|dVqdS)rNr r!r r r rPrz4 when it first gets there (minutes) : median z.0fz, p25 z, p75 z1 how far above the pre-match price does it peak:))r皙?z+0-5c)r&333333?z+5-15c)r'333333?z+15-30c)r( z +30c or morec3s6|].}|d|dkr&krnqdVqdSrrrNr r!)hilor r rZrz z>14 z>4z>4.1fcss"|]}|d|dkrdVqdSr*r r!r r r r]rz never reacheszC The 3h in-play window covers the whole match, so a book strandedzC on the draw gets this entire distribution as its second chance --zC provided the offer is left resting, which is what the HOLD changez1 does. Cancelling on abandon forfeits all of it.)sortedoslistdirLIVE_DIRDAYS collections defaultdictlistopenpathjoincsvZ DictReadergetrrr appenditemslen statisticsZmedianmaxnextprintsum)filesZpreZlivefnZfhr"ZelkeyraZrowskZpsZlsrrnZhitZfirstsZlblcZbelowr )rr+r,r main#s"      2      .*rJ__main__)__doc__r9r3r/r>sysr7insertZ mm_settleSr1r2r rJ__name__r r r r s(C