HSX Forum

Playing & Trading Strategy

When your ideas are more developed, post here. I may be able to help out with historical data, etc. {nm}

Posted by: RogerMore on Feb 05, 15:35 in response to Smartlink's post For Starbond, maybe keep track of next 90 days Adjusts or...

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. 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)