|
PureBytes Links
Trading Reference Links
|
1 shot
<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:
Lionel
Issen
To: <A title=metastock@xxxxxxxxxxxxx
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx
Sent: Monday, September 03, 2001 11:35
AM
Subject: Re: Yahoo Quotes Import to
Metastock, how?
Is this a one shot fee of $54.00 or a monthly
fee?
Lionel Issen<A
href="mailto:lissen@xxxxxxxxxxxxxx";>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:
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.htmyou
can down load free data from Yahoo directly by the Meta Stock
downloaderthat is a lot cheaper than bying MS
Excel.Bob-----Original Message-----From: <A
href="mailto:owner-metastock@xxxxxxxxxxxxx";>owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]OnBehalf Of YarrollSent:
Sunday, September 02, 2001 3:12 PMTo: <A
href="mailto:metastock@xxxxxxxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxxxxxxxSubject:
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 columnsare arranged as
follows:<TICKER>,<PER>,<DTYYMMDD>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOLUME>For
example:MSFT,D,20010831,50,55,45,50,100000where columns
are separated by a comma.If necessary, arrange your columns to fit
this pattern (Im not sure, but Ithink I saw some data from Yahoo where
you had Close before the Open,Highetc.) Also, Yahoo spreadsheets
wouldnt have "Ticker","Per" columns (justinsert 2 columns, fill the
first row, and copy down). Also possibly, thedate 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 thatin Germany, but some European
countries use semicolon {;} rather than acomma {,} 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 withcommas
(Edit->Replace). Save the file.Finally, change the file
extension again from .csv {or .doc} into .txt andyou're ready to
import it using Downloader as a usual simple text file. Yourfile
should have the structure shown below, and make sure that you
includethe file "headers" in the first
line:<TICKER>,<PER>,<DTYYMMDD>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOLUME>MSFT,D,20010831,50,55,45,50,100000etc.This
sounds complicated but believe me, if you do it once or twice and
thensettle to do it every day, the routine takes in. Personally I've
hunted downand converted so many weird data formats into Metastock
that I just can'tdream of something else than a complicated data
conversion problem ;-))All the
best,Yarroll
|