|
PureBytes Links
Trading Reference Links
|
Dan
<FONT face=Arial color=#0000ff
size=2>
The
software works for any number of tickers and it is just as fast as
Reuters.
<FONT face=Arial color=#0000ff
size=2>Bob
<FONT face=Tahoma
size=2>-----Original Message-----From:
owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]On
Behalf Of DanSent: Monday, September 03, 2001 5:52
PMTo: metastock@xxxxxxxxxxxxxSubject: Re: Yahoo Quotes
Import to Metastock, how?Bob,
How would it act on a larger no of symbols, like 1000 or more?
Dan
Robert Badgley wrote:
<FONT
size=-1>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.<FONT
face=Arial>Bob
<FONT
size=-1>-----Original Message----- <FONT
face=Tahoma>From: owner-metastock@xxxxxxxxxxxxx [<A
href="mailto:owner-metastock@xxxxxxxxxxxxx";>mailto:owner-metastock@xxxxxxxxxxxxx]On
Behalf Of Lionel Issen <FONT
size=-1>Sent: Monday, September 03, 2001 8:35 AM
To:
metastock@xxxxxxxxxxxxx <FONT
size=-1>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
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
<A title=wd78@xxxxxxxxxxxx
href="mailto:wd78@xxxxxxxxxxxx";>wavemechanic
To: <A
title=metastock@xxxxxxxxxxxxx
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx
Sent: Monday, September 03, 2001
7:14 AM
Subject: Re: Yahoo Quotes Import to
Metastock, how? Also easier and
faster.
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
<A title=rbad832654@xxxxxxxxxxxxx
href="mailto:rbad832654@xxxxxxxxxxxxx";>Robert Badgley
To: <A
title=metastock@xxxxxxxxxxxxx
href="mailto:metastock@xxxxxxxxxxxxx";>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
<A
href="http://www.traders-soft.com/dc/HowToBuy.htm";>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: <A
href="mailto:owner-metastock@xxxxxxxxxxxxx";>owner-metastock@xxxxxxxxxxxxx
[<A
href="mailto:owner-metastock@xxxxxxxxxxxxx";>mailto:owner-metastock@xxxxxxxxxxxxx]On
Behalf Of Yarroll Sent: Sunday, September 02, 2001 3:12 PM
To: <A
href="mailto:metastock@xxxxxxxxxxxxxxxxxx";>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
|