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