Re: [amibroker] Quotes Plus Mutual Funds in AB

[Steve Dugas]

Hi Joe,   Unfortunately, QP's database has lots of problems, and problems of all types. There are still over 3000 dead tickers ( mostly MF's now, I remember Dan Clark working with Gary in the past to get most of the dead stocks removed ). Tickers are classified incorrectly with regard to type of issue ( for one example, run an exploration on the MF group with "Filter = Volume > 0" and you will see some ETF's and stocks classified as MF's ). Tickers are also classified incorrectly with regard to trading status, which is what caused Ken's problem. There is no good solution other than a massive effort on QP's part to clean things up, which I don't hold out much hope for. TJ has tried several times in the past to patch the "dead ticker" issue on his end, but it cannot really work properly as long as so many tickers are classified incorrectly in QP's DB. As things stand now, there are basically 2 options:   1. You can check either/both boxes at the bottom of the plugin Configuration box - this will eliminate most of the dead tickers from AB, but it will also eliminate some valid tickers because they are misclassified as non-trading, etc. How many? Which ones? I have no idea, but it always bothered me to know that, when I am exploring for good stocks that meet some criteria or another, I could very well be missing some of the better ones because they were misclassified and not retrieved by AB.   2. So I always choose this 2nd option instead - uncheck both boxes and just download all tickers including the dead ones. Then at least you know you have *all* the tickers, and at that point you can either just live with a bloated DB or you can delete the dead ones via Database Cleanup.   I can think of a couple of possibilities why you have ERH with the box checked...   1. Maybe your DB dates back to previous versions of the plugin, before TJ added the option to skip non-trading tickers?   2. Maybe, for at least one prior retreive, you unchecked these boxes?   3. Maybe QP changed the status somewhere along the way?   Steve ----- Original Message ----- From: Joe Landry To: amibroker@yahoogroups.com Sent: Thursday, September 28, 2006 8:32 AM Subject: Re: [amibroker] Quotes Plus Mutual Funds in AB Steve,Ken - Now that we have the answer on ERH from Gary L of QP in the QP forum, that the status code was not zero, what are the other status codes?   AH! ONCE I KEYED IN THE QUESTION, I RTFM and there are the status codes. Lots of them.   In my database configuration I've got retrieve only active symbols (status code =0) BUT I was getting ERH anyway?  Another puzzle.   What are options do you have ticked off in your database configuration?   Regards JOE     "IssueStatus" - (string) - with default settings all symbols should have issue status = 0 other possible values: 0 = actively trading; 1, P = trading on a when issued basis, 5, 6, 7, A, B, C, D, E, M = not trading 4, N = new symbol, G, K, X, R, Z = changes to symbol, cusip, name, etc. - requires QP plugin 1.5.1   ----- Original Message ----- From: Steve Dugas To: amibroker@yahoogroups.com Sent: Wednesday, September 27, 2006 1:15 PM Subject: Re: [amibroker] Quotes Plus Mutual Funds in AB Hi Ken - I can see it in AB. QP still has a number of tickers that are "misclassified". To get around this, when I do a retreive I uncheck both of the bottom boxes in the Configure dialog so the plugin will retrieve all tickers, then I run Cleanup Database on the Tools menu to delete all the dead ones.   Steve ----- Original Message ----- From: Ken Close To: amibroker@yahoogroups.com Sent: Wednesday, September 27, 2006 1:38 PM Subject: [amibroker] Quotes Plus Mutual Funds in AB I am a new user of Quotes Plus to drive data to AB (vs TC2000) and I have been doing ok with the transition.   I just now retrieved all of the mutual funds I have been downloading, and can use them just like any stock symbol.   There is an interesting closed end fund named ERH (Evergreen) which is in the QP database (I can plot it using the QP charting program), but Amibroker can not see it.   Any QP data users here who could see whether you can see/plot ERH in Amibroker from the QP database?  If you can, can you speculate why the symbol does not show up on mine.   I have reloaded AB (but not rebooted the computer), but I wonder why that would make a difference.   Any suggestions?   Thanks,   Ken __._,_.___ Please note that this group is for discussion between users only. To get support from AmiBroker please send an e-mail directly to SUPPORT {at} amibroker.com For other support material please check also: http://www.amibroker.com/support.html SPONSORED LINKS Software support Small business finance Business finance online Business finance training Business finance course 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 __,_._,___