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!


Rich Flu (RCFLU) 15000 0.07 (+0.05)          Rich Flu (RCFLU) 9994 0.07 (+0.05)          Sigourney Weaver (SWEAV) 25000 133.29 (+9.44)          Sigourney Weaver (SWEAV) 25000 133.29 (+9.44)          David Robert Mitchell (DRMIT) 25000 22.00 (0.00)          Greta Lee (GLEE) 25000 101.23 (+0.66)          The End of Oak Street (FLWVS) 150000 76.75 (+1.09)          Greta Lee (GLEE) 1 101.23 (+0.66)          Naomi Ackie (NACKI) 25000 14.06 (-0.32)          Rich Flu (RCFLU) 150000 0.07 (+0.05)          Rich Flu (RCFLU) 150000 0.07 (+0.05)          Naomi Ackie (NACKI) 25000 14.06 (-0.32)          Will Poulter (WPOUL) 25000 59.71 (+1.02)          Craig Robinson (CROBI) 1 73.43 (+0.99)          Tahar Rahim (TRAHI) 25000 21.30 (+0.64)          Keke Palmer (KPALM) 25000 63.47 (+1.25)          Craig Robinson (CROBI) 25000 73.43 (+0.99)          Keke Palmer (KPALM) 25000 63.47 (+1.25)          Bad Bunny (BBUNN) 25000 59.78 (+0.50)          Sigourney Weaver (SWEAV) 25000 133.29 (+9.44)          Jon Favreau (JFAVR) 25000 233.04 (-1.20)          Alan Cumming (ACUMM) 25000 33.12 (+0.87)          Alan Cumming (ACUMM) 1 33.12 (+0.87)          Jon Favreau (JFAVR) 25000 233.04 (-1.20)          Taylour Paige (TPAIG) 25000 3.17 (+0.05)          Noah Centineo (NCENT) 25000 52.99 (+0.07)          Emma Mackey (EMACK) 25000 51.08 (-1.23)          Naomi Ackie (NACKI) 25000 14.06 (-0.32)          Naomi Ackie (NACKI) 25000 14.06 (-0.32)          Noah Centineo (NCENT) 25000 52.99 (+0.07)          Emma Mackey (EMACK) 25000 51.08 (-1.23)          Chloe Sevigny (CSEVI) 25000 0.69 (-0.39)          Chloe Sevigny (CSEVI) 25000 0.69 (-0.39)          Keke Palmer (KPALM) 25000 63.47 (+1.25)          Broadsword (BROSW) 12000 42.82 (-2.10)          Keke Palmer (KPALM) 25000 63.47 (+1.25)          Toy Story 5 (TOYS5) 20000 407.77 (+2.37)          The Comebacker (CMBAC) 20000 28.39 (+2.35)          Lakeith Stanfield (LSTAN) 25000 8.70 (-2.19)          Lakeith Stanfield (LSTAN) 25000 8.70 (-2.19)          Alessandro Nivola (ANIVO) 25000 17.81 (+0.23)          Alessandro Nivola (ANIVO) 25000 17.81 (+0.23)          Will Poulter (WPOUL) 24999 59.71 (+1.02)          Asa Butterfield (ABUTT) 25000 1.01 (-0.03)          Martin Scorsese (MSCOR) 25000 46.74 (+13.85)          Asa Butterfield (ABUTT) 25000 1.01 (-0.03)          David Robert Mitchell (DRMIT) 20000 22.00 (0.00)          Melissa Leo (MLEO) 25000 28.45 (-0.89)          Jimmy O. Yang (JYANG) 25000 15.15 (-0.15)          Jon Favreau (JFAVR) 25000 233.04 (-1.20)