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!


Only What We Carry (OWWC) 150000 2.00 (0.00)          Audition (AUDTN) 150000 4.00 (0.00)          Soulm8te (SOM8T) 150000 13.32 (-3.55)          Soulm8te (SOM8T) 150000 13.32 (-3.55)          Misty Green (MSTYG) 150000 15.64 (-0.08)          X-Men aka Mutants (XMEN8) 4000 162.88 (-0.54)          Kill Bill: The Whole Bloody Affa (KBWBA) 150000 19.65 (-2.12)          Kill Bill: The Whole Bloody Affa (KBWBA) 150000 19.65 (-2.12)          The Simpsons Movie 2 (SIMP2) 150000 158.48 (-2.38)          Five Nights at Freddy's 2 (5NAF2) 150000 112.30 (+4.50)          Five Nights at Freddy's 2 (5NAF2) 150000 112.30 (+4.50)          Ready or Not 2: Here I Come (RONO2) 150000 25.61 (+1.46)          Greenland 2: Migration (GRNL2) 4000 23.60 (-0.54)          Greenland 2: Migration (GRNL2) 1000 23.60 (-0.54)          Super Troopers 3 (STRO3) 150000 23.96 (+1.18)          Soulm8te (SOM8T) 47519 13.32 (-3.55)          Only What We Carry (OWWC) 150000 2.00 (0.00)          Mark Ruffalo (MRUFF) 25000 110.72 (+0.33)          The SpongeBob Movie: Search for (SPBO4) 8699 73.41 (-6.32)          Audition (AUDTN) 150000 4.00 (0.00)          X-Men aka Mutants (XMEN8) 2000 162.88 (-0.54)          Return to Silent Hill (SHIL3) 4000 17.13 (+0.08)          X-Men aka Mutants (XMEN8) 2000 162.88 (-0.54)          Return to Silent Hill (SHIL3) 1000 17.13 (+0.08)          Rental Family (RNTLF) 112205 9.70 (-0.06)          Ready or Not 2: Here I Come (RONO2) 150000 25.61 (+1.46)          Only What We Carry (OWWC) 150000 2.00 (0.00)          Audition (AUDTN) 150000 4.00 (0.00)          The Chaperones (CHAPR) 50000 9.46 (-0.54)          Dog Years (DOGYS) 50000 1.61 (-0.39)          David H$25 Call (DAVID.CA) 25000 2.14 (-0.36)          Only What We Carry (OWWC) 150000 2.00 (0.00)          Zootopia 2 (ZOOT2) 150000 306.08 (-1.10)          Mercy (MRCY1) 150000 35.65 (-1.70)          Audition (AUDTN) 150000 4.00 (0.00)          Super Troopers 3 (STRO3) 150000 23.96 (+1.18)          Zootopia 2 (ZOOT2) 150000 306.08 (-1.10)          Protector (PRTEC) 96906 1.89 (+0.18)          The President's Cake (TPCAK) 150000 0.52 (-0.06)          Five Nights at Freddy's 2 (5NAF2) 150000 112.30 (+4.50)          Animal Farm (AFARM) 127800 6.17 (-0.05)          The Wrecking Crew (WCREW) 150000 16.51 (-0.07)          The Chaperones (CHAPR) 150000 9.46 (-0.54)          Audition (AUDTN) 150000 4.00 (0.00)          Only What We Carry (OWWC) 150000 2.00 (0.00)          The Invite (TINVT) 150000 11.96 (-0.18)          Star Trek (TREK4) 150000 26.23 (-0.24)          Is This Thing On? (ISTON) 150000 17.67 (-0.29)          Kill Bill: The Whole Bloody Affa (KBWBA) 150000 19.65 (-2.12)          Kill Bill: The Whole Bloody Affa (KBWBA) 150000 19.65 (-2.12)