HSX Forum

Playing & Trading Strategy

Announcing the beta version of the HSXsanity box office database, with adjust and delist estimators for you to try.

Posted by: RogerMore on Feb 24, 14:20

I'm making my box office database available on Google Drive. It's a huge file, but the new Google Sheets is much faster at loading and calculating so I think it should work out.

It has daily box office data on almost every wide release since HSX started, a bunch of calculations based on that data and tools for estimating weekend adjusts and delists.

Here's a link to the beta version for anyone who wants to try it out.

https://docs.google.com/spreadsheets/d/1O0sNH_An1oCqxZQo0hd1v6lq0KTw1uCODh4_UflRA8Y/edit?usp=sharing

Opening the link will let you see it, and if you copy a version into your Google Drive, you can edit it and test out calculators.  There are instructions on how everything works in the Info tab.

If you have time, I'd also appreciate some feedback on the workings of the spreadsheet - What other information would be useful? Are the calculators intuitive and easy to use? Could any of the labels be made clearer? etc.  Please provide any comments you have in the spreadsheet

Announcing the beta version of the HSXsanity box office database, with adjust and delist estimators for you to try. RogerMore Feb 24, 14:20

um, holy crap this is amazing? {nm} Moviesnob Feb 24, 14:38

Wow, good stuff!! {nm} eyescovered Feb 24, 18:35

finally had a chance to take a peek...holy smokes! {nm} tealfan Feb 24, 22:41

oh...and thanks for doing this! {nm} tealfan Feb 24, 23:34

That is awesome. You've really outdone yourself. Thanks! {nm} Willroast Feb 24, 22:43

2 competitor kaigee {nm} mike255 Feb 25, 06:58

Hmm, every interesting. I could implement a nice regression model on all that data, and do BO predictions. {nm} elchan2012 Feb 25, 07:01

Yeah, letting the number-crunchers have a go at that sort of stuff and seeing the result is one of my main motivations for sharing the info. RogerMore Feb 25, 07:55

So you've run Linear Regressions? I guess it a matter of identifying the right set of features to get the best fit. elchan2012 Feb 25, 15:33

Only to see what relationships there are between early indicators and delist. RogerMore Feb 25, 17:04

(So I think you can do it with two factors - target audience and level of audience interest) {nm} RogerMore Feb 25, 17:07

This data is a little more complicated. I'm going to work on a regression for the predictions database you have above, first. {nm} elchan2012 Feb 25, 19:47

(Actually, Three - I forgot "time of year") {nm} RogerMore Feb 26, 03:52

Wow..that's a lot of work...thanks for the effort...much appreciated! {nm} Flash Feb 25, 09:51

WOWZER - That's Impressive. A Tip O' The Hat. {nm} RotoHockeyYTD2014 Feb 25, 19:03





Post a Reply

To post to the forums you must first login!


Flavia (FLAVI) 1 3.48 (-0.66)          White Lies (WHTLI) 50000 9.83 (-0.17)          The Last Druid (TLDRU) 150000 5.00 (0.00)          The Catch (TCATC) 100000 69.17 (-0.45)          The Catch (TCATC) 150000 69.17 (-0.45)          Wonder Woman (WOND3) 150000 43.40 (-0.20)          Skeletons (SKLTN) 149975 22.49 (+0.24)          The Catch (TCATC) 149975 69.17 (-0.45)          Supergirl (SUPGR) 1000 124.62 (-4.76)          Couture (STCHS) 1000 1.38 (-0.12)          Lucky Strike (LCKYS) 1000 4.64 (-0.51)          The Last Druid (TLDRU) 150000 5.00 (0.00)          The Get Out (BEARC) 1000 2.75 (-0.37)          Lucky Strike (LCKYS) 150000 4.64 (-0.51)          Lucky Strike (LCKYS) 150000 4.64 (-0.51)          Scary Movie (SCAR6) 43139 104.80 (+2.36)          The Last Druid (TLDRU) 150000 5.00 (0.00)          Doppelganger (DPLGN) 20000 74.79 (+0.54)          Scary Movie (SCAR6) 29739 104.80 (+2.36)          Paper Tiger (PTIGR) 149975 23.29 (-0.03)          The Last Druid (TLDRU) 150000 5.00 (0.00)          Scary Movie (SCAR6) 29739 104.80 (+2.36)          The Worst (TWORS) 150000 7.05 (-0.24)          The Last Druid (TLDRU) 150000 5.00 (0.00)          It Ends (ITNDS) 150000 5.23 (-0.11)          It Ends (ITNDS) 150000 5.23 (-0.11)          Supergirl (SUPGR) 4 124.62 (-4.76)          Scary Movie (SCAR6) 39341 104.80 (+2.36)          White Lies (WHTLI) 150000 9.83 (-0.17)          Sense and Sensibility (SNSNS) 150000 19.11 (-0.45)          Sense and Sensibility (SNSNS) 150000 19.11 (-0.45)          White Lies (WHTLI) 150000 9.83 (-0.17)          Motor City (MTRCT) 150000 8.27 (-0.19)          Motor City (MTRCT) 150000 8.27 (-0.19)          4 x 4: The Event (4X4TE) 150000 8.49 (+0.18)          4 x 4: The Event (4X4TE) 150000 8.49 (+0.18)          Above The Below (ABELW) 150000 7.14 (+0.08)          Above The Below (ABELW) 150000 7.14 (+0.08)          The Last Druid (TLDRU) 150000 5.00 (0.00)          Romy & Michelle 2 (ROMY2) 150000 3.97 (+0.04)          Ecto aka Ghostbusters animated (GBUST) 150000 4.60 (+0.01)          Broadsword (BROSW) 150000 44.64 (+1.08)          Broadsword (BROSW) 150000 44.64 (+1.08)          The Thing That Hurts (TTTHU) 150000 1.42 (+0.02)          A Winter's Journey (AWNTJ) 150000 1.28 (+0.02)          Merrily We Roll Along (MWRA) 150000 0.84 (+0.02)          Anything But Ghosts (ANYBG) 150000 24.47 (-0.06)          Baby Driver 2 (BDRV2) 150000 2.19 (+0.02)          Just Watch Me (JUSWM) 150000 2.10 (+0.04)          Voyagers (VOYGR) 150000 1.78 (+0.02)