logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
annonymous  
#1 Posted : Sunday, November 21, 2010 4:43:44 AM(UTC)
annonymous

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/5/2009(UTC)
Posts: 18

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
annonymous  
#2 Posted : Sunday, November 21, 2010 7:31:06 AM(UTC)
annonymous

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/5/2009(UTC)
Posts: 18

Does someone have a sample intraday .xls that is convertible to Metastock with The Downloader ? I would need one to compare it with my file to see if the problem is with the format of my file. Or if someone wants to try my file in their Metastock to see if they get the same result...
MS Support  
#3 Posted : Monday, November 22, 2010 3:02:22 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,929

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
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
annonymous  
#4 Posted : Wednesday, November 24, 2010 11:44:27 AM(UTC)
annonymous

Rank: Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/5/2009(UTC)
Posts: 18

It works perfectly. Thank you very much.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.