To: Perspective who wrote (171 ) 4/18/2003 3:12:17 PM From: Terry Maloney Read Replies (1) | Respond to of 4905 BC, nice study. I'm not sure what you meant by converting tabs to spaces (I assume your data was tab-delimited to begin with), but the problem seems to be with SI: it will only accept a certain number of chars per column before things go wonky. Thus I had to delete the company names in the cleaned up version below. Even then, it would only 'accept' 5 digits and a decimal point in the third column, even though it accepted 8 plus dp in the second -- go figure. I've added a fourth column, yesterday's closing prices as per yahoo (a price of zero most likely indicates the stock's gone to the pink sheets). (If anyone wants to put this data into a table or spreadsheet, copy it into Word, use "Replace All' to replace two spaces with a single space ... do this several times, until you're down to single spaces only. At this point you can either replace the spaces with commas and export to a spreadsheet, or use Word's "Text to Table" command, choosing a space as the deliminator). Company Debt Load Ratio Close AMBWQ 1189.095 1410 0.00 IRIDQ 2316.842 1174.3 0.00 FPFX 2184.221 1150.3 0.00 APUUY 9904.035 688 0.00 ASGXF 1580.571 679 0.00 GBLXQ 8885.45 555.5 0.00 MFNXQ 4069.735 479.5 0.00 ADELQ 19183.553 453 0.00 ABIZQ 1395.544 384.24 0.00 ENRNQ 12823.434 338 0.00 MCWEQ 5414.13 324.5 0.00 UAL 10327.219 160.90 0.00 PGOGY 2368.168 123.87 0.00 WBR 3273.74 108.26 0.20 KQIPQ 1695.187 93.867 0.00 BGY 1736.071 85.366 4.21 TWSTY 8829.535 79.026 6.8336 SPGLA 1387.123 70.081 0.00 CHTR 18410.283 69.413 1.22 WCOEQ 24694.848 63.143 0.00 DJT 1916.472 39.044 2.03 ALGX 1201.094 33.179 0.24 AMR 12445.114 30.685 5.00 SBAC 1011.247 29.149 1.20 AOR 1085.832 28.151 0.37 NOR 2406.736 27.981 1.95 LEND 3333.229 22.475 9.69 DX 1161.046 21.925 4.85 NTL 1065.93 19.493 2.15 KMRTQ 1268.728 18.948 0.00 UHAL 1487.808 17.73 6.10 FLM 1904.542 17.649 0.00 CAL 5712.696 16.934 7.49 SCR.A 2239.363 16.885 0.00 FRE 623413.375 16.639 57.45 MIR 8619.069 15.028 1.93 MHX 1673.899 14.929 3.51 ACF 3978.784 14.866 4.32 KLM 4546.525 14.497 8.10 ILA 3568.667 13.099 1.83 CPN 13435.012 12.925 4.09 AGM 3278.027 12.2 23.80 CMS 7543.738 12.035 5.65 SRP 3764.479 11.775 3.84 FNM 710514.625 11.413 72.67 F 156005.281 10.955 9.41 STU 19791.424 10.522 100.35 GM 186186.266 10.506 35.37 LVMUY 9090.733 10.252 0.00 WFSI 7865.621 10.045 19.73 SAXN 3071.366 9.884 14.50 RWT 4952.224 9.844 32.94 DAL 10211.789 9.705 11.75 DVI 1230.687 9.657 8.98 IMH 5612.521 9.452 13.09 DRRA 1099.945 9.406 6.06 ENI 5724.226 9.084 4.11 CNH 3326.701 8.763 8.20 TMM 1455.642 8.688 3.71 CIT 30105.533 8.326 18.48 DYN 6078.726 8.267 3.09 TMA 9351.541 8.036 21.91 ALS 4781.313 7.928 1.84 IX 35173.723 7.698 21.80 CMO 1329.201 7.586 11.65 AYE 5108.406 7.181 7.89 KOR 1369.456 7.024 3.19 WMB 13936.641 6.916 5.90 RRI 7758.483 6.596 4.68 BAB 10820.612 6.398 19.48 VTO 1235.314 6.327 2.19 HI 80062.906 6.269 0.00 IST 2350.792 6.211 3.51 DTG 2384.953 6.044 16.70 BUH 2123.982 6 3.05 EP 17579.188 5.917 7.17 PGTV 1287.775 5.888 19.28 TSO 2051.174 5.836 7.63 GMT 4279.599 5.742 16.67 BSC 34290.371 5.711 68.47 TEO 3741.101 5.556 4.66 CNP 10018.118 5.514 7.59 CCK 4583.77 5.458 5.59 OMG 1213.561 5.194 11.42 WLT 2140.121 5.142 9.50 SNSA 1650.868 5.01 5.99 CCH 16504.344 4.86 13.30 GT 3623.86 4.819 4.90 PKS 2307.619 4.81 5.60 S 29730.854 4.7 26.63 EMT 1470.899 4.555 1.57 AHO 14996.411 4.499 3.58 FCH 1680.642 4.393 6.83 PCS 16331.053 4.302 4.48 ING 108095.445 4.289 15.75 CKC 1288.929 4.014 3.90 URI 2608.623 3.916 10.47 UCI 1772.173 3.856 10.99 WR 3337.417 3.818 13.00 CGA 2866.759 3.773 1.37 TXU 19772.75 3.755 18.07 DEG 5035.55 3.738 19.52 JCC 1151.476 3.7 9.20 ICCI 2592.616 3.677 13.08 AMT 3621.244 3.645 6.54 EIX 14776.257 3.64 14.02 IPX 1555.2 3.635 15.22 UAG 1447.789 3.57 14.05 XEL 16091.704 3.562 13.01 UNS 1976.453 3.536 17.63 TWTC 1205.391 3.499 3.49 PHI 3064.227 3.493 7.42 MITSY 29822.049 3.444 96.79 CCI 3345.243 3.427 6.25 IKN 3392.475 3.35 8.11 GP 12000.413 3.337 14.33 KWHIY 3827.993 3.192 0.00 AHR 1695.66 3.116 11.34 DCN 3502.261 3.081 8.23 CSR 69476.352 3.078 21.00 OI 3879.705 3.076 8.83 LEH 39696.508 3.064 63.79 FUWAY 5188.463 3.062 0.00 NIPNY 19306.131 3.04 2.97 ABB 7951.252 2.952 2.97 NCEN 1992.888 2.951 34.32 MCCC 2923.765 2.949 8.69 SLGN 1106.606 2.947 22.70 MWD 119079.805 2.943 45.15 CEA 1987.948 2.928 11.18 VE 18940.898 2.866 18.25 CFC 18920.43 2.866 60.39 DCX 86648.734 2.858 32.51 SZE 36360.387 2.853 14.40 TEX 1561.439 2.816 14.06 V 43715.477 2.814 15.40 MER 79201.195 2.727 40.08 SLM 43909.297 2.657 115.05 TRZ 3344.962 2.623 8.92 FJTSY 16351.769 2.602 0.00 HMT 4451.877 2.562 7.56 GS 79192.875 2.531 76.10 CK 1274.39 2.523 4.84 IDR 1269.769 2.486 10.35 SE 1781.35 2.428 7.88 AKS 1321.854 2.388 3.75 FMC 1266.304 2.384 17.05 NU 4297.099 2.381 14.54 FIF 1074.797 2.372 20.42 HANA 1258.404 2.371 2.35 TAR 2193.631 2.37 6.00 PPE 4915.292 2.367 7.18 AMKR 1812.312 2.34 5.81 MAC 3690.807 2.329 33.00 DDS 2640.283 2.327 12.99 IGL 2276.265 2.255 9.19 SRV 1983.141 2.248 3.06 AVA 1086.48 2.232 11.67 SAH 1320.303 2.232 15.90 RCL 5477.746 2.229 16.25 PCG 11763.13 2.213 14.55 VC 1649.567 2.212 6.52 LYO 3913.356 2.196 15.00 HRC 3219.761 2.195 0.00 EOC 4351.197 2.192 8.20 LNT 3155.66 2.188 17.01 CTX 6728.997 2.179 59.60 TE 3964.192 2.176 11.21 POM 6368.556 2.164 16.82 FCE.A 3398.833 2.155 0.00 SBGI 1551.92 2.143 9.47 CCTVY 1766.247 2.12 7.99 GTN.A 1099.858 2.115 0.00 AW 3314.836 2.115 8.18 CNL 1192.941 2.114 14.00 COLT 1910.549 2.07 2.72 SID 2451.237 2.052 21.95 ZNH 1804.961 2.026 11.20 KEP 20835.225 1.983 9.15 FRO 1662.044 1.965 12.36 NAV 3058.691 1.959 27.50 UNEWY 1524.758 1.939 3.67 DUK 22461.553 1.901 15.70 MCH 1216.72 1.898 12.35 CZN 5360.195 1.884 10.90 OKE 2403.245 1.879 18.87 CBL 2212.555 1.871 41.65 HIT 25957.814 1.86 33.96 FLS 1096.569 1.856 13.50 SUG 1401.22 1.854 13.29 ELE 23382.461 1.839 14.44 SANYY 9949.305 1.81 16.00 BNN 6192.777 1.809 20.97 EDP 8288.924 1.806 19.10 NRD 3579.039 1.78 8.59 AEP 13150.054 1.768 25.17 XRX 10957.419 1.737 9.00 CLP 1262.23 1.734 34.15 CPJ 1011.289 1.725 20.06 PC 2694.339 1.719 7.19 NI 7163.859 1.697 19.11 LR 12283.514 1.674 15.88 MBG 2568.972 1.643 26.01 HAVS 1186.905 1.641 3.23 CTTAY 3062.651 1.636 0.00 TDS 3758.507 1.636 42.75 SWX 1106.806 1.633 20.30 PPS 1374.828 1.633 24.85 TKG 3207.843 1.628 17.01 PEG 12508.753 1.623 37.87 TU 5642.157 1.62 11.87 TOSBF 15499.202 1.605 0.00 ARM 1509.219 1.603 14.45 RSE 4527.779 1.588 34.95 SSCC 5004.762 1.577 13.95 T 22570.559 1.555 14.23 HME 1323.735 1.547 34.92 FE 13728.712 1.545 32.15 IPR 2513.68 1.541 15.10 TCO 1370.119 1.538 17.73 EAS 4100.669 1.525 18.65 DT 72966.828 1.519 13.40 ARW 2094.177 1.503 15.68 DE 14641.697 1.501 41.66 TOY 2515.461 1.499 9.49 BXP 5177.396 1.463 39.95 CCE 11979.934 1.461 19.85 WEC 3971.25 1.461 25.32 CD 18320.635 1.451 13.09 GR 2521.822 1.42 14.62 IDA 1161.832 1.419 24.24 EMMS 1246.88 1.412 19.35 LNR 1427.987 1.383 35.45 PNM 1115.72 1.375 22.57 BDN 1000.704 1.364 21.78 TXT 6504.329 1.363 29.36 TSN 4082.843 1.361 8.93 SLR 3558.224 1.359 2.96 MGG 5220.063 1.357 28.03 BYD 1101.737 1.356 12.80 OGE 1842.777 1.345 17.50 DPL 2141.699 1.337 13.17 SKS 1428.295 1.337 8.67 AHC 5038.852 1.314 45.23 SVU 2296.99 1.309 16.19 PNW 3687.086 1.299 33.39 RA 1540.355 1.288 19.40 SFI 3325.963 1.286 30.20 SPOT 2551.868 1.285 16.80 WY 13571.96 1.28 49.90 VOLVY 9087.306 1.274 18.27 DTE 8853.997 1.274 39.23 FR 1381.78 1.27 29.33 CEI 1802.073 1.248 14.70 AIV 4200.425 1.246 37.18 PSD 2350.341 1.238 21.90 BTY 27142.682 1.237 29.15 KSE 6206.031 1.224 32.32 ABY 3854.692 1.222 6.76 CSX 7049.816 1.222 31.11 DHI 3038.183 1.212 22.59 ESA 1166.164 1.211 10.63 RG 2282.292 1.209 12.39 LPX 1105.573 1.196 8.25 BPO 3576.99 1.193 20.53 AVT 1390.348 1.191 11.69 NMR 27016.721 1.18 9.39 CUM 1133.686 1.178 25.23 PPL 7026.91 1.178 36.20 POSRY 1982.708 1.175 0.00 X 1407.814 1.17 12.13 SANM 2477.751 1.169 4.75 HOT 5346.011 1.165 25.43 CEG 5040.203 1.155 29.38 HLT 4721.993 1.153 12.59 MLS 1474.352 1.153 31.84 NXTP 1445.646 1.149 4.79 TNE 2922.55 1.148 10.08 RCN 1605.85 1.147 12.51 PGN 10713.765 1.143 39.40 AXA 23993.973 1.142 14.35 CKSNY 1244.991 1.141 0.00 VLO 4946.873 1.141 37.83 HAN 4066.549 1.137 26.10 BOW 2306.979 1.136 37.17 SPG 7303.784 1.132 37.38 CAT 17685.836 1.126 51.98 SJR 2382.538 1.126 12.01 ELN 1442.294 1.123 2.97 GE 264829.688 1.117 28.49 KPN 17788.104 1.116 6.22 NST 2367.288 1.113 40.90 STN 1162.831 1.112 21.88 CPT 1387.141 1.107 34.36 R 1553.189 1.107 21.54 TAC 2037.78 1.102 11.12 EOP 10839.165 1.087 26.52 PY 2067.849 1.085 13.10 RYCEY 2100.184 1.084 0.00 DQE 1068.228 1.082 13.01 SRE 4963.295 1.07 26.30 NTT 65171.871 1.069 17.13 GGP 3436.999 1.057 55.00 NGG 12033.943 1.057 32.73 CLI 1757.242 1.054 31.90 UGI 1230.617 1.054 30.25 ATO 1031.827 1.052 21.90 SPI 11282.692 1.052 24.54 HIW 1159.218 1.05 20.73 AMD 1948.274 1.047 8.03 DVA 1323.097 1.046 19.81 SCG 3487.018 1.043 30.33 BCC 1402.151 1.039 22.45 PDE 1925.798 1.036 14.07 KMG 4267.795 1.022 40.58 TOL 1313.649 1.018 21.92 ASN 3966.396 1.017 22.31 NSC 7449.459 1.014 19.85 TIN 2183.485 1.008 42.05 HET 3566.077 1.003 35.80