Annualized gain/loss of open positions

[mimo_100]

I computed the number of days in each of the open positions. Next I
annualized them, then sorted by the annualized percent, low to high.


[code:1:3f10e5c4a3]4/8/4004
STOCK DATE IN PAID NOW GAIN TARGET days annualized
BEL 1/2/2004 21.12 13.61 -35.60% 24.4 98 -132.44%
OFG 4/5/2004 31.91 31.53 -1.20% 36.9 4 -108.66%
CBK 10/20/2003 29.38 20.90 -28.90% 33.9 172 -61.25%
SSNC 2/14/2004 29.60 27.34 -7.60% 34.1 55 -50.67%
PRX 9/18/2003 72.40 57.30 -20.90% 83.7 204 -37.32%
PTSI 4/15/2002 24.84 16.63 -33.10% 28.9 725 -149.76%
AACE 3/5/2004 31.34 30.84 -1.60% 36.2 35 -16.64%
WSB 6/30/2003 10.67 10.06 -5.70% 12.4 284 -7.35%
CHKE 5/22/2002 21.50 23.00 7.00% 24.9 688 3.70%
GGI 1/9/2004 24.11 24.62 2.10% 27.7 91 8.48%
HAR 1/14/2004 77.39 82.15 6.20% 89.3 86 26.10%
SAFM 2/17/2004 38.25 41.91 9.60% 44.2 52 67.16%
PDX 3/30/2004 60.14 65.49 8.90% 69.6 10 324.70%[/code:1:3f10e5c4a3]

[mimo_100]

The preview page showed a nice table all across.

When submitted, it wrapped the last column around making it difficult
to read. Hey Karel, why is the preiview different from the
actual post????? Thanks

[Dave]

Looks good to me! Nice work!

-Dave

[mimo_100]

Looks good to me! Nice work!

-Dave

Hey Dave,

Are you saying that when you view my post, the annualized percent
is NOT wrapped around to the next line?

Thank you.

Tim

[mimo_100]

[code:1:50d80a8779]4/8/4004
STOCK DATE IN PAID NOW GAIN TARGET days annualized
PTSI 4/15/2002 24.84 16.63 -33.10% 28.9 725 -149.76%
BEL 1/2/2004 21.12 13.61 -35.60% 24.4 98 -132.44%
OFG 4/5/2004 31.91 31.53 -1.20% 36.9 4 -108.66%
CBK 10/20/2003 29.38 20.90 -28.90% 33.9 172 -61.25%
SSNC 2/14/2004 29.60 27.34 -7.60% 34.1 55 -50.67%
PRX 9/18/2003 72.40 57.30 -20.90% 83.7 204 -37.32%
AACE 3/5/2004 31.34 30.84 -1.60% 36.2 35 -16.64%
WSB 6/30/2003 10.67 10.06 -5.70% 12.4 284 -7.35%
CHKE 5/22/2002 21.50 23.00 7.00% 24.9 688 3.70%
GGI 1/9/2004 24.11 24.62 2.10% 27.7 91 8.48%
HAR 1/14/2004 77.39 82.15 6.20% 89.3 86 26.10%
SAFM 2/17/2004 38.25 41.91 9.60% 44.2 52 67.16%
PDX 3/30/2004 60.14 65.49 8.90% 69.6 10 324.70%
[/code:1:50d80a8779]

[Dave]

They both look the same, no wrapping.

-Dave

[Karel]

Mimo: the preview might look different because that view is wider (it lacks the author column). But I see nothing wrong with your table. But then I am using a 1024x768 screen resolution. I checked with 800x600, and then the last column did wrap. Now I am back at 1024x768

Regards,

Karel

[mimo_100]

Mimo: the preview might look different because that view is wider (it lacks the author column). But I see nothing wrong with your table.

Regards,

Karel

Karel,

Besides the fact that my first post was sorted incorrectly, my table warps around, that is not all columns are on the first line of display. Is there a setting that makes the viewing area larger (wider)? I just deleted my av
to see if that would make a difference, and it does not.

Tim

[Karel]

Errm, you caught me when I was editing my reply.

[shannonkeo]

good info

good info, you had one calculated wrong on PTSI. Heres the info sorted a couple ways....

[code:1:71efb737de]
SORTED BY DATE IN
STOCK DATE IN PAID NOW GAIN TARGET days annualized
PTSI 04/15/02 $24.84 $16.63 -33.10% $28.90 726 -16.64%
CHKE 05/22/02 $21.50 $23.00 7.00% $24.90 689 3.71%
WSB 06/30/03 $10.67 $10.06 -5.70% $12.40 285 -7.30%
PRX 09/18/03 $72.40 $57.30 -20.90% $83.70 205 -37.21%
CBK 10/20/03 $29.38 $20.90 -28.90% $33.90 173 -60.97%
BEL 01/02/04 $21.12 $13.61 -35.60% $24.40 99 -131.25%
GGI 01/09/04 $24.11 $24.62 2.10% $27.70 92 8.33%
HAR 01/14/04 $77.39 $82.15 6.20% $89.30 87 26.01%
SSNC 02/14/04 $29.60 $27.34 -7.60% $34.10 56 -49.54%
SAFM 02/17/04 $38.25 $41.91 9.60% $44.20 53 66.11%
AACE 03/05/04 $31.34 $30.84 -1.60% $36.20 36 -16.22%
PDX 03/30/04 $60.14 $65.49 8.90% $69.60 11 295.32%
OFG 04/05/04 $31.91 $31.53 -1.20% $36.90 5 -87.60%

SORTED BY GAIN/LOSS
BEL 01/02/04 $21.12 $13.61 -35.60% $24.40 99 -131.25%
OFG 04/05/04 $31.91 $31.53 -1.20% $36.90 5 -87.60%
CBK 10/20/03 $29.38 $20.90 -28.90% $33.90 173 -60.97%
SSNC 02/14/04 $29.60 $27.34 -7.60% $34.10 56 -49.54%
PRX 09/18/03 $72.40 $57.30 -20.90% $83.70 205 -37.21%
PTSI 04/15/02 $24.84 $16.63 -33.10% $28.90 726 -16.64%
AACE 03/05/04 $31.34 $30.84 -1.60% $36.20 36 -16.22%
WSB 06/30/03 $10.67 $10.06 -5.70% $12.40 285 -7.30%
CHKE 05/22/02 $21.50 $23.00 7.00% $24.90 689 3.71%
GGI 01/09/04 $24.11 $24.62 2.10% $27.70 92 8.33%
HAR 01/14/04 $77.39 $82.15 6.20% $89.30 87 26.01%
SAFM 02/17/04 $38.25 $41.91 9.60% $44.20 53 66.11%
PDX 03/30/04 $60.14 $65.49 8.90% $69.60 11 295.32%

[/code:1:71efb737de]

[mimo_100]

Shannon,

Thanks for pointing this out. I discovered it also after I posted.
It is nice to know that someone is interested enough to
dig into the details.

Tim

[Karel]

Errm, you caught me when I was editing my reply.

I mean: it could be because of your screen resolution. If you are using 800x600, the table wil wrap the last column. In fact, I tested it in my browser window, made it narrower, and found it will wrap at a width of about 820. A preview doesn't show the author column (width about 180), so the table doesn't wrap then. Set your screen to 1024x768 and the table won't wrap.

Regards,

Karel