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!


Hadestown: The Musical (HDSTW) 20000 20.67 (+0.38)          Moana (MOAN1) 30000 117.45 (-0.06)          Elsinore (ELSNR) 150000 7.38 (+0.63)          NDA (NDA) 150000 8.50 (+0.70)          The Stunt Driver (STNTD) 150000 1.78 (-0.04)          Ali G: Who Iz I? (ALIG2) 143188 20.58 (-0.15)          Paranormal Activity 8 (PNAC8) 1000 31.08 (-0.03)          Atonement (ATONM) 150000 1.88 (-0.12)          I Want Your Sex (IWYSX) 50000 3.66 (+0.07)          I Want Your Sex (IWYSX) 50000 3.66 (+0.07)          I Want Your Sex (IWYSX) 50000 3.66 (+0.07)          I Want Your Sex (IWYSX) 50000 3.66 (+0.07)          I Want Your Sex (IWYSX) 50000 3.66 (+0.07)          I Want Your Sex (IWYSX) 50000 3.66 (+0.07)          Paper Tiger (PTIGR) 1000 29.95 (-0.06)          Wonder Woman (WOND3) 118000 37.11 (+0.07)          Paddington 4 (PADT4) 149999 37.26 (+0.06)          Paris Paramount aka Untitled Nan (PRSPM) 2500 57.70 (-0.05)          Tony (TONY) 149999 17.65 (+0.51)          Super Troopers 3 (STRO3) 149999 24.36 (+0.12)          One Night Only (ONTON) 149999 23.78 (-0.05)          Ice Cream Man (ICREM) 149999 12.94 (-0.07)          The Matrix 5 (MTRX5) 150000 29.38 (-0.14)          Blade (BLAD1) 105979 17.59 (-0.03)          Alien sequel (ALIE6) 150000 64.44 (-1.00)          Alien sequel (ALIE6) 150000 64.44 (-1.00)          Coward (COWRD) 150000 0.96 (-0.04)          Atonement (ATONM) 150000 1.88 (-0.12)          Varanasi (VARAN) 767 7.15 (0.00)          PAW Patrol: The Dino Movie (PAWP3) 554 41.23 (0.00)          Victorian Psycho (VPSYC) 7676 14.05 (+0.91)          Dennis (DENIS) 7899 5.33 (+0.23)          Dennis (DENIS) 6577 5.33 (+0.23)          Tom Holland (TOHOL) 25000 149.09 (+0.40)          Jon Bernthal (JBERN) 25000 47.44 (0.00)          Florence Pugh (FPUGH) 25000 156.11 (+0.50)          Not Alone (NTALN) 200 114.28 (-0.11)          Incredibles 3 (NCRD3) 50 411.02 (+0.49)          Everytime (EVRTM) 19 0.31 (0.00)          Donkey (DONKE) 100 129.09 (0.00)          Atonement (ATONM) 5000 1.88 (-0.12)          Resident Evil (RESE8) 166 71.41 (0.00)          Ramayana (RAMAY) 2477 14.98 (+0.17)          Alien sequel (ALIE6) 150000 64.44 (-1.00)