HSX Forum

Playing & Trading Strategy

Also, I keep a similar spreadsheet to track prediction sites against moviestock and OW adjusts. (not calls/puts, though I suppose I could)

Posted by: RogerMore on Feb 05, 14:55 in response to Smartlink's post Now finishing 1st version of my HSX Excel tools. My...

A couple of suggested calculations that you might want to include:

the per screen average needed to make the current price and the predictions made by the various prediction sites.  This gives you another way of making comparisons with similar movies.

the cost of flipping the stock.

Conditional formatting is very helpful - I use it a lot in my bonds spreadsheet

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!


Angel and the Badman (ANBAD) 150000 4.05 (-0.03)          The Great Beyond aka Ghostwriter (ACRNS) 150000 89.32 (+0.16)          How to Rob a Bank - Opening Week (HTRAB.OW) 100000 15.42 (-0.02)          The Hunger Games: Sunrise on the (HGAM6) 150000 197.58 (+1.38)          Sight & Sound Presents: Josh (SSPJL) 1 3.19 (+0.08)          The Mongoose (MNGOS) 1 1.33 (0.00)          Ebenezer - Opening Weekend (EBNZR.OW) 100000 35.31 (-0.97)          Christmas At The Kringles (CKRNG) 1 5.62 (-0.13)          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.42 (-0.02)          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 197.58 (+1.38)          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.31 (-0.97)          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)