Re: FinancialData still broken

*To*: mathgroup at smc.vnet.net*Subject*: [mg120533] Re: FinancialData still broken*From*: DrMajorBob <btreat1 at austin.rr.com>*Date*: Wed, 27 Jul 2011 06:15:13 -0400 (EDT)*Delivered-to*: l-mathgroup@mail-archive0.wolfram.com*References*: <201107261107.HAA09255@smc.vnet.net>*Reply-to*: drmajorbob at yahoo.com

Interesting!! I had thought the failure rate was lower, but I had noticed the erroneous prices had several different values. I've considered computing tighter acceptable ranges for each stock, but so far it appears sufficient to reject anything > 10^8 and repeat the call until I get a usable answer. I have no proof that smaller errors are not getting through unnoticed, of course. Sigh... Bobby On Tue, 26 Jul 2011 06:07:02 -0500, DANA DELOUIS <dana01 at me.com> wrote: > > Hi. Here's some added thoughts on the issue you bring up. > I added some stocks just in case the issue is related to mutual funds. > > stocks = {"ACEIX", "FCNTX", "JACNX", "JANFX", "JANWX", "JMSCX=94, > "JNGIX=94, > "JNGLX", "JNMCX=94, "JNOSX", "JNSGX", "JNSTX", "PTTAX", "RGACX=94, > "STRFX=94, "AAPL", "IBM", "INTL", "VZ", "GE"}; > > I've noticed that if I ask for price about 100 times, then about 80% of > the time I get a correct value, > and 20% an incorrect value (n*^8). > Here, a value of 8.91 was returned 77 times, or 77% (out of 100 tries) > > f[n_]:=Table[FinancialData[stocks[[n]],"Price"],{100}]//Tally//Sort > > f[1] > {{8.91,77},{5.032406*10^8,23}} > > This took a little while, but I did it 100 times on each stock. > > m=Table[f[j],{j,stocks//Length}]; > m//TableForm > > Here's a count of the successful returns: > > good=m[[All,1,-1]] > {76,74,77,77,87,77,90,79,81,82,76,79,79,77,85,77,80,78,76,81} > > Here's the Mean and SD. > As you can see, there's only about a 80% success rate, with a small > Stand Deviation. > > {Mean[good],StandardDeviation[good]}//N > {79.4, 4.031455} > > With such a consistent failure rate, it sounds like a communication > problem between servers > > Out of curiosity, here are the different values that were high. > I don't see any pattern to these nonsense values. > > m[[All,2,1]]//Union > > 5.031051*10^8 > 5.031396*10^8 > 5.031565*10^8 > 5.031669*10^8 > 5.031676*10^8 > 5.031677*10^8 > 5.031678*10^8 > 5.032022*10^8 > 5.032406*10^8 > 5.055450*10^8 > 5.055453*10^8 > 5.055455*10^8 > 5.055456*10^8 > 5.055457*10^8 > > Thanks for bringing this up. > > = = = = = = = = = = > Dana DeLouis > $Version > 8.0 for Mac OS X x86 (64-bit) (November 6, 2010) > > > > On Jul 21, 5:47 am, DrMajorBob <btre... at austin.rr.com> wrote: > Erroneous prices are randomly returned: > > FinancialData /@ {"ACEIX", "FCNTX", "JACNX", "JANFX", "JANWX", > "JMSCX", "JNGIX", "JNGLX", "JNMCX", "JNOSX", "JNSGX", "JNSTX", > "PTTAX", "RGACX", "STRFX"} > > {8.81, 72.4, 14., 10.64, 46.49, 12.48, > 5.03202*10^8, 26.48, 23.72, 45.35, 12.48, > 5.03241*10^8, 11.04, 31.44, 32.47} > > FinancialData /@ {"ACEIX", "FCNTX", "JACNX", "JANFX", "JANWX", > "JMSCX", "JNGIX", "JNGLX", "JNMCX", "JNOSX", "JNSGX", "JNSTX", > "PTTAX", "RGACX", "STRFX"} > > {5.03241*10^8, 72.4, 14., 10.64, 5.03241*10^8, > 5.03168*10^8, 32.61, 26.48, 23.72, 5.03168*10^8, > 5.03168*10^8, 3.1, 11.04, 5.03241*10^8, 32.47} > > Bobby > > -- > DrMajor... at yahoo.com > > > -- DrMajorBob at yahoo.com

**References**:**Re: FinancialData still broken***From:*DANA DELOUIS <dana01@me.com>