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!


Oh, the Places You'll Go (OTPYG) 1900 88.50 (-0.40)          The Catch (TCATC) 150000 58.23 (+4.24)          Demon Slayer: Infinity Castle 2 (DSIC2) 500 99.13 (0.00)          Hokum (HOKUM) 150000 17.44 (+1.82)          Bluey the Movie (BLUEY) 1000 134.13 (+0.12)          Good People Bad Things (GPBT) 150000 14.28 (+0.99)          The Catch (TCATC) 150000 58.23 (+4.24)          Cocomelon the Movie (COMEL) 2000 52.82 (-0.05)          The Angry Birds Movie 3 (ANGR3) 1000 37.43 (+0.04)          The Cat in the Hat (TCATH) 100 88.85 (-0.06)          Michael Sarnoski (MSARN) 25000 55.96 (+0.16)          Wildwood (WILDW) 300 9.92 (+0.01)          White Elephant (WELEP) 150000 18.00 (0.00)          Shaun The Sheep: The Beast Of Mo (SHEP3) 4000 13.00 (-0.05)          White Elephant (WELEP) 150000 18.00 (0.00)          Perfect Girl (PRFCG) 90000 6.48 (-0.02)          April X (APRLX) 150000 2.00 (0.00)          Them (THEM) 150000 41.21 (+1.21)          The Super Mario Galaxy Movie $39 (MARI2.BW) 25000 11.83 (+0.54)          The Amazing Digital Circus: The (AMZDC) 717 19.32 (+0.23)          The Sun Never Sets (TSNVS) 150000 2.50 (+0.77)          The Bookie & the Bruiser (TBATB) 150000 7.87 (+1.24)          The Amazing Digital Circus: The (AMZDC) 10000 19.32 (+0.23)          Swamp Thing (SWAMP) 120000 20.65 (-0.01)          The Angry Birds Movie 3 (ANGR3) 2000 37.43 (+0.04)          The Authority (AUTHO) 120000 11.57 (0.00)          Cocomelon the Movie (COMEL) 1000 52.82 (-0.05)          Them (THEM) 150000 41.21 (+1.21)          Spider-Man: Beyond the Spider-Ve (ASPD3) 1000 235.95 (+0.24)          The Catch (TCATC) 150000 58.23 (+4.24)          The Cat in the Hat (TCATH) 1000 88.85 (-0.06)          Rolling Loud (RLOUD) 10000 10.08 (+0.60)          Wildwood (WILDW) 100 9.92 (+0.01)          Rolling Loud (RLOUD) 10000 10.08 (+0.60)          The Housemaid's Secret (HMAI2) 900 88.41 (-0.23)          American Psycho (APSYC) 2000 19.21 (-0.31)          American Psycho (APSYC) 2000 19.21 (-0.31)          The Devil Wears Prada 2 (PRAD2) 150000 199.79 (-6.31)          Oh, the Places You'll Go (OTPYG) 100 88.50 (-0.40)          The Sun Never Sets (TSNVS) 150000 2.50 (+0.77)          Ono Ghost Market (ONOGM) 250 87.88 (+0.83)          Tony (TONY) 150000 16.19 (+3.25)          Tony (TONY) 150000 16.19 (+3.25)          Scary Movie 6 (SCAR6) 4000 74.83 (+0.40)          The Catch (TCATC) 150000 58.23 (+4.24)          The Catch (TCATC) 150000 58.23 (+4.24)          April X (APRLX) 150000 2.00 (0.00)          White Elephant (WELEP) 150000 18.00 (0.00)          Angel and the Badman (ANBAD) 150000 13.82 (+1.72)          Angel and the Badman (ANBAD) 150000 13.82 (+1.72)