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


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

Re: Random prices from FinancialData

From "Chris Degnen" <degnen@cwgsy.net>
Newsgroups comp.soft-sys.math.mathematica
Subject Re: Random prices from FinancialData
Date 2011-08-09 11:30 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <j1r5ph$fld$1@smc.vnet.net> (permalink)

Show all headers | View raw


> I have noticed that if the Last Trade result from Yahoo contains a time 
> rather than a date, it is likely to be correct.

I should clarify this comment.  At the moment, on August 8th, quite often 
the Yahoo results' Last Trades are erroneously dated August 1st or 2nd, with 
no times given at all although the european markets are open.  This is 
happening about one in ten times I run the Yahoo query below.  Most of the 
time it works ok though, with times given except for two which say August 
5th.  (Specifically that's for S&P which is understandable, and FTSEurofirst 
(LSE) which is not.)

If I see August 1st or 2nd I rerun the query.  Results may be different by 
the time this post appears on the MathGroup.


----- Original Message ----- 
From: "Chris Degnen" <degnen@cwgsy.net>
To: <mathgroup@smc.vnet.net>; <drmajorbob@yahoo.com>
Sent: Monday, August 08, 2011 1:09 PM
Subject: Re: Random prices from FinancialData


> DrMajorBob, This reply doesn't directly address your post, but I have been 
> observing Yahoo and Wolfram quotes both varying substantially.
> I have noticed that if the Last Trade result from Yahoo contains a time 
> rather than a date, it is likely to be correct.
>
> quotes = Import[
> "http://finance.yahoo.com/d/quotes.csv?s=CLU11.NYM+GBPUSD=X+DX-Y.NYB+^FTSE+\
> ^GSPC+E3X.L+^GDAXI+^N225+000001.SS&f=snabll1ohgp"];
> quoteset =
> Append[quotes[[All, 6]],
> DateString[{"Time", " ", "Day", "/", "Month", "/", "Year"}]];
> TableForm[quotes,
> TableHeadings -> {None, {"Symbol", "Name", "Ask", "Bid", "Last Trade",
> "Last Price", "Open", "High", "Low", "Previous Close"}}]
>
> indices = {"NYM:CLU11", "GBP/USD", "NYB:DX-Y", "^FTSE", "^GSPC", 
> "LSE:E3X",
> "^GDAXI", "^N225", "SS:000001"};
> set = Append[FinancialData[#] & /@ indices,
> DateString[{"Time", " ", "Day", "/", "Month", "/", "Year"}]];
> TableForm[{quoteset, set, Append[Most[quoteset] - Most[set], ""]},
> TableHeadings -> {{"Yahoo", "Wolfram", "Delta"}, {"WTI", "GBP/USD", "DX",
> "FTSE", "S&P", "Eurofirst", "DAX", "Nikkei", "Shangahi", "Time & Date"}}]
>
>
>
> ----- Original Message ----- 
> From: "DrMajorBob" <btreat1@austin.rr.com>
> Newsgroups: comp.soft-sys.math.mathematica
> Sent: Monday, August 08, 2011 9:22 AM
> Subject: Random prices from FinancialData
>
>
>> FOR EXAMPLE, below you see both "Close" and "RawClose" prices varying
>> randomly within ELEVEN seconds.
>>
>> All the differences in the last three outputs should be zero for mutual
>> funds, especially on a Sunday.
>>
>> AbsoluteTiming[
>>  s1 = {#, FinancialData[#, "Close"], FinancialData[#, "RawClose"]} & /@
>>      janusStocks // Transpose;
>>  s2 = {#, FinancialData[#, "Close"], FinancialData[#, "RawClose"]} & /@
>>      janusStocks // Transpose;
>>  s3 = {#, FinancialData[#, "Close"], FinancialData[#, "RawClose"]} & /@
>>      janusStocks // Transpose;]
>> s1[[2 ;;]] - s2[[2 ;;]]
>> s1[[2 ;;]] - s3[[2 ;;]]
>> s2[[2 ;;]] - s3[[2 ;;]]
>>
>> {10.728764, Null}
>>
>> {{0., 0., 0., 0., 0., 0., 0., 0.79, 0., 0.}, {-4.06, 0., 0.,
>>   0., -1.61, 0., 0., 0.79, 0., 0.}}
>>
>> {{0., -3.69, 0., 0., 0., 0., 0., 0.79, 0., 0.}, {0., 0., 0., 0., 0.,
>>   0., 0., 0., 0., 0.}}
>>
>> {{0., -3.69, 0., 0., 0., 0., 0., 0., 0., 0.}, {4.06, 0., 0., 0., 1.61,
>>    0., 0., -0.79, 0., 0.}}
>>
>> Bobby
>>
>> -- 
>> DrMajorBob@yahoo.com
>>
> 


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


Thread

Re: Random prices from FinancialData "Chris Degnen" <degnen@cwgsy.net> - 2011-08-09 11:30 +0000

csiph-web