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

[amibroker] How to pad quotes in Explore with blanks not zeros ?



PureBytes Links

Trading Reference Links

Hello,

In a AFL formula I wrote something like that :

AddColumn( DateTime(), "Date", formatDateTime );
AddColumn(Open,"Open",1.6);
AddColumn(High,"High",1.6);
AddColumn(Low,"Low",1.6);
AddColumn(Close,"Close",1.6);
AddColumn(Volume,"Volume",1.0);

With a Explore, than a File / Export, I have some datas like that :

01/02/2007 02:04:00,1.965200,1.965200,1.965150,1.965200,-5
01/02/2007 02:09:00,1.965200,1.965200,1.965050,1.965050,-5
01/02/2007 02:14:00,1.965050,1.965200,1.965050,1.965100,-5
01/02/2007 02:19:00,1.965100,1.965250,1.964950,1.965100,-5
01/02/2007 02:24:00,1.965100,1.965200,1.964900,1.965200,-5
01/02/2007 02:29:00,1.965200,1.965200,1.964650,1.964750,-5

What I am looking for is something like that :
01/02/2007 01:05:00,1.9652,1.9652,1.96515,1.9652,-5
01/02/2007 01:10:00,1.9652,1.9652,1.96505,1.96505,-5
01/02/2007 01:15:00,1.96505,1.9652,1.96505,1.9651,-5
01/02/2007 01:20:00,1.9651,1.96525,1.96495,1.9651,-5
01/02/2007 01:25:00,1.9651,1.9652,1.9649,1.9652,-5
01/02/2007 01:30:00,1.9652,1.9652,1.96465,1.96475,-5
01/02/2007 01:35:00,1.96475,1.9648,1.9645,1.96455,-5

Quotes paded with blanks not zeros.

How to pad with blanks not zeros ?

Thanks,

Pierre8r


------------------------------------

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/