HSX Forum

CelebStock and StarBonds

No - you are right. Excel decided to treat a bunch of delisted stocks as active and tried to look up their prices. Here are the correct #s

Posted by: RogerMore on Jan 11, 15:33 in response to ophelia665's post ok, errors i see inside

Star Current
 price
Out of TAG next Gross of movie leaving TAG Entering TAG next Price of movie entering TAG next Expected TAG at next adjust Next
adjust date
Days to adjust dROI
AFARI  $   98.43 HBUNY  $   48.24 TMHTN  $   21.86  $   93.15 05/24/2011 133 0.03%
AMADA  $   73.43 SUNCL  $   12.03 MUPET  $   74.18  $   85.86 12/20/2011 343 0.04%
CBALE  $ 106.84 DYLAN  $    4.00 BATM3  $ 250.00  $ 156.04 08/14/2012 581 0.06%
DARON  $   20.30 RQDRM  $    3.61 WOLV2  $ 138.49  $   47.28
DAYKR  $   54.07 BRTYT  $    0.93 BURKE  $    3.12  $   54.50
DKRUG  $   68.34 COPYB  $    0.35 UWMAL  $   45.77  $   77.43 03/15/2011 63 0.17%
DMULR  $   11.82 ZODIC  $   33.05 SXBLT  $    0.01  $    5.22
DORUS  $   43.76    UNCHT  $   45.58  $   44.22
GHEDL  $   65.23 4BROS  $   74.48 CSTRN  $   20.46  $   54.42 02/01/2011 21 0.66%
JBRID  $   44.58 HLFAP  $    2.78 TGRIT  $ 114.14  $   66.85 01/18/2011 7 5.70%
JFRAI  $   45.96 CRSTO  $   54.23  $        -     
JLBRO  $   72.85     $        -     
JNICH  $ 102.60 ANGER  $ 133.76  $        -     
JTIMB  $   40.40 SLNDT  $    0.27 BDTCH  $   53.67  $   51.08 07/12/2011 182 0.12%
MISHE  $ 138.89 UNDW3  $   45.80 MIDNP  $    3.86  $ 130.50
MKUNI  $   61.25 PAYNE  $   40.69 FWBFT  $   62.02  $   65.52 08/16/2011 217 0.02%
MLEO  $   22.71 RTKIL  $   40.08 WRILY  $    0.16  $   14.73 01/18/2011 7 4.21%
MWAHL  $   72.09 PAYNE  $   40.69 CNTRB  $   33.51  $   70.65 04/10/2012 455 0.00%
NPORT  $   23.80 BOLYN  $   26.81 NSATA  $   53.19  $   29.07 02/15/2011 35 0.52%
OWILD  $   45.58 ALPHA  $   15.23 CBALN  $ 180.44  $   78.62 08/23/2011 224 0.24%
OWILS  $   80.77 MARLY  $ 143.15 MPRN3  $ 127.40  $   74.05 01/18/2011 7 0.89%
PRUDD  $   87.75 ROMOD  $   67.27 WLUST  $   47.55  $   80.23 11/01/2011 294 0.02%
RWITH  $   73.40 RNDTN  $    9.66 WELPH  $   59.01  $   79.69 05/17/2011 126 0.05%
SSHEP  $    8.12 DNTCK  $    0.44 FGAME  $    9.24  $    9.88 01/25/2011 14 1.28%
VCASS  $   23.03 DRAIL  $   36.02 11MNS  $    0.24  $   15.87
WRYDE  $   63.50 SCANR  $    5.48 DILEM  $   57.80  $   73.96 02/08/2011 28 0.48%

Experiencing technical problems. Post Adjust Bond Show will not be available until later today RazorHawk Jan 11, 11:50

In lieu of RH....for now: GHEDL BUY StarBondFund Short the Pats Jan 11, 12:07

in lieu of RH... JBRID....which was a short this week ... BUY StarBondFund Short the Pats Jan 11, 12:11

One more no er dilemma ....WRYDE.....next is DILEM which is replacing SCANR BUY StarBondFund Short the Pats Jan 11, 12:38

Here's my take on the post-adjust - let's see if it c&p's cleanly RogerMore Jan 11, 14:22

Here's my take on the post-adjust - let's see if it c&p's cleanly RogerMore Jan 11, 14:22

looks nice! (but I have spotted a few errors) {nm} RazorHawk Jan 11, 14:44

agreed, some of the future adjusts are off, but love that it includes droi. thanx. {nm} ophelia665 Jan 11, 14:48

Yeah, CBALE is off - I forgot to set the price for BATM3 at 250, but any others? {nm} RogerMore Jan 11, 14:58

Oh, and for some reason I have DMULR attached to JOLEN {nm} RogerMore Jan 11, 15:01

Actually, they are off. For some reason, this week's box office didn't take. I'll re-do and repost {nm} RogerMore Jan 11, 15:17

