Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2011

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: FinancialData still broken

  • To: mathgroup at smc.vnet.net
  • Subject: [mg120499] Re: FinancialData still broken
  • From: DANA DELOUIS <dana01 at me.com>
  • Date: Tue, 26 Jul 2011 07:07:02 -0400 (EDT)
  • Delivered-to: l-mathgroup@mail-archive0.wolfram.com

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






  • Prev by Date: Re: And now for something completely different
  • Next by Date: Path variable
  • Previous by thread: Re: FinancialData errors
  • Next by thread: Re: FinancialData still broken