HSX Forum

Playing & Trading Strategy

What are your ideas around moviestock and starbond spreadsheets? I mean, what are your objectives? {nm}

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

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

Ads disabled on hsx.com


Star Wars: Starfighter (SWAR4) 100 249.08 (-0.22)          Emma Laird (ELAIR) 462 21.42 (0.00)          John Travolta (JTRAV) 25000 19.26 (-0.10)          The Devil Wears Prada 2 (PRAD2) 500 199.99 (-1.17)          Bob Odenkirk (BODEN) 25000 32.39 (-1.26)          Jurassic World sequel (JURA8) 650 239.49 (-0.17)          The Deb (THDEB) 150000 0.58 (+0.54)          Tower of Terror (TOWRT) 180 11.24 (0.00)          Top Gun 3 (TOPG3) 3 232.88 (-0.09)          John Wick: Chapter 5 (WICK5) 14 68.07 (-0.14)          Bob Odenkirk (BODEN) 25000 32.39 (-1.26)          Wonder Woman (WOND3) 30 50.17 (-0.14)          Insidious: Out of the Further (NSID6) 3210 42.95 (+0.24)          Ben Wheatley (BWHEA) 25000 18.18 (+0.33)          Tomb Raider (TOMB4) 525 2.83 (0.00)          The Man with the Bag (TMWTB) 149 9.08 (-1.34)          John Wick Prequel (WICK0) 3 36.58 (+0.06)          Jack Reynor (JREYN) 25000 17.36 (-0.93)          What Happens At Night (WHANT) 3 43.91 (-0.04)          John Wick: Chapter 5 (WICK5) 49 68.07 (-0.14)          Wonder Woman (WOND3) 55 50.17 (-0.14)          Wonka 2 (WONK2) 4 64.39 (-0.25)          Lena Headey (LHEAD) 25000 7.84 (-6.63)          Watch Dogs (WTDOG) 3 9.22 (+0.01)          X-Men aka Mutants (XMEN8) 3 164.55 (-0.01)          Olivia Holt (OHOLT) 25000 12.31 (-0.51)          New York Will Eat You Alive aka (ZMBRO) 99 0.45 (-0.01)          Himesh Patel (HPATE) 4 50.86 (-0.16)          Kiernan Shipka (KSHIP) 6 85.96 (-0.49)          Tramell Tillman (TTILL) 1 149.00 (0.00)          Dua Lipa (DLIPA) 8 96.47 (-0.74)          Anne Hathaway (AHATH) 18 23.68 (-0.37)          Jonathan Bailey (JBAIL) 1 147.95 (+0.33)          Barracuda (BRCUD) 5000 9.04 (+1.01)          Michael Sarnoski (MSARN) 4 55.95 (+0.16)          Ben Stiller (BSTIL) 4 53.71 (+0.16)          Vanessa Kirby (VKIRB) 5 105.50 (+0.33)          Daniel: The Fiery Furnace (DANIL) 150000 5.00 (0.00)          Milly Alcock (MALCO) 4 66.97 (+0.27)          Margaret Qualley (MQUAL) 6 9.50 (+0.05)          Charlize Theron (CTHER) 6 132.27 (+0.68)          Jurassic World sequel (JURA8) 3 239.49 (-0.17)          Jurassic World sequel (JURA8) 650 239.49 (-0.17)          Moana (MOAN1) 25 234.02 (+0.78)          Evil Dead Burn (EVLD6) 4 55.66 (+0.01)          Minions & Monsters (MNIO3) 8 326.91 (+2.03)          The Invite (TINVT) 6 16.15 (+0.08)          Supergirl (SUPGR) 13 158.33 (+1.68)          Animal Farm (AFARM) 15 5.69 (-0.08)          Over Your Dead Body (TETRP) 20 3.17 (-0.06)