|
PureBytes Links
Trading Reference Links
|
|
THANKS FOR THE INSTRUCTIONS
CHECK THE FIRST DATE AGAIN
TOOLS ADJUST FIRST DATE
I HOPE IT MAY HELP
ANIL
----- Original Message -----
Sent: 05 November, 2004 11:59 PM
Subject: [EquisMetaStock Group] EXCEL
CONVERT/METASTOCK CHART DISPLAY PROBLEM
I wish to display a high, low, close,
volume stock price chart using
Excel data. When I convert an
Excel file to a Metastock stock chart
not all of the chart is displayed.
The portion of the chart
corresponding to several months data is
missing. I would appreciate
assistance in identifying the
problem. The details of what I am
doing is as follows:
I
have an Excel file with the following column headings: DATE,
HIGH,LOW, CLOSE, VOLUME
The file contains dates ranging from
2/4/1966 to 12/16/1968. The
file was saved using Microsoft Excel
in the format 97-2000 & 5.0
Workbook *.xls.
To convert the
data to a Metastock chart I used Metastock
Professional 9.0. Using
the downloader I went to tools, convert and
entered File type
Excel. Under options/Source I put the First date
as 2/4/1966 and
the Last date as 12/16/1968. The periodicity was set
at
Daily. In the Destination tab I ticked "Replace existing file"
and "Create new files". Upon completion I got the message that the
Data was Converted and Stored. All 697 entries were added and none
were discarded.
However, when I opened the converted file with
Metastock the chart
was displayed from the date 11/15/1966 to 12/16/1968
instead of from
2/4/1966 to 12/16/1968.
It appears as
though the program will only display a certain maximum
number of
entries. Could somebody please let me know what I am doing
wrong.
Gilbert
| Yahoo! Groups Sponsor |
ADVERTISEMENT
![click here]() | |
![]() |
Yahoo! Groups Links
|
|