----- Original Message -----
Sent: Friday, October 22, 2004
9:05 AM
Subject: Re: [Metastockusers]
importing Data from Excel into Metastock
I used to get into a tangle when
trying this in the initial stages. As the Help says -
To convert from Excel file to
Metastock you need to do the following-
- The data must be in columns.
- Each column must have a heading that
describes what data is in the column. The only required columns
are DATE and CLOSE.
Optional columns are TICKER, PER, OPEN, HIGH, LOW, VOLUME,
and O/I. The column
names must be spelled as shown here. The column headings must
all be on the same row.
- The dates must be in the mm/dd/yy
style and must be formatted as text labels
to add to the above
1)
My source Excel files have the following
TICKER |
DATE |
OPEN |
HIGH |
LOW |
CLOSE |
VOLUME |
O/I |
2)
Make sure the DATE is in TEXT
format.
3)
The TICKER cell is also in TEXT format in my source
file.
4)
Different
TICKER or SYMBOL needs to be a separate Excel source
file
5)
The TICKER or SYMBOL should match your
destination file
6)
My set of Excel files are in one folder and the
destination or Metastock files are in another
folder
7)
In the downloader choose TOOLs choose
CONVERT
8)
In source file type choose EXCEL, specify the folder, Click on Browse.
9)
Highlight the source files then click
OPEN.
10) Now go to
the Destination section choose Metastock, then indicate the folder.
Click BROWSE . all the files in the folder will be shown, click
SAVE.
11) You come
back to the CONVERT screen. Go to the OPTIONS and make the appropriate
entries.(You could increase the max error msgs to 10,000 since the
data conversion stops when the Max amount is reached the data
after conversion seems fine in spite of error msgs ! ) Click the OK
button for the conversion to take place.
I download my EOD as a Excel file.
Using a macro each symbol is saved in a different Excel file, I
update the MS data through the above process.
Hope this helps !
PS - the source file is used for charting by MS
Guss <nasdaq@xxxxxxxxx>
wrote:
Dear all,
I have some Data in excel format (open,high, Low,close)
columns, that I would like to import into Metastock as a
chart.
Is that possible? if yes, how can
I do that
Thanks in advance
Regards,
Guss
__________________________________________________
Do You
Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection
around
http://mail.yahoo.com