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!


One Spoon of Chocolate (OSOCH) 150000 1.44 (-0.07)          Monopoly (MONOP) 149999 9.14 (+0.43)          Hokum (HOKUM) 149999 16.22 (+3.41)          Rolling Loud (RLOUD) 150000 9.70 (+0.36)          Rolling Loud (RLOUD) 149999 9.70 (+0.36)          Hokum (HOKUM) 150000 16.22 (+3.41)          Felicity Jones (FJONE) 12500 12.36 (+0.15)          Good People Bad Things (GPBT) 150000 13.29 (+0.23)          The Devil Wears Prada 2 (PRAD2) 9634 217.04 (-5.79)          The Devil Wears Prada 2 (PRAD2) 150000 217.04 (-5.79)          Good People Bad Things (GPBT) 149999 13.29 (+0.23)          Moral Capacity (MORLC) 150000 5.04 (+0.17)          Moral Capacity (MORLC) 149999 5.04 (+0.17)          Her Private Hell (HERPH) 150000 7.37 (+0.08)          Her Private Hell (HERPH) 149999 7.37 (+0.08)          Mutiny (MUTNY) 1 26.96 (+0.14)          The Isolate Thief (ISOLT) 150000 0.91 (+0.11)          The Isolate Thief (ISOLT) 149999 0.91 (+0.11)          Jackass: Best and Last (JCKA6) 1 57.00 (+0.13)          The Wrong Girls (TWRNG) 150000 9.34 (+0.04)          The Devil Wears Prada 2 (PRAD2) 150000 217.04 (-5.79)          The Wrong Girls (TWRNG) 149999 9.34 (+0.04)          Whalefall (WHALF) 149999 30.80 (+1.85)          The Devil Wears Prada 2 (PRAD2) 150000 217.04 (-5.79)          The Devil Wears Prada 2 (PRAD2) 150000 217.04 (-5.79)          Whalefall (WHALF) 149999 30.80 (+1.85)          Exit 8 (EXIT8) 1 3.89 (+0.02)          The Catch (TCATC) 150000 50.00 (0.00)          Digger (DIGER) 120000 120.10 (-0.67)          Wishful Thinking (WSHFT) 150000 4.00 (-0.21)          Wishful Thinking (WSHFT) 149999 4.00 (-0.21)          Hershey (HERSH) 150000 14.92 (-0.30)          Hershey (HERSH) 149999 14.92 (-0.30)          Animal Farm (AFARM) 150000 7.92 (-0.28)          The Catch (TCATC) 150000 50.00 (0.00)          Animal Farm (AFARM) 50605 7.92 (-0.28)          The Catch (TCATC) 100000 50.00 (0.00)          Hokum (HOKUM) 150000 16.22 (+3.41)          Hokum (HOKUM) 150000 16.22 (+3.41)          The Catch (TCATC) 150000 50.00 (0.00)          The Devil Wears Prada 2 (PRAD2) 150000 217.04 (-5.79)          The Catch (TCATC) 150000 50.00 (0.00)          Hokum (HOKUM) 150000 16.22 (+3.41)          Godzilla x Kong: Supernova (GOKO3) 40000 156.41 (-0.19)          Toy Story 5 (TOYS5) 10000 362.28 (-0.47)          James Bond 26 (JB26) 50000 152.76 (-1.48)          The Horror Fund X (SPOOK) 20000 25.66 (-0.03)          Ono Ghost Market (ONOGM) 40000 86.08 (+1.01)          The Catch (TCATC) 40000 50.00 (0.00)          Planet of the Apes sequel (APES5) 40000 48.17 (-0.42)