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!


The Graduates (GRADS) 150000 0.05 (-0.03)          Mother Mary (MMARY) 150000 8.58 (+3.81)          La Cocina (LCOCI) 150000 0.04 (-0.02)          Spa Weekend (SPAWK) 150000 10.00 (0.00)          Eureka (EURKA) 150000 0.04 (-0.02)          Famous (FAMOS) 25000 21.75 (-0.18)          Dear Santa (DSATA) 50000 1.03 (-0.24)          Magpie (MGPIE) 150000 0.05 (+0.01)          The Wedding Banquet (TWEDB) 150000 8.62 (+1.16)          The Wedding Banquet (TWEDB) 150000 8.62 (+1.16)          Dear Santa (DSATA) 50000 1.03 (-0.24)          Dear Santa (DSATA) 50000 1.03 (-0.24)          Dear Santa (DSATA) 50000 1.03 (-0.24)          Dear Santa (DSATA) 50000 1.03 (-0.24)          Belushi (BELUS) 150000 0.05 (+0.03)          Dear Santa (DSATA) 50000 1.03 (-0.24)          Famous (FAMOS) 25000 21.75 (-0.18)          A Complete Unknown (GOELC) 15000 26.01 (-0.25)          Famous (FAMOS) 25000 21.75 (-0.18)          All We Imagine As Light (AWIAL) 50000 0.87 (-0.01)          The Fence (TFENC) 150000 0.03 (-0.04)          Hey Joe (TUMIA) 150000 0.03 (-0.02)          Famous (FAMOS) 24999 21.75 (-0.18)          The Line (THLIN) 150000 0.04 (+0.01)          Spa Weekend (SPAWK) 150000 10.00 (0.00)          Paper Tiger (PTIGR) 50000 19.31 (-0.09)          The Piano Lesson (TPLSN) 150000 0.03 (+0.02)          Spa Weekend (SPAWK) 150000 10.00 (0.00)          Paul Bettany (PBETT) 25000 148.04 (-0.66)          Flight of the Navigator (FNAVG) 150000 0.03 (-0.04)          Brothers (BROHS) 150000 0.02 (-0.02)          Rothko (ROTHK) 150000 0.01 (-0.02)          Rothko (ROTHK) 150000 0.01 (-0.02)          Spider-Man: Beyond the Spider-Ve (ASPD3) 150000 206.22 (-1.56)          The Prince of Fashion (POFSH) 150000 0.02 (0.00)          Spider-Man: Beyond the Spider-Ve (ASPD3) 150000 206.22 (-1.56)          The Magnificent Life of Marcel P (MLOMP) 150000 0.03 (+0.02)          His Three Daughters (HIS3D) 150000 0.02 (-0.02)          Rothko (ROTHK) 150000 0.01 (-0.02)          Pryor (PRYOR) 150000 0.01 (-0.02)          The Wedding Banquet (TWEDB) 150000 8.62 (+1.16)          The Wedding Banquet (TWEDB) 150000 8.62 (+1.16)          Not Bloody Likely (NBLKL) 150000 0.02 (-0.01)          Mother Mary (MMARY) 150000 8.58 (+3.81)          Mother Mary (MMARY) 150000 8.58 (+3.81)          Wuthering Heights (WUTHR) 1 37.97 (+0.34)          Wuthering Heights (WUTHR) 1 37.97 (+0.34)          Valiant One (VLNT1) 3 6.51 (+0.28)          How to Train Your Dragon (HTTYD) 60000 178.18 (+2.45)          Valiant One (VLNT1) 3 6.51 (+0.28)