|
PureBytes Links
Trading Reference Links
|
Hi graham,
Ran an exploration using the formula below,
Buy=O;
Sell=C;
Filter=1;
AddTextColumn("D","<PER>");
AddColumn(19000000+DateNum(),"<DTYYYYMMDD>",1);
AddColumn(Open,"<OPEN> ",1.4);
AddColumn( High,"<HIGH>",1.4);
AddColumn(Low," <LOW>",1.4);
AddColumn(Close,"<CLOSE>",1.4);
AddColumn(Volume,"<VOL>",1);
AddColumn(OI,"<OPENINT> ",1);
and having the same prob,
It creates many double dates down the new date column.
You may need to place
Probably a bug.
If you are using excel you could format the original date in the
Ami exploration e.g. 03/19/1980 to this 19801903.
Insert this formula
=TEXT(A1,"0000-00-00")+0
in column D, and fill down. When finished, Copy column D,
PasteSpecial values to column C, and then format as you wish with
your valid dates.
Peter.
--- In amibroker@xxxxxxxxxxxxxxx, "Graham" <gkavanagh@xxxx> wrote:
> I am having a little problem getting the export right so that I can
convert
> the csv file back into MS database. The MS downloader won't accept
the date
> format that is standard, so I removed the normal first 2 columns
and tried
> alternatives. They seem to come up with funny dates in the
exploration. In
> the example below I have used datenum()+19000000 to get the date
format in
> yyyymmdd. To show the prob I have put back the standard ticker &
date
> columns. Basically I get the same date for 3 consecutive bars.
Datenum() is
> the 3rd column :-) The datenum() result is ok if I do not add the
> 19,000,000.
>
>
>
> BPT 14/03/2003 20030314 30.5 31.0 30.0
30.0
> 30634
>
> BPT 17/03/2003 20030316 30.5 31.0 30.0
31.0
> 124793
>
> BPT 18/03/2003 20030318 30.0 31.0 30.0
30.0
> 16885
>
> BPT 19/03/2003 20030320 31.0 31.0 30.0
30.0
> 21608
>
> BPT 20/03/2003 20030320 30.5 31.0 30.5
31.0
> 81143
>
> BPT 21/03/2003 20030320 31.0 31.5 31.0
31.0
> 154565
>
> Cheers,
> Graham
>
> <http://groups.msn.com/ASXShareTrading>
> http://groups.msn.com/ASXShareTrading
>
> <http://groups.msn.com/FMSAustralia>
http://groups.msn.com/FMSAustralia
>
> -----Original Message-----
> From: Graham [mailto:gkavanagh@x...]
> Sent: Sunday, 23 March 2003 5:32 AM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: RE: [amibroker] exporting to txt file modified data
>
>
>
> Thanks, but just tried the link and after closing, then re-closing
many pop
> up adds, the site ends up being non existent, then I got a request
to make
> another site my home page. Do you have another link for this.?
>
>
>
> Cheers,
> Graham
>
> <http://groups.msn.com/ASXShareTrading>
> http://groups.msn.com/ASXShareTrading
>
> <http://groups.msn.com/FMSAustralia>
http://groups.msn.com/FMSAustralia
>
> -----Original Message-----
> From: Panos Boufardeas [mailto:akaraman@x...]
> Sent: Sunday, 23 March 2003 12:24 AM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: Re: [amibroker] exporting to txt file modified data
>
>
>
> 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 <http://www.ultraeditor.com/> 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@xxxx
>
>
> 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@xxxx
>
>
>
> 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@xxxx
> >Send SUGGESTIONS to suggest@xxxx
> >-----------------------------------------
> >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/
>
>
>
>
> Send BUG REPORTS to bugs@xxxx
> Send SUGGESTIONS to suggest@xxxx
> -----------------------------------------
> 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/
>
>
>
> Send BUG REPORTS to bugs@xxxx
> Send SUGGESTIONS to suggest@xxxx
> -----------------------------------------
> 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
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/M=243066.2784921.4151384.1927555/D=egroupweb/S=17
056321
> 98:HM/A=1377501/R=0/*http:/www.verisign.com/cgi-bin/go.cgi?
a=b30890113200616
> 000>
>
>
>
> <http://us.adserver.yahoo.com/l?
M=243066.2784921.4151384.1927555/D=egroupmai
> l/S=:HM/A=1377501/rand=349560013>
>
>
> Send BUG REPORTS to bugs@xxxx
> Send SUGGESTIONS to suggest@xxxx
> -----------------------------------------
> 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
> <http://docs.yahoo.com/info/terms/> .
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Your own Online Store Selling our Overstock.
http://us.click.yahoo.com/rZll0B/4ftFAA/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/
|