HSX Forum

Playing & Trading Strategy

When your ideas are more developed, post here. I may be able to help out with historical data, etc. {nm}

Posted by: RogerMore on Feb 05, 15:35 in response to Smartlink's post For Starbond, maybe keep track of next 90 days Adjusts or...

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


Silent Night, Deadly Night (SNDN) 4000 15.45 (+0.29)          Emily Blunt (EBLUN) 25000 126.08 (+0.33)          Supergirl (SUPGR) 10000 168.71 (+0.35)          The Devil Wears Prada 2 aka Reve (PRAD2) 150000 153.72 (+0.55)          Dead Man's Wire (DMWIR) 18000 7.68 (-0.03)          The SpongeBob Movie: Search for (SPBO4) 20000 73.37 (-6.36)          Dead Man's Wire (DMWIR) 8000 7.68 (-0.03)          Mother Mary (MMARY) 150000 11.68 (-0.71)          Mother Mary (MMARY) 150000 11.68 (-0.71)          Avatar: Fire and Ash (AVAT3) 2500 459.19 (-1.25)          The Chosen Season 6 (TCS61) 150000 12.20 (+0.29)          Untitled Event Film Directed By (SKIES) 150000 147.85 (+0.26)          The Chosen Season 6 (TCS61) 150000 12.20 (+0.29)          Fauzi (FAUZI) 150000 4.89 (+1.18)          Fauzi (FAUZI) 150000 4.89 (+1.18)          Five Nights at Freddy's 2 (5NAF2) 150000 112.58 (+4.78)          Shelter (SELTR) 150000 22.26 (+0.11)          The Young People (TYPEP) 150000 19.07 (-0.29)          The Young People (TYPEP) 150000 19.07 (-0.29)          Ella McCay (EMCAY) 10998 13.38 (+0.62)          The Mummy 4 (MUMY5) 150000 66.27 (+0.68)          Ella McCay (EMCAY) 9800 13.38 (+0.62)          The SpongeBob Movie: Search for (SPBO4.PU) 25000 2.91 (+1.02)          The SpongeBob Movie: Search for (SPBO4.CA) 25000 1.63 (-0.94)          The SpongeBob Movie: Search for (SPBO4.OW) 100000 22.50 (-2.86)          Top Gun 3 (TOPG3) 3000 257.77 (-1.73)          Merrily We Roll Along (MWRAL) 150000 4.27 (+0.42)          Soulm8te (SOM8T) 150000 13.14 (-3.73)          The SpongeBob Movie: Search for (SPBO4) 150000 73.37 (-6.36)          Fauzi (FAUZI) 150000 4.89 (+1.18)          Only What We Carry (OWWC) 150000 2.00 (0.00)          Audition (AUDTN) 150000 4.00 (0.00)          Demon Slayer: Infinity Castle 2 (DSIC2) 150000 91.02 (+0.98)          The Mummy 4 (MUMY5) 150000 66.27 (+0.68)          Archangel (ARCNG) 150000 18.19 (-0.34)          Archangel (ARCNG) 150000 18.19 (-0.34)          Audition (AUDTN) 150000 4.00 (0.00)          Ebenezer: A Christmas Carol (EBNZR) 150000 63.28 (+0.02)          Only What We Carry (OWWC) 150000 2.00 (0.00)          Michael (MJACK) 150000 163.05 (+0.88)          Michael 2 (MJAC2) 150000 136.10 (+0.66)          Five Nights at Freddy's 2 (5NAF2) 150000 112.58 (+4.78)          Everyone Wants to F*ck Me (EWTFM) 50000 9.66 (+0.02)          Marty Supreme (MRTSU) 150000 31.01 (+0.40)          Marty Supreme (MRTSU) 150000 31.01 (+0.40)          Dust Bunny (DUSTB) 150000 5.77 (+0.04)          Hunting Matthew Nichols (HUNMN) 150000 4.16 (-0.40)          Only What We Carry (OWWC) 150000 2.00 (0.00)          Audition (AUDTN) 150000 4.00 (0.00)          Ready or Not 2: Here I Come (RONO2) 25000 25.69 (+1.54)