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 Sequel Fund (SQUEL) 20000 68.48 (+0.04)          The Horror Fund 9 (SPOOK) 20000 93.21 (-0.06)          Paul Thomas Anderson - One Battl (A6DPTA) 100 11.19 (+0.07)          The Asian Fund (ASIAN) 20000 27.03 (-0.72)          The Animal Fund (ZOO) 20000 20.12 (+0.03)          Teenage Mutant Ninja Turtles: Mu (TMNT4) 5000 73.08 (0.00)          Michael B. Jordan - Sinners - Ac (A6AMBJ) 100 6.56 (+0.03)          The African-American Fund (AFRAM) 20000 41.19 (+0.06)          Spaceballs 2 (SPCB2) 5000 120.21 (+0.01)          Amy Madigan - Weapons - Sup Actr (A6SAMA) 100 7.89 (-0.03)          Broadsword (BROSW) 37500 55.68 (-0.03)          Timothée Chalamet - Marty Supre (A6ATCH) 100 9.92 (+0.06)          ABC: RJ Decker (RJDECK) 25000 9.15 (+0.07)          Evil Dead Burn (EVLD6) 5 38.47 (+0.02)          The Odyssey (ODYSE) 4 292.96 (+0.55)          Minions 3 (MNIO3) 119 317.36 (0.00)          The Drama (TDRAM) 28000 22.56 (+0.30)          Stellan Skarsgård - Sentimental (A6RSSK) 100 9.29 (0.00)          Moana (MOAN1) 500 219.43 (+0.36)          Supergirl (SUPGR) 50 181.23 (+0.04)          The Breadwinner (BREDW) 70000 25.98 (+0.51)          Toy Story 5 (TOYS5) 4 363.14 (+1.25)          Disclosure Day (SKIES) 4 162.80 (+0.16)          Iron Lung (IRONL) 1600 24.05 (-0.31)          Scary Movie 6 (SCAR6) 4 54.93 (-0.05)          Send Help (SENDH) 150000 46.60 (+0.01)          Avengers: Doomsday (AVNG5) 9998 548.84 (+0.63)          The Mandalorian and Grogu (SWAR3) 5000 239.09 (-0.55)          The Mandalorian and Grogu (SWAR3) 5000 239.09 (-0.55)          Hey Bear (HEYBR) 10941 6.47 (+0.68)          Animal Friends (ANFRN) 5 74.43 (+0.25)          Spider-Man: Brand New Day (SPID9) 150000 420.83 (0.00)          Passenger (PSNGR) 4 18.11 (-0.04)          Pressure (PRSUR) 20 15.84 (+0.27)          Toy Story 5 (TOYS5) 150000 363.14 (+1.25)          The Mandalorian and Grogu (SWAR3) 4 239.09 (-0.55)          The Mandalorian and Grogu (SWAR3) 23418 239.09 (-0.55)          The Custom of the Country (TCOTC) 150000 18.96 (+2.29)          The Sheep Detectives (3BAGF) 4 40.33 (+0.11)          They Follow aka It Follows 2 (TFLW2) 78333 5.64 (+0.03)          Wuthering Heights H$45 Put Fri-M (WUTHR.PU) 25000 2.38 (-0.08)          The Devil Wears Prada 2 (PRAD2) 8 175.85 (-1.18)          John Wick: Chapter 5 (WICK5) 150000 108.70 (+1.62)          Over Your Dead Body aka The Trip (TETRP) 160 7.44 (+0.96)          Normal (NORML) 120 17.72 (-0.04)          Beneath the Storm (BSTRM) 150000 5.14 (-0.06)          The Drama (TDRAM) 40200 22.56 (+0.30)          The Moment (MOMNT) 150000 9.06 (-0.07)          Cillian Murphy (CMURP) 820 90.76 (0.00)          In the Grey (NGREY) 4 17.16 (+0.02)