HSX Forum

Playing & Trading Strategy

Not sure I got the formula right, what information should this output? must did something wrong...

Posted by: Smartlink on Feb 05, 15:59 in response to RazorHawk's post Release Date/Delist Date

Did but realse date in "X" cell, then using formula (adpated for "X"cell) I get a huge result. 41316,00 date entered was 2013-01-18 (Mama or Broken City)

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 Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          Hoppers (HOPPR) 10 137.09 (-0.95)          The Bride! (BRIDE) 4 23.48 (-0.03)          Mortal Kombat II (MKMB2) 10000 75.88 (-0.18)          Varanasi (VARAN) 150000 10.00 (0.00)          Varanasi (VARAN) 150000 10.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.PU) 25000 2.00 (0.00)          The Drama H$15 Call (TDRAM.CA) 25000 2.00 (0.00)          The Drama - Opening Weekend (TDRAM.OW) 100000 15.00 (0.00)          The Drama H$15 Put (TDRAM.PU) 25000 2.00 (0.00)          Varanasi (VARAN) 150000 10.00 (0.00)          Undertone (UNDTN) 60000 21.17 (-0.02)          The Drama H$15 Put (TDRAM.PU) 25000 2.00 (0.00)          The Drama - Opening Weekend (TDRAM.OW) 100000 15.00 (0.00)          The Drama H$15 Call (TDRAM.CA) 25000 2.00 (0.00)          The Super Mario Galaxy Movie (MARI2) 20000 497.03 (-1.54)          James Bond 26 (JB26) 3000 158.05 (-0.02)          The Super Mario Galaxy Movie - O (MARI2.OW) 5000 145.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          The Drama H$15 Put (TDRAM.PU) 5000 2.00 (0.00)          Charlie Day (CDAY) 25000 89.55 (+0.25)          The Super Mario Galaxy Movie H$1 (MARI2.PU) 25000 2.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 5000 2.00 (0.00)          Spider-Man: Brand New Day (SPID9) 8780 422.03 (+2.03)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          The Super Mario Galaxy Movie (MARI2) 150000 497.03 (-1.54)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          World War Hulk (THLK2) 37500 36.15 (-0.05)          Varanasi (VARAN) 150000 10.00 (0.00)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          Evil Dead Burn (EVLD6) 374 46.97 (-0.07)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          Reminders of Him (RMNDH) 60000 38.04 (-0.27)          Joel Edgerton (JEDGE) 25000 15.29 (-0.29)          Luis Guzman (LGUZM) 25000 30.30 (+0.25)          Joel Edgerton (JEDGE) 25000 15.29 (-0.29)          Varanasi (VARAN) 150000 10.00 (0.00)          Jack Ryan: Ghost War (RYAN1) 139 13.78 (-0.48)          A Quiet Place: Part III (AQPL4) 15985 110.79 (+2.62)          The Super Mario Galaxy Movie H$1 (MARI2.CA) 25000 2.00 (0.00)          The Super Mario Galaxy Movie - O (MARI2.OW) 100000 145.00 (0.00)          Helldivers (HELDV) 31000 98.75 (-0.04)