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