|
PureBytes Links
Trading Reference Links
|
I
download all common stocks. Can this be done from Yahoo or do you have to do one
at at time?
<SPAN
class=640350516-16102000>
<SPAN
class=640350516-16102000>neo
<FONT face=Tahoma
size=2>-----Original Message-----From:
owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]On
Behalf Of A.J. MaasSent: Sunday, October 15, 2000 3:52
PMTo: Metastock-ListSubject: Yahoo!
See the updated Yahoo! FAQ - repost
(printed below) for obtaining FREE data, or
"How to download data from Yahoo".
Program = FREE and Data = FREE.
To download full files directly from the Yahoo! site (or any
other site) use the AutoWinNet95 program.
See my Homepage for details(on this easy to use "download
files&pages from the web" program).
Regards,Ton Maas<A
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";>ms-irb@xxxxxxxxxxxxxxxxDismiss
the ".nospam" bit (including the dot) when replying.Homepage <A
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas
=====================================Yahoo!
FAQ ===================================
The BITM download program
{Jay + Frans wrote before:}
Here are the tools for you to download free EOD + historical data from
Yahoo.
Try this FREE neat 'BITM' quote download utility. It works quite well as
a stand-alone application...
<A
href="http://www.tarnsoft.com/data.html";>http://www.tarnsoft.com/data.html
BITM Instructions:
When downloading data from Yahoo, leave the name open, only fill in the
symbol.After downloading the data, go to MS downloader, convert and choose
as source the so-called csvsec folder.
BITM FAQ:
Q: I downloaded the BITM program and one stock's data fine from
Yahoo. Yet the Metastock's
Downloader program will not convert it to Metastock format.
Any suggestion?
A: After downloading your data fm yahoo, go to the folder
Bitm2. In this folder you will find the data
you just downloaded as a csv. file. You will
also notice there's a subfolder created called csvsec which also
contains the csv-table(s) you just
downloaded. While converting with the
downloader you should use the csv tables from
this subfolder as the source. It will work 100%.
As mentioned before, don't fill in a (optional) security name, only the
symbol in the first screen you get after clicking
download history. If you do fill in a name, the
file that you get back won't be ready for
converting in the downloader.
The Yahoo code
Widen mail-program's preview window for a complete and "total-link"
look
(or directly click any of the links below to GO or to download the here
pre-set history).
Download Spreadsheet Format<A
href="http://chart.yahoo.com/table.csv?s=^";>http://chart.yahoo.com/table.csv?s=^<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<A
href="http://chart.yahoo.com/table.csv?s=^";>http://chart.yahoo.com/table.csv?s=^<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<A
href="http://chart.yahoo.com/table.csv?s=^";>http://chart.yahoo.com/table.csv?s=^<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
with?s = Symbol&a = Start Month (m or
mm)&b = Start Day (d or dd)&c = Start Year
(yy)&d = End Month (m or mm)&e = End Day (d or
dd)&f = End Year (yy)&g = (d: Daily, w:
Weekly, m: Monthly)&q = (q: spreadsheet, <other>:
html)&y = Records (Additional Line Rows) &z =
Filename (Symbol)&x = Filename Extension (.csv, .html)
-Many Tickers are preceded by (included with) the " ^ " cap-character
(Reuters)
-The Tickers are twice(2x) mentioned on the one(1x) single line
(link)
-It is set to download all available historical data(from 01-01-01)
updated to todays date(03/17/1999)
(I wonder if the Yahoo's date sequence " yy " will get
adjusted to " yyyy " for millenium complience)
-It will then automaticaly return a " xxx.csv " file wich needs a minor
adjusting(eg adding
the Metastocks period "comma-D-comma" ( ,D, ) overhaul in
Excel, adjust the columns, then
save as txt(or csv) file and open in Word for the
overhaul to remove the (any blanc) spaces,
eg for the txt or csv (=users choise) file to be Downloader
ready
-And, this as I haven't tried switching the " a,b,c " parts into for
instance " c,a,b " to see what type
of colom layout it will send or if it will return an error,
but this should not be a problem to try
out at first, otherwise the before mentioned very tiny
overhaul in Excel/Word is required
-There are many symbols available and there are more
indexes available, eg
like funds + stocks + sector symbols, grouped per sector and
many are available
from Exchanges around the globe.
Symbol Look Up<A
href="http://biz.yahoo.com/l/";><FONT
size=2>http://biz.yahoo.com/l/
Symbol Look Up (alphabetical)<FONT
size=2>http://biz.yahoo.com/i/
<A
href="http://quote.yahoo.com/lookup";>http://quote.yahoo.com/lookup
Symbol Look Up (<FONT
size=2>alphabetical by company)<A
href="http://biz.yahoo.com/i/a_-aa.html";>http://biz.yahoo.com/i/a_-aa.html
Symbol Look Up (Indexes and Indices)
Index<A
href="http://quote.yahoo.com/l?s=index";>http://quote.yahoo.com/l?s=indexIndex
Next 200<A
href="http://quote.yahoo.com/l?s=index&m=201";>http://quote.yahoo.com/l?s=index&m=201Index
Next 200<A
href="http://quote.yahoo.com/l?s=index&m=401";>http://quote.yahoo.com/l?s=index&m=401Index
Next 200<A
href="http://quote.yahoo.com/l?s=index&m=601";>http://quote.yahoo.com/l?s=index&m=601
Historical quotes
<FONT
size=2>http://chart.yahoo.com/table.csv?s=<A
href="http://chart.yahoo.com/table.csv?s=";><FONT
size=2>^dji&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=q&y=0&z=^dji&x=.csv
<A
href="http://chart.yahoo.com/t?a=01&b=01&c=00&d=12&e=30&f=00&g=d&s=&y=0&z=abx";><FONT
size=2>http://chart.yahoo.com/t?a=01&b=01&c=00&d=12&e=30&f=00&g=d&s=&y=0&z=abx
<A
href="http://chart.yahoo.com/t?a=12&b=31&c=89&d=03&e=17&f=99&g=d&s=ge&y=0&z=ge";>http://chart.yahoo.com/t?a=12&b=31&c=89&d=03&e=17&f=99&g=d&s=ge&y=0&z=ge
<A
href="http://chart.yahoo.com/table.csv?s=ge&a=3&b=31&c=99&d=4&e=17&f=99&g=d&q=q&y=0&z=ge&x=.csv";>http://chart.yahoo.com/table.csv?s=ge&a=3&b=31&c=99&d=4&e=17&f=99&g=d&q=q&y=0&z=ge&x=.csv
Some of the Indexes available (there are many others,
e.g. SOX, XAU):Ticker
Description
Start_Date^SPX S&P500
Jan/3/1950^DJI DOW JONES
INDUSTRIALS OCT/1/1928^DJU
DOW JONES
UTILITIES
JAN/2/1929^DJT DOW JONES
TRANSPORTS OCT/1/1928^RUT RUSSELL
2000
SEP/10/1987
Get Yahoo's historical data input menu:<A
href="http://chart.yahoo.com/t?a=12&b=31&c=79&d=12&e=31&f=91&g=d&s=&y=0&z=%5Espc";>http://chart.yahoo.com/t?a=12&b=31&c=79&d=12&e=31&f=91&g=d&s=&y=0&z=%5EspcGet
Historical Data DJ Industrials<A
href="http://chart.yahoo.com/t?a=01&b=01&c=01&d=11&e=05&f=98&g=d&s=%5EDJI&y=0&z=.csv";>http://chart.yahoo.com/t?a=01&b=01&c=01&d=11&e=05&f=98&g=d&s=%5EDJI&y=0&z=.csvNext
200 records<A
href="http://chart.yahoo.com/t?s=^dji&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=t&y=200&z=^dji&x=.csv";>http://chart.yahoo.com/t?s=^dji&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=t&y=200&z=^dji&x=.csvDownload
Spreadsheet Format<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";>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=.csvGet
Historical Data DJ Transports<A
href="http://chart.yahoo.com/t?a=01&b=01&c=01&d=11&e=05&f=98&g=d&s=%5Edjt&y=0&z=%5Edjt";>http://chart.yahoo.com/t?a=01&b=01&c=01&d=11&e=05&f=98&g=d&s=%5Edjt&y=0&z=%5EdjtNext
200 records<A
href="http://chart.yahoo.com/t?s=^djt&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=t&y=200&z=^djt&x=.csv";>http://chart.yahoo.com/t?s=^djt&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=t&y=200&z=^djt&x=.csvDownload
Spreadsheet Format<A
href="http://chart.yahoo.com/table.csv?s=^djt&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=q&y=0&z=^djt&x=.csv";>http://chart.yahoo.com/table.csv?s=^djt&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=q&y=0&z=^djt&x=.csvGet
Historical Data DJ Utilities<A
href="http://chart.yahoo.com/t?a=01&b=01&c=01&d=11&e=05&f=98&g=d&s=%5Edju&y=0&z=%5Edjt";>http://chart.yahoo.com/t?a=01&b=01&c=01&d=11&e=05&f=98&g=d&s=%5Edju&y=0&z=%5EdjtNext
200 records<A
href="http://chart.yahoo.com/t?s=^dju&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=t&y=200&z=^djt&x=.csv";>http://chart.yahoo.com/t?s=^dju&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=t&y=200&z=^djt&x=.csvDownload
Spreadsheet Format<A
href="http://chart.yahoo.com/table.csv?s=^dju&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=q&y=0&z=^djt&x=.csv";>http://chart.yahoo.com/table.csv?s=^dju&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=q&y=0&z=^djt&x=.csvGet
Historical Data Standard & Poors 500<A
href="http://chart.yahoo.com/t?a=01&b=01&c=01&d=11&e=05&f=98&g=d&s=%5Espx&y=0&z=%5Edju";>http://chart.yahoo.com/t?a=01&b=01&c=01&d=11&e=05&f=98&g=d&s=%5Espx&y=0&z=%5EdjuNext
200 records<A
href="http://chart.yahoo.com/t?s=^spx&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=t&y=200&z=^dju&x=.csv";>http://chart.yahoo.com/t?s=^spx&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=t&y=200&z=^dju&x=.csvDownload
Spreadsheet Format<A
href="http://chart.yahoo.com/table.csv?s=^spx&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=q&y=0&z=^dju&x=.csv";>http://chart.yahoo.com/table.csv?s=^spx&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=q&y=0&z=^dju&x=.csvGet
Historical Data Russel 2000<A
href="http://chart.yahoo.com/t?a=01&b=01&c=01&d=11&e=05&f=98&g=d&s=%5Erut&y=0&z=%5Espx";>http://chart.yahoo.com/t?a=01&b=01&c=01&d=11&e=05&f=98&g=d&s=%5Erut&y=0&z=%5EspxNext
200 records<A
href="http://chart.yahoo.com/t?s=^rut&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=t&y=200&z=^spx&x=.csv";>http://chart.yahoo.com/t?s=^rut&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=t&y=200&z=^spx&x=.csvDownload
Spreadsheet Format<A
href="http://chart.yahoo.com/table.csv?s=^rut&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=q&y=0&z=^spx&x=.csv";>http://chart.yahoo.com/table.csv?s=^rut&a=1&b=1&c=1&d=11&e=5&f=98&g=d&q=q&y=0&z=^spx&x=.csv
Basic quotes
<FONT
size=2>http://quote.yahoo.com/q?s=VIMSX+VISVX+VISGX+<A
href="http://quote.yahoo.com/q?s=VIMSX+VISVX+VISGX+";><FONT
size=2>^TXS+FNISX+AUSSX+^IXA+ADIAX+ADIBX+AEIBX+^BVQ+^ECU+&d=v1
<A
href="http://quote.yahoo.com/download/quotes.csv?symbols=$TICKERS&format=sl1d1t1c1ohgv&ext=.csv";>http://quote.yahoo.com/download/quotes.csv?symbols=$TICKERS&format=sl1d1t1c1ohgv&ext=.csv
Stock splits<FONT
size=2>http://biz.yahoo.com/c/s.html
Split adjusted data
The table that displays on the web page will show both the
pre-split prices and the split adjusted close.
If you scroll to the bottom and click
download spreadsheet format, the split adjusted OHLC will
download.<FONT
size=2>http://chart.yahoo.com/d
Yahoo! Finance - U.S. Market Digest
Advancing Issues, Declining Issues, Unchanged Issues, Total
Issues, New Highs, New Lows, Up Volume,
Down Volume, Unchanged Volume and Total Volume. For the
NYSE, AMEX, NASDAQ and BBII. <A
href="http://quote.yahoo.com/m0?u";><FONT
size=2>http://quote.yahoo.com/m0?u
Company Profiles by Sector<A
href="http://biz.yahoo.com/p/sectors.html";>http://biz.yahoo.com/p/sectors.html<FONT
size=3>
Company Profiles by Industries<A
href="http://biz.yahoo.com/p/industries.html";>http://biz.yahoo.com/p/industries.html
==================================================
----- Original Message -----
From: Dale Wingo
To: <<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx>
Sent: woensdag 17 maart 1999 14:50
Subject: RE: data download template
>Lionel,>>Yahoo can provide you with data in
"csv" format for a range of dates.>>Here's how you do that
manually (I'm trying to figure out how to>automate
it):>>Get a quote on a symbol. make sure you get one of the
"Views" that>shows the "More Info" box. In that box click the "Chart"
link. You'll>then get a graph and below that you'll see options for:
"Small",>"Big", and "Table". The "Table" options are "daily",
weekly",>"monthly", "dividends". Each of the first 3 will give you
historical>quotes based on the respective time period. So, if you're
looking for>daily historical quotes then click the "daily" link. You'll
then get a>nice table which you can adjust for date range. At the
bottom of the>table is a link "Download Spreadsheet Format" which will
do as it>says.>>I've been working trying to crack the
Yahoo "code" used to download>this data.>>For instance
code to download historical data for Ge from 12/31/97>thru 3/17/99
would be:>><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>>>Of
course, some of this code is obvious. And some of it
isn't...>>Anyone cracked the Yahoo code?>>Dale
|