|
PureBytes Links
Trading Reference Links
|
Graham,
As Tradestation and Metastock, AMiBroker uses 32 bit IEEE
floating point representation
for data arrays. 32 bit single precision IEEE floating
point is limited to 7 significant digits accuracy.
20030314
is EIGHT digits therefore the last one (least significant)
eighth digit can not be represented <FONT
size=2>accurately.
This is the reason why DateNum returns YYYMMDD and not
YYYYMMDD
Solution for your export problem:
Go to Windows Control panel - Regional settings and change the
date format to one accepted by Metastock
and then re-run exploration
Best regards,Tomasz Janeczkoamibroker.com
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
<A title=gkavanagh@xxxxxxxxxxxxx
href="">Graham
To: <A title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Saturday, March 22, 2003 10:59
PM
Subject: RE: [amibroker] exporting to txt
file modified data
<SPAN
>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 <FONT face=Wingdings
size=3><SPAN
>J<FONT
size=3> The datenum() result is ok if I do not
add the 19,000,000.
<SPAN
>
<SPAN
>BPT <FONT
size=3>14/03/2003<FONT
size=3>
20030314
30.5 31.0
30.0 30.0 30634
<SPAN
>BPT <FONT
size=3>17/03/2003<FONT
size=3>
20030316
30.5 31.0
30.0 31.0
124793
<SPAN
>BPT <FONT
size=3>18/03/2003<FONT
size=3>
20030318
30.0 31.0
30.0 30.0 16885
<SPAN
>BPT <FONT
size=3>19/03/2003<FONT
size=3>
20030320
31.0 31.0
30.0 30.0 21608
<SPAN
>BPT <FONT
size=3>20/03/2003<FONT
size=3>
20030320
30.5 31.0
30.5 31.0 81143
<SPAN
>BPT <FONT
size=3>21/03/2003<FONT
size=3>
20030320
31.0 31.5
31.0 31.0
154565
<FONT face="Times New Roman" color=teal
size=3><SPAN
>Cheers,Graham
<FONT
face="Times New Roman" color=#339966 size=2><SPAN
><A
href=""><SPAN
>http://groups.msn.com/ASXShareTrading
<FONT
face="Times New Roman" color=#339966 size=2><SPAN
><A
href=""><SPAN
>http://groups.msn.com/FMSAustralia
<SPAN
>-----Original
Message-----From:
<SPAN
>Graham<SPAN
> [mailto:<SPAN
>gkavanagh@xxxxxxxxxxxxx<FONT
face=Tahoma>] <SPAN
>Sent: Sunday, 23 March 2003 5:32
AMTo:
amibroker@xxxxxxxxxxxxxxx<SPAN
>Subject: RE: [amibroker] exporting to txt
file modified data
<FONT face="Times New Roman"
size=2>
<FONT face="Times New Roman"
size=3>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 face="Times New Roman"
size=3>
<P
><FONT
face="Times New Roman" color=teal size=3><SPAN
>Cheers,Graham
<FONT
face="Times New Roman" color=#339966 size=2><SPAN
><A
href=""><SPAN
>http://groups.msn.com/ASXShareTrading
<FONT
face="Times New Roman" color=#339966 size=2><SPAN
><A
href=""><SPAN
>http://groups.msn.com/FMSAustralia
<SPAN
>-----Original
Message-----From: Panos
Boufardeas [mailto:akaraman@xxxxxxx] <SPAN
>Sent: Sunday, 23 March 2003 12:24
AMTo:
amibroker@xxxxxxxxxxxxxxx<SPAN
>Subject: Re: [amibroker] exporting to txt
file modified data
<FONT face="Times New Roman"
size=2>
<P class=MsoNormal
><FONT
face="Arial Greek" size=2><SPAN
>Frst export your data
<SPAN
>// Exporting more than one
stock to CSV or txt<SPAN
>Filter<FONT
face="Courier New"> =<FONT
color=fuchsia>1; <FONT
color=green>/* all stocks and quotes accepted
*/<SPAN
>AddColumn(<SPAN
>Open,<SPAN
>"Open ", <SPAN
>1.2);<SPAN
>AddColumn(<SPAN
>High,<SPAN
>"High ", <SPAN
>1.2);<SPAN
>AddColumn(<SPAN
>Low,<SPAN
>"Low ", <SPAN
>1.2);<SPAN
>AddColumn(<SPAN
>Close,<SPAN
>"Close", <SPAN
>1.2);<SPAN
>AddColumn(<SPAN
>Volume,<SPAN
>"Volume", <SPAN
>1.0);Then <FONT
face="Arial Greek">I use
<FONT
face="Arial Greek"><SPAN
>www.ultraeditor.com<FONT
face="Arial Greek"> programmA
32mb ascii file take less than one minute on AMD 1200hz<SPAN
>i dont know if you are looking for something like
that butThis macro find comma “,” end zero’s at the end of the
line And delete this line---------macro
start------------InsertModeColumnModeOffHexOffUnixReOffTopLoop
Find MatchCase RegExp ",0+"IfFoundFind MatchCase RegExp
",0+"DeleteLineTopElseExitLoopEndIfEndLoopTop-----------end
of macro ThanksPanos
Boufardeasakaraman@xxxxxxxAt 05:10 ìì 22/3/2003 +0200, you
wrote:
<FONT face="Times New Roman"
size=2>hican you send me a sample of your
ASCII file i think i can help you ThanksPanos
Boufardeasakaraman@xxxxxxxAt 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><A
href=""
eudora="autourl">http://groups.msn.com/ASXShareTrading><A
href=""
eudora="autourl">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@xxxxxxxxxxxxxSend 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/
<P class=MsoNormal
><FONT
face="Times New Roman" size=2><SPAN
>
<FONT face="Courier New"
size=2>Send BUG REPORTS to
bugs@xxxxxxxxxxxxx<SPAN
>Send
SUGGESTIONS to suggest@xxxxxxxxxxxxx<FONT
face="Courier New">-----------------------------------------<FONT
face="Courier New">Post AmiQuote-related messages ONLY to:
amiquote@xxxxxxxxxxxxxxx (Web
page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)<FONT
face="Courier New">--------------------------------------------<FONT
face="Courier New">Check group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to
the Yahoo! Terms of
Service.
<FONT face="Times New Roman"
size=2><SPAN
><FONT
face="Courier New">Send BUG REPORTS to bugs@xxxxxxxxxxxxx<FONT
face="Courier New"><FONT
face="Courier New">Send SUGGESTIONS to
suggest@xxxxxxxxxxxxx<FONT
face="Courier New">-----------------------------------------<FONT
face="Courier New">Post AmiQuote-related messages ONLY to:
amiquote@xxxxxxxxxxxxxxx (Web
page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)<FONT
face="Courier New">--------------------------------------------<FONT
face="Courier New">Check group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to
the Yahoo! Terms of
Service.
Send
BUG REPORTS to bugs@xxxxxxxxxxxxxSend 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.
|