|
PureBytes Links
Trading Reference Links
|
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 <span
>J<span
> The datenum() result is ok if I do not add the
19,000,000.
BPT 14/03/2003<font
size=3> 20030314 30.5 31.0 30.0 30.0 30634
BPT 17/03/2003<font
size=3> 20030316 30.5 31.0 30.0 31.0 124793
BPT 18/03/2003<font
size=3> 20030318 30.0 31.0 30.0 30.0 16885
BPT 19/03/2003<font
size=3> 20030320 31.0 31.0 30.0 30.0 21608
BPT 20/03/2003<font
size=3> 20030320 30.5 31.0 30.5 31.0 81143
BPT 21/03/2003<font
size=3> 20030320 31.0 31.5 31.0 31.0 154565
<font size=3 color=teal
face="Times New Roman">Cheers,
Graham
<font size=2
color="#339966" face="Times New Roman"><font size=1
color="#339966">http://groups.msn.com/ASXShareTrading
<font size=2
color="#339966" face="Times New Roman"><font size=1
color="#339966">http://groups.msn.com/FMSAustralia
<span
>-----Original Message-----
From: <font
face=Tahoma>Graham<font
face=Tahoma> [mailto:<font
face=Tahoma>gkavanagh@xxxxxxxxxxxxx<font
face=Tahoma>]
Sent: Sunday, 23 March 2003 5:32
AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] exporting
to txt file modified data
<font size=2
face="Times New Roman">
<font size=3
face="Times New Roman">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.?
<font size=3
face="Times New Roman">
<font
size=3 color=teal face="Times New Roman">Cheers,
Graham
<font
size=2 color="#339966" face="Times New Roman"><font size=1
color="#339966">http://groups.msn.com/ASXShareTrading
<font
size=2 color="#339966" face="Times New Roman"><font size=1
color="#339966">http://groups.msn.com/FMSAustralia
<span
>-----Original Message-----
From: Panos Boufardeas
[mailto:akaraman@xxxxxxx]
Sent: Sunday, 23 March 2003 12:24
AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] exporting
to txt file modified data
<font size=2
face="Times New Roman">
Frst export your data
// Exporting more than one stock to CSV or txt
Filter<span
> =1; /* all
stocks and quotes accepted */
AddColumn(<span
>Open,<span
>"Open ", <span
>1.2);
AddColumn(<span
>High,<span
>"High ", <span
>1.2);
AddColumn(<span
>Low,<span
>"Low ", <font
color=fuchsia>1.2);
AddColumn(<span
>Close,<span
>"Close", <span
>1.2);
AddColumn(<span
>Volume,<span
>"Volume", <span
>1.0);
Then
I
use <font
face="Arial Greek">www.ultraeditor.com<font
face="Arial Greek"> 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:
<font size=2
face="Times New Roman">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:
><a href=""
eudora=autourl>http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>
>Your use of Yahoo! Groups is subject to <a
href="" eudora=autourl>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.
<a href=""
eudora=autourl>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: <a
href=""
eudora=autourl>http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to <a
href="" eudora=autourl>http://docs.yahoo.com/info/terms/
<font size=2
face="Courier New">Send BUG REPORTS to
bugs@xxxxxxxxxxxxx<span
>
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to:
amiquote@xxxxxxxxxxxxxxx
(Web page: <a
href="">http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: <a
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <a
href="">Yahoo! Terms of Service.
<font size=2
face="Times New Roman">
Send
BUG REPORTS to bugs@xxxxxxxxxxxxx<span
>
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to:
amiquote@xxxxxxxxxxxxxxx
(Web page: <a
href="">http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: <a
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <a
href="">Yahoo! Terms of Service.
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.
|