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


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

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:29 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <j1r5mm$fki$1@smc.vnet.net> (permalink)
References <j1o6cm$4i0$1@smc.vnet.net>

Show all headers | View raw


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 — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Random prices from FinancialData DrMajorBob <btreat1@austin.rr.com> - 2011-08-08 08:22 +0000
  Re: Random prices from FinancialData "Chris Degnen" <degnen@cwgsy.net> - 2011-08-09 11:29 +0000
  Re: Random prices from FinancialData DrMajorBob <btreat1@austin.rr.com> - 2011-08-09 11:31 +0000

csiph-web