Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #3937 > unrolled thread

Re: FinancialData still broken

Started byDrMajorBob <btreat1@austin.rr.com>
First post2011-07-24 00:26 +0000
Last post2011-07-30 10:13 +0000
Articles 11 — 4 participants

Back to article view | Back to comp.soft-sys.math.mathematica

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.


Contents

  Re: FinancialData still broken DrMajorBob <btreat1@austin.rr.com> - 2011-07-24 00:26 +0000
    Re: FinancialData still broken Armand Tamzarian <mike.honeychurch@gmail.com> - 2011-07-27 10:16 +0000
    Re: FinancialData still broken DrMajorBob <btreat1@austin.rr.com> - 2011-07-28 11:55 +0000
    FinancialData errors DrMajorBob <btreat1@austin.rr.com> - 2011-07-29 08:43 +0000
    FinancialData errors DrMajorBob <btreat1@austin.rr.com> - 2011-07-29 08:46 +0000
    Re: FinancialData errors MinHsuan Peng <minhsuanp@wolfram.com> - 2011-07-30 10:08 +0000
    Re: FinancialData errors DrMajorBob <btreat1@austin.rr.com> - 2011-07-30 10:00 +0000
    Re: FinancialData errors DrMajorBob <btreat1@austin.rr.com> - 2011-07-30 10:01 +0000
    Re: FinancialData errors DrMajorBob <btreat1@austin.rr.com> - 2011-07-30 10:09 +0000
    Re: FinancialData errors DrMajorBob <btreat1@austin.rr.com> - 2011-07-30 10:12 +0000
    Re: FinancialData errors James Stein <mathgroup@stein.org> - 2011-07-30 10:13 +0000

#3937 — Re: FinancialData still broken

FromDrMajorBob <btreat1@austin.rr.com>
Date2011-07-24 00:26 +0000
SubjectRe: FinancialData still broken
Message-ID<j0fos4$8p6$1@smc.vnet.net>
I usually don't see the "price > 10^8" bug, either. It may have been  
permanently gone by the time you looked for it. But it was there for a day  
or so.

I know the occasional spurious Missing coming back is a months-old issue  
at least, and Dan Delouis confirmed it still exists.

I've inoculated my code against both bugs, so I may not notice when they  
go away.

Bobby

On Sat, 23 Jul 2011 01:29:09 -0500, James Stein <mathgroup@stein.org>  
wrote:

>
> DANA DELOUIS wrote:
> I really hope they fix this soon, but I guess they never issue bug fixes.
>
> Are these bugs in Mathematica, or bugs in Yahoo?
> FWIW, I do not see the bug reported by the OP (DrMajorBob).
>
>
> On Fri, Jul 22, 2011 at 4:44 PM, DANA DELOUIS <dana.del@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...@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...@yahoo.com
>>
>>
>>
>>


-- 
DrMajorBob@yahoo.com

[toc] | [next] | [standalone]


#3996

FromArmand Tamzarian <mike.honeychurch@gmail.com>
Date2011-07-27 10:16 +0000
Message-ID<j0ooi6$kqa$1@smc.vnet.net>
In reply to#3937
On Jul 24, 10:26 am, DrMajorBob <btre...@austin.rr.com> wrote:
> I usually don't see the "price > 10^8" bug, either. It may have been  
> permanently gone by the time you looked for it. But it was there for a day  
> or so.
>
> I know the occasional spurious Missing coming back is a months-old issue 
> at least, and Dan Delouis confirmed it still exists.
>
> I've inoculated my code against both bugs, so I may not notice when they 
> go away.
>
> Bobby



Would it be easier to just get the data from Yahoo rather than have to
worry about fixes and innoculations?



