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!


Helldivers (HELDV) 3 101.75 (-1.76)          Boner aka Rise (VIAGR) 150000 1.75 (0.00)          Here Comes the Flood (HCTFL) 150000 0.24 (+0.09)          Letitia Wright (LWRIG) 25000 144.03 (-0.66)          The Comebacker (CMBAC) 1 28.40 (+2.36)          The Comebacker (CMBAC) 1 28.40 (+2.36)          Boiuna: Legend of the Amazon (BOUNA) 150000 17.02 (+0.01)          Buddy (BUDDY) 3 7.15 (+1.60)          Buddy (BUDDY) 3 7.15 (+1.60)          Kathryn Newton (KNEWT) 25000 68.99 (+0.50)          Blood on Snow (BLOSN) 150000 14.56 (-0.07)          Bitter Christmas (BITRC) 150000 0.74 (+0.03)          Supergirl - Opening Weekend (SUPGR.OW) 99999 57.16 (+0.47)          Being Heumann (BHEUM) 150000 0.42 (+0.02)          Lilo & Stitch 2 (LILS2) 50000 268.29 (-0.54)          Being Mortal (BMRTL) 150000 0.07 (-0.01)          The Death of Robin Hood - Openin (TDORH.OW) 100000 8.35 (-0.30)          Toy Story 5 - Opening Weekend (TOYS5.OW) 99999 145.15 (+0.80)          Belly of the Beast (BELYB) 150000 3.21 (+0.04)          Ken Russell's The Devil (KRSTD) 50000 2.00 (0.00)          Bermuda (BTRIA) 150000 0.67 (+0.02)          Incredibles 3 (NCRD3) 50000 391.28 (-3.36)          Tony (TONY) 150000 20.79 (-0.06)          Big Thunder Mountain (BTMTN) 150000 20.12 (-0.02)          Lakeith Stanfield (LSTAN) 25000 8.70 (-2.19)          X-Men aka Mutants (XMEN8) 1 165.72 (-1.19)          X-Men aka Mutants (XMEN8) 1 165.72 (-1.19)          Billion Dollar Spy (BDSPY) 150000 5.18 (-0.01)          Bitcoin: Killing Satoshi (KSATO) 150000 18.63 (-0.04)          Toy Story 5 (TOYS5) 3 407.78 (+2.38)          Beautiful (BUTIF) 150000 2.69 (-0.04)          Bedford Park (BEDFP) 150000 0.97 (+0.01)          Keke Palmer (KPALM) 11 63.47 (+1.25)          Florence Pugh (FPUGH) 25000 155.83 (0.00)          Be My Baby (BMYBB) 150000 10.41 (-0.04)          Asa Butterfield (ABUTT) 25000 1.01 (-0.03)          Incredibles 3 (NCRD3) 50000 391.28 (-3.36)          The Origin of the World (TOOTW) 1 18.18 (+1.15)          Asa Butterfield (ABUTT) 20000 1.01 (-0.03)          The Origin of the World (TOOTW) 1 18.18 (+1.15)          Please (PLESE) 2 21.96 (+1.03)          Baton (BATON) 150000 4.89 (+0.02)          Please (PLESE) 2 21.96 (+1.03)          Will Forte (WFORT) 25000 14.64 (-1.12)          Will Forte (WFORT) 20000 14.64 (-1.12)          Alessandro Nivola (ANIVO) 20000 17.81 (+0.23)          Barracuda (BRCUD) 150000 8.51 (0.00)          Elizabeth Olsen (EOLSE) 25000 153.08 (0.00)          Chloe Sevigny (CSEVI) 25000 0.69 (-0.39)          Toy Story 5 (TOYS5) 150000 407.78 (+2.38)