Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #4214 > unrolled thread
| Started by | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| First post | 2011-08-08 08:22 +0000 |
| Last post | 2011-08-09 11:31 +0000 |
| Articles | 3 — 2 participants |
Back to article view | Back to comp.soft-sys.math.mathematica
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
| From | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| Date | 2011-08-08 08:22 +0000 |
| Subject | Random prices from FinancialData |
| Message-ID | <j1o6cm$4i0$1@smc.vnet.net> |
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
[toc] | [next] | [standalone]
| From | "Chris Degnen" <degnen@cwgsy.net> |
|---|---|
| Date | 2011-08-09 11:29 +0000 |
| Message-ID | <j1r5mm$fki$1@smc.vnet.net> |
| In reply to | #4214 |
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
>
[toc] | [prev] | [next] | [standalone]
| From | DrMajorBob <btreat1@austin.rr.com> |
|---|---|
| Date | 2011-08-09 11:31 +0000 |
| Message-ID | <j1r5rf$flp$1@smc.vnet.net> |
| In reply to | #4214 |
Thanks for your reply.
I'm only interested in mutual funds, so some of what you've noticed
doesn't affect me.
I have found that calling without a date is too buggy and random for any
possible use, so from now on, I will provide specific TRADING DATES only.
I've also found that "RawClose" is relevant to my trades, but "Close"
prices are not.
I've been told, repeatedly, that "Close" prices are adjusted for splits
and dividends, but not over what time period. It's very obvious that a
specific time period is necessary for that kind of adjustment, but no one
offers a clue what period that might be. I no longer care, so... not a
problem.
Thanks again!
Bobby
On Mon, 08 Aug 2011 07:09:21 -0500, Chris Degnen <degnen@cwgsy.net> wrote:
> 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
>>
>
>
--
DrMajorBob@yahoo.com
[toc] | [prev] | [standalone]
Back to top | Article view | comp.soft-sys.math.mathematica
csiph-web