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!


Ghost Soldier (ARCNG) 10000 24.67 (+0.03)          How to Rob a Bank H$15 Put (HTRAB.PU) 25000 1.65 (-0.06)          How to Rob a Bank H$15 Put (HTRAB.PU) 25000 1.65 (-0.06)          How to Rob a Bank H$15 Call (HTRAB.CA) 25000 2.25 (+0.01)          Wild Horse Nine (WILDH) 10000 14.44 (-0.08)          How to Rob a Bank H$15 Call (HTRAB.CA) 25000 2.25 (+0.01)          How to Rob a Bank - Opening Week (HTRAB.OW) 100000 15.47 (+0.03)          Turpentine (TURPN) 150000 7.56 (+1.69)          Ebenezer H$35 Put (EBNZR.PU) 25000 2.59 (+0.12)          Ebenezer H$35 Put (EBNZR.PU) 25000 2.59 (+0.12)          The Hunger Games: Sunrise on the (HGAM6) 150000 198.07 (+1.87)          Ebenezer H$35 Call (EBNZR.CA) 25000 1.40 (-0.12)          Swamp Thing (SWAMP) 3 17.11 (-0.04)          Ebenezer H$35 Call (EBNZR.CA) 25000 1.40 (-0.12)          They Follow aka It Follows 2 (TFLW2) 3 7.15 (-0.01)          Tyrant (TYRNT) 150000 19.16 (+2.55)          The Cat in the Hat (TCATH) 5000 101.08 (-0.16)          Ebenezer - Opening Weekend (EBNZR.OW) 100000 35.41 (-0.87)          The Memory Police (TMEMP) 375 3.63 (-0.02)          Untitled A24 Horror Film aka Unt (UASTE) 3 25.35 (-0.06)          Crazy Rich Asians 2 (CRAS2) 1000 9.61 (+0.01)          The Man with the Bag (TMWTB) 3 6.09 (-0.01)          Tomb Raider (TOMB4) 50 1.86 (0.00)          Swamp Thing (SWAMP) 1000 17.11 (-0.04)          White Elephant (WELEP) 3 11.92 (+0.02)          What Happens At Night (WHANT) 3 49.26 (-0.10)          White Lies (WHTLI) 4 11.88 (+0.04)          The Movie Critic (TMOVC) 1000 10.39 (-0.04)          John Wick Prequel (WICK0) 2 25.79 (+0.03)          John Wick: Chapter 5 (WICK5) 65 57.64 (-0.05)          Static Shock (STATC) 1000 1.82 (-0.01)          Emily Blunt (EBLUN) 1 124.11 (0.00)          Claire Foy (CFOY) 1 5.86 (0.00)          Scarlett Johansson (SJOHA) 1 62.32 (0.00)          Blade (BLAD1) 1000 13.84 (0.00)          Wind of Change (WNDOC) 8 2.96 (-0.02)          Watch Dogs (WTDOG) 3 6.97 (-0.01)          Wonka 2 (WONK2) 3 32.04 (-0.03)          Hourman (HRMAN) 1000 5.75 (+0.03)          Wonder Woman (WOND3) 3 31.56 (-0.03)          Jonathan Bailey (JBAIL) 7 147.56 (-0.03)          Anne Hathaway (AHATH) 6 116.62 (-0.33)          The Authority (AUTHO) 1000 8.20 (-0.01)          Ben Stiller (BSTIL) 5 56.26 (-0.16)          Julia Roberts (JROBE) 5 54.98 (-0.16)          Lewis Tan (LTAN) 7 122.65 (-0.66)          Aaron Sorkin (ASORK) 104 12.55 (-0.20)          Fede Alvarez (FALVA) 120 66.59 (0.00)          Monica Barbaro (MBARB) 3 96.51 (+0.25)          Emma Corrin (EMCOR) 3 108.99 (+0.33)