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!


Not Alone (NTALN) 200 114.39 (0.00)          Incredibles 3 (NCRD3) 50 410.78 (+0.25)          Everytime (EVRTM) 19 0.31 (0.00)          Donkey (DONKE) 100 129.09 (0.00)          Atonement (ATONM) 5000 1.92 (-0.08)          Resident Evil (RESE8) 166 71.41 (0.00)          Ramayana (RAMAY) 2477 14.98 (+0.17)          Alien sequel (ALIE6) 150000 64.46 (-0.98)          Jennifer's Body 2 (JBOD2) 149999 14.22 (+0.69)          Tony (TONY) 150000 17.72 (+0.58)          Rosamund Pike (RPIKE) 25000 18.12 (-0.10)          Tom Hiddleston (THIDD) 25000 152.99 (+0.50)          Christian Convery (CCONV) 25000 51.17 (+0.33)          Christian Convery (CCONV) 25000 51.17 (+0.33)          Tom Cruise (TCRUI) 25000 190.79 (-0.50)          Nell Tiger Free (NTFRE) 25000 9.38 (-0.05)          Alien sequel (ALIE6) 150000 64.46 (-0.98)          Atonement (ATONM) 150000 1.92 (-0.08)          The Unknown (TUNKN) 150000 1.68 (-0.02)          Lucy Boynton (LBOYN) 25000 80.08 (+0.25)          The Stunt Driver (STNTD) 150000 1.80 (-0.02)          Ryan Coogler (RCOOG) 25000 172.74 (+1.00)          Ryan Coogler (RCOOG) 25000 172.74 (+1.00)          Craig Brewer (CBREW) 25000 28.07 (+0.12)          Andy Samberg (ASAMB) 25000 59.68 (+0.16)          Ali G: Who Iz I? (ALIG2) 149753 20.64 (-0.09)          Denzel Washington (DWASH) 25000 78.94 (+0.50)          Denzel Washington (DWASH) 25000 78.94 (+0.50)          David Jonsson (DJONS) 25000 42.46 (+0.66)          David Jonsson (DJONS) 25000 42.46 (+0.66)          Dynamic Duo (DYDUO) 27802 120.72 (+0.06)          Victorian Psycho (VPSYC) 150000 14.03 (+0.89)          Atonement (ATONM) 150000 1.92 (-0.08)          Danielle Brooks (DBROO) 25000 104.79 (-0.66)          Danielle Brooks (DBROO) 25000 104.79 (-0.66)          NDA (NDA) 150000 8.46 (+0.66)          Black Panther III (BPNT3) 20825 246.15 (-0.10)          NDA (NDA) 150000 8.46 (+0.66)          Matt Dillon (MDILL) 25000 7.65 (-0.10)          Matt Dillon (MDILL) 25000 7.65 (-0.10)          Elsinore (ELSNR) 150000 7.34 (+0.59)          Elsinore (ELSNR) 150000 7.34 (+0.59)          Club Kid (CLUBK) 50000 12.84 (-0.04)          Ali G: Who Iz I? (ALIG2) 100000 20.64 (-0.09)          Alien sequel (ALIE6) 140000 64.46 (-0.98)          Astaire (ASTAI) 150000 16.90 (+0.90)          Alien sequel (ALIE6) 60198 64.46 (-0.98)          Ramayana (RAMAY) 1073 14.98 (+0.17)          David Jonsson (DJONS) 25000 42.46 (+0.66)          David Jonsson (DJONS) 25000 42.46 (+0.66)