HSX Forum

Playing & Trading Strategy

Also, I keep a similar spreadsheet to track prediction sites against moviestock and OW adjusts. (not calls/puts, though I suppose I could)

Posted by: RogerMore on Feb 05, 14:55 in response to Smartlink's post Now finishing 1st version of my HSX Excel tools. My...

A couple of suggested calculations that you might want to include:

the per screen average needed to make the current price and the predictions made by the various prediction sites.  This gives you another way of making comparisons with similar movies.

the cost of flipping the stock.

Conditional formatting is very helpful - I use it a lot in my bonds spreadsheet

Now finishing 1st version of my HSX Excel tools. My formulas ideas, your thoughts and suggestions. Smartlink Feb 05, 14:34

What are your ideas around moviestock and starbond spreadsheets? I mean, what are your objectives? {nm} RogerMore Feb 05, 14:40

For Starbond, maybe keep track of next 90 days Adjusts or something along those lines... No clue yet on movie stock sheet . {nm} Smartlink Feb 05, 14:56

When your ideas are more developed, post here. I may be able to help out with historical data, etc. {nm} RogerMore Feb 05, 15:35

I use Kaigee data to reference starbonds to my portfolio; gives me a quick overview of what to sell/buy based on DROI JOOST! Feb 07, 06:34

For movie Stock, I now have formula working with post OW adj prediction based on OW prediction... (details inside) Smartlink Feb 05, 18:32

Also, I keep a similar spreadsheet to track prediction sites against moviestock and OW adjusts. (not calls/puts, though I suppose I could) RogerMore Feb 05, 14:55

So add screen average needed and number of screen released on. Just need to find a math formula to use the data, thanks for the idea! {nm} Smartlink Feb 05, 15:06

The formula is easy for OWs: OW price * 1000000 / number of screens. A little more complicated for moviestocks {nm} RogerMore Feb 05, 15:34

Release Date/Delist Date RazorHawk Feb 05, 15:13

Not sure I got the formula right, what information should this output? must did something wrong... Smartlink Feb 05, 15:59

format your result to date {nm} RazorHawk Feb 05, 16:05

41316 (general number) = 2/11/13 (date formatted) {nm} RazorHawk Feb 05, 16:06

Ahhh works now, thank you! I knew I had forgotten something! {nm} Smartlink Feb 05, 16:35





Post a Reply

To post to the forums you must first login!


Dynamic Duo (DYDUO) 148 103.82 (+1.00)          The Asian Fund (ASIAN) 20000 40.70 (+0.03)          Project Hail Mary (PRJHM) 30681 208.89 (-0.57)          Spider-Man: Brand New Day (SPID9) 2668 421.38 (+1.38)          The Sequel Fund (SQUEL) 20000 87.75 (+0.21)          Outcome (OUTCM) 150000 1.91 (+0.07)          The Goonies 2 (GONI2) 150000 62.16 (-0.58)          Star Trek (TREK4) 150000 22.51 (-0.08)          The Death of Robin Hood (TDORH) 120000 26.78 (-0.14)          Reminders of Him (RMNDH) 150000 38.08 (-0.23)          Reminders of Him (RMNDH) 150000 38.08 (-0.23)          Spider-Man: Brand New Day (SPID9) 132668 421.38 (+1.38)          Sweet Vengeance (SWVNG) 150000 0.40 (0.00)          A Quiet Place: Part III (AQPL4) 1117 110.45 (+2.28)          Ready or Not 2: Here I Come (RONO2) 150000 27.37 (-0.49)          Ready or Not 2: Here I Come (RONO2) 150000 27.37 (-0.49)          Margie Claus (MARGC) 25000 33.38 (-0.06)          Margie Claus (MARGC) 25000 33.38 (-0.06)          Thomasin McKenzie (TMCKE) 5000 13.08 (+0.43)          Supergirl (SUPGR) 25000 165.63 (-0.18)          Air Bud Returns (AIRB3) 50000 6.30 (+0.03)          Passenger (PSNGR) 150000 24.73 (+0.08)          Amanda Seyfried (ASEYF) 25000 27.02 (+1.14)          Three Incestuous Sisters (3INCS) 11000 14.69 (+2.34)          Glen Powell (GPOWE) 25000 82.10 (+1.31)          Glen Powell (GPOWE) 25000 82.10 (+1.31)          Georgina Campbell (GCAMP) 25000 16.51 (+0.51)          Gail Daughtry and the Celebrity (GDCSP) 30000 8.90 (+0.06)          Fuze (FUZE) 20000 14.64 (0.00)          The Weight (THEWT) 20000 5.98 (-0.03)          Wicker (WCKER) 150000 6.28 (+0.06)          Charlotte Rampling (CRAMP) 25000 73.14 (+1.20)          Bad Fairies (BFAIR) 73000 40.24 (-0.02)          Ciaran Hinds (CHIND) 25000 54.37 (+0.66)          Cate Blanchett (CBLAN) 25000 9.74 (+0.70)          The Matrix 5 (MTRX5) 40000 28.80 (+0.01)          Wolf Creek Legacy (WCRE2) 50000 18.17 (+0.29)          The Entertainment System Is Down (TESID) 7000 11.23 (0.00)          Amanda Seyfried (ASEYF) 25000 27.02 (+1.14)          Three Incestuous Sisters (3INCS) 37000 14.69 (+2.34)          Untitled Fourth Film directed by (UJPE4) 20000 52.38 (+0.12)          Hoppers (HOPPR) 32000 137.09 (-0.95)          Clika (CLIKA) 150000 4.07 (+0.10)          Wicker (WCKER) 150000 6.28 (+0.06)          Clika (CLIKA) 150000 4.07 (+0.10)          The Memory Police (TMEMP) 150000 4.73 (-0.61)          Corporate Retreat (CRPRT) 150000 4.30 (-0.13)          Nirvanna The Band The Show The M (NTBTS) 150000 4.28 (+0.08)          Corporate Retreat (CRPRT) 150000 4.30 (-0.13)          Three Incestuous Sisters (3INCS) 20000 14.69 (+2.34)