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


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

Re: FinancialData errors

From DrMajorBob <btreat1@austin.rr.com>
Newsgroups comp.soft-sys.math.mathematica
Subject Re: FinancialData errors
Date 2011-07-30 10:00 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <j10koa$oo5$1@smc.vnet.net> (permalink)
References <201107222344.TAA28525@smc.vnet.net> <j0fos4$8p6$1@smc.vnet.net>

Show all headers | View raw


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

Back to comp.soft-sys.math.mathematica | Previous | Next — Previous in thread | Next 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