>
> On Sat, 23 Jul 2011 01:29:09 -0500, James Stein <mathgr...@stein.org>  
> wrote:
>
>
>
>
>
>
>
>
>
>
>
> > DANA DELOUIS wrote:
> > I really hope they fix this soon, but I guess they never issue bug fixes.
>
> > Are these bugs in Mathematica, or bugs in Yahoo?
> > FWIW, I do not see the bug reported by the OP (DrMajorBob).
>
> > On Fri, Jul 22, 2011 at 4:44 PM, DANA DELOUIS <dana....@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...@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...@yahoo.com
>
> --
> DrMajor...@yahoo.com

[toc] | [prev] | [next] | [standalone]


#4024

FromDrMajorBob <btreat1@austin.rr.com>
Date2011-07-28 11:55 +0000
Message-ID<j0rimv$407$1@smc.vnet.net>
In reply to#3937
> Would it be easier to just get the data from Yahoo rather than have to
> worry about fixes and innoculations?

I don't know how to do that, but I suspect it's Yahoo sending erroneous  
prices, anyway.

Bobby

On Wed, 27 Jul 2011 05:12:30 -0500, Armand Tamzarian  
<mike.honeychurch@gmail.com> wrote:

> On Jul 24, 10:26 am, DrMajorBob <btre...@austin.rr.com> wrote:
>> I usually don't see the "price > 10^8" bug, either. It may have been
>> permanently gone by the time you looked for it. But it was there for a  
>> day
>> or so.
>>
>> I know the occasional spurious Missing coming back is a months-old issue
>> at least, and Dan Delouis confirmed it still exists.
>>
>> I've inoculated my code against both bugs, so I may not notice when they
>> go away.
>>
>> Bobby
>
>
>
> Would it be easier to just get the data from Yahoo rather than have to
> worry about fixes and innoculations?
>
>
>
>>
>> On Sat, 23 Jul 2011 01:29:09 -0500, James Stein <mathgr...@stein.org>
>> wrote:
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> > DANA DELOUIS wrote:
>> > I really hope they fix this soon, but I guess they never issue bug  
>> fixes.
>>
>> > Are these bugs in Mathematica, or bugs in Yahoo?
>> > FWIW, I do not see the bug reported by the OP (DrMajorBob).
>>
>> > On Fri, Jul 22, 2011 at 4:44 PM, DANA DELOUIS <dana....@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...@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...@yahoo.com
>>
>> --
>> DrMajor...@yahoo.com
>
>


-- 
DrMajorBob@yahoo.com

[toc] | [prev] | [next] | [standalone]


#4038 — FinancialData errors

FromDrMajorBob <btreat1@austin.rr.com>
Date2011-07-29 08:43 +0000
SubjectFinancialData errors
Message-ID<j0trr4$d3j$1@smc.vnet.net>
In reply to#3937
FUNNY STORY: Here is Tech Support's non-response to my problem, described  
farther down:

Hello,

Thank you for taking the time to send in this report to us. The  accuracy
of the financial data depends on how quickly our sources  of data provide
updates. A 15 minutes delay on current prices is common. Longer delays are
possible depending on the data. A complete list of the sources queried by
FinancialData is available at:

http://reference.wolfram.com/mathematica/note/FinancialDataSourceInformatio
n.html

We are always looking for alternative sources of financial information to
query. If you have any suggestions on alternate sources of information we
should consider, please let us know.

Sincerely,

Sean Clarke


========================================================================

Now, isn't that special? The data is 5 months old, and TS tells me there's  
a 15-minute delay?

========================================================================


I've found a new (to me) species of error in FinancialData.

One example is the price of the following stock on Feb 10, 2011:

s = "JANFX";
FinancialData["JANFX", "Name"]
FinancialData["JANFX", {{2011, 2, 9}, {2011, 2, 11}}]

"Janus Flexible Bond Fund D Shar"

{{{2011, 2, 9}, 10.25}, {{2011, 2, 10}, 10.23}, {{2011, 2, 11},
     10.24}}

As you see, FinancialData says the price was 10.23.

But I BOUGHT the stock through Janus Funds on that day, and the price was
10.36.

Moreover, if I go to Yahoo's interactive price chart for the stock at the
following page, 10.36 is the price I find:

