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!


Charlie Day (CDAY) 25000 89.55 (+0.25)          The Super Mario Galaxy Movie H$1 (MARI2.PU) 25000 2.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 5000 2.00 (0.00)          Spider-Man: Brand New Day (SPID9) 8780 422.03 (+2.03)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          The Super Mario Galaxy Movie (MARI2) 150000 497.03 (-1.54)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          World War Hulk (THLK2) 37500 36.15 (-0.05)          Varanasi (VARAN) 150000 10.00 (0.00)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          Evil Dead Burn (EVLD6) 374 46.97 (-0.07)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          Reminders of Him (RMNDH) 60000 38.04 (-0.27)          Joel Edgerton (JEDGE) 25000 15.29 (-0.29)          Luis Guzman (LGUZM) 25000 30.30 (+0.25)          Joel Edgerton (JEDGE) 25000 15.29 (-0.29)          Varanasi (VARAN) 150000 10.00 (0.00)          Jack Ryan: Ghost War (RYAN1) 139 13.78 (-0.48)          A Quiet Place: Part III (AQPL4) 15985 110.79 (+2.62)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          Helldivers (HELDV) 31000 98.75 (-0.04)          Deeper (DEPER) 37500 36.07 (+0.01)          The Super Mario Galaxy Movie H$1 (MARI2.PU) 25000 2.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          Varanasi (VARAN) 1 10.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          Georgina Campbell (GCAMP) 25000 16.61 (+0.61)          The Drama H$15 Put (TDRAM.PU) 25000 2.00 (0.00)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.PU) 25000 2.00 (0.00)          Glen Powell (GPOWE) 25000 82.11 (+1.32)          Moana (MOAN1) 10100 222.58 (-0.45)          The Drama H$15 Call (TDRAM.CA) 25000 2.00 (0.00)          Our Hero, Balthazar (OURHB) 1 0.70 (-0.04)          Glen Powell (GPOWE) 25000 82.11 (+1.32)          The Drama - Opening Weekend (TDRAM.OW) 100000 15.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.PU) 25000 2.00 (0.00)          Varanasi (VARAN) 150000 10.00 (0.00)          Zealot (ZELOT) 1 1.64 (+0.10)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          Dune: Part Three (DUNE3) 500 234.86 (0.00)