|
PureBytes Links
Trading Reference Links
|
Bob,
How would it act on a larger no of symbols, like 1000 or more?
Dan
Robert Badgley wrote:
one
time charge for the software and every time he improves it you get a free
update (unlike Metastock) it works pretty good if you dont have to download
all the stocks in the world I just use it to download about 400 stocks
a day. you can get all the history you want as long as Yahoo has it.Bob
-----Original
Message-----
From: owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Lionel Issen
Sent: Monday, September 03,
2001 8:35 AM
To: metastock@xxxxxxxxxxxxx
Subject: Re: Yahoo Quotes
Import to Metastock, how?
Is this a one shot fee of $54.00 or a
monthly fee? Lionel Issen
lissen@xxxxxxxxxxxxxx
----- Original Message -----
From:
wavemechanic
To: metastock@xxxxxxxxxxxxx
Sent: Monday, September 03, 2001 7:14
AM
Subject: Re: Yahoo Quotes Import to
Metastock, how?
Also easier and faster.
----- Original Message -----
From:
Robert
Badgley
To: metastock@xxxxxxxxxxxxx
Sent: Monday, September 03, 2001 4:16
AM
Subject: RE: Yahoo Quotes Import to
Metastock, how?
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:
,,,,,,,
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:
,,,,,,,
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
|