|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<STYLE></STYLE>
<META content="MSHTML 5.00.2014.206" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Tahoma size=2><SPAN class=140095700-18031999>Ton,
Thanks!</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=140095700-18031999>I've also been
doing a little "hacking" Yahoo codes. Below is a string and the code definitions
I've solved so far:</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=140095700-18031999>Historical quotes +
ask if save to disk.<BR><A
href="http://chart.yahoo.com/table.csv?s=ge&a=12&b=31&c=97&d=3&e=17&f=99&g=d&q=q&y=0&z=ge&x=.csv";>http://chart.yahoo.com/table.csv?s=ge&a=12&b=31&c=97&d=3&e=17&f=99&g=d&q=q&y=0&z=ge&x=.csv</A></SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=140095700-18031999>Historical quotes +
Don't Ask<BR><A
href="http://chart.yahoo.com/table.csv?s=ge&a=12&b=31&c=97&d=3&e=17&f=99&g=d&q=q&y";>http://chart.yahoo.com/table.csv?s=ge&a=12&b=31&c=97&d=3&e=17&f=99&g=d&q=q&y</A></SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=140095700-18031999>Multiple Quotes +
ask if save to disk.<BR><A
href="http://quote.yahoo.com/d/quotes.csv?s=AOL+T+CSCO&f=sl1d1t1c1ohgv&e=.csv";>http://quote.yahoo.com/d/quotes.csv?s=AOL+T+CSCO&f=sl1d1t1c1ohgv&e=.csv</A></SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=140095700-18031999>Multiple Quotes +
Don't Ask<BR><A
href="http://quote.yahoo.com/d/quotes.csv?s=AOL";>http://quote.yahoo.com/d/quotes.csv?s=AOL</A>+T+CSCO&f=sl1d1t1c1ohgv</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999>
/d =
download </SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999> ?s
= symbol list follows</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999>
&f = format codes follow</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999>
</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999>
format codes:</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999> s
=
symbol<BR> l
= last trade time and
price<BR>
l1 = last price
only<BR>
d =
dividend<BR>
d1 =
date<BR>
t1 = time of last
trade<BR>
c = price change in points &
percent<BR>
c1 = price change points
only<BR>
o = open
price<BR>
h =
high<BR>
g =
low<BR>
v =
volume<BR>
v1 = value</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999>
&e=.csv apparently means to as if save to disk</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=140095700-18031999><BR>Multiple
Quotes: Symbol, Date, Open, Hi, Low, Close, Volume<BR><A
href="http://quote.yahoo.com/d/quotes.csv?s=AOL+T+CSCO&f=sd1ohgl1v";>http://quote.yahoo.com/d/quotes.csv?s=AOL+T+CSCO&f=sd1ohgl1v</A></SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=140095700-18031999>Now what I'm trying
to solve is how to incorporate the above http strings into a web query that
formats the results into the appropriate columns. If you just take one of
the above and make it into a web query thusly:</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999>WEB</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999>1</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=140095700-18031999><A
href="http://quote.yahoo.com/d/quotes.csv?s=AOL+T+CSCO&f=sd1ohgl1v";>http://quote.yahoo.com/d/quotes.csv?s=AOL+T+CSCO&f=sd1ohgl1v</A></SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=140095700-18031999>and then load the
sheet thru the data/get external data/web query menu selections the result
is a csv all treated as an alfa string in one column. </SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=140095700-18031999>Anyone got the
magic code to solve this?</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=140095700-18031999>Dale<BR></DIV></SPAN></FONT>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">
<DIV class=OutlookMessageHeader><FONT face="Times New Roman"
size=2>-----Original Message-----<BR><B>From:</B>
owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]<B>On
Behalf Of</B> A.J. Maas<BR><B>Sent:</B> Wednesday, March 17, 1999 4:55
PM<BR><B>To:</B> metastock@xxxxxxxxxxxxx<BR><B>Subject:</B> Re: data download
template<BR><BR></DIV></FONT>
<DIV>
<DIV>The Yahoo code</DIV>
<DIV><FONT size=3> </DIV></FONT>
<DIV>Widen mail-program's preview window for a complete and "total-link"
look</DIV>
<DIV>(or directly click any of the links below to GO or to download the here
pre-set history).</DIV>
<DIV> </DIV>
<DIV>Download Spreadsheet Format</DIV><A
href="http://chart.yahoo.com/table.csv?s=^";>http://chart.yahoo.com/table.csv?s=^</A><FONT
color=#0000ff>spx&a=1&b=1&c=1&d=3&e=17&f=99&g=d&q=q&y=0&z=^spx&x=.csv</FONT><BR><A
href="http://chart.yahoo.com/table.csv?s=^";>http://chart.yahoo.com/table.csv?s=^</A><FONT
color=#0000ff>djt&a=1&b=1&c=1&d=3&e=17&f=99&g=d&q=q&y=0&z=^djt&x=.csv</FONT><BR><A
href="http://chart.yahoo.com/table.csv?s=^";>http://chart.yahoo.com/table.csv?s=^</A><FONT
color=#0000ff>dji&a=1&b=1&c=1&d=3&e=17&f=99&g=d&q=q&y=0&z=^dji&x=.csv</FONT>
<DIV><BR>with<BR>?s = Symbol<BR>&a = Start Month (m or
mm)<BR>&b = Start Day (d or dd)<BR>&c = Start Year
(yy)<BR>&d = End Month (m or mm)<BR>&e = End Day (d or
dd)<BR>&f = End Year (yy)<BR>&g = (d: Daily, w:
Weekly, m: Monthly)<BR>&q = (q: spreadsheet, <other>:
html)<BR>&y = Records (Additional Line Rows) <BR>&z =
Filename (Symbol)<BR>&x = Filename Extension (.csv, .html)</DIV>
<DIV> </DIV>
<DIV>-Many Tickers are preceded by (included with) the " ^ " cap-character
(Reuters)</DIV>
<DIV>-The Tickers are twice(2x) mentioned on the one(1x) single line
(link)<BR>
<DIV>-It is set to download all available historical data(from 01-01-01)
updated to todays date(03/17/1999)</DIV>
<DIV> (I wonder if the Yahoo's date sequence " yy " will get
adjusted to " yyyy " for millenium complience)</DIV>
<DIV>-It will then automaticaly return a " xxx.csv " file wich needs a minor
adjusting(eg adding</DIV>
<DIV> the Metastocks period "comma-D-comma" ( ,D, ) overhaul in
Excel, adjust the columns, then</DIV>
<DIV> save as txt(or csv) file and open in Word for the
overhaul to remove the (any blanc) spaces,</DIV>
<DIV> eg for the txt or csv (=users choise) file to be Downloader
ready</DIV>
<DIV>-And, this as I haven't tried switching the " a,b,c " parts into for
instance " c,a,b " to see what type</DIV>
<DIV> of colom layout it will send or if it will return an error,
but this should not be a problem to try</DIV>
<DIV> out at first, otherwise the before mentioned very tiny
overhaul in Excel/Word is required</DIV>
<DIV>-Attached are some (not all) of the symbols available (as of mid 1998),
there are more indexes</DIV>
<DIV> available, eg like funds + stocks + sector symbols,
grouped per sector and many are available</DIV>
<DIV> from Exchanges around the globe</DIV>
<DIV>-The Tickers can also very well and easy be used in the (Metastock)
QuoteManager v1.01 program, </DIV>
<DIV> and use the spaces to seperate them(before downloading).
Rename the auto saved prn-file to txt-file</DIV>
<DIV> and run the Downloader.</DIV></DIV>
<DIV><BR>Symbol Look Up<BR><A
href="http://biz.yahoo.com/l/";>http://biz.yahoo.com/l/</A></DIV>
<DIV> </DIV>
<DIV>Symbol Look Up (alphabetical)<BR><A
href="http://biz.yahoo.com/i/";>http://biz.yahoo.com/i/</A></DIV>
<DIV> </DIV>
<DIV>
<DIV>Historical quotes </DIV>
<DIV><A
href="http://chart.yahoo.com/table.csv?s=";>http://chart.yahoo.com/table.csv?s=</A><A
href="http://chart.yahoo.com/table.csv?s=";>^dji&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=q&y=0&z=^dji&x=.csv</A></DIV>
<DIV> </DIV>
<DIV>Basic quotes</DIV>
<DIV><A
href="http://quote.yahoo.com/q?s=VIMSX+VISVX+VISGX+";>http://quote.yahoo.com/q?s=VIMSX+VISVX+VISGX+</A><A
href="http://quote.yahoo.com/q?s=VIMSX+VISVX+VISGX+";>^TXS+FNISX+AUSSX+^IXA+ADIAX+ADIBX+AEIBX+^BVQ+^ECU+&d=v1</A></DIV>
<DIV> </DIV>
<DIV>
<DIV> </DIV></DIV>
<DIV>
<DIV>See also attachement (YahooTick.txt) for more Tickers(symbols).</DIV>
<DIV> </DIV>
<DIV>==================================================</DIV></DIV></DIV></DIV></BLOCKQUOTE></BODY></HTML>
</x-html>From ???@??? Wed Mar 17 19:51:36 1999
Received: from listserv.equis.com (204.246.137.2)
by mail02.rapidsite.net (RS ver 1.0.2) with SMTP id 3581
for <neal@xxxxxxxxxxxxx>; Wed, 17 Mar 1999 22:17:39 -0500 (EST)
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id KAA25197
for metastock-outgoing; Thu, 18 Mar 1999 10:53:35 -0700
X-Authentication-Warning: listserv.equis.com: majordom set sender to owner-metastock@xxxxxxxxxxxxx using -f
Received: from freeze.metastock.com (freeze.metastock.com [204.246.137.5])
by listserv.equis.com (8.8.7/8.8.7) with ESMTP id KAA25194
for <metastock@xxxxxxxxxxxxxxxxxx>; Thu, 18 Mar 1999 10:53:33 -0700
Received: from netcom13.netcom.com (genepool@xxxxxxxxxxxxxxxxxxx [192.100.81.125])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id TAA07668
for <metastock@xxxxxxxxxxxxx>; Wed, 17 Mar 1999 19:52:05 -0700 (MST)
Received: (from genepool@xxxxxxxxx)
by netcom13.netcom.com (8.8.5-r-beta/8.8.5/(NETCOM v1.02)) id SAA28779;
Wed, 17 Mar 1999 18:40:32 -0800 (PST)
Date: Wed, 17 Mar 1999 18:40:31 -0800 (PST)
From: Jim Michael <genepool@xxxxxxxxxx>
Subject: QuoteMonster Challenge
To: metastock@xxxxxxxxxxxxx
In-Reply-To: <000901be6ffd$eed35970$6069e0c7@xxxxxxxxxx>
Message-ID: <Pine.3.89.9903171808.A28077-0100000@xxxxxxxx>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
X-Loop-Detect: 1
X-UIDL: 02d3f760d6fb8fff47fe67259b57a05a.16
Since the issue has come up of the value/accuracy/etc of free vs non-free
quotes, I have uploaded the file
http://xmlworks.com/quotemonster/challenge.zip [ca. 240KB] which contains
five files with data from the past 10 years for MSFT, CPQ, IBM, OEX, SPX.
I am as interested as anyone else in a comparison of this data with any
other commercial data.
Cheers,
Jim
|