HSX Forum

Playing & Trading Strategy

Reply Topic List All Forums

report abuse

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