|
PureBytes Links
Trading Reference Links
|
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:
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
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Lionel
> and Gail Issen
> Sent: Tuesday, March 16, 1999 4:12 PM
> To: metastock@xxxxxxxxxxxxx
> Subject: Re: data download template
>
>
> Walter:
>
> This looks fine.
> I have one question which is can be serious if we are
> downloading daily
> updates from "free" internet sites: If we are away for a
> few days, ae
> there sites where we can access historical data, say 1 day
> to 2 or 3 weeks?
>
> Lionel
> -----Original Message-----
> From: Walter Lake <wlake@xxxxxxxxx>
> To: Metastock bulletin board <metastock@xxxxxxxxxxxxx>
> Date: Tuesday, March 16, 1999 1:08 PM
> Subject: data download template
>
>
> >I've been asked to put this out for comments.
> >
> >Attached is a sample spreadsheet that contains no macros or code or
> >anything. It's just documentation as to what approach we
> would take in
> >making a generalized approach to the "data download situation".
> >
> >Even though it is organized with Futures contracts listed,
> it could just
> as
> >easily be stocks, funds, etc. Please ignore the contract
> symbols and
> "think"
> >of your own symbols.
> >
> >This is just the start of things and the items on the
> layout page will
> >increase as time goes on.
> >
> >I also envision a toolbar totally devoted to this project:
> a buttons to
> fire
> >up the download process; a button to maintain the symbol
> list (and the
> >sheets that will contain the data); a button to fire up a
> >form that will show most of the parametric info on the layout; etc.
> >
> >The "download" worksheet allows easy insertion or deletion
> of stocks,
> funds,
> >contracts, etc. ROWS
> >
> >Each stock, fund or contract will have a separate worksheet, i.e.,
> >"SymbolAAA", SymbolZZZ", etc.
> >
> >The "layout" worksheet lists possible things and actions
> the workbook will
> >do.
> >
> >For those of you with larger universes of tradeables (250)
> pages per
> >workbook, other approaches or workarounds will need to be
> suggested.
> >
> >One "Trading system" workbook is in the works that will be
> designed to
> "call
> >up" the data worksheet from a drop down list rather than endless
> duplication
> >of indicators etc..
> >
> >Please post comments.
> >
> >Best regards
> >
> >Walter
> >
> >
>
|