That doesn't count unless you share them {nm} RogerMore Jan 11, 14:52

wasn't having a competition... RazorHawk Jan 11, 15:30

Did I suggest you were? Like mrbinns said, if you have corrections, just post them {nm} RogerMore Jan 11, 15:35

No offense, but that is as meaningful as another nameless person saying :"I saw a movie, it sucks, but I cannot tell you the name." BUY StarBondFund Short the Pats Jan 11, 15:11

ok, errors i see inside ophelia665 Jan 11, 15:25

No - you are right. Excel decided to treat a bunch of delisted stocks as active and tried to look up their prices. Here are the correct #s RogerMore Jan 11, 15:33

(and thanks) {nm} RogerMore Jan 11, 15:34

Thank you for all the work and providing such a useful tool. {nm} ophelia665 Jan 11, 15:41

Oh,m and I have AFARI has having a double adjust, dropping HBUNY and OBSRV, and gaining TMHTN and WYNUM {nm} RogerMore Jan 11, 15:39





Post a Reply

To post to the forums you must first login!


Full Phil (FPHIL) 1 4.21 (-0.02)          Full Phil (FPHIL) 25000 4.21 (-0.02)          Margie Claus (MARGC) 1 34.04 (+0.03)          Aaron Eckhart (AECKH) 100 13.29 (-0.10)          Margie Claus (MARGC) 15000 34.04 (+0.03)          50 Cent Curtis Jackson (50CEN) 100 51.10 (-0.16)          The SpongeBob Movie: Search for (SPBO4) 150000 62.15 (-3.04)          The Sheep Detectives (3BAGF) 1 37.63 (+0.52)          The Sheep Detectives (3BAGF) 150000 37.63 (+0.52)          I Was a Stranger (TSCAS) 1 3.61 (+0.22)          I Was a Stranger (TSCAS) 150000 3.61 (+0.22)          The Chaperones (CHAPR) 1 10.24 (+0.53)          The Chaperones (CHAPR) 150000 10.24 (+0.53)          Corporate Retreat (CRPRT) 1 4.20 (+0.04)          Corporate Retreat (CRPRT) 80000 4.20 (+0.04)          Magic Hour (MGCHR) 150000 1.00 (0.00)          First Warrior (FWARR) 150000 4.00 (0.00)          Fellowship (FELWS) 150000 14.73 (-0.27)          Babies (BBIES) 150000 12.69 (-0.96)          Anaconda (ANAC3) 50000 66.29 (-4.69)          Marty Supreme - Opening Weekend (MRTSU.OW) 100000 13.61 (+1.68)          Anaconda (ANAC3) 20000 66.29 (-4.69)          Anaconda (ANAC3) 25000 66.29 (-4.69)          Avatar: Fire and Ash (AVAT3) 15000 419.10 (-20.06)          The Housemaid (HMAID) 20000 64.85 (-0.37)          The Breadwinner (BREDW) 29999 23.53 (-0.28)          The Breadwinner (BREDW) 60000 23.53 (-0.28)          50 Cent Curtis Jackson (50CEN) 25000 51.10 (-0.16)          Corporate Retreat (CRPRT) 30000 4.20 (+0.04)          Corporate Retreat (CRPRT) 49999 4.20 (+0.04)          Wuthering Heights (WUTHR) 19999 55.52 (+0.27)          Love is Not the Answer (LINTA) 149999 5.06 (+0.25)          Love is Not the Answer (LINTA) 75000 5.06 (+0.25)          Tangled (TANGL) 44999 95.12 (+5.68)          Marty Supreme - Opening Weekend (MRTSU.OW) 100000 13.61 (+1.68)          Avatar: Fire and Ash (AVAT3) 144637 419.10 (-20.06)          50 Cent Curtis Jackson (50CEN) 25000 51.10 (-0.16)          Constantine 2 (CNST2) 100 41.01 (-0.57)          Sonic the Hedgehog 4 (SONC4) 100 156.68 (-0.56)          The Beatles - A Four-Film Cinema (BEAT1) 100 106.87 (-0.55)          The Conjuring Prequel (CNJU5) 100 88.46 (-0.53)          Ghostwriter aka Acorns (ACRNS) 150000 112.15 (+2.16)          Tangled (TANGL) 150000 95.12 (+5.68)          Tangled (TANGL) 150000 95.12 (+5.68)          Avatar: Fire and Ash (AVAT3) 150000 419.10 (-20.06)          Avatar: Fire and Ash (AVAT3) 150000 419.10 (-20.06)          Avatar: Fire and Ash (AVAT3) 150000 419.10 (-20.06)          Avatar: Fire and Ash (AVAT3) 150000 419.10 (-20.06)          The SpongeBob Movie: Search for (SPBO4) 33800 62.15 (-3.04)          Avatar: Fire and Ash (AVAT3) 150000 419.10 (-20.06)