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!


Send Help (SENDH) 1419 45.73 (0.00)          Wuthering Heights (WUTHR) 150000 87.31 (+0.16)          John Wick Prequel (WICK0) 150000 32.81 (+0.20)          Street Fighter (STFTR) 150000 73.69 (+0.33)          Melania (MLNIA) 150000 13.86 (-0.86)          Shiver (SHVER) 150000 51.68 (+0.61)          John Wick Prequel (WICK0) 1 32.81 (+0.20)          The Entertainment System Is Down (TESID) 1 11.91 (0.00)          Shiver (SHVER) 150000 51.68 (+0.61)          Roman Griffin Davis (RGDAV) 25000 36.34 (-0.13)