HSX Forum

Playing & Trading Strategy

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

Posted by: RogerMore on Feb 05, 15:34 in response to Smartlink's post So add screen average needed and number of screen...

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 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!


Resident Evil (RESE8) 166 71.41 (0.00)          Ramayana (RAMAY) 2477 14.98 (+0.17)          Alien sequel (ALIE6) 150000 64.46 (-0.98)          Jennifer's Body 2 (JBOD2) 149999 14.22 (+0.69)          Tony (TONY) 150000 17.72 (+0.58)          Rosamund Pike (RPIKE) 25000 18.12 (-0.10)          Tom Hiddleston (THIDD) 25000 152.99 (+0.50)          Christian Convery (CCONV) 25000 51.17 (+0.33)          Christian Convery (CCONV) 25000 51.17 (+0.33)          Tom Cruise (TCRUI) 25000 190.79 (-0.50)          Nell Tiger Free (NTFRE) 25000 9.38 (-0.05)          Alien sequel (ALIE6) 150000 64.46 (-0.98)          Atonement (ATONM) 150000 1.92 (-0.08)          The Unknown (TUNKN) 150000 1.68 (-0.02)          Lucy Boynton (LBOYN) 25000 80.08 (+0.25)          The Stunt Driver (STNTD) 150000 1.80 (-0.02)          Ryan Coogler (RCOOG) 25000 172.74 (+1.00)          Ryan Coogler (RCOOG) 25000 172.74 (+1.00)          Craig Brewer (CBREW) 25000 28.07 (+0.12)          Andy Samberg (ASAMB) 25000 59.68 (+0.16)          Ali G: Who Iz I? (ALIG2) 149753 20.64 (-0.09)          Denzel Washington (DWASH) 25000 78.94 (+0.50)          Denzel Washington (DWASH) 25000 78.94 (+0.50)          David Jonsson (DJONS) 25000 42.46 (+0.66)          David Jonsson (DJONS) 25000 42.46 (+0.66)          Dynamic Duo (DYDUO) 27802 120.72 (+0.06)          Victorian Psycho (VPSYC) 150000 14.03 (+0.89)          Atonement (ATONM) 150000 1.92 (-0.08)          Danielle Brooks (DBROO) 25000 104.79 (-0.66)          Danielle Brooks (DBROO) 25000 104.79 (-0.66)          NDA (NDA) 150000 8.46 (+0.66)          Black Panther III (BPNT3) 20825 246.15 (-0.10)          NDA (NDA) 150000 8.46 (+0.66)          Matt Dillon (MDILL) 25000 7.65 (-0.10)          Matt Dillon (MDILL) 25000 7.65 (-0.10)          Elsinore (ELSNR) 150000 7.34 (+0.59)          Elsinore (ELSNR) 150000 7.34 (+0.59)          Club Kid (CLUBK) 50000 12.84 (-0.04)          Ali G: Who Iz I? (ALIG2) 100000 20.64 (-0.09)          Alien sequel (ALIE6) 140000 64.46 (-0.98)          Astaire (ASTAI) 150000 16.90 (+0.90)          Alien sequel (ALIE6) 60198 64.46 (-0.98)          Ramayana (RAMAY) 1073 14.98 (+0.17)          David Jonsson (DJONS) 25000 42.46 (+0.66)          David Jonsson (DJONS) 25000 42.46 (+0.66)          Cailee Spaeny (CSPAE) 25000 41.97 (+0.16)          Alien sequel (ALIE6) 150000 64.46 (-0.98)          Alien sequel (ALIE6) 150000 64.46 (-0.98)          Coward (COWRD) 150000 0.98 (-0.02)          Atonement (ATONM) 150000 1.92 (-0.08)