Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #3937 > unrolled thread
| Started by | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| First post | 2011-07-24 00:26 +0000 |
| Last post | 2011-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.
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
| From | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| Date | 2011-07-24 00:26 +0000 |
| Subject | Re: 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]
| From | Armand Tamzarian <mike.honeychurch@gmail.com> |
|---|---|
| Date | 2011-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]
| From | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| Date | 2011-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]
| From | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| Date | 2011-07-29 08:43 +0000 |
| Subject | FinancialData 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]
| From | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| Date | 2011-07-29 08:46 +0000 |
| Subject | FinancialData 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]
| From | MinHsuan Peng <minhsuanp@wolfram.com> |
|---|---|
| Date | 2011-07-30 10:08 +0000 |
| Subject | Re: 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]
| From | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| Date | 2011-07-30 10:00 +0000 |
| Subject | Re: 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]
| From | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| Date | 2011-07-30 10:01 +0000 |
| Subject | Re: 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]
| From | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| Date | 2011-07-30 10:09 +0000 |
| Subject | Re: 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]
| From | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| Date | 2011-07-30 10:12 +0000 |
| Subject | Re: 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]
| From | James Stein <mathgroup@stein.org> |
|---|---|
| Date | 2011-07-30 10:13 +0000 |
| Subject | Re: 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