HSX Forum

Playing & Trading Strategy

format your result to date {nm}

Posted by: RazorHawk on Feb 05, 16:05 in response to Smartlink's post Not sure I got the formula right, what information should...

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


Charlie Harper (CHARP) 99775 4.67 (-0.03)          Disclosure Day (SKIES) 150000 176.00 (-0.66)          Spider-Man: Brand New Day (SPID9) 279 421.38 (+1.38)          Barbarella (BARBA) 80000 26.40 (-0.02)          Dynamic Duo (DYDUO) 148 103.82 (+1.00)          The Asian Fund (ASIAN) 20000 40.70 (+0.03)          Project Hail Mary (PRJHM) 30681 208.89 (-0.57)          Spider-Man: Brand New Day (SPID9) 2668 421.38 (+1.38)          The Sequel Fund (SQUEL) 20000 87.75 (+0.21)          Outcome (OUTCM) 150000 1.91 (+0.07)          The Goonies 2 (GONI2) 150000 62.16 (-0.58)          Star Trek (TREK4) 150000 22.51 (-0.08)          The Death of Robin Hood (TDORH) 120000 26.78 (-0.14)          Reminders of Him (RMNDH) 150000 38.08 (-0.23)          Reminders of Him (RMNDH) 150000 38.08 (-0.23)          Spider-Man: Brand New Day (SPID9) 132668 421.38 (+1.38)          Sweet Vengeance (SWVNG) 150000 0.40 (0.00)          A Quiet Place: Part III (AQPL4) 1117 110.45 (+2.28)          Ready or Not 2: Here I Come (RONO2) 150000 27.37 (-0.49)          Ready or Not 2: Here I Come (RONO2) 150000 27.37 (-0.49)          Margie Claus (MARGC) 25000 33.38 (-0.06)          Margie Claus (MARGC) 25000 33.38 (-0.06)          Thomasin McKenzie (TMCKE) 5000 13.08 (+0.43)          Supergirl (SUPGR) 25000 165.63 (-0.18)          Air Bud Returns (AIRB3) 50000 6.30 (+0.03)          Passenger (PSNGR) 150000 24.73 (+0.08)          Amanda Seyfried (ASEYF) 25000 27.02 (+1.14)          Three Incestuous Sisters (3INCS) 11000 14.69 (+2.34)          Glen Powell (GPOWE) 25000 82.10 (+1.31)          Glen Powell (GPOWE) 25000 82.10 (+1.31)          Georgina Campbell (GCAMP) 25000 16.51 (+0.51)          Gail Daughtry and the Celebrity (GDCSP) 30000 8.90 (+0.06)          Fuze (FUZE) 20000 14.64 (0.00)          The Weight (THEWT) 20000 5.98 (-0.03)          Wicker (WCKER) 150000 6.28 (+0.06)          Charlotte Rampling (CRAMP) 25000 73.14 (+1.20)          Bad Fairies (BFAIR) 73000 40.24 (-0.02)          Ciaran Hinds (CHIND) 25000 54.37 (+0.66)          Cate Blanchett (CBLAN) 25000 9.74 (+0.70)          The Matrix 5 (MTRX5) 40000 28.80 (+0.01)          Wolf Creek Legacy (WCRE2) 50000 18.17 (+0.29)          The Entertainment System Is Down (TESID) 7000 11.23 (0.00)          Amanda Seyfried (ASEYF) 25000 27.02 (+1.14)          Three Incestuous Sisters (3INCS) 37000 14.69 (+2.34)          Untitled Fourth Film directed by (UJPE4) 20000 52.38 (+0.12)          Hoppers (HOPPR) 32000 137.09 (-0.95)          Clika (CLIKA) 150000 4.07 (+0.10)          Wicker (WCKER) 150000 6.28 (+0.06)          Clika (CLIKA) 150000 4.07 (+0.10)          The Memory Police (TMEMP) 150000 4.73 (-0.61)