http://finance.yahoo.com/echarts?s=JANFX+Interactive#chart3:symbol=janfx;range=ytd;indicator=volume;charttype=line;crosshair=on;ohlcvalues=0;logscale=on;source=undefined

So... where are the errors really coming from?

This is not an astronomically large price or a Missing["Not Available"]
price; it's within 2% of the correct price. But it's wrong.

These errors make it very difficult to trust FinancialData for any useful
purpose.

Bobby

-- 
DrMajorBob@yahoo.com

[toc] | [prev] | [next] | [standalone]


#4045 — FinancialData errors

FromDrMajorBob <btreat1@austin.rr.com>
Date2011-07-29 08:46 +0000
SubjectFinancialData errors
Message-ID<j0ts1r$d5l$1@smc.vnet.net>
In reply to#3937
I've found a new (to me) species of error in FinancialData.

One example is the price of the following stock on Feb 10, 2011:

s = "JANFX";
FinancialData["JANFX", "Name"]
FinancialData["JANFX", {{2011, 2, 9}, {2011, 2, 11}}]

"Janus Flexible Bond Fund D Shar"

{{{2011, 2, 9}, 10.25}, {{2011, 2, 10}, 10.23}, {{2011, 2, 11},
   10.24}}

As you see, FinancialData says the price was 10.23.

But I BOUGHT the stock through Janus Funds on that day, and the price was  
10.36.

Moreover, if I go to Yahoo's interactive price chart for the stock at the  
following page, 10.36 is the price I find:

http://finance.yahoo.com/echarts?s=JANFX+Interactive#chart3:symbol=janfx;range=ytd;indicator=volume;charttype=line;crosshair=on;ohlcvalues=0;logscale=on;source=undefined

So... where are the errors really coming from?

This is not an astronomically large price or a Missing["Not Available"]  
price; it's within 2% of the correct price. But it's wrong.

These errors make it very difficult to trust FinancialData for any useful  
purpose.

Bobby

-- 
DrMajorBob@yahoo.com

[toc] | [prev] | [next] | [standalone]


#4068 — Re: FinancialData errors

FromMinHsuan Peng <minhsuanp@wolfram.com>
Date2011-07-30 10:08 +0000
SubjectRe: FinancialData errors
Message-ID<j10l6n$ou2$1@smc.vnet.net>
In reply to#3937
On Jul 29, 2011, at 3:41 AM, DrMajorBob wrote:

> FUNNY STORY: Here is Tech Support's non-response to my problem, described 
> farther down:
>
> Hello,
>
> Thank you for taking the time to send in this report to us. The  accuracy
> of the financial data depends on how quickly our sources  of data provide
> updates. A 15 minutes delay on current prices is common. Longer delays are
> possible depending on the data. A complete list of the sources queried by
> FinancialData is available at:
>
> 
http://reference.wolfram.com/mathematica/note/FinancialDataSourceInformation.html
>
> We are always looking for alternative sources of financial information to
> query. If you have any suggestions on alternate sources of information we
> should consider, please let us know.
>
> Sincerely,
>
> Sean Clarke
>
>
> 
==========================
==========================
======================
>
> Now, isn't that special? The data is 5 months old, and TS tells me there's 
> a 15-minute delay?
>
> 
==========================
==========================
======================
>
>
> I've found a new (to me) species of error in FinancialData.
>
> One example is the price of the following stock on Feb 10, 2011:
>
> s = "JANFX";
> FinancialData["JANFX", "Name"]
> FinancialData["JANFX", {{2011, 2, 9}, {2011, 2, 11}}]
>
> "Janus Flexible Bond Fund D Shar"
>
> {{{2011, 2, 9}, 10.25}, {{2011, 2, 10}, 10.23}, {{2011, 2, 11},
>     10.24}}
>
> As you see, FinancialData says the price was 10.23.
>
> But I BOUGHT the stock through Janus Funds on that day, and the price was
> 10.36.
>
> Moreover, if I go to Yahoo's interactive price chart for the stock at the
> following page, 10.36 is the price I find:
>
> 
http://finance.yahoo.com/echarts?s=JANFX+Interactive#chart3:symbol=janfx;range=ytd;indicator=volume;charttype=line;crosshair=on;ohlcvalues=0;logscale=on;source=undefined
>
> So... where are the errors really coming from?
>


