Is it possible to link the matrix to the chart? I want to load the stock chart simply by clicking the points in the matrix. Is it also possible to add filters and select the industry for the results using just the AFL editor?
This is the best I managed to do in two days of looking for a solution. It works but I want to be more efficient, and a lot of these issues aren't liquid that's why I want the AFL to filter those out.
For now I settled with making a watchlist like this. I add one rule at a time to narrow down my analysis, and I can't imagine making a watchlist for each step. It would be great if the matrix only show the results in the "result list tab". I originally have this database in excel. But it started to lag due to the size of the file, so I imported the relevant data to Amibroker. It works great but I need to be efficient.
It would be a big help if anyone could point me to the right direction or approach.
if your data source or you have categorized the symbols, then in AFL you can directly filter using this: AFL Function Reference - CATEGORYGETSYMBOLS
see the example of testing membership of symbol
If you don't have categories, then you can manually create your own watchlists and use this to test for membership and achieve filtering in AFL. AFL Function Reference - INWATCHLISTNAME
With both methods, you can then run your exploration on all symbols. You don't need to use the Analysis UI Filter window.
I don't think you can directly click from scatter-plot chart.
Since your active tab is not the results tab, you can try the below method instead of flipping back and forth.
Similarly, you can use AFL Function Reference - CATEGORYADDSYMBOL
clear the list, run exploration and it will populate your watchlist with symbols.
then you can click through the list to view chart of that symbol while the scatter-plot tab is active.
Thank you! Linking the matrix isn't that important. But I really want the AFL filter to work. I'll get back when I made some progress. Thank you once again!
Hi. Unfortunately, it didn't work. I already have the function you mentioned in my code, but the matrix still displays all of the stocks in my database unless I specifically use the analysis filter settings. But even then, it ignores everything else I typed in the code like liquid and industryid.
Filter = Close != 0
AND IndustryID(0) == 171
AND InWatchListName("nikkei 225")
AND Liquid
;