[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] Re: finding pairs



PureBytes Links

Trading Reference Links

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/





Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___