Re: Yahoo Quotes Import to Metastock, how?

["Henry Amand" <back@xxxxxxxxxxx>]

One time.

> Is this a one shot fee of $54.00 or a monthly fee?


>>  Also easier and faster.


    For  $54.00 US from this site
    http://www.traders-soft.com/dc/HowToBuy.htm
    you can down load free data from Yahoo directly by the Meta Stock
downloader
    that is a lot cheaper than bying MS Excel.

    Bob


    -----Original Message-----
    From: owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]On
    Behalf Of Yarroll
    Sent: Sunday, September 02, 2001 3:12 PM
    To: metastock@xxxxxxxxxxxxxxxxxx
    Subject: Re: Yahoo Quotes Import to Metastock, how?


    Bodo,

    It's actually quite easy to do and you don't need any third-party
software
    (Excel is enough).

    Once you get the quotes from Yahoo in Excel .xls format see that the
columns
    are arranged as follows:

    <TICKER>,<PER>,<DTYYMMDD>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOLUME>

    For example:

    MSFT,D,20010831,50,55,45,50,100000

    where columns are separated by a comma.
    If necessary, arrange your columns to fit this pattern (Im not sure, but
I
    think I saw some data from Yahoo where you had Close before the
Open,High
    etc.) Also, Yahoo spreadsheets wouldnt have "Ticker","Per" columns (just
    insert 2 columns, fill the first row, and copy down). Also possibly, the
    date format would have to be changed to fit the pattern.

    Next, save the Excel spreadsheet as a .csv format. I'm not sure how's
that
    in Germany, but some European countries use semicolon {;} rather than a
    comma {,} in csv format; if that's your case, change the file extension
from
    .csv to .doc {WordPad document} , open it up and replace all semicolons
with
    commas (Edit->Replace). Save the file.

    Finally, change the file extension again from .csv {or .doc} into .txt
and
    you're ready to import it using Downloader as a usual simple text file.
Your
    file should have the structure shown below, and make sure that you
include
    the file "headers"  in the first line:

    <TICKER>,<PER>,<DTYYMMDD>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOLUME>
    MSFT,D,20010831,50,55,45,50,100000
    etc.

    This sounds complicated but believe me, if you do it once or twice and
then
    settle to do it every day, the routine takes in. Personally I've hunted
down
    and converted so many weird data formats into Metastock that I just
can't
    dream of something else than a complicated data conversion problem ;-))

    All the best,
    Yarroll