investor0329; I believe that there are flaws in the logic of your spreadsheet and that it is not quite ready for prime time.
I suspect that what you are seeing here is simply the year-end distribution of capital gains. I have checked several of the items on your list and indeed this appears to me the case. It would appear that a lot of the lists time is being wasted here on items that have not been researched before we state them as facts. More time needs to spent on reading a good book on the fundamentals of investing in mutual funds rather then the fundamentals of building spreadsheets. The result of this merely creates the impression that the database is in really bad shape. I know that errors exist, but the level is not anywhere near what you are reporting. Let's give Gary and the rest of us a break. --- In [email protected], "investor0329" <[EMAIL PROTECTED]> wrote: > > There seems to be lots of data errors in the mutual funds. Below is > just a small sampling going back to 11/13/06. I created a > spreadsheet that simply computes the absolute value of the % change > from one day to the next...rolling it back, the idea being that days > with a very large % change is probably due to an error, a price > error, or an error due to not adjusting for capital gains or > dividends correctly, etc. Using a sample of about 20,000 day over > day databpoints, it appears that 5% is about 2 standard deviations > over the average day over day change...so I set my lower limit at 5%. > The list below sorts the results from highest ABSOLUTE % day over > day change back to 11/13/06 only. As i get time, i will go further > back..but running the spreadsheet with over 17000 mutual fund > tickers takes alot of time. Maybe I'll create a scan to do it..it > may be faster. I can only analyze 10 days at a time because it runs > so slow...but I am posting this beginning list below to give you an > idea of what's up. A 5% level obviously won't catch all the errors > and perhaps some of them are valid..but the higher on the list you > go, the higher the probability of error. Look at PWECX for example. > This can't be close to right. Look at all the NEGATIVE PRICES in the > negative 100s. What's up? > > > > > abs % chg Date ticker > 1655.34% 12/13/06 ICIBX > 1172.16% 12/13/06 ICIAX > 176.24% 12/19/06 TAMVX > 149.54% 12/13/06 IPSLX > 147.47% 12/13/06 IPSBX > 109.00% 12/13/06 IPSAX > 103.13% 12/19/06 PWECX > 100.19% 11/13/06 MPHYX > 100.19% 11/13/06 MAHYX > 100.15% 11/13/06 UHYPX > 87.28% 12/15/06 DIVDX > 87.09% 12/15/06 DIVAX > 86.44% 12/15/06 DIVCX > 84.99% 12/15/06 DIVBX > 72.79% 12/22/06 JIREX > 59.98% 12/19/06 AVALX > 34.66% 12/28/06 UJPSX > 34.06% 12/15/06 BRSCX > 33.76% 12/15/06 LIFUX > 33.68% 12/28/06 UJPIX > 33.00% 12/15/06 USCIX > 32.68% 12/21/06 AISCX > 32.16% 12/21/06 APNBX > 31.84% 12/27/06 ICPAX > 30.97% 12/13/06 IVELX > 30.55% 12/13/06 IVEQX > 30.01% 12/15/06 DPEMX > 27.23% 12/14/06 BIRMX > 27.17% 12/13/06 IVEAX > 26.94% 12/28/06 HEMGX > 26.90% 12/28/06 HEMMX > 26.87% 12/27/06 LZCOX > 26.48% 12/27/06 LZSCX > 26.37% 12/27/06 HISRX > 25.53% 12/18/06 BBBFX > 25.36% 12/18/06 IBBFX > 24.37% 12/21/06 AILIX > 23.73% 12/21/06 AAICX > 23.63% 12/21/06 DABAX > 23.11% 12/21/06 DABBX > 23.08% 12/21/06 DABCX > 22.70% 12/21/06 DABIX > 22.65% 12/21/06 APCBX > 21.95% 12/27/06 LZSMX > 21.93% 12/27/06 LZISX > 21.87% 12/15/06 JAGTX > 21.82% 12/14/06 GBEMX > 21.30% 12/20/06 MAGIX > 21.29% 12/20/06 MGIFX > 21.26% 12/20/06 RCECX > 20.03% 12/14/06 SKSEX > 19.22% 12/19/06 VALLX > 19.04% 12/15/06 MICBX > 18.92% 12/21/06 SWOSX > 18.82% 12/6/06 MAKOX > 18.79% 12/21/06 SWMSX > 18.58% 12/14/06 RSGRX > 18.31% 12/15/06 MICAX > 18.16% 12/19/06 TPLNX > 17.70% 12/14/06 WSCYX > 17.51% 12/20/06 SSCYX > 17.27% 12/6/06 RYCOX > 17.12% 12/6/06 TMRCX > 17.09% 12/13/06 IRHBX > 16.92% 12/22/06 TGSVX > 16.92% 12/27/06 AZIBX > 16.88% 12/27/06 AZIAX > 16.88% 12/27/06 AZICX > 16.73% 12/20/06 ARTJX > 16.71% 12/6/06 TMRFX > 16.39% 12/14/06 RSIFX > 16.36% 12/13/06 IRHAX > 16.32% 12/6/06 TMRIX > 16.08% 12/15/06 HCRBX > 16.04% 12/15/06 HCRCX > 16.04% 12/8/06 CCPCX > 16.00% 12/14/06 RMCAX > 15.80% 12/14/06 RMDIX > 15.69% 12/28/06 HINTX > 15.65% 12/28/06 HIVVX > 15.57% 12/14/06 RSNRX > 15.44% 12/21/06 GPGCX > 15.19% 12/11/06 DRSMX > 14.90% 12/13/06 MBRFX > 14.80% 12/22/06 NRSBX > 14.80% 12/22/06 NRSCX > 14.74% 11/21/06 LADPX > 14.72% 12/13/06 IRHLX > 14.63% 12/21/06 MGEMX > 14.53% 12/15/06 FVFDX > 14.51% 12/29/06 APITX > 14.49% 12/15/06 FVFBX > 14.23% 12/6/06 MACSX > 14.18% 12/15/06 HCRAX > 14.18% 12/4/06 DLDRX > 14.06% 12/20/06 RMKAX > 13.94% 12/29/06 YCVTX > 13.92% 12/11/06 LSCCX > 13.89% 12/15/06 TEEMX > 13.87% 12/22/06 NRSAX > 13.87% 12/11/06 LSCBX > 13.81% 12/20/06 GMSIX > 13.76% 12/15/06 HCRDX > 13.74% 12/29/06 CGROX > 13.72% 12/11/06 LSRRX > 13.66% 11/15/06 VVFCX > 13.64% 12/14/06 WSLCX > 13.63% 12/27/06 LZEMX > 13.62% 12/20/06 RAGAX > 13.54% 12/20/06 RMKIX > 13.53% 12/11/06 LISRX > 13.50% 12/7/06 SIMTX > 13.48% 12/21/06 HCCEX > 13.41% 12/27/06 LZOEX > 13.21% 12/22/06 NECVX > 13.21% 12/22/06 NEVBX > 13.08% 12/15/06 GVEWX > 13.05% 12/15/06 GVEVX > 12.99% 12/22/06 TGVNX > 12.94% 12/15/06 GVEYX > 12.91% 12/22/06 TGVKX > 12.87% 12/15/06 FVFCX > 12.87% 11/14/06 SHGDX > 12.85% 11/14/06 SHGBX > 12.80% 11/14/06 SHGCX > 12.74% 12/22/06 TGVOX > 12.72% 12/15/06 FVFAX > 12.71% 12/29/06 EMRCX > 12.54% 12/14/06 PRAAX > 12.52% 12/29/06 GBFAX > 12.49% 12/19/06 CHUSX > 12.46% 11/28/06 COCAX > 12.44% 12/27/06 CNJFX > 12.44% 12/7/06 CWVCX > 12.36% 12/22/06 NEDCX > 12.35% 12/22/06 NEDBX > 12.34% 12/15/06 DPAGX > 12.27% 12/15/06 SMEAX > 12.26% 12/14/06 XSTFX > 12.26% 12/11/06 DMGTX > 12.11% 12/19/06 XAMSX > 12.11% 12/15/06 ICSIX > 12.08% 12/5/06 LFEAX > 12.08% 12/5/06 LFETX > 12.08% 12/7/06 CWVBX > 12.03% 12/15/06 VKIIX > 11.87% 12/15/06 RISIX > 11.86% 12/15/06 GIEWX > 11.82% 12/15/06 VKIAX > 11.81% 12/15/06 GIEVX > 11.77% 12/20/06 ARTVX > 11.72% 12/15/06 VKIBX > 11.71% 12/21/06 SWMGX > 11.71% 12/19/06 PIIRX > 11.68% 11/28/06 CWRSX > 11.65% 11/14/06 SLFCX > 11.63% 12/15/06 GIEYX > 11.61% 12/29/06 LSVAX > 11.60% 12/15/06 VKICX > 11.58% 11/14/06 SLFBX > 11.58% 11/14/06 SLFDX > 11.51% 12/7/06 LGASX > 11.51% 12/22/06 NEFVX > 11.46% 12/22/06 TGSSX > 11.35% 12/11/06 SEQUX > 11.33% 11/14/06 SGSRX > 11.32% 12/15/06 GSCWX > 11.30% 12/27/06 CNZLX > 11.26% 12/29/06 IIGCX > 11.25% 11/14/06 SHGAX > 11.23% 12/15/06 GSCVX > 11.04% 12/22/06 NEFDX > 11.01% 12/29/06 INIVX > 10.99% 12/19/06 AMGCX > 10.99% 12/15/06 MSRAX > 10.97% 12/19/06 AMCGX > 10.94% 12/15/06 GSCYX > 10.87% 12/28/06 WMICX > 10.86% 11/14/06 SGSIX > 10.83% 12/7/06 CWVGX > 10.74% 11/14/06 SHEBX > 10.71% 12/28/06 ADEGX > 10.70% 11/14/06 SHECX > 10.63% 11/28/06 CMCPX > 10.62% 11/14/06 SHEDX > 10.55% 12/20/06 TAVIX > 10.41% 12/29/06 KOGRX > 10.26% 12/27/06 LZSIX > 10.24% 12/27/06 LZESX > 10.24% 12/4/06 PSBNX > 10.22% 12/26/06 MARTX > 10.20% 12/8/06 SLLAX > 10.16% 12/12/06 SFCSX > 10.13% 12/7/06 CWVIX > 10.11% 12/8/06 SLLGX > 10.02% 12/20/06 ARTMX > 9.99% 11/14/06 SFFRX > 9.96% 11/28/06 CMCEX > 9.96% 12/29/06 DNAIX > 9.92% 11/14/06 SLFRX > 9.92% 12/22/06 TISVX > 9.92% 12/19/06 AMGAX > 9.91% 12/22/06 SAHMX > 9.86% 12/15/06 GIEZX > 9.81% 11/14/06 SERRX > 9.77% 11/14/06 SHEMX > 9.72% 12/19/06 VLIFX > 9.66% 12/13/06 ICRLX > 9.61% 12/13/06 ICRAX > 9.60% 11/14/06 SFFIX > 9.59% 12/13/06 ICRBX > 9.32% 12/18/06 DFFVX > 9.30% 12/14/06 PMGAX > 9.28% 12/20/06 TAREX > 9.26% 12/15/06 DPIEX > 9.24% 11/14/06 SERIX > 9.08% 12/18/06 DTMVX > 9.06% 12/15/06 DPHYX > 8.99% 12/7/06 HAREX > 8.99% 12/7/06 HARSX > 8.94% 12/19/06 ASRRX > 8.93% 12/22/06 TISBX > 8.92% 12/21/06 ALEIX > 8.92% 12/22/06 SAUMX > 8.91% 12/19/06 ASRGX > 8.85% 12/22/06 TGAPX > 8.84% 12/14/06 PMCIX > 8.83% 12/28/06 NNLEX > 8.80% 12/15/06 IMVBX > 8.78% 12/28/06 NCLEX > 8.75% 11/29/06 OGIYX > 8.65% 12/22/06 TISGX > 8.65% 12/14/06 KREYX > 8.63% 12/21/06 AQEAX > 8.59% 12/14/06 KREAX > 8.56% 12/29/06 DCAIX > 8.48% 12/28/06 SMIIX > 8.47% 12/14/06 KRECX > 8.46% 12/28/06 TWEBX > 8.45% 12/28/06 SNRAX > 8.43% 12/14/06 KREBX > 8.39% 12/19/06 PGNBX > 8.39% 12/28/06 RSIHX > 8.39% 12/19/06 PIGRX > 8.35% 12/6/06 PUVBX > 8.33% 12/19/06 PIGMX > 8.31% 12/28/06 SMIAX > 8.29% 12/26/06 NICSX > 8.29% 12/19/06 PNGAX > 8.27% 12/20/06 ARTIX > 8.24% 12/18/06 DFBMX > 8.24% 12/28/06 FMNAX > 8.21% 12/28/06 SMIBX > 8.17% 12/28/06 RSITX > 8.15% 12/19/06 DSVTX > 8.14% 12/28/06 FBMGX > 8.12% 12/7/06 LGSCX > 8.10% 11/30/06 FFINX > 8.06% 12/28/06 RSIOX > 8.04% 12/28/06 SNRBX > 8.02% 12/14/06 KSRYX > 8.00% 12/15/06 GSCZX > 8.00% 12/21/06 RYGEX > 7.98% 12/15/06 WSDCX > 7.97% 12/21/06 RYGHX > 7.96% 12/14/06 KSRAX > 7.88% 12/21/06 AQEBX > 7.87% 12/21/06 RYGGX > 7.86% 12/7/06 XSTFX > 7.86% 11/30/06 NBVZX > 7.85% 12/15/06 GVEZX > 7.83% 12/14/06 KSRCX > 7.83% 12/14/06 KSRBX > 7.81% 12/6/06 PRENX > 7.80% 11/27/06 AWGFX > 7.78% 12/29/06 GHACX > 7.75% 12/21/06 SWMIX > 7.75% 12/15/06 ATICX > 7.75% 12/22/06 HWAIX > 7.74% 12/15/06 ATIBX > 7.69% 12/18/06 MGRCX > 7.64% 12/15/06 ATIAX > 7.64% 12/18/06 DFAVX > 7.63% 12/27/06 MFCPX > 7.62% 12/15/06 ATIRX > 7.62% 12/21/06 SWOIX > 7.53% 12/18/06 DFUVX > 7.53% 12/15/06 SRTDX > 7.50% 12/21/06 PMVCX > 7.49% 12/15/06 ATIIX > 7.46% 12/22/06 TGONX > 7.46% 12/19/06 AGIRX > 7.46% 12/22/06 SABTX > 7.44% 12/19/06 VLAAX > 7.42% 12/14/06 RSCNX > 7.42% 12/29/06 GHAAX > 7.40% 12/29/06 MAFDX > 7.40% 12/22/06 TGOKX > 7.40% 12/29/06 GHAIX > 7.39% 12/18/06 PVFIX > 7.38% 12/14/06 RSCIX > 7.37% 12/28/06 JHLGX > 7.34% 12/22/06 TRCVX > 7.33% 12/28/06 REBHX > 7.32% 12/29/06 LCMMX > 7.31% 12/21/06 PAMVX > 7.31% 12/19/06 ALMRX > 7.31% 12/28/06 JILGX > 7.30% 11/30/06 SPVZX > 7.30% 12/18/06 DFCVX > 7.29% 12/28/06 JTLGX > 7.29% 12/28/06 SEBIX > 7.26% 12/26/06 MNRMX > 7.25% 12/14/06 USTBX > 7.25% 12/28/06 EVAMX > 7.23% 12/22/06 DIVSX > 7.23% 12/29/06 MAFAX > 7.20% 12/19/06 VALSX > 7.20% 12/15/06 SRTBX > 7.19% 12/20/06 RMCVX > 7.19% 12/28/06 REBTX > 7.18% 12/18/06 DFLVX > 7.18% 12/28/06 NBSAX > 7.15% 12/13/06 IAIBX > 7.12% 12/28/06 SLBAX > 7.11% 12/27/06 HMCGX > 7.10% 12/27/06 LZMOX > 7.09% 12/28/06 REBOX > 7.08% 12/13/06 IAILX > 7.08% 12/27/06 HMDIX > 7.06% 12/28/06 JSLGX > 7.01% 12/27/06 LZMIX > 7.00% 12/15/06 GGBWX > 6.97% 12/15/06 GGBVX > 6.94% 12/22/06 TCLCX > 6.93% 12/15/06 LSHIX > 6.92% 12/6/06 BMCFX > 6.91% 12/28/06 SLBBX > 6.90% 12/5/06 EBGLX > 6.88% 12/28/06 JALGX > 6.87% 12/15/06 DPCEX > 6.87% 12/13/06 IAIAX > 6.87% 12/22/06 TGEIX > 6.86% 12/5/06 ECGLX > 6.85% 12/22/06 TGLNX > 6.83% 12/14/06 IGNAX > 6.82% 12/28/06 JRLGX > 6.82% 12/29/06 HOVLX > 6.81% 11/29/06 DXMLX > 6.81% 12/28/06 SCARX > 6.80% 12/28/06 NBSBX > 6.76% 12/15/06 SRTCX > 6.72% 12/15/06 SRTAX > 6.68% 12/18/06 DEMSX > 6.67% 12/29/06 MAFCX > 6.67% 12/7/06 LGFMX > 6.60% 11/27/06 DXRLX > 6.59% 12/29/06 MAFBX > 6.58% 12/28/06 JILBX > 6.58% 12/15/06 EXLSX > 6.58% 12/28/06 JHLAX > 6.56% 12/28/06 JTSBX > 6.55% 12/13/06 PEMBX > 6.52% 12/28/06 SNPIX > 6.51% 12/26/06 MPHSX > 6.48% 12/15/06 GCOWX > 6.48% 12/26/06 DLHYX > 6.47% 12/15/06 GCOVX > 6.45% 12/22/06 TIMGX > 6.45% 12/15/06 TFEQX > 6.45% 12/26/06 MPHLX > 6.44% 12/19/06 XEMOX > 6.44% 12/28/06 JRLBX > 6.44% 12/28/06 JALBX > 6.44% 12/28/06 JSLBX > 6.42% 12/28/06 SOPIX > 6.37% 11/27/06 DXRSX > 6.35% 12/18/06 DFSVX > 6.32% 12/28/06 JBLBX > 6.30% 12/21/06 PSPFX > 6.29% 12/7/06 PSSJX > 6.29% 12/28/06 JCLGX > 6.26% 12/18/06 DISVX > 6.26% 12/15/06 LLCVX > 6.25% 12/26/06 MPHAX > 6.25% 12/28/06 JCLBX > 6.22% 12/28/06 JBLGX > 6.21% 12/18/06 DFSCX > 6.20% 12/29/06 VSVAX > 6.20% 12/26/06 MPHNX > 6.18% 12/13/06 ICVBX > 6.18% 12/29/06 PYHIX > 6.16% 12/12/06 WFOSX > 6.15% 12/27/06 WBGBX > 6.13% 12/15/06 VADDX > 6.12% 11/14/06 SSCBX > 6.12% 11/14/06 SSVDX > 6.12% 11/14/06 SVMCX > 6.12% 12/13/06 ICVLX > 6.09% 12/15/06 LCVJX > 6.07% 12/13/06 ICVAX > 6.07% 12/14/06 USTFX > 5.98% 12/29/06 PVFAX > 5.98% 12/29/06 AVIEX > 5.97% 12/15/06 GGBYX > 5.94% 12/22/06 PINSX > 5.94% 12/15/06 DCRIX > 5.91% 12/28/06 RRPIX > 5.90% 12/29/06 FISBX > 5.88% 12/20/06 FEFPX > 5.88% 12/13/06 FEFPX > 5.88% 12/28/06 JILCX > 5.88% 12/28/06 JTLRX > 5.88% 12/29/06 ADJEX > 5.85% 12/28/06 JHLMX > 5.85% 12/28/06 JTLMX > 5.81% 12/28/06 JSLCX > 5.81% 12/28/06 TEQUX > 5.81% 12/28/06 JRLCX > 5.81% 12/12/06 WFMBX > 5.79% 12/26/06 CNWFX > 5.78% 12/28/06 JILMX > 5.78% 12/28/06 JSLMX > 5.74% 12/28/06 JALRX > 5.72% 12/27/06 NCTWX > 5.71% 12/28/06 JALMX > 5.71% 12/28/06 JRLMX > 5.70% 12/22/06 CMDPX > 5.67% 11/21/06 PMPIX > 5.66% 12/22/06 TMVIX > 5.66% 12/5/06 PHGCX > 5.66% 12/5/06 PIHGX > 5.66% 12/28/06 HICFX > 5.65% 11/21/06 PMPSX > 5.62% 11/14/06 SSVRX > 5.61% 12/28/06 JCLCX > 5.61% 12/28/06 JBLCX > 5.60% 12/22/06 AMDPX > 5.59% 12/20/06 ARTQX > 5.59% 12/28/06 HICCX > 5.58% 12/28/06 JCLMX > 5.57% 11/14/06 SSCVX > 5.56% 12/28/06 FAMEX > 5.54% 11/27/06 DXQLX > 5.54% 12/28/06 SHPIX > 5.52% 12/27/06 NNTWX > 5.52% 12/22/06 TGINX > 5.51% 12/28/06 JBLMX > 5.51% 12/14/06 NAPRX > 5.50% 12/22/06 TRBDX > 5.49% 11/27/06 DXQSX > 5.49% 12/27/06 MBEQX > 5.48% 12/5/06 PDHZX > 5.48% 12/26/06 CNWEX > 5.46% 12/27/06 AZAGX > 5.46% 12/27/06 MNNKX > 5.46% 11/16/06 CICVX > 5.45% 12/28/06 FFCEX > 5.43% 12/5/06 PGARX > 5.42% 12/4/06 PLVNX > 5.42% 12/28/06 BRPIX > 5.40% 12/5/06 PHGAX > 5.39% 12/29/06 FISSX > 5.38% 12/4/06 PLVPX > 5.38% 12/27/06 PFNDX > 5.36% 11/29/06 OEPIX > 5.36% 11/14/06 SSVIX > 5.35% 11/29/06 OEPSX > 5.34% 12/20/06 ARTKX > 5.33% 12/15/06 VADCX > 5.30% 12/27/06 AZBGX > 5.28% 12/15/06 BTTNX > 5.27% 12/20/06 TASCX > 5.26% 12/15/06 FRMCX > 5.25% 11/30/06 PMPSX > 5.23% 11/30/06 PMPIX > 5.23% 11/27/06 UAPIX > 5.21% 11/27/06 UAPSX > 5.21% 12/15/06 ATDIX > 5.20% 12/22/06 CEDPX > 5.18% 12/28/06 BCIFX > 5.17% 12/18/06 OEPIX > 5.17% 12/27/06 AZCGX > 5.17% 12/18/06 OEPSX > 5.17% 12/28/06 CNCRX > 5.16% 12/14/06 RSSGX > 5.16% 12/15/06 BTTTX > 5.15% 12/22/06 AEDPX > 5.14% 12/14/06 RFSIX > 5.14% 11/27/06 RYRSX > 5.14% 11/27/06 RYIUX > 5.14% 11/27/06 RYIZX > 5.13% 12/28/06 FAMVX > 5.13% 11/27/06 RYRLX > 5.13% 11/27/06 DXMLX > 5.12% 12/19/06 ASTBX > 5.12% 11/27/06 RYQCX > 5.11% 11/27/06 RYIRX > 5.11% 12/15/06 BTFTX > 5.11% 11/27/06 RYRUX > 5.10% 12/15/06 ACTRX > 5.10% 11/27/06 UCPSX > 5.09% 12/21/06 HCVEX > 5.08% 11/27/06 INPSX > 5.07% 11/27/06 INPIX > 5.07% 11/27/06 UCPIX > 5.07% 12/29/06 MHEFX > 5.07% 11/16/06 CGIIX > 5.07% 11/27/06 DXZLX > 5.06% 12/27/06 ASGIX > 5.06% 12/28/06 UCPIX > 5.02% 12/29/06 JACOX > 5.02% 12/29/06 LSGIX > 5.02% 12/21/06 SAISX > 5.02% 12/14/06 RSINX > 5.01% 12/15/06 DCPFX > 5.01% 12/28/06 SNPSX >
