MathGroup Archive 2011

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: FinancialData errors

  • To: mathgroup at
  • Subject: [mg120601] Re: FinancialData errors
  • From: magma <maderri2 at>
  • Date: Sat, 30 Jul 2011 06:03:03 -0400 (EDT)
  • Delivered-to:
  • References: <> <j0u7it$fb7$>

DrMajorBob wrote:
> 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:

Pierpaolo Bernardi replied:

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

Bernardi's argument is valid in general, but not in this particular
It seems that this Janus fund is not traded the whole day long, but
that only a closing price is issued every day, and all transactions
are executed at that price.

The solution to this mysterious price divergence is simple.
Check the historical price series in yahoo:

(I hope the link comes out right, anyway check the historical price
link on the fund's page in Yahoo finance )

For the date 10 Feb 2011 you will see that the price is indeed 10.36$,
but in the rightmost column the ADJUSTED price is 10.23$, the same
reported in FinancialData.
It seems the the price of this Janus fund is adjusted daily for
dividends/distributions and that FinancialData just reports the
Adjusted price.

So, at least in this case, FinancialData is correct

  • Prev by Date: Re: FinancialData still broken
  • Next by Date: Re: Mathematica 8 remote parallel kernels
  • Previous by thread: Re: FinancialData errors
  • Next by thread: Re: FinancialData errors