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

Re: [amibroker] exporting to txt file modified data



PureBytes Links

Trading Reference Links

Frst export your data // Exporting more than one stock to CSV or txt Filter =1; /* all stocks and quotes accepted */ AddColumn(Open,"Open ", 1.2); AddColumn(High,"High ", 1.2); AddColumn(Low,"Low  ", 1.2); AddColumn(Close,"Close", 1.2); AddColumn(Volume,"Volume", 1.0); Then I use www.ultraeditor.com programm A 32mb ascii file take less than one minute on AMD 1200hz i dont know if you are looking for something like that but This macro find comma “,” end zero’s at the end of the line And delete this line ---------macro start------------ InsertMode ColumnModeOff HexOff UnixReOff Top Loop Find MatchCase RegExp ",0+" IfFound Find MatchCase RegExp ",0+" DeleteLine Top Else ExitLoop EndIf EndLoop Top -----------end of macro   Thanks Panos  Boufardeas akaraman@xxxxxxx At 05:10 ìì 22/3/2003 +0200, you wrote: hi can you send me a sample of your ASCII file  i think i can help you   Thanks Panos  Boufardeas akaraman@xxxxxxx At 12:45 ìì 22/3/2003 +0800, you wrote: >I use the export dll supplied on the Amibroker library to back up and make >some modifications to my databases. Thanks to who supplied it, absolutely >fantastic. >I have used this before to round off the data supplied in the far past. This >works ok when you just need to make changes to the OHLCV data directly, but >I want to remove all zero volume days from the database without it taking a >month of Sundays to complete. >I have tried adding filters and additional buy condition to the line >Buy=bhExportAsMetaStock("c:\\MSBackup"); > >Such as: > >Buy=bhExportAsMetaStock("c:\\MSBackup") AND V>0; > >But it still exports the whole data without change. > >Can anyone help me with a method of doing this >TIA > >Cheers, >Graham >http://groups.msn.com/ASXShareTrading >http://groups.msn.com/FMSAustralia > > > > >Send BUG REPORTS to bugs@xxxxxxxxxxxxx >Send SUGGESTIONS to suggest@xxxxxxxxxxxxx >----------------------------------------- >Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx >(Web page: http://groups.yahoo.com/group/amiquote/messages/) >-------------------------------------------- >Check group FAQ at: >http://groups.yahoo.com/group/amibroker/files/groupfaq.html > >Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ ------------------------ Yahoo! Groups Sponsor ---------------------~--> New Yahoo! Mail Plus. More flexibility. More control. More power. Get POP access, more storage, more filters, and more. http://us.click.yahoo.com/Hcb0iA/P.iFAA/46VHAA/GHeqlB/TM ---------------------------------------------------------------------~-> Send BUG REPORTS to bugs@xxxxxxxxxxxxx Send SUGGESTIONS to suggest@xxxxxxxxxxxxx ----------------------------------------- Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: http://groups.yahoo.com/group/amiquote/messages/) -------------------------------------------- Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ Yahoo! Groups Sponsor ADVERTISEMENT Send BUG REPORTS to bugs@xxxxxxxxxxxxx Send SUGGESTIONS to suggest@xxxxxxxxxxxxx ----------------------------------------- Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: http://groups.yahoo.com/group/amiquote/messages/) -------------------------------------------- Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.