[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










Thanks Jayson, worked like a charm. I did one thing and that was add
V>0 to the filter and saved excel manipulation as there are only about
65,000 lines allowed in excel (100 stocks create about 180,000 lines of data in
the csv file J<span
> )

 



<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: Jayson
[mailto:jcasavant@xxxxxxxxxxxx] 
Sent: Saturday, 22 March 2003 1:16
PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] exporting
to txt file modified data

<font size=2
face="Times New Roman"> 



<font size=2 color=blue
face=Arial>Graham,





<font size=2
face="Times New Roman"> 





<font size=2 color=blue
face=Arial>how
about exploring the whole database, exporting it to Excel. sort on volume, make
your deletions or adjustments then bring it back into AB as a new database?





<font size=2
face="Times New Roman"> 





<font size=2 color=blue
face=Arial>I have
not tried it, have no knowledge if it would work but seems like a
possibility...





<font size=2
face="Times New Roman"> 



<font size=2 color=blue
face=Arial>Jayson


-----Original Message-----
From: Graham
[mailto:gkavanagh@xxxxxxxxxxxxx]
Sent: Friday, March 21, 2003 11:46
PM
To: AB yahoo group
Subject: [amibroker] exporting to
txt file modified data

<font size=2
face="Courier New">I use the export dll supplied
on the Amibroker library to back up and make<font
face="Courier New">
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<font
face="Courier New">
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.





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.