HSX Forum

Playing & Trading Strategy

Ahhh works now, thank you! I knew I had forgotten something! {nm}

Posted by: Smartlink on Feb 05, 16:35 in response to RazorHawk's post format your result to date

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! Smartlink Feb 05, 16:35





Post a Reply

To post to the forums you must first login!


The Catch (TCATC) 150000 50.00 (0.00)          Bette Midler (BMIDL) 25000 41.67 (0.00)          Zendaya (ZENDA) 91 120.72 (0.00)          The Catch (TCATC) 150000 50.00 (0.00)          John Travolta (JTRAV) 24999 19.26 (-0.01)          Lee Cronin's The Mummy (TMUMY) 150000 29.20 (-0.46)          David Harbour (DHARB) 25000 71.91 (+0.50)          The Catch (TCATC) 150000 50.00 (0.00)          The Catch (TCATC) 150000 50.00 (0.00)          Hokum (HOKUM) 150000 15.85 (+3.04)          A Colt Is My Passport (ACIMP) 10000 7.92 (-0.08)          David Harbour (DHARB) 25000 71.91 (+0.50)          Angel and the Badman (ANBAD) 150000 13.85 (+1.71)          Hokum (HOKUM) 150000 15.85 (+3.04)          The Super Mario Galaxy Movie $39 (MARI2.BW) 1000 10.87 (+0.86)          The Catch (TCATC) 150000 50.00 (0.00)          Hokum (HOKUM) 150000 15.85 (+3.04)          The Catch (TCATC) 150000 50.00 (0.00)          The Catch (TCATC) 150000 50.00 (0.00)          Moana (MOAN1) 10000 228.68 (+0.93)          Planet of the Apes sequel (APES5) 15000 48.14 (-0.45)          Moana (MOAN1) 25000 228.68 (+0.93)          Narnia: The Magician's Nephew (NARN4) 10000 21.69 (+0.36)          Tangled (TANGL) 150000 117.11 (+0.45)          The Devil Wears Prada 2 (PRAD2) 150000 217.06 (-5.77)          The Catch (TCATC) 150000 50.00 (0.00)          The Catch (TCATC) 150000 50.00 (0.00)          Star Wars: The Mandalorian and G (SWAR3) 111272 198.82 (-0.04)          It Ends (ITNDS) 150000 5.20 (+0.03)          Doctor Strange 3 (DRST3) 25000 77.11 (-1.27)          4 x 4: The Event (4X4TE) 150000 8.70 (-0.02)          The Catch (TCATC) 5000 50.00 (0.00)          The Devil Wears Prada 2 (PRAD2) 1 217.06 (-5.77)          Supergirl (SUPGR) 1 159.59 (-0.86)          The Catch (TCATC) 150000 50.00 (0.00)          Moana (MOAN1) 5622 228.68 (+0.93)          The Catch (TCATC) 150000 50.00 (0.00)          Supergirl (SUPGR) 149999 159.59 (-0.86)          Incredibles 3 (NCRD3) 200 379.03 (-0.21)          The Kidnapping of Arabella (TKOAR) 45000 0.76 (-0.24)          Bloodsport (BLDSP) 60000 21.62 (-0.02)          Wonder Woman (WOND3) 149999 50.93 (+0.09)          Ally (ALLY) 60000 21.53 (-0.16)          Animal Farm (AFARM) 150000 7.94 (-0.26)          Whitney Springs aka Untitled Tre (WHTSP) 149999 21.92 (-0.01)          The Catch (TCATC) 100000 50.00 (0.00)          The Catch (TCATC) 150000 50.00 (0.00)          The Man with the Bag (TMWTB) 150000 12.15 (-0.15)          The Man with the Bag (TMWTB) 149999 12.15 (-0.15)          Planet of the Apes sequel (APES5) 149999 48.14 (-0.45)