|
PureBytes Links
Trading Reference Links
|
Dave,
Thank you for your suggestion.
A SQL database would be a overkill for me.
I probably don't need that much speed, flexibility and sophistication.
I just want to create a sorted list of a million or two correlations
in columns, not in matrices.
I can definitely live with AmiBroker's sorting speed and capability if
it can be done within AmiBroker.
ysk
--- In amibroker@xxxxxxxxxxxxxxx, "Dave Merrill" <dmerrill@xxxx>
wrote:
> 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.
>
> 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.
>
> Dave
> Since I started losing column names around 625 columns, I
incorrectly
> assumed 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 columnal
> form ( security1, security2 and correaltion columns ) for easy
> sorting.
>
> 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:
http://docs.yahoo.com/info/terms/
|