|
PureBytes Links
Trading Reference Links
|
herman,
With your explanation, it has become clear to me that it's not an easy
problem not only for me but also for afl experts.
It seems I have to invest some time to adapt DT's method to show top
100 or so correlation pairs.
It might be faster for a cut-and-paste programmer like myself to wait
for "string arrays" but ...
Thank you for the inputs.
ysk
--- In amibroker@xxxxxxxxxxxxxxx, "Herman vandenBergen" <psytek@xxxx>
wrote:
> ysk,
>
> the main problem is that AB cannot display string arrays in columns,
to make
> side by side ticker columns. If you would be willing to work with
> stock-numbers then it could be done but for long lists this is quite
messy
> and subject to errors.
>
> There has been talk about string arrays for AB, when that capability
arrives
> your problem will be solved.
>
> I would suggest to seek ways in which to screen your securities, or
use DT's
> method to extract only relevant values from the table.
>
> herman.
> -----Original Message-----
> From: qqqqq_99999_qqqqq [mailto:qqqqq_99999_qqqqq@x...]
> Sent: December 30, 2003 12:47 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Re: to HERMAN: N100 Correlation table
>
>
> 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@xxxx
> Send SUGGESTIONS to suggest@xxxx
> -----------------------------------------
> 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
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/amibroker/
>
> b.. To unsubscribe from this group, send an email to:
> amibroker-unsubscribe@xxxxxxxxxxxxxxx
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
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/
|