|
PureBytes Links
Trading Reference Links
|
If you
have access (negative pun intended) to a decent SQL database, you can export
really big stuff from AB, import it, and query on it any way you like from
there. It's faster and more flexible than sorting huge lists directly in AB, and
if need be you can query across multiple exports at once.
<SPAN
class=885414503-30122003>
I
recently did a project this in Microsoft SQL Server. Not 1000 columns, but more
than Excel could handle, and it did fine. MS SQL I think is limited to 1024
per table or view, but up to there you should be ok. Be aware that the DTS
import wizard can't handle more than 255 columns, so you need to use the SQL
BULK INSERT command to import the data. I've had a major disk crash, but once
the smoke clears from that I (hope to still) have tools to help build a .fmt
file if you need to.
<SPAN
class=885414503-30122003>
<SPAN
class=885414503-30122003>Dave
<BLOCKQUOTE
>Since
I started losing column names around 625 columns, I incorrectlyassumed
there was a limit. I should have known better:THERE IS
NO LIMIT FOR Almighty AmiBroker.But poor Excel and I cannot handle
that large matrix.Considering my proficiency in Perl, I'd still prefer in
a columnalform ( security1, security2 and correaltion columns ) for
easysorting.Any help would be
appreciated.ysk
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
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/amibroker/
To unsubscribe from this group, send an email to:amibroker-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
|