• Registered: 2008-10-09
  • Posts: 1

Topic: Need help with AWK convertor.

First off I want tosay you have developed a fantastic tool. Excellent work. I'm trying to import 1 minute EURUSD data. Here is what the data looks like after I used Awk Convertor.

2008-10-02;01:20;1.3966;1.3964;1.3962;1.397;133
2008-10-02;01:21;1.3964;1.396;1.3956;1.3967;204
2008-10-02;01:22;1.3961;1.3959;1.3953;1.3963;164
2008-10-02;01:23;1.3957;1.3961;1.3954;1.3967;261
2008-10-02;01:24;1.396;1.3955;1.3953;1.3963;196

FSB says it can't read the pricing information.

How do I fix this?

Thanks, Mike

  • Popov
  • Popov
  • Lead Developer
  • Offline
  • From: Bulgaria
  • Registered: 2006-11-30
  • Posts: 8,024

Re: Need help with AWK convertor.

Hi Mike,
This converter is actually an AWK script. You have to adopt the script according to your data file. There are some help files about it.
Post a part of your initial data. I'll try to make a script for you.

By the way it seams the last data column is Price High. I can assume that your order is Open Close Low High. FSB cannot be sure of the exact order of the columns and give error.

Try to arrange columns like this:
Date Hour OpenPrice HighPrice LowPrice ClosePrice Volume

Regards

Popov's Website