Title: Re: [amibroker] Re: finding pairs
Bruce,
you can trick the AA to display data from any table. Just run the AA on a WatchLists that has more tickers than their are rows in your external table. Then use the StockNum as a row number to retrieve the data. This allows you to display any information in the AA grid. If you append an auto-export to your AA operation this will automatically reformat/filter/sort the data to show exactly what you want to see. I used to do this and it worked very nice.
Thanks Bruce, I always welcome new ideas! I realize there was an error in the way i looped through the tickers from both ends :-) that won't work.
Looking forward to your feedback!
herman
Tuesday, August 25, 2009, 9:50:08 AM, you wrote:
> Herman, All -
> When I was catching up on this thread over the weekend, I was hoping
> that it would continue to highlight the need to produce output like the
> following in the AA grid. I run into this frequently and resort to
> output to text files, Excel, etc. With the column and sorting
> manipulation functions of the AA grid, colorization, plus the HTML
> output, it is just too inviting if the AA grid had a few enhancements -
> Ticker1 Ticker2 Correlation
> XYZ ABC 0.867
> DFG JKI 0.932
> To do the above one would need an AddRawTextColumn function - roughly
> analogous to RawTextOutput() in the CBT. The user would have to be
> responsible for all output, in this mode, though, and bar output would
> probably conflict.
> BTW, Herman - I know that your original code was a quick example, but
> since you asked for improvements - it can be sped up by probably an
> order of magnitude. I'll add some comments and send you the quick hack
> that I did on it.
> -- BruceR
> ------------------------------------
> **** IMPORTANT PLEASE READ ****
> This group is for the discussion between users only.
> This is *NOT* technical support channel.
> TO GET TECHNICAL SUPPORT send an e-mail directly to
> SUPPORT {at} amibroker.com
> TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
> http://www.amibroker.com/feedback/
> (submissions sent via other channels won't be considered)
> For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> http://www.amibroker.com/devlog/
> Yahoo! Groups Links
> <*> To visit your group on the web, go to:
> http://groups.yahoo.com/group/amibroker/
> <*> Your email settings:
> Individual Email | Traditional
> <*> To change settings online go to:
> http://groups.yahoo.com/group/amibroker/join
> (Yahoo! ID required)
> <*> To change settings via email:
> mailto:amibroker-digest@xxxxxxxxxxxxxxx
> mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx
> <*> 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/
__._,_.___
**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
__,_._,___
|