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

Notification

Icon
Error

Options
Go to last post Go to first unread
crunchor  
#1 Posted : Friday, November 25, 2011 10:21:44 PM(UTC)
crunchor

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 11/26/2011(UTC)
Posts: 1

I have data in these format: 20111125 091301; 17602; 17602; 17602; 17602; 511 20111125 091401; 17603; 17637; 17600; 17637; 28 20111125 091500; 17635; 17640; 17585; 17591; 659 How do I convert this with metastock pro v11? I have tried many times in different ways but no success so far.
haddison  
#2 Posted : Saturday, November 26, 2011 3:45:09 PM(UTC)
haddison

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London

1. Replace the space and semi-colon with a comma.
2. Add a header.

It should be something like this:

<date>,<time>,<open>,<high>,<low>,<close>,<volume>
20111125,091301,17602,17602,17602,17602,511
20111125,091401,17603,17637,17600,17637,28
20111125,091500,17635,17640,17585,17591,659

It will ask you for a ticker symbol. If you don't want it to ask you, you have to include it like this:

<ticker>,<date>,<time>,<open>,<high>,<low>,<close>,<volume>
MYTICKER,20111125,091301,17602,17602,17602,17602,511
MYTICKER,20111125,091401,17603,17637,17600,17637,28
MYTICKER,20111125,091500,17635,17640,17585,17591,659

If you want more information, see the help file in the Downloader.
mstt  
#3 Posted : Saturday, November 26, 2011 4:21:44 PM(UTC)
mstt

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042

Was thanked: 57 time(s) in 54 post(s)

For whatever reason the date format has to be in US format for me, so I would change the date field (using Excel) to 11/20/2011 or 11/20/11. 20/11/2011 would cause an error but without pointing to a specific cause.

Roy
Users browsing this topic
Guest (Hidden)
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.