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!


The Odyssey (ODYSE) 50 309.66 (-0.01)          Alpha (ALPH1) 1000 1.42 (+0.03)          Flavia (FLAVI) 10000 3.43 (-0.71)          Damian Lewis (DLEWI) 25000 30.85 (-0.12)          Jackass: Best and Last (JCKA6) 150000 42.45 (-3.24)          Jackass: Best and Last (JCKA6) 150000 42.45 (-3.24)          Supergirl (SUPGR) 150000 124.65 (-4.73)          Jackass: Best and Last (JCKA6) 150000 42.45 (-3.24)          Supergirl (SUPGR) 150000 124.65 (-4.73)          Damian Lewis (DLEWI) 25000 30.85 (-0.12)          The Magic Faraway Tree (TMFAT) 150000 9.57 (+0.68)          Minions & Monsters H$75 Put (MNIO3.PU) 25000 1.03 (-0.12)          The Magic Faraway Tree (TMFAT) 150000 9.57 (+0.68)          Minions & Monsters H$75 Call (MNIO3.CA) 25000 6.08 (+0.27)          Chris Messina (CMESS) 25000 22.42 (+0.25)          Chris Messina (CMESS) 25000 22.42 (+0.25)          Man of Tomorrow (SPMOT) 150000 270.86 (-2.68)          Jackass: Best and Last (JCKA6) 150000 42.45 (-3.24)          White Elephant (WELEP) 150000 13.98 (+0.45)          The Last Druid (TLDRU) 150000 5.00 (0.00)          White Elephant (WELEP) 150000 13.98 (+0.45)          Metal Gear Solid (MTLGR) 150000 14.18 (+0.59)          Colin Jost (CJOST) 25000 34.26 (-0.87)          Metal Gear Solid (MTLGR) 150000 14.18 (+0.59)          Colin Jost (CJOST) 25000 34.26 (-0.87)          Chiwetel Ejiofor (CEJIO) 25000 68.42 (+1.24)          Jackass: Best and Last (JCKA6) 150000 42.45 (-3.24)          Chiwetel Ejiofor (CEJIO) 25000 68.42 (+1.24)          Fjord (FJORD) 150000 7.29 (+0.81)          Fjord (FJORD) 150000 7.29 (+0.81)          Brendan Fraser (BFRAS) 25000 26.26 (+0.74)          Brendan Fraser (BFRAS) 25000 26.26 (+0.74)          Josh O'Connor (JOOCO) 25000 19.64 (0.00)          Supergirl (SUPGR) 150000 124.65 (-4.73)          Andrew Scott (ANSCO) 25000 38.39 (-0.25)          Scary Movie (SCAR6) 150000 104.80 (+2.36)          Scary Movie (SCAR6) 150000 104.80 (+2.36)          Toy Story 5 (TOYS5) 150000 427.99 (-1.52)          Toy Story 5 (TOYS5) 150000 427.99 (-1.52)          The Last Druid (TLDRU) 3 5.00 (0.00)          Jackass: Best and Last (JCKA6) 73585 42.45 (-3.24)          Jackass: Best and Last (JCKA6) 75000 42.45 (-3.24)          The Last Druid (TLDRU) 100000 5.00 (0.00)          The Secret Life of Pets 3 (PETS3) 150000 105.77 (-2.72)          Masters of the Universe (HEMAN) 150000 62.00 (+1.49)          Brendan Fraser (BFRAS) 25000 26.26 (+0.74)          Brendan Fraser (BFRAS) 20000 26.26 (+0.74)          Claire Foy (CFOY) 20000 9.48 (-0.14)          Claire Foy (CFOY) 20000 9.48 (-0.14)          The Last Druid (TLDRU) 25000 5.00 (0.00)