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!


The Catch (TCATC) 150000 50.00 (0.00)          John Travolta (JTRAV) 24999 19.26 (-0.01)          Lee Cronin's The Mummy (TMUMY) 150000 29.20 (-0.46)          David Harbour (DHARB) 25000 71.91 (+0.50)          The Catch (TCATC) 150000 50.00 (0.00)          The Catch (TCATC) 150000 50.00 (0.00)          Hokum (HOKUM) 150000 15.85 (+3.04)          A Colt Is My Passport (ACIMP) 10000 7.92 (-0.08)          David Harbour (DHARB) 25000 71.91 (+0.50)          Angel and the Badman (ANBAD) 150000 13.85 (+1.71)          Hokum (HOKUM) 150000 15.85 (+3.04)          The Super Mario Galaxy Movie $39 (MARI2.BW) 1000 10.87 (+0.86)          The Catch (TCATC) 150000 50.00 (0.00)          Hokum (HOKUM) 150000 15.85 (+3.04)          The Catch (TCATC) 150000 50.00 (0.00)          The Catch (TCATC) 150000 50.00 (0.00)          Moana (MOAN1) 10000 228.68 (+0.93)          Planet of the Apes sequel (APES5) 15000 48.14 (-0.45)          Moana (MOAN1) 25000 228.68 (+0.93)          Narnia: The Magician's Nephew (NARN4) 10000 21.69 (+0.36)          Tangled (TANGL) 150000 117.11 (+0.45)          The Devil Wears Prada 2 (PRAD2) 150000 217.06 (-5.77)          The Catch (TCATC) 150000 50.00 (0.00)          The Catch (TCATC) 150000 50.00 (0.00)          Star Wars: The Mandalorian and G (SWAR3) 111272 198.82 (-0.04)          It Ends (ITNDS) 150000 5.20 (+0.03)          Doctor Strange 3 (DRST3) 25000 77.11 (-1.27)          4 x 4: The Event (4X4TE) 150000 8.70 (-0.02)          The Catch (TCATC) 5000 50.00 (0.00)          The Devil Wears Prada 2 (PRAD2) 1 217.06 (-5.77)          Supergirl (SUPGR) 1 159.59 (-0.86)          The Catch (TCATC) 150000 50.00 (0.00)          Moana (MOAN1) 5622 228.68 (+0.93)          The Catch (TCATC) 150000 50.00 (0.00)          Supergirl (SUPGR) 149999 159.59 (-0.86)          Incredibles 3 (NCRD3) 200 379.03 (-0.21)          The Kidnapping of Arabella (TKOAR) 45000 0.76 (-0.24)          Bloodsport (BLDSP) 60000 21.62 (-0.02)          Wonder Woman (WOND3) 149999 50.93 (+0.09)          Ally (ALLY) 60000 21.53 (-0.16)          Animal Farm (AFARM) 150000 7.94 (-0.26)          Whitney Springs aka Untitled Tre (WHTSP) 149999 21.92 (-0.01)          The Catch (TCATC) 100000 50.00 (0.00)          The Catch (TCATC) 150000 50.00 (0.00)          The Man with the Bag (TMWTB) 150000 12.15 (-0.15)          The Man with the Bag (TMWTB) 149999 12.15 (-0.15)          Planet of the Apes sequel (APES5) 149999 48.14 (-0.45)          The Devil Wears Prada 2 (PRAD2) 150000 217.06 (-5.77)          Backrooms (BACRM) 40000 39.78 (-0.13)          The Devil Wears Prada 2 (PRAD2) 150000 217.06 (-5.77)