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!

Ads disabled on hsx.com


Michael Sarnoski (MSARN) 25000 56.13 (+0.34)          Stoner (STONR) 150000 0.02 (+0.01)          Taylor Russell (TARUS) 25000 9.33 (+0.10)          Taylor Russell (TARUS) 25000 9.33 (+0.10)          Demi Moore (DMOOR) 25000 9.61 (-0.10)          Spider-Woman (SPDWM) 150000 17.93 (+0.10)          Shailene Woodley (SWOOD) 25000 17.57 (-0.10)          Shailene Woodley (SWOOD) 1 17.57 (-0.10)          Spa Weekend (SPAWK) 150000 15.53 (+0.12)          Fonda (FONDA) 49999 8.54 (+0.45)          Matthias Schoenaerts (MSCHO) 24999 35.95 (+0.01)          (Saint) Peter (STPET) 100000 5.27 (+0.30)          Smile 3 (SMIL3) 150000 21.80 (+0.02)          Lewis Tan (LTAN) 24999 127.65 (+0.33)          Daniel: The Fiery Furnace (DANIL) 150000 5.00 (0.00)          Sing 3 (SING3) 150000 50.19 (+0.25)          The Flood (FLOOD) 1 69.23 (+1.36)          Jessica Rothe (JROTH) 25000 9.45 (-0.05)          Jessica Rothe (JROTH) 1 9.45 (-0.05)          The Flood (FLOOD) 30000 69.23 (+1.36)          Sharlto Copley (SCOPL) 25000 12.06 (0.00)          Jack Ryan: Ghost War (RYAN1) 150000 6.00 (-2.07)          Scary Movie (SCAR6) 50000 81.41 (+2.47)          Joan Chen (JCHEN) 25000 2.72 (+0.07)          Shockwave (SHKWV) 150000 0.05 (+0.04)          Joan Chen (JCHEN) 1 2.72 (+0.07)          Danny Huston (DHUST) 25000 17.10 (+0.40)          Danny Huston (DHUST) 25000 17.10 (+0.40)          Bill Skarsgard (BSKAR) 25000 23.50 (+0.12)          The Deb (THDEB) 150000 0.59 (+0.55)          Bill Skarsgard (BSKAR) 1 23.50 (+0.12)          Paranormal Activity 8 (PNAC8) 15000 28.14 (+0.04)          Kevin Smith (KSMIT) 25000 1.34 (-0.17)          Obsession - Opening Weekend (OBSSN.OW) 100000 7.03 (+0.82)          Kiersey Clemons (KCLEM) 25000 24.40 (+1.12)          The Cat in the Hat (TCATH) 50000 89.67 (+1.09)          The Flood (FLOOD) 20000 69.23 (+1.36)          Daniel: The Fiery Furnace (DANIL) 150000 5.00 (0.00)          Michael (MJACK) 150000 268.17 (-0.26)          Star Wars: The Mandalorian and G (SWAR3.PU) 25000 2.51 (+0.06)          Jack Reynor (JREYN) 25000 17.36 (-0.93)          Jack Reynor (JREYN) 25000 17.36 (-0.93)          The Flood (FLOOD) 15000 69.23 (+1.36)          Daniel: The Fiery Furnace (DANIL) 150000 5.00 (0.00)          Peter Asher: Everywhere Man (PAEWM) 10000 0.63 (-0.37)          Tramell Tillman (TTILL) 1 149.00 (0.00)          Anthony Mackie (AMACK) 25000 41.03 (0.00)          Lena Headey (LHEAD) 25000 7.84 (-6.63)          Anthony Mackie (AMACK) 25000 41.03 (0.00)          Star Wars: The Mandalorian and G (SWAR3) 150000 196.17 (-0.62)