[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [EquisMetaStock Group] EXCEL CONVERT/METASTOCK CHART DISPLAY PROBLEM



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 -----
From: g_dares
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