|
PureBytes Links
Trading Reference Links
|
<SPAN
class=934315305-22032003>Graham,
You
will have to talk to Bill (Gates) about upping the max allowable lines in excel.
I think his personal email address is listed in the "About" section of
excel <SPAN
>J<FONT
size=3>
Jayson
<FONT face=Tahoma
size=2>-----Original Message-----From: Graham
[mailto:gkavanagh@xxxxxxxxxxxxx]Sent: Saturday, March 22, 2003 12:38
AMTo: amibroker@xxxxxxxxxxxxxxxSubject: RE: [amibroker]
exporting to txt file modified data
<SPAN
>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 <SPAN
>J<FONT
size=3> )
<SPAN
>
<FONT color=teal face="Times New Roman"
size=3><SPAN
>Cheers,<FONT
color=teal size=3><SPAN
>Graham
<FONT
color=#339966 face="Times New Roman" size=2><SPAN
><A
href=""><SPAN
>http://groups.msn.com/ASXShareTrading
<FONT
color=#339966 face="Times New Roman" size=2><SPAN
><A
href=""><SPAN
>http://groups.msn.com/FMSAustralia
<SPAN
>-----Original
Message-----From: Jayson
[mailto:jcasavant@xxxxxxxxxxxx] <SPAN
>Sent: Saturday, 22 March 2003 1:16
PMTo:
amibroker@xxxxxxxxxxxxxxx<SPAN
>Subject: RE: [amibroker] exporting to txt
file modified data
<FONT face="Times New Roman"
size=2>
<FONT color=blue face=Arial
size=2><SPAN
>Graham,
<FONT face="Times New Roman"
size=2>
<FONT color=blue face=Arial
size=2>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 face="Times New Roman"
size=2>
<FONT color=blue face=Arial
size=2>I have not
tried it, have no knowledge if it would work but seems like a
possibility...
<FONT face="Times New Roman"
size=2>
<FONT color=blue face=Arial
size=2><SPAN
>Jayson
<P class=MsoNormal
><FONT
face=Tahoma size=2><SPAN
>-----Original
Message-----From: Graham
[mailto:gkavanagh@xxxxxxxxxxxxx]<SPAN
>Sent: Friday, March 21, 2003 11:46
PMTo: AB yahoo
groupSubject: [amibroker]
exporting to txt file modified data
<FONT face="Courier New"
size=2>I use the export dll supplied on the
Amibroker library to back up and make<FONT
face="Courier New"><FONT
face="Courier New">some modifications to my databases. Thanks to who supplied
it, absolutely<FONT
face="Courier New">fantastic.I have
used this before to round off the data supplied in the far past.
Thisworks ok when you just need to
make changes to the OHLCV data directly, but<FONT
face="Courier New">I want to remove all zero volume days from the database
without it taking amonth of Sundays
to complete.I have tried adding
filters and additional buy condition to the line <FONT
face="Courier New">Buy=bhExportAsMetaStock("c:\\MSBackup");<FONT
face="Courier New">Such as:<FONT
face="Courier New">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<FONT
face="Courier New">TIA<FONT
face="Courier New">Cheers,<FONT
face="Courier New">Graham<A
href="">http://groups.msn.com/ASXShareTrading<FONT
face="Courier New"><A
href="">http://groups.msn.com/FMSAustralia<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. <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.
|