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!


The Origin of the World (TOOTW) 10000 17.77 (-0.53)          Eiza Gonzalez (EGONZ) 25000 11.66 (-0.09)          Golshifteh Farahani (GFARA) 25000 56.04 (-0.16)          Wilford Nappy Pulawa biopic (NAPPY) 8000 51.99 (-0.15)          Don Cheadle (DCHEA) 25000 121.00 (+0.34)          Emma Mackey (EMACK) 25000 51.42 (+0.34)          Chloe Sevigny (CSEVI) 25000 0.71 (+0.02)          Emma Mackey (EMACK) 25000 51.42 (+0.34)          Eiza Gonzalez (EGONZ) 25000 11.66 (-0.09)          Asa Butterfield (ABUTT) 25000 1.04 (+0.03)          Don Cheadle (DCHEA) 25000 121.00 (+0.34)          Chloe Sevigny (CSEVI) 25000 0.71 (+0.02)          Alessandro Nivola (ANIVO) 20000 17.72 (-0.09)          Please (PLESE) 20000 21.61 (-0.47)          Sigourney Weaver (SWEAV) 25000 133.28 (-0.01)          Martin Scorsese (MSCOR) 25000 46.74 (0.00)          Noah Centineo (NCENT) 25000 52.83 (-0.16)          Jeremy Allen White (JEAWH) 25000 45.21 (+0.15)          Sigourney Weaver (SWEAV) 25000 133.28 (-0.01)          Sigourney Weaver (SWEAV) 25000 133.28 (-0.01)          Keke Palmer (KPALM) 25000 63.47 (0.00)          Keke Palmer (KPALM) 25000 63.47 (0.00)          Demi Moore (DMOOR) 20000 9.81 (+0.02)          Lakeith Stanfield (LSTAN) 25000 8.70 (0.00)          Lakeith Stanfield (LSTAN) 25000 8.70 (0.00)          Melissa Leo (MLEO) 25000 28.46 (+0.01)          Martin Scorsese (MSCOR) 25000 46.74 (0.00)          Naomi Ackie (NACKI) 25000 14.06 (0.00)          Naomi Ackie (NACKI) 25000 14.06 (0.00)          David Robert Mitchell (DRMIT) 25000 22.42 (+0.42)          Alessandro Nivola (ANIVO) 25000 17.72 (-0.09)          Alessandro Nivola (ANIVO) 25000 17.72 (-0.09)          Don Cheadle (DCHEA) 25000 121.00 (+0.34)          Demi Moore (DMOOR) 25000 9.81 (+0.02)          Ken Russell's The Devil (KRSTD) 150000 1.97 (-0.03)          John Wick: Chapter 5 (WICK5) 860 66.45 (0.00)          Wilford Nappy Pulawa biopic (NAPPY) 150000 51.99 (-0.15)          Wilford Nappy Pulawa biopic (NAPPY) 150000 51.99 (-0.15)          Moana (MOAN1) 149999 241.46 (-0.99)          A Visit to Grandpa’s (AVTGP) 150000 3.64 (-0.14)          A Visit to Grandpa’s (AVTGP) 150000 3.64 (-0.14)          When Darkness Loves Us (WDLUS) 150000 8.04 (-0.16)          When Darkness Loves Us (WDLUS) 150000 8.04 (-0.16)          Buddy (BUDDY) 150000 7.00 (-0.15)          Buddy (BUDDY) 150000 7.00 (-0.15)          Dinner With Audrey (DWAUD) 150000 4.17 (-0.15)          Dinner With Audrey (DWAUD) 150000 4.17 (-0.15)          Hot Spot (HTSPT) 150000 6.11 (-0.19)          Hot Spot (HTSPT) 150000 6.11 (-0.19)          Club Kid (CLUBK) 150000 13.12 (-0.35)