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!


Please (PLESE) 1 22.02 (+1.09)          Alessandro Nivola (ANIVO) 25000 17.81 (+0.23)          Please (PLESE) 150000 22.02 (+1.09)          Toy Story 5 (TOYS5) 3 407.78 (+2.38)          Primetime (PRMTM) 93127 23.10 (+0.01)          Ryan Reynolds (RREYN) 25000 142.65 (+0.48)          Sylvia Hoeks (SHOEK) 25000 29.02 (-0.50)          Hot Spot (HTSPT) 3 6.30 (+0.63)          Hot Spot (HTSPT) 3 6.30 (+0.63)          Ken Russell's The Devil (KRSTD) 150000 2.00 (0.00)          Gold Mountain (OGMTN) 150000 15.61 (-0.13)          The Get Out (BEARC) 3 4.43 (-0.58)          The Get Out (BEARC) 3 4.43 (-0.58)          Asa Butterfield (ABUTT) 25000 1.01 (-0.03)          Avengers: Doomsday (AVNG5) 3 526.26 (-1.38)          Avengers: Doomsday (AVNG5) 3 526.26 (-1.38)          Asa Butterfield (ABUTT) 25000 1.01 (-0.03)          The Death of Robin Hood (TDORH) 150000 18.67 (-1.56)          The Death of Robin Hood (TDORH) 3 18.67 (-1.56)          Top Gun 3 (TOPG3) 1 206.68 (-1.65)          Top Gun 3 (TOPG3) 1 206.68 (-1.65)          Minions & Monsters (MNIO3) 3 309.56 (-1.75)          Minions & Monsters (MNIO3) 3 309.56 (-1.75)          Helldivers (HELDV) 3 101.75 (-1.76)          Helldivers (HELDV) 3 101.75 (-1.76)          Boner aka Rise (VIAGR) 150000 1.75 (0.00)          Here Comes the Flood (HCTFL) 150000 0.24 (+0.09)          Letitia Wright (LWRIG) 25000 144.03 (-0.66)          The Comebacker (CMBAC) 1 28.40 (+2.36)          The Comebacker (CMBAC) 1 28.40 (+2.36)          Boiuna: Legend of the Amazon (BOUNA) 150000 17.02 (+0.01)          Buddy (BUDDY) 3 7.15 (+1.60)          Buddy (BUDDY) 3 7.15 (+1.60)          Kathryn Newton (KNEWT) 25000 68.99 (+0.50)          Blood on Snow (BLOSN) 150000 14.56 (-0.07)          Bitter Christmas (BITRC) 150000 0.74 (+0.03)          Supergirl - Opening Weekend (SUPGR.OW) 99999 57.16 (+0.47)          Being Heumann (BHEUM) 150000 0.42 (+0.02)          Lilo & Stitch 2 (LILS2) 50000 268.29 (-0.54)          Being Mortal (BMRTL) 150000 0.07 (-0.01)          The Death of Robin Hood - Openin (TDORH.OW) 100000 8.35 (-0.30)          Toy Story 5 - Opening Weekend (TOYS5.OW) 99999 145.15 (+0.80)          Belly of the Beast (BELYB) 150000 3.21 (+0.04)          Ken Russell's The Devil (KRSTD) 50000 2.00 (0.00)          Bermuda (BTRIA) 150000 0.67 (+0.02)          Incredibles 3 (NCRD3) 50000 391.28 (-3.36)          Tony (TONY) 150000 20.79 (-0.06)          Big Thunder Mountain (BTMTN) 150000 20.12 (-0.02)          Lakeith Stanfield (LSTAN) 25000 8.70 (-2.19)          X-Men aka Mutants (XMEN8) 1 165.72 (-1.19)