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


Groups > comp.soft-sys.math.mathematica > #4086

Re: FinancialData errors

From James Stein <mathgroup@stein.org>
Newsgroups comp.soft-sys.math.mathematica
Subject Re: FinancialData errors
Date 2011-07-30 10:13 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <j10lg9$p0f$1@smc.vnet.net> (permalink)
References <201107222344.TAA28525@smc.vnet.net> <j0fos4$8p6$1@smc.vnet.net> <201107290842.EAA13406@smc.vnet.net>

Show all headers | View raw


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
>
>

Back to comp.soft-sys.math.mathematica | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

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

csiph-web