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!


FOX: Baywatch (BAYWAT) 25000 8.00 (0.00)          Ramayana (RAMAY) 150000 18.30 (-0.08)          Johnny Depp (JDEPP) 25000 93.05 (-0.50)          World War Z 2 (WWZ2) 191 102.77 (+2.77)          Peter Dinklage (PDINK) 25000 79.61 (-0.25)          Outside Man (OUTSM) 30000 9.16 (-0.37)          Grandgear (GGEAR) 150000 59.34 (+0.35)          Grandgear (GGEAR) 150000 59.34 (+0.35)          FOX: Baywatch (BAYWAT) 25000 8.00 (0.00)          FOX: Baywatch (BAYWAT) 25000 8.00 (0.00)          FOX: Baywatch (BAYWAT) 25000 8.00 (0.00)          Sonic the Hedgehog 4 (SONC4) 10 167.24 (-0.33)          Twilight of the Dead (TWOTD) 11 4.64 (-1.48)          Dune: Part Three (DUNE3) 10 258.96 (+1.50)          Ramayana (RAMAY) 150000 18.30 (-0.08)          Ramayana (RAMAY) 150000 18.30 (-0.08)          Clayface (CLAYF) 9 57.74 (-0.90)          Wildwood (WILDW) 150000 35.42 (+0.59)          Dune: Part Three (DUNE3) 10 258.96 (+1.50)          Chloe Coleman (CCOLE) 4000 81.77 (-0.25)          Tyrant (TYRNT) 9 20.09 (-0.86)          Chloe Coleman (CCOLE) 8001 81.77 (-0.25)          World War Z 2 (WWZ2) 150000 102.77 (+2.77)          The Mosquito Bowl (MSQTB) 150000 2.46 (-0.04)          Zachary Levi (ZLEVI) 25000 12.88 (-0.30)          Clayface (CLAYF) 150000 57.74 (-0.90)          Wicker (WCKER) 150000 22.33 (-0.80)          Wicker (WCKER) 150000 22.33 (-0.80)          Clayface (CLAYF) 150000 57.74 (-0.90)          The Decline Of Fucking Western C (DOFWC) 11 4.42 (-0.56)          Esme Creed-Miles (ECREE) 25000 5.06 (-0.05)          Glen Powell (GPOWE) 5001 115.68 (-0.33)          Wunmi Mosaku (WMOSA) 25000 102.91 (-0.33)          Sleepover (SLEPO) 40000 23.00 (-0.06)          Tony Revolori (TREVO) 25000 82.34 (-0.85)          Taika Waititi (TAWAI) 25000 98.12 (+0.25)          Taika Waititi (TAWAI) 25000 98.12 (+0.25)          Natasha Lyonne (NLYON) 25000 73.38 (0.00)          Twilight of the Dead (TWOTD) 150000 4.64 (-1.48)          Sebastian Stan (SSTAN) 25000 42.31 (-0.50)          Gatto (GATTO) 9 147.88 (-0.33)          Sebastian Stan (SSTAN) 25000 42.31 (-0.50)          Sebastian Stan (SSTAN) 25000 42.31 (-0.50)          Queen at Sea (QUASE) 150000 0.25 (-0.03)          Queen at Sea (QUASE) 150000 0.25 (-0.03)          Ghost Market (ONOGM) 9 106.65 (-0.22)          Helldivers (HELDV) 150000 106.88 (+0.88)          Tatiana Maslany (TMASL) 25000 9.56 (+0.10)          Helldivers (HELDV) 150000 106.88 (+0.88)          Single Female (SIFEM) 6 19.89 (-0.19)