HSX Forum

Playing & Trading Strategy

Release Date/Delist Date

Posted by: RazorHawk on Feb 05, 15:13 in response to Smartlink's post Now finishing 1st version of my HSX Excel tools. My...

 

Enter Release Date(wide) In H9

=IF(H9="","",IF(WEEKDAY(H9,1)=6,H9+24,IF(WEEKDAY(H9,1)=5,H9+25,IF(WEEKDAY(H9,1)=4,H9+26,IF(WEEKDAY(H9,1)=3,H9+27,IF(WEEKDAY(H9,1)=2,H9+28,IF(WEEKDAY(H9,1)=7,H9+23,"0")))))))

 

Enter Release Date (limited) in H19

=IF(H19="","",IF(WEEKDAY(H19,1)=6,H19+80,IF(WEEKDAY(H19,1)=5,H19+81,IF(WEEKDAY(H19,1)=4,H19+82,IF(WEEKDAY(H19,1)=3,H19+83,IF(WEEKDAY(H19,1)=2,H19+84,IF(WEEKDAY(H19,1)=7,H19+79,"0")))))))

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 {nm} 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!

Ads disabled on hsx.com


In the Grey - Opening Weekend (NGREY.OW) 100000 3.74 (-0.53)          The Sun Never Sets (TSNVS) 75000 2.41 (+0.02)          In the Grey - Opening Weekend (NGREY.OW) 100000 3.74 (-0.53)          Mortal Kombat II (MKMB2) 150000 99.44 (-1.90)          Octet (OCTET) 25000 21.61 (+1.61)          White Elephant (WELEP) 125000 16.79 (+0.11)          Octet (OCTET) 3000 21.61 (+1.61)          Embers (EMBER) 150000 3.63 (-0.09)          Embers (EMBER) 150000 3.63 (-0.09)          Octet (OCTET) 22500 21.61 (+1.61)          White Elephant (WELEP) 150000 16.79 (+0.11)          White Elephant (WELEP) 150000 16.79 (+0.11)          Daniel: The Fiery Furnace (DANIL) 20000 5.00 (0.00)          The Catch (TCATC) 100 63.76 (+0.54)          (Saint) Peter (STPET) 125000 5.56 (+0.59)          Man of Tomorrow (SPMOT) 1 261.33 (-0.34)          Scream 8 (SCRM8) 100 77.71 (-0.08)          Obsession (OBSSN) 1 22.28 (-0.47)          Obsession (OBSSN) 25000 22.28 (-0.47)          Incredibles 3 (NCRD3) 5 381.49 (+0.46)          Teenage Mutant Ninja Turtles: Mu (TMNT4) 25000 76.24 (+0.12)          White Elephant (WELEP) 24999 16.79 (+0.11)          The Bourne Dilemma (BORN6) 100 81.25 (-0.16)          Fing! (FING) 10000 5.14 (-0.35)          Fing! (FING) 30000 5.14 (-0.35)          Ally (ALLY) 2000 21.75 (+1.33)          Elden Ring (ELDEN) 1000 53.08 (+0.36)          Lena Headey (LHEAD) 15000 7.84 (-6.63)          Daniel: The Fiery Furnace (DANIL) 1000 5.00 (0.00)          Voltron (VOLTN) 150000 22.23 (-0.39)          Clayface (CLAYF) 1000 87.21 (+0.48)          Daniel: The Fiery Furnace (DANIL) 100000 5.00 (0.00)          Peter Asher: Everywhere Man (PAEWM) 150000 0.56 (-0.44)          Octet (OCTET) 150000 21.61 (+1.61)          Avengers: Doomsday (AVNG5) 2000 539.78 (-1.07)          Chris O'Dowd (CODOW) 5000 23.51 (-0.27)          Fonda (FONDA) 150000 8.84 (+0.75)          The Batman: Part II (TBAT2) 1 251.35 (+0.80)          Fonda (FONDA) 150000 8.84 (+0.75)          Patrick Stewart (PSTEW) 5000 56.05 (-0.70)          Lena Headey (LHEAD) 25000 7.84 (-6.63)          (Saint) Peter (STPET) 10000 5.56 (+0.59)          (Saint) Peter (STPET) 60000 5.56 (+0.59)          Daniel: The Fiery Furnace (DANIL) 30026 5.00 (0.00)          The Rivals Of Amziah King (TROAK) 50000 5.03 (-0.29)          Ben Wheatley (BWHEA) 25000 18.18 (+0.33)          The Rivals Of Amziah King (TROAK) 10000 5.03 (-0.29)          White Elephant (WELEP) 70000 16.79 (+0.11)          White Elephant (WELEP) 40000 16.79 (+0.11)          Fonda (FONDA) 40000 8.84 (+0.75)