HSX Forum

Playing & Trading Strategy

For movie Stock, I now have formula working with post OW adj prediction based on OW prediction... (details inside)

Posted by: Smartlink on Feb 05, 18:32 in response to RogerMore's post What are your ideas around moviestock and starbond...

Ok I take OW prediction, * 2.7 (or the applicable multiplier, think I accounted for all possibilities). I use this to calculate the estimated Post OW adjust, if the Current stock price is lower or higher it will recommend a buy or short on stock.

=IF(F3="";"";IF(J3F3;"Buy";)))

J3= Post OW Adjust F3=Current MovieStock Price

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!


Emma Mackey (EMACK) 25000 51.08 (-1.23)          Naomi Ackie (NACKI) 25000 14.06 (-0.32)          Naomi Ackie (NACKI) 25000 14.06 (-0.32)          Noah Centineo (NCENT) 25000 52.99 (+0.07)          Emma Mackey (EMACK) 25000 51.08 (-1.23)          Chloe Sevigny (CSEVI) 25000 0.69 (-0.39)          Chloe Sevigny (CSEVI) 25000 0.69 (-0.39)          Keke Palmer (KPALM) 25000 63.47 (+1.25)          Broadsword (BROSW) 12000 42.82 (-2.10)          Keke Palmer (KPALM) 25000 63.47 (+1.25)          Toy Story 5 (TOYS5) 20000 407.77 (+2.37)          The Comebacker (CMBAC) 20000 28.39 (+2.35)          Lakeith Stanfield (LSTAN) 25000 8.70 (-2.19)          Lakeith Stanfield (LSTAN) 25000 8.70 (-2.19)          Alessandro Nivola (ANIVO) 25000 17.81 (+0.23)          Alessandro Nivola (ANIVO) 25000 17.81 (+0.23)          Will Poulter (WPOUL) 24999 59.71 (+1.02)          Asa Butterfield (ABUTT) 25000 1.01 (-0.03)          Martin Scorsese (MSCOR) 25000 46.74 (+13.85)          Asa Butterfield (ABUTT) 25000 1.01 (-0.03)          David Robert Mitchell (DRMIT) 20000 22.00 (0.00)          Melissa Leo (MLEO) 25000 28.45 (-0.89)          Jimmy O. Yang (JYANG) 25000 15.15 (-0.15)          Jon Favreau (JFAVR) 25000 233.04 (-1.20)          Jaeden Martell (JALIE) 25000 34.45 (-19.51)          Emma Mackey (EMACK) 25000 51.08 (-1.23)          Emma Mackey (EMACK) 25000 51.08 (-1.23)          Sigourney Weaver (SWEAV) 1 133.29 (+9.44)          Sigourney Weaver (SWEAV) 25000 133.29 (+9.44)          Naomi Ackie (NACKI) 25000 14.06 (-0.32)          Ken Russell's The Devil (KRSTD) 150000 2.00 (0.00)          Eiza Gonzalez (EGONZ) 25000 11.75 (-2.19)          David Robert Mitchell (DRMIT) 25000 22.00 (0.00)          Pedro Pascal (PPASC) 24999 126.81 (+0.99)          Don Cheadle (DCHEA) 25000 120.66 (-4.63)          Martin Scorsese (MSCOR) 20000 46.74 (+13.85)          My Darling California (MDCAL) 150000 22.91 (-0.42)          Asa Butterfield (ABUTT) 25000 1.01 (-0.03)          Alessandro Nivola (ANIVO) 25000 17.81 (+0.23)          Chloe Sevigny (CSEVI) 25000 0.69 (-0.39)          Chloe Sevigny (CSEVI) 25000 0.69 (-0.39)          Naomi Ackie (NACKI) 24999 14.06 (-0.32)          Broadsword (BROSW) 150000 42.82 (-2.10)          David Robert Mitchell (DRMIT) 25000 22.00 (0.00)          The Comebacker (CMBAC) 150000 28.39 (+2.35)          Ken Russell's The Devil (KRSTD) 150000 2.00 (0.00)          Star Wars: The Mandalorian and G (SWAR3.BW) 25000 6.51 (+0.83)          Ken Russell's The Devil (KRSTD) 150000 2.00 (0.00)          Keke Palmer (KPALM) 24999 63.47 (+1.25)          Keke Palmer (KPALM) 25000 63.47 (+1.25)