Hello,

I have downloaded some intraday 1-min quotes and used The Downloader from Equis to convert the file to Metastock format. The file I used as input is an xls and looks like this:


Date Time Open High Low Close Volume
11/08/2010 09:30:00 624.02 624.02 624 624.01 21758
11/08/2010 09:31:00 624.01 624.85 623.13 624.32 9130
11/08/2010 09:32:00 624.51 624.86 624.3 624.86 7835
11/08/2010 09:33:00 624.89 625 624.7 624.73 6413
...
11/08/2010 16:00:00 626.1799 627.16 626.16 627.16 100910
11/08/2010 16:01:00 627.16 627.16 626.6 626.77 44676
11/09/2010 09:30:00 630 630 630 630 52278
...

and goes on like this until 11/19/2010.

As you can see, I have one line for every minute. When using The Downloader to convert it, for 'minutes per bar' I entered 1. The Downloader says convertion went ok and no error appeared and it says it created a file with the same number of lines as my input file.

When opening the file in Metastock to view the chart, it sees the file, it correctly sees that the periodicity is 1 minute, but when I open the file, Metastock prints a chart that has only 1 bar per day, and the displayed bar represents the last minute of each trading day.

Any hint as to what I might be doing wrong is highly appreciated.

Thank you,
Mihaela

I strongly do not recommend converting from excel to metastock format. the download expects to see a version 4 excel worksheet. I find the conversion is usually much easier to save the data from excel into a .CSV formated file and then tell the downloader the source file is ASCII

The downloader's help file has several examples of how the CSV / ASCII file should be formated