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!


Jackass: Best and Last (JCKA6) 150000 42.42 (-3.27)          Supergirl (SUPGR) 150000 124.62 (-4.76)          Supergirl (SUPGR) 1 124.62 (-4.76)          Moana H$100 Call (MOAN1.CA) 24999 2.92 (+0.33)          Moana - Opening Weekend (MOAN1.OW) 99900 101.99 (+0.70)          The Last Druid (TLDRU) 150000 5.00 (0.00)          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)