Re: FinancialData still broken
- To: mathgroup at smc.vnet.net
- Subject: [mg120448] Re: FinancialData still broken
- From: DrMajorBob <btreat1 at austin.rr.com>
- Date: Sat, 23 Jul 2011 02:28:58 -0400 (EDT)
- References: <201107222344.TAA28525@smc.vnet.net>
- Reply-to: drmajorbob at yahoo.com
I'm used to some of these problems, and I wrote code to try something else
when Missing comes back.
This is the first time I've seen prices on the order of 5 x 10^8.
And so... I've coded an infinite loop to call over and over (on each
stock) until I get a price less than 10^8. I may never get rid of that
kludge, since it doesn't hurt anything unless it's TRULY infinite, or
semi-infinite, if you will. So far, the error seems truly random, so it
only takes an extra call or two to get past it.
I don't think there's a problem in Mathematica on our machines. It's
probably a problem at the curated database end of things, and if so, there
couldn't be a bug fix.
Bobby
On Fri, 22 Jul 2011 18:44:52 -0500, DANA DELOUIS <dana.del at gmail.com>
wrote:
> ...> {5.03241*10^8, 72.4, 14., 10.64, 5.03241*10^8...
>
> Hi. This function has lots of problems.
> In addition to the problems you point out, here's a slightly different
> view.
> Sometimes the Price, and Latest Price match.
> Other times, the Price is corrupt, but the latest price is correct, and
> sometimes it's the other way around.
> Sometimes the CIK codes or Exchange are missing, etc.
> Other issues are bugs in Option pricing, etc.
> I really hope they fix this soon, but I guess they never issue bug fixes.
>
>
> stocks={"ACEIX","FCNTX","JACNX","JANFX","JANWX","JMSCX","JNGIX","JNGLX",
> "JNMCX=94,
> "JNOSX","JNSGX","JNSTX","PTTAX","RGACX","STRFX=94};
>
> Transpose[
> {
> Map[FinancialData[#,"Price"]&,stocks],
> Map[FinancialData[#,"LatestTrade"]&,stocks],
> Map[FinancialData[#,"CIK"]&,stocks],
> Map[FinancialData[#,"Company"]&,stocks]
> }][[;;6]]
>
> < Just the first 6 for posting
> < Looks better in MatrixForm, or something similar...>
>
> {5.0324*10^8,{Missing[NotAvailable],5.0324*10^8},0000080832,Van Kampen
> Equity Income Fund A}
> {5.0311*10^8,{{2011,7,20,17,11,0.},72.17},0000024238,Fidelity Contra
> Fund}
> {13.97,{{2011,7,20,17,50,0.},13.97},0000277751,Janus Contrarian Fund D
> Shares}
> {5.0324*10^8,{{2001,12,22,20,42,0.},5.0324*10^8},0000277751,Janus
> Flexible Bond Fund D Shar}
> {5.0324*10^8,{{2011,7,20,18,24,0.},46.74},0000277751,Janus Worldwide
> Fund D Shares}
> {12.48,{{2011,7,20,17,51,0.},12.48},Missing[NotAvailable],Janus Smart
> Portfolio Conservat}
>
> = = = = = = = = = =
> 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
- Follow-Ups:
- how to ListPlot3D large data sets
- From: "Ted Sariyski" <tsariysk@craft-tech.com>
- how to ListPlot3D large data sets
- References:
- Re: FinancialData still broken
- From: DANA DELOUIS <dana.del@gmail.com>
- Re: FinancialData still broken