HSX Forum

Playing & Trading Strategy

I think Roger's advice about looking at the data and knowing what we know (high delist values over winter holidays)

Posted by: Moviesnob on Feb 08, 20:37 in response to PVL Admin's post @moviesnob/rogermore - Advice requested (attempt #2)

is a start. If we think (and I do) that seasonality will have the greatest effect on delist multiple, then the next step is to figure how how to normalize it for your genre study. There could be other factors (box office, demographics) that we can layer in layer. But for starters, I would create a genre for African American comedies and African American dramas. I think those will likely have similar delist performance and may be different from genres that are mainstream. I would also create an arthouse genre, that will likely include films like nebraska that had a wider release further into its release. King's Speech is another example. One could argue that once a movie hits 20 mil at the box office, its no longer arthouse, but I suspect that these titles will have a higher delist multiple so they may need their own genre.

 I looked at Roger's average delist by month and caculated values based on the assumption the average delist is 2.7. One thing that looks screwy is November, since you expect Thanksgiving titles to have a higher delist (that may or may not be true, thats my assumption). The other thing is I would probably reduce the data to the last five years. And maybe look at seasonality by week (i usually use month, but that november number looks counter-intuitive so we may need to look at seasonality by week). 

Finally, I would throw out any genre with 1 or 2 titles. Especially docs. 

I tend to let the data define the groupings, but in this case there are already established genres, but the data may allow us to create new genres (hence my recommendations to create AA Drama and AA Comedy and Arthouse). One new genre could be "blockbusters" if non kids titles that open over $50 mil (random threshold) they may have similar delist regardless if they are sci-fi or action.

 

Month  
Average Delist Multiplier 2.7
   
January  
2.69 1.003717
   
February  
2.46 1.097561
   
March  
2.63 1.026616
   
April  
2.55 1.058824
   
May  
2.57 1.050584
   
June  
2.87 0.940767
   
July  
2.92 0.924658
   
August  
2.75 0.981818
   
September  
2.46 1.097561
   
October  
2.69 1.003717
   
November  
2.34 1.153846
   
December  
4.27 0.632319





Post a Reply

To post to the forums you must first login!


Bad Bunny (BBUNN) 7 42.38 (0.00)          Ariana Greenblatt (ARGRE) 23835 83.30 (+0.48)          Resident Evil (RESE8) 8 55.98 (+1.96)          The Super Mario Galaxy Movie $39 (MARI2.BW) 25000 8.98 (+0.46)          Moana (MOAN1) 8709 227.13 (+0.34)          Alia Shawkat (ASHAW) 25000 4.87 (+0.15)          The Riders (RIDER) 49903 29.93 (+0.03)          The Super Mario Galaxy Movie $39 (MARI2.BW) 5 8.98 (+0.46)          Project Hail Mary $260M Blockbus (PRJHM.BW) 8 13.58 (+0.07)          Project Hail Mary $260M Blockbus (PRJHM.BW) 8 13.58 (+0.07)          Colony (CLONY) 150000 1.95 (-0.05)          What Happens At Night (WHANT) 2500 42.86 (0.00)          Colony (CLONY) 60000 1.95 (-0.05)          Spider-Man: Brand New Day (SPID9) 7 420.41 (+0.26)          Normal (NORML) 150000 8.62 (+0.01)          The Hunger Games: Sunrise on the (HGAM6) 4 177.38 (+0.34)          Michael (MJACK) 150000 233.05 (+0.32)          The Odyssey (ODYSE) 12 286.24 (+0.25)          Backrooms (BACRM) 800 39.96 (+0.15)          Scary Movie 6 (SCAR6) 100 73.73 (+0.37)          The Devil Wears Prada 2 (PRAD2) 150000 227.97 (+0.83)          Bad Bunny (BBUNN) 7 42.38 (0.00)          The Amazing Digital Circus: The (AMZDC) 500 18.52 (-0.03)          Good People Bad Things (GPBT) 6 13.26 (+0.55)          James Marsden (JMARS) 5000 163.64 (+0.60)          I Love Boosters (ILBOS) 7 15.45 (-0.18)          Avengers: Secret Wars (AVNG6) 5 488.65 (+0.52)          B.J. Novak (BJNOV) 10 101.52 (+1.33)          Minions & Monsters (MNIO3) 10 325.53 (+1.22)          The Isolate Thief (ISOLT) 150000 1.00 (0.00)          Resident Evil (RESE8) 150000 55.98 (+1.96)          Resident Evil (RESE8) 11543 55.98 (+1.96)          The Devil Wears Prada 2 (PRAD2) 4500 227.97 (+0.83)          Avengers: Doomsday (AVNG5) 10 546.00 (+1.00)          The Isolate Thief (ISOLT) 150000 1.00 (0.00)          Deep Water (DEEPW) 118133 5.60 (+0.69)          Scream 7 $115M Blockbuster Warra (SCRM7.BW) 5 9.58 (-0.07)          Angel and the Badman (ANBAD) 150000 10.00 (0.00)          The Devil Wears Prada 2 (PRAD2) 17 227.97 (+0.83)          Minions & Monsters (MNIO3) 7 325.53 (+1.22)          The Hunger Games: Sunrise on the (HGAM6) 100 177.38 (+0.34)          Deep Water (DEEPW) 150000 5.60 (+0.69)          Resident Evil (RESE8) 7 55.98 (+1.96)          Lady Gaga (LGAGA) 100 97.71 (+0.50)          Tom Holland (TOHOL) 10 133.90 (+0.01)          Bad Bunny (BBUNN) 20 42.38 (0.00)          In the Grey - Opening Weekend (NGREY.OW) 5 5.39 (+0.39)          Adam Sandler (ASAND) 999 97.31 (0.00)          The Isolate Thief (ISOLT) 150000 1.00 (0.00)          Deep Water (DEEPW) 1 5.60 (+0.69)