[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: data download template



PureBytes Links

Trading Reference Links

<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//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.0910.1309"' name=GENERATOR></HEAD>
<BODY bgColor=#ffffff>
<DIV>
<DIV>The Yahoo code</DIV>
<DIV><FONT size=3>&nbsp;</DIV></FONT>
<DIV>Widen mail-program's preview window for a complete and 
&quot;total-link&quot; look</DIV>
<DIV>(or directly click any of the links below to GO or to download the here 
pre-set history).</DIV>
<DIV>&nbsp;</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&amp;a=1&amp;b=1&amp;c=1&amp;d=3&amp;e=17&amp;f=99&amp;g=d&amp;q=q&amp;y=0&amp;z=^spx&amp;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&amp;a=1&amp;b=1&amp;c=1&amp;d=3&amp;e=17&amp;f=99&amp;g=d&amp;q=q&amp;y=0&amp;z=^djt&amp;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&amp;a=1&amp;b=1&amp;c=1&amp;d=3&amp;e=17&amp;f=99&amp;g=d&amp;q=q&amp;y=0&amp;z=^dji&amp;x=.csv</FONT> 

<DIV><BR>with<BR>?s&nbsp; = Symbol<BR>&amp;a&nbsp; = Start Month (m or 
mm)<BR>&amp;b&nbsp; = Start Day (d or dd)<BR>&amp;c&nbsp; = Start Year 
(yy)<BR>&amp;d&nbsp; = End Month (m or mm)<BR>&amp;e&nbsp; = End Day (d or 
dd)<BR>&amp;f&nbsp;&nbsp; = End Year (yy)<BR>&amp;g&nbsp; = (d: Daily, w: 
Weekly, m: Monthly)<BR>&amp;q&nbsp; = (q: spreadsheet, &lt;other&gt;: 
html)<BR>&amp;y&nbsp;&nbsp;= Records (Additional Line Rows) <BR>&amp;z&nbsp; = 
Filename (Symbol)<BR>&amp;x&nbsp; = Filename Extension (.csv, .html)</DIV>
<DIV>&nbsp;</DIV>
<DIV>-Many Tickers are preceded by (included with) the &quot; ^ &quot; 
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>&nbsp;&nbsp; (I wonder if the Yahoo's date sequence &quot; yy &quot; will 
get adjusted to &quot; yyyy &quot; for millenium complience)</DIV>
<DIV>-It will then automaticaly return a &quot; xxx.csv &quot; file wich needs a 
minor adjusting(eg adding</DIV>
<DIV>&nbsp;&nbsp; the Metastocks period &quot;comma-D-comma&quot; ( ,D, ) 
overhaul in Excel, adjust the columns, then</DIV>
<DIV>&nbsp;&nbsp; save as txt(or csv) file and open in Word&nbsp;for the 
overhaul to remove the (any blanc) spaces,</DIV>
<DIV>&nbsp;&nbsp; eg for the txt or csv (=users choise) file to be Downloader 
ready</DIV>
<DIV>-And, this as I haven't tried switching the &quot; a,b,c &quot; parts into 
for instance &quot; c,a,b &quot; to see what type</DIV>
<DIV>&nbsp;&nbsp; of colom layout it will send or if it will return an error, 
but this should not be a problem to try</DIV>
<DIV>&nbsp;&nbsp; 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>&nbsp;&nbsp;&nbsp;available, eg like funds + stocks + sector symbols, 
grouped per sector and many are available</DIV>
<DIV>&nbsp;&nbsp;&nbsp;from Exchanges around the globe</DIV>
<DIV>-The Tickers can also very well and easy be used in the (Metastock) 
QuoteManager v1.01 program,&nbsp;&nbsp; </DIV>
<DIV>&nbsp;&nbsp; and use the spaces to seperate them(before downloading). 
Rename the auto saved prn-file to txt-file</DIV>
<DIV>&nbsp;&nbsp; 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>&nbsp;</DIV>
<DIV>Symbol Look Up (alphabetical)<BR><A 
href="http://biz.yahoo.com/i/";>http://biz.yahoo.com/i/</A></DIV>
<DIV>&nbsp;</DIV>
<DIV>
<DIV>Historical quotes&nbsp;</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&amp;a=1&amp;b=1&amp;c=1&amp;d=11&amp;e=5&amp;f=98&amp;g=d&amp;q=q&amp;y=0&amp;z=^dji&amp;x=.csv</A></DIV>
<DIV>&nbsp;</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+&amp;d=v1</A></DIV>
<DIV>&nbsp;</DIV>
<DIV>
<DIV>&nbsp;</DIV></DIV>
<DIV>
<DIV>See also attachement (YahooTick.txt) for more Tickers(symbols).</DIV>
<DIV>&nbsp;</DIV>
<DIV>==================================================</DIV>
<DIV>&nbsp;</DIV></DIV>
<DIV>&nbsp;</DIV>----- Original Message ----- </DIV></DIV>
<DIV>
<DIV>From: Dale Wingo &lt;<A 
href="mailto:dingo@xxxxxxxxxxxx";>dingo@xxxxxxxxxxxx</A>&gt;</DIV>
<DIV>To: &lt;<A 
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>&gt;</DIV>
<DIV>Sent: woensdag 17 maart 1999 14:50</DIV>
<DIV>Subject: RE: data download template</DIV></DIV>
<DIV><BR></DIV>&gt;Lionel,<BR>&gt;<BR>&gt;Yahoo can provide you with data in 
&quot;csv&quot; format for a range of dates.<BR>&gt;<BR>&gt;Here's how you do 
that manually (I'm trying to figure out how to<BR>&gt;automate 
it):<BR>&gt;<BR>&gt;Get a quote on a symbol. make sure you get one of the 
&quot;Views&quot; that<BR>&gt;shows the &quot;More Info&quot; box. In that box 
click the &quot;Chart&quot; link. You'll<BR>&gt;then get a graph and below that 
you'll see options for: &quot;Small&quot;,<BR>&gt;&quot;Big&quot;, and 
&quot;Table&quot;.&nbsp; The &quot;Table&quot; options are &quot;daily&quot;, 
weekly&quot;,<BR>&gt;&quot;monthly&quot;, &quot;dividends&quot;. Each of the 
first 3 will give you historical<BR>&gt;quotes based on the respective time 
period. So, if you're looking for<BR>&gt;daily historical quotes then click the 
&quot;daily&quot; link. You'll then get a<BR>&gt;nice table which you can adjust 
for date range. At the bottom of the<BR>&gt;table is a link &quot;Download 
Spreadsheet Format&quot; which will do as it<BR>&gt;says.<BR>&gt;<BR>&gt;I've 
been working trying to crack the Yahoo &quot;code&quot; used to 
download<BR>&gt;this data.<BR>&gt;<BR>&gt;For instance code to download 
historical data for Ge from 12/31/97<BR>&gt;thru 3/17/99 would 
be:<BR>&gt;<BR>&gt;<A 
href="http://chart.yahoo.com/table.csv?s=ge&amp;a=12&amp;b=31&amp;c=97&amp;d=3&amp;e=17&amp;f=99&amp;g=d";>http://chart.yahoo.com/table.csv?s=ge&amp;a=12&amp;b=31&amp;c=97&amp;d=3&amp;e=17&amp;f=99&amp;g=d</A><BR>&gt;&amp;q=q&amp;y<BR>&gt;<BR>&gt;Of 
course, some of this code is obvious. And some of it 
isn't...<BR>&gt;<BR>&gt;Anyone cracked the Yahoo code?<BR>&gt;<BR>&gt;Dale 
</BODY></HTML>
</x-html>
Attachment Converted: "c:\eudora\attach\YahooTick.txt"