The price you bought and shown in yahoo's page was "RawClose" as described in the documentation of FinancialData as a unadjusted price.

In[161]:= FinancialData["JANFX","RawClose",{{2011,2,10},{2011,2,10}}]
Out[161]= {{{2011,2,10},10.36}}

The default query is "Close" which has been adjusted by the dividends and stock splits.

MinHsuan

> This is not an astronomically large price or a Missing["Not Available"]
> price; it's within 2% of the correct price. But it's wrong.
>
> These errors make it very difficult to trust FinancialData for any useful
> purpose.
>
> Bobby
>
> --
> DrMajorBob@yahoo.com
>

[toc] | [prev] | [next] | [standalone]


#4074 — Re: FinancialData errors

FromDrMajorBob <btreat1@austin.rr.com>
Date2011-07-30 10:00 +0000
SubjectRe: FinancialData errors
Message-ID<j10koa$oo5$1@smc.vnet.net>
In reply to#3937
Your reply DID stimulate useful experimentation.

For instance:

FinancialData[
    "JANFX", #, {{2011, 2, 10}, {2011, 2, 10}}] & /@ {"Close", "High",
   "Low", "Open", "Price", "Range", "RawClose", "RawHigh", "RawLow",
   "RawOpen"}

{{{{2011, 2, 10}, 10.23}}, {{{2011, 2, 10}, 10.23}}, {{{2011, 2, 10},
    10.23}}, {{{2011, 2, 10}, 10.23}}, {{{2011, 2, 10},
    10.23}}, {{{2011, 2, 10}, {10.23, 10.23}}}, {{{2011, 2, 10},
    10.36}}, {{{2011, 2, 10}, 10.36}}, {{{2011, 2, 10},
    10.36}}, {{{2011, 2, 10}, 10.36}}}

The high, low, open, price, and range returned are nonsense, but the "Raw"  
numbers agree with reality, so I may be on the road to what I want.

Bobby

On Fri, 29 Jul 2011 03:48:42 -0500, Pierpaolo Bernardi  
<olopierpa@gmail.com> wrote:

> On Fri, Jul 29, 2011 at 10:41, DrMajorBob <btreat1@austin.rr.com> wrote:
>> FUNNY STORY: Here is Tech Support's non-response to my problem,  
>> described
>> farther down:
>
>> I've found a new (to me) species of error in FinancialData.
>>
>> One example is the price of the following stock on Feb 10, 2011:
>>
>> s = "JANFX";
>> FinancialData["JANFX", "Name"]
>> FinancialData["JANFX", {{2011, 2, 9}, {2011, 2, 11}}]
>>
>> "Janus Flexible Bond Fund D Shar"
>>
>> {{{2011, 2, 9}, 10.25}, {{2011, 2, 10}, 10.23}, {{2011, 2, 11},
>>     10.24}}
>>
>> As you see, FinancialData says the price was 10.23.
>>
>> But I BOUGHT the stock through Janus Funds on that day, and the price  
>> was
>> 10.36.
>>
>> Moreover, if I go to Yahoo's interactive price chart for the stock at  
>> the
>> following page, 10.36 is the price I find:
>
> Prices do vary continuously, they don't stay the same for a whole day,
> At the moment you bought it was 10.36.  At the moment the data source
> was sampled it was 10.23. Usually historical data use the closing
> price, AFAIK. I see nothing strange in this.
>
>> So... where are the errors really coming from?
>>
>> This is not an astronomically large price or a Missing["Not Available"]
>> price; it's within 2% of the correct price. But it's wrong.
>>
>> These errors make it very difficult to trust FinancialData for any  
>> useful
>> purpose.
>
> If a difference of less than 2% in the historical market data
> influences your algorithms, I won't trust your conclusions.  :)
>
> Cheers


