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

Re: data download template



PureBytes Links

Trading Reference Links

Dale:

Just for your information.  A few years ago, when I subscribed to Prodigy,
there were only a few expensive data suppliers.  There was an outfit in
Dallas TX that provided a relatively inexpensive program that would
download selected EOD stock quotes and put them into the metastock files.
The fellow who wrote the program also converted the advances and declines,
which were in a graphic format, to metastock format and put this into the
desired files.  I think that the name of one of their programs was megatech
or megastock or somesuch.

Thanks for the posting it is much appreciated

Lionel
-----Original Message-----
From: Dale Wingo <dingo@xxxxxxxxxxxx>
To: metastock@xxxxxxxxxxxxx <metastock@xxxxxxxxxxxxx>
Date: Wednesday, March 17, 1999 8:02 AM
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:
>
>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
>> >
>> >
>>
>
>