Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #4055 > unrolled thread
| Started by | Pierpaolo Bernardi <olopierpa@gmail.com> |
|---|---|
| First post | 2011-07-29 12:03 +0000 |
| Last post | 2011-08-01 03:38 +0000 |
| Articles | 5 — 3 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 errors Pierpaolo Bernardi <olopierpa@gmail.com> - 2011-07-29 12:03 +0000
Re: FinancialData errors magma <maderri2@gmail.com> - 2011-07-30 10:11 +0000
Re: FinancialData errors DrMajorBob <btreat1@austin.rr.com> - 2011-07-31 11:33 +0000
Re: FinancialData errors magma <maderri2@gmail.com> - 2011-07-31 12:04 +0000
Re: FinancialData errors DrMajorBob <btreat1@austin.rr.com> - 2011-08-01 03:38 +0000
| From | Pierpaolo Bernardi <olopierpa@gmail.com> |
|---|---|
| Date | 2011-07-29 12:03 +0000 |
| Subject | Re: FinancialData errors |
| Message-ID | <j0u7it$fb7$1@smc.vnet.net> |
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},
> =C2 =C2 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
[toc] | [next] | [standalone]
| From | magma <maderri2@gmail.com> |
|---|---|
| Date | 2011-07-30 10:11 +0000 |
| Message-ID | <j10lcf$ovo$1@smc.vnet.net> |
| In reply to | #4055 |
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 case. 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: http://finance.yahoo.com/q/hp?s=JANFX&a=01&b=05&c11&d=06&e=2= 9&f11&g=d&z=66&y=66 (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
[toc] | [prev] | [next] | [standalone]
| From | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| Date | 2011-07-31 11:33 +0000 |
| Message-ID | <j13eic$56u$1@smc.vnet.net> |
| In reply to | #4055 |
> So, at least in this case, FinancialData is correct Correct in what sense? In the sense that it agrees with an unexplained column on a Yahoo page? > It seems the the price of this Janus fund is adjusted daily for > dividends/distributions And no, IMHO, that is not an explanation. Bobby On Sat, 30 Jul 2011 05:03:03 -0500, magma <maderri2@gmail.com> wrote: > 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 > case. > 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: > http://finance.yahoo.com/q/hp?s=JANFX&a=01&b=05&c11&d=06&e=2= > 9&f11&g=d&z=66&y=66 > > (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 > > > > -- DrMajorBob@yahoo.com
[toc] | [prev] | [next] | [standalone]
| From | magma <maderri2@gmail.com> |
|---|---|
| Date | 2011-07-31 12:04 +0000 |
| Message-ID | <j13gc1$5jf$1@smc.vnet.net> |
| In reply to | #4055 |
For DrMajorBob
DrMajorBob wrote:
>Correct in what sense? In the sense that it agrees with an unexplained column on a Yahoo page?
No Bobby, in the sense that FinancialData gave you back EXACTLY what
you asked for!
Let me explain:
this is perhaps not so well known/interiorized by most users, but
FinancialData info page clearly states that:
"For historical data, properties such as "High", "Low", "Close" are
adjusted for stock splits, dividends and related changes."
So when Bobby asked
FinancialData["JANFX", {{2011, 2, 9}, {2011, 2, 11}}]
Mathematica gave back historical closing prices ADJUSTED for stock spits ,ect.
In order to get the RAW closing prices, one has to ask for
FinancialData["JANFX", "RawClose", {{2011, 2, 9}, {2011, 2, 11}}]
and indeed one gets....
{{{2011, 2, 9}, 10.38}, {{2011, 2, 10}, 10.36}, {{2011, 2, 11},
10.37}}
the famous 10.36$ paid by Bobby on Feb 10th 2011.
hth
[toc] | [prev] | [next] | [standalone]
| From | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| Date | 2011-08-01 03:38 +0000 |
| Message-ID | <j15747$b4e$1@smc.vnet.net> |
| In reply to | #4055 |
You are right, I could have asked for RAW close.
But there IS only one price for that date, and any adjustments need a
precise explanation.
MinHsuan Peng (thank you!) at Wolfram has provided that explanation.
Using adjusted prices, rather than the ACTUAL prices, as the default seems
an odd choice, however.
Bobby
On Sun, 31 Jul 2011 07:03:40 -0500, magma <maderri2@gmail.com> wrote:
> For DrMajorBob
>
> DrMajorBob wrote:
>> Correct in what sense? In the sense that it agrees with an unexplained
>> column on a Yahoo page?
>
>
>
> No Bobby, in the sense that FinancialData gave you back EXACTLY what
> you asked for!
>
> Let me explain:
> this is perhaps not so well known/interiorized by most users, but
> FinancialData info page clearly states that:
>
> "For historical data, properties such as "High", "Low", "Close" are
> adjusted for stock splits, dividends and related changes."
>
> So when Bobby asked
> FinancialData["JANFX", {{2011, 2, 9}, {2011, 2, 11}}]
>
> Mathematica gave back historical closing prices ADJUSTED for stock spits
> ,ect.
>
> In order to get the RAW closing prices, one has to ask for
>
> FinancialData["JANFX", "RawClose", {{2011, 2, 9}, {2011, 2, 11}}]
>
> and indeed one gets....
>
> {{{2011, 2, 9}, 10.38}, {{2011, 2, 10}, 10.36}, {{2011, 2, 11},
> 10.37}}
>
> the famous 10.36$ paid by Bobby on Feb 10th 2011.
>
> hth
>
--
DrMajorBob@yahoo.com
[toc] | [prev] | [standalone]
Back to top | Article view | comp.soft-sys.math.mathematica
csiph-web