-- 
DrMajorBob@yahoo.com

[toc] | [prev] | [next] | [standalone]


#4075 — Re: FinancialData errors

FromDrMajorBob <btreat1@austin.rr.com>
Date2011-07-30 10:01 +0000
SubjectRe: FinancialData errors
Message-ID<j10kp9$oop$1@smc.vnet.net>
In reply to#3937
Thank you. I had already seen the page you sent, and had also discovered  
the following:

FinancialData[
    "JANFX", #, {{2011, 2, 10}, {2011, 2, 10}}] & /@ {"Close", "High",
   "Low", "Open", "Price", "Range", "RawClose", "RawHigh", "RawLow",
   "RawOpen", "RawRange"}

{{{{2011, 2, 10}, 10.23}}, {{{2011, 2, 10}, 10.23}}, {{{2011, 2, 10},
    10.23}}, {{{2011, 2, 10}, 10.23}}, {{{2011, 2, 10},
    10.23}}, {{{2011, 2, 10}, {10.23, 10.23}}}, {{{2011, 2, 10},
    10.36}}, {{{2011, 2, 10}, 10.36}}, {{{2011, 2, 10},
    10.36}}, {{{2011, 2, 10},
    10.36}}, {{{2011, 2, 10}, {10.36, 10.36}}}}

where the "Raw" numbers appear to be what I want.

Bobby

On Fri, 29 Jul 2011 10:06:18 -0500, James Stein <mathgroup@stein.org>  
wrote:

> You purchased shares at 10.36, which WAS the "closing" price for that  
> day.
> (Note to PierPaolo: Mutual Funds, unlike stocks, do NOT trade DURING the
> day).
>
> The 10.23 price reported by Yahoo is an "adjusted" price. When a fund or
> stock makes a distribution (typically dividends or capital gains), all
> historical prices are "adjusted" downward in order that ROI  between two
> dates is consistent.  JANFX distributes dividends at the end of every  
> month.
> Check out this URL:
> <http://finance.yahoo.com/q/hp?s=JANFX&a=01&b=10&c11&d=02&e&f11&g=d
>>
>
> Note that both "Close" and "Adj Close" are available, and if you check
> Mathematica's documentation you can learn how to obtain the former. The
> adjusted prices are the defaults.
>
> On Fri, Jul 29, 2011 at 1:42 AM, DrMajorBob <btreat1@austin.rr.com>  
> wrote:
>
>> I've found a new (to me) species of error in FinancialData.
>>
>> One example is the price of the following stock on Feb 10, 2011:
>>
>> s = "JANFX";
>> FinancialData["JANFX", "Name"]
>> FinancialData["JANFX", {{2011, 2, 9}, {2011, 2, 11}}]
>>
>> "Janus Flexible Bond Fund D Shar"
>>
>> {{{2011, 2, 9}, 10.25}, {{2011, 2, 10}, 10.23}, {{2011, 2, 11},
>>   10.24}}
>>
>> As you see, FinancialData says the price was 10.23.
>>
>> But I BOUGHT the stock through Janus Funds on that day, and the price  
>> was
>> 10.36.
>>
>> Moreover, if I go to Yahoo's interactive price chart for the stock at  
>> the
>> following page, 10.36 is the price I find:
>>
>>
>> http://finance.yahoo.com/echarts?s=JANFX+Interactive#chart3:symbol=janfx;range=ytd;indicator=volume;charttype=line;crosshair=on;ohlcvalues=0;logscale=on;source=undefined
>>
>> So... where are the errors really coming from?
>>
>> This is not an astronomically large price or a Missing["Not Available"]
>> price; it's within 2% of the correct price. But it's wrong.
>>
>> These errors make it very difficult to trust FinancialData for any  
>> useful
>> purpose.
>>
>> Bobby
>>
>> --
>> DrMajorBob@yahoo.com
>>
>>


-- 
DrMajorBob@yahoo.com

[toc] | [prev] | [next] | [standalone]


#4078 — Re: FinancialData errors

FromDrMajorBob <btreat1@austin.rr.com>
Date2011-07-30 10:09 +0000
SubjectRe: FinancialData errors
Message-ID<j10l8k$ouj$1@smc.vnet.net>
In reply to#3937
> The default query is "Close" which has been adjusted by the dividends  
> and stock splits.

Adjusted in what sense? Over what relevant time period?

In the following, there are no splits or dividends in the time period  
requested:

FinancialData[
    "JANFX", #, {{2011, 2, 10}, {2011, 2, 10}}] & /@ {"Close", "High",
   "Low", "Open", "Price", "Range", "RawClose", "RawHigh", "RawLow",
   "RawOpen", "RawRange"}

{{{{2011, 2, 10}, 10.23}}, {{{2011, 2, 10}, 10.23}}, {{{2011, 2, 10},
    10.23}}, {{{2011, 2, 10}, 10.23}}, {{{2011, 2, 10},
    10.23}}, {{{2011, 2, 10}, {10.23, 10.23}}}, {{{2011, 2, 10},
    10.36}}, {{{2011, 2, 10}, 10.36}}, {{{2011, 2, 10},
    10.36}}, {{{2011, 2, 10},
    10.36}}, {{{2011, 2, 10}, {10.36, 10.36}}}}

Does this "adjusted" price depend on splits and dividends from Feb 10th  
until NOW?

If so, what good is that for analysis over a different time frame?

And if so, shouldn't the following plot be monotone?

GatherBy[Flatten[
     FinancialData["JANFX", #, {2011, 2, 10}] & /@ {"Close",
       "RawClose"}, 1],
    First] /. {{dt_, adjusted_}, {dt_, raw_}} :> {dt,
     raw - adjusted} // DateListPlot

Bobby

On Fri, 29 Jul 2011 16:52:30 -0500, MinHsuan Peng <minhsuanp@wolfram.com>  
wrote:

>
> On Jul 29, 2011, at 3:41 AM, DrMajorBob wrote:
>
>> FUNNY STORY: Here is Tech Support's non-response to my problem,  
>> described
>> farther down:
>>
>> Hello,
>>
>> Thank you for taking the time to send in this report to us. The   
>> accuracy
>> of the financial data depends on how quickly our sources  of data  
>> provide
>> updates. A 15 minutes delay on current prices is common. Longer delays  
>> are
>> possible depending on the data. A complete list of the sources queried  
>> by
>> FinancialData is available at:
>>
>> http://reference.wolfram.com/mathematica/note/FinancialDataSourceInformatio
>> n.html
>>
>> We are always looking for alternative sources of financial information  
>> to
>> query. If you have any suggestions on alternate sources of information  
>> we
>> should consider, please let us know.
>>
>> Sincerely,
>>
>> Sean Clarke
>>
>>
>> ========================================================================
>>
>> Now, isn't that special? The data is 5 months old, and TS tells me  
>> there's
>> a 15-minute delay?
>>
>> ========================================================================
>>
>>
>> I've found a new (to me) species of error in FinancialData.
>>
>> One example is the price of the following stock on Feb 10, 2011:
>>
>> s = "JANFX";
>> FinancialData["JANFX", "Name"]
>> FinancialData["JANFX", {{2011, 2, 9}, {2011, 2, 11}}]
>>
>> "Janus Flexible Bond Fund D Shar"
>>
>> {{{2011, 2, 9}, 10.25}, {{2011, 2, 10}, 10.23}, {{2011, 2, 11},
>>     10.24}}
>>
>> As you see, FinancialData says the price was 10.23.
>>
>> But I BOUGHT the stock through Janus Funds on that day, and the price  
>> was
>> 10.36.
>>
>> Moreover, if I go to Yahoo's interactive price chart for the stock at  
>> the
>> following page, 10.36 is the price I find:
>>
>> http://finance.yahoo.com/echarts?s=JANFX+Interactive#chart3:symbol=janfx;range=ytd;indicator=volume;charttype=line;crosshair=on;ohlcvalues=0;logscale=on;source=undefined
>>
>> So... where are the errors really coming from?
>>
>
>
> The price you bought and shown in yahoo's page was "RawClose" as  
> described in the documentation of FinancialData as a unadjusted price.
>
> In[161]:= FinancialData["JANFX","RawClose",{{2011,2,10},{2011,2,10}}]
> Out[161]= {{{2011,2,10},10.36}}
>
> The default query is "Close" which has been adjusted by the dividends  
> and stock splits.
>
> MinHsuan
>
>> This is not an astronomically large price or a Missing["Not Available"]
>> price; it's within 2% of the correct price. But it's wrong.
>>
>> These errors make it very difficult to trust FinancialData for any  
>> useful
>> purpose.
>>
>> Bobby
>>
>> --
>> DrMajorBob@yahoo.com
>>
>


-- 
DrMajorBob@yahoo.com

[toc] | [prev] | [next] | [standalone]


#4085 — Re: FinancialData errors

FromDrMajorBob <btreat1@austin.rr.com>
Date2011-07-30 10:12 +0000
SubjectRe: FinancialData errors
Message-ID<j10lfb$p07$1@smc.vnet.net>
In reply to#3937
> Prices do vary continuously, they don't stay the same for a whole day,
> At the moment you bought it was 10.36.  At the moment the data source
> was sampled it was 10.23. Usually historical data use the closing
> price, AFAIK. I see nothing strange in this.

Nonsense.

It's a mutual fund, as you can see from its name. It has one price,  
exactly once a day. I can look up that price at Yahoo! Finance, and it  
agrees with what the fund company charged me on that day. Check Feb 10th  
on the following page:

http://finance.yahoo.com/q/hp?s=JANFX&d=6&e=29&f11&g=d&a=1&b=16&c10&z=66&y=66

where open, high, low, and close are all the same -- namely, $10.36.

I JUST noticed the last column on that page says the "adjusted" close was  
$10.23, and that's what FinancialData returned -- part of a possible  
explanation -- but:

a) There was no dividend or split on that day or any day nearby,
b) NONE of the numbers in that column make any sense,
c) For most days and/or most funds, FinancialData returns the unadjusted  
close, so there's no consistency, and
d) I want the price I paid, not an "adjusted" number, even if it made  
sense.

> If a difference of less than 2% in the historical market data
> influences your algorithms, I won't trust your conclusions.  :)

I want to input the dollars I contributed and compute the shares I bought,  
to the same 3 to 4 digits that the fund companies compute it, in order to  
simplify "buy" and "sell" functions -- to save me time when entering  
trades. 2% is far too much error to do that.

Ending with the wrong number of shares in my account -- because of days  
when the price comes back wrong from FinancialData -- is unacceptable. It  
makes the share and dollar balance wrong, the internal rate of return  
wrong, etc.

I'm contributing $100 to my IRA 60 times a year, plus occasional transfers  
among the funds I hold, so simpler "buy" and "sell" functions seem  
worthwhile, if it were possible... which, with these errors, it is not.

And regardless, whether I need perfection or not, the "curated" data is  
simply wrong.

Bobby

On Fri, 29 Jul 2011 03:48:42 -0500, Pierpaolo Bernardi  
<olopierpa@gmail.com> wrote:

> On Fri, Jul 29, 2011 at 10:41, DrMajorBob <btreat1@austin.rr.com> wrote:
>> FUNNY STORY: Here is Tech Support's non-response to my problem,  
>> described
>> farther down:
>
>> I've found a new (to me) species of error in FinancialData.
>>
>> One example is the price of the following stock on Feb 10, 2011:
>>
>> s = "JANFX";
>> FinancialData["JANFX", "Name"]
>> FinancialData["JANFX", {{2011, 2, 9}, {2011, 2, 11}}]
>>
>> "Janus Flexible Bond Fund D Shar"
>>
>> {{{2011, 2, 9}, 10.25}, {{2011, 2, 10}, 10.23}, {{2011, 2, 11},
>>     10.24}}
>>
>> As you see, FinancialData says the price was 10.23.
>>
>> But I BOUGHT the stock through Janus Funds on that day, and the price  
>> was
>> 10.36.
>>
>> Moreover, if I go to Yahoo's interactive price chart for the stock at  
>> the
>> following page, 10.36 is the price I find:
>
> Prices do vary continuously, they don't stay the same for a whole day,
> At the moment you bought it was 10.36.  At the moment the data source
> was sampled it was 10.23. Usually historical data use the closing
> price, AFAIK. I see nothing strange in this.
>
>> So... where are the errors really coming from?
>>
>> This is not an astronomically large price or a Missing["Not Available"]
>> price; it's within 2% of the correct price. But it's wrong.
>>
>> These errors make it very difficult to trust FinancialData for any  
>> useful
>> purpose.
>
> If a difference of less than 2% in the historical market data
> influences your algorithms, I won't trust your conclusions.  :)
>
> Cheers


-- 
DrMajorBob@yahoo.com

[toc] | [prev] | [next] | [standalone]


#4086 — Re: FinancialData errors

FromJames Stein <mathgroup@stein.org>
Date2011-07-30 10:13 +0000
SubjectRe: FinancialData errors
Message-ID<j10lg9$p0f$1@smc.vnet.net>
In reply to#3937
You purchased shares at 10.36, which WAS the "closing" price for that day.
(Note to PierPaolo: Mutual Funds, unlike stocks, do NOT trade DURING the
day).

The 10.23 price reported by Yahoo is an "adjusted" price. When a fund or
stock makes a distribution (typically dividends or capital gains), all
historical prices are "adjusted" downward in order that ROI  between two
dates is consistent.  JANFX distributes dividends at the end of every month.
Check out this URL:
<http://finance.yahoo.com/q/hp?s=JANFX&a=01&b=10&c11&d=02&e&f11&g=d
>

Note that both "Close" and "Adj Close" are available, and if you check
Mathematica's documentation you can learn how to obtain the former. The
adjusted prices are the defaults.

On Fri, Jul 29, 2011 at 1:42 AM, DrMajorBob <btreat1@austin.rr.com> wrote:

> I've found a new (to me) species of error in FinancialData.
>
> One example is the price of the following stock on Feb 10, 2011:
>
> s = "JANFX";
> FinancialData["JANFX", "Name"]
> FinancialData["JANFX", {{2011, 2, 9}, {2011, 2, 11}}]
>
> "Janus Flexible Bond Fund D Shar"
>
> {{{2011, 2, 9}, 10.25}, {{2011, 2, 10}, 10.23}, {{2011, 2, 11},
>   10.24}}
>
> As you see, FinancialData says the price was 10.23.
>
> But I BOUGHT the stock through Janus Funds on that day, and the price was
> 10.36.
>
> Moreover, if I go to Yahoo's interactive price chart for the stock at the
> following page, 10.36 is the price I find:
>
>
> http://finance.yahoo.com/echarts?s=JANFX+Interactive#chart3:symbol=janfx;range=ytd;indicator=volume;charttype=line;crosshair=on;ohlcvalues=0;logscale=on;source=undefined
>
> So... where are the errors really coming from?
>
> This is not an astronomically large price or a Missing["Not Available"]
> price; it's within 2% of the correct price. But it's wrong.
>
> These errors make it very difficult to trust FinancialData for any useful
> purpose.
>
> Bobby
>
> --
> DrMajorBob@yahoo.com
>
>

[toc] | [prev] | [standalone]


Back to top | Article view | comp.soft-sys.math.mathematica


csiph-web