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

RE: [amibroker] Report on Quotes Plus Data



PureBytes Links

Trading Reference Links

 
Bob,
 
Regarding the your first question, I looked at my laptop which also has QP and AB loaded.   Without re-downloading QP daily data, I "Retrieve"d the QP symbols into AB for the first time since loading the new QP plugin.   The new groupings popped up.   I noticed that all of the Mutual Fund symbols are 3 digit, not five digit.   One symbol is "FCM" ("First Trust/Four Corners Senior Floating Rate Income Fund").   I'm not familiar with this kind of instrument.
 
Regarding "...the only difference is their segregation into new Groups.", that's an excellent point.  I think you are correct. (I'll confirm later today.)
 
I think that some non-stock instruments "snuck" into my sector and industry indexes.  For example, if ETFs were in the Group "Stocks" (I believe they were), my Financial Sector composite index would be impacted because ETFs have a Sector of "Financial".  Nothing like including a Bond Fund in a Sector index to screw up the results.
 
The new groupings provide a better categorization and make it easier to work around this overall issue.  I'll need to use the Group or QP IssueType in my scans.
 
Thanks for pointing this out!
 
Best regards,
 
Dan.
 
-------------- Original message --------------

Yes, and the new DB used the QP feed that includes MFs.

Which 5-letter Mutual Fund symbols were imported?

 

Re your further comments, the other symbols were imported by the previous plug-in; the only difference is their segregation into new Groups.

 

Bob

 

 

 

-----Original Message-----
From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@ yahoogroups.com]On Behalf Of dan_public@xxxxxxxxxxx
Sent: Thursday, August 11, 2005 11:12 AM
To: amibroker@xxxxxxxxxxxxxxx; amibroker@xxxxxxxxxxxxxxx
Cc: Bob Jagow
Subject: RE: [amibroker] Report on Quotes Plus Data

 

Bob,

 

Do you have the new QP plugin?   Tomasz indicates that things have changed.  

 

Regarding the number of Mutual Fund symbols, when "Mutual Funds" is unchecked some Mutual Funds symbols are still imported.  (Based on Tomasz's feedback, I think it's related to problems with QP's "IssueType" setting.  I need to check more when I get home.)

 

Regarding "Preferred Stocks, Warrant or right, Convertible preferred, or Certificate and Units", these don't meeting my needs.   Including them adds symbols to the database that don't meet my needs and increase the number of symbols that are scanned.     From my perspecitive it needlessly increases the size of the AB local database. 

 

However the biggest issue is that these symbols may skew my composite indexes.   For example, Alcoa has a Common and a Preferred Stock symbol.   The Common price is about 1/3 of the Preferred price, but the preferred volume is almost non-existent.   Using Preferred Stock when creating a composite index could skew the results.  It's mixing apples and oranges.

 

If you see some problems with my logic, please let me know.  I'm here to learn.  I have more questions than answers.

 

Regards,


Dan.

 

-------------- Original message --------------

Dan,

I created a new DB per your ‘Part A’ and got 8477 symbols vs 26,010 for one that includes MFs.

Re ‘Part B’, why exclude   Preferred Stocks, Warrant or right, Convertible preferred, or Certificate and Units from ‘Stocks’?

 

Bob

-----Original Message-----
From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx]On Behalf Of Dan Clark
Sent: Thursday, August 11, 2005 8:36 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Report on Quotes Plus Data

 

Tomasz,

 

I did not realize that the groupings changed because of the plugin version.   If these are standard grouping going forward, then I’ll change my code to match the new groupings.   However…

 

There are still two issues:

 

1.    1.      Part A - Even though “Mutual Funds” is NOT checked in the “Quotes Plus plugin configuration” window, Mutual Fund symbols are still retrieved.  To ensure that the DB was clean, I deleted all symbols from AB.  Then I “Retrieve”d symbols, etc. from the “Quotes Plus plugin configuration” window with “Mutual Funds” NOT checked.  I still got Mutual Funds symbols.   Why are they retrieved?  Shouldn’t they be excluded?

 

Part B – In addition to Mutual Funds, other non-Stock/non-Index items are retrieved - Preferred Stocks, ADRs, Warrant or right, Convertible preferred, ETF, Certificate and Unit.     ADRs and ETFs may be considered stocks, but not the others (AFAIK).

 

Which leads to issue 2…

 

2.    2.      With the old plugin, the AB Groups and “Quotes Plus plugin configuration” categories roughly matched.  With the new plugin, the Groups and Categories no longer match.   Shouldn’t the “Quotes Plus plugin configuration” categories be a closer match to the AB Groups so that unwanted symbols can be excluded?

 

Including symbols that we don’t want increases database size, scan time, and risk of composite errors (key for me).  Please take a look.

 

Regards,

 

Dan.

 


From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Tomasz Janeczko
Sent: Thursday, August 11, 2005 7:32 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Report on Quotes Plus Data

 

Hello,

 

New plugin uses new groupings, old plugin uses old groupings.

If you like old one, use old plugin.

 

Old plugin "stocks" group was not entirely correct as it included not only stocks, but for example ADRs and ETFs as well.

If you need old "stocks" category, you can try EXCLUDE "Indexes" group instead.

 

Best regards,
Tomasz Janeczko
amibroker.com

----- Original Message -----

From: Dan Clark

To: amibroker@xxxxxxxxxxxxxxx

Sent: Thursday, August 11, 2005 4:11 PM

Subject: RE: [amibroker] Report on Quotes Plus Data

 

Steve,

 

You’re right.  I’m still getting used to QP data.  QP was set up to download Mutual funds, but AB was not.  I changed that.   It now pulls in 29,320 symbols.   Hmmm…   That’s a lot.

 

I also found something I didn’t expect – the Groups have changed massively.   For example, “Stocks” are now “Common Stocks” and “Preferred Stocks”.   And, some of my scan and explorations no longer work!    (Some were filtered by Group = “Stocks”.)    The Database size has increased significantly.   Now I have a mess!   What’s worse…

 

I’m tried to convert AB back to using the original QP groupings and excluding Mutual Funds, but id doesn’t work!  I’ve deleted the QP database, created a new one, and retrieved the QP stocks, indices and industry/sector assignments.  Even though I did NOT retrieve Mutual Fund symbols, AB continues to use the OLD Groups and it still has the Mutual Fund symbols!!!

 

How do I revert to the old groupings and get rid of the Mutual Fund symbols?

 

Regards,

 

Dan.

 


From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Steve Dugas
Sent: Wednesday, August 10, 2005 10:21 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Report on Quotes Plus Data

 

OK thanks Dan - I guess you are not downloading funds...

 

Steve

----- Original Message -----

From: Dan Clark

To: amibroker@xxxxxxxxxxxxxxx

Sent: Thursday, August 11, 2005 12:06 AM

Subject: RE: [amibroker] Report on Quotes Plus Data

 

Steve,

 

I did a scan of all symbols and got 9,308 symbols including QP’s indexes and my composite indexes.  Regards,

 

Dan.

 

 

 


From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Steve Dugas
Sent: Wednesday, August 10, 2005 12:15 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: Re: [amibroker] Report on Quotes Plus Data

 

Hi Dan !  Just curious - would you mind telling me how many tickers you have in your AB Quotes Plus database? Thanks !

 

Steve

----- Original Message -----

From: Dan Clark

To: amibroker@xxxxxxxxxxxxxxx

Sent: Tuesday, August 09, 2005 12:06 PM

Subject: [amibroker] Report on Quotes Plus Data

 

Hi,

 

Over the last several weeks, I’ve posted questions about Quotes Plus data.   This a quick report on what’s happened so far.

 

When I started using AB again in April, I used TeleChart as my data source.   As a source and as a charting package, TeleChart had some advantages.   The TC charting had a few, minor advantages over AB.   And, the data had some good features when compared to Quotes Plus – Media General Industry Group and Sector Indexes, intraday data updates, and clean data (minimal dead tickers).

 

However, on the downside, the TC UI had loads of idiosyncrasies and is not even in the same league with AB for scanning and back testing.   And, as I became more familiar with QP3 data, TC data advantages started to disappear:

 

·         While TC intraday data updates are still an advantage, I can work around it with intraday updates from my broker – Interactive Brokers.    

 

·         With the new QP plugin, the QP data appears to be much cleaner; dead tickers are excluded.  

 

·         It turns out that TC’s implemention of Hemscott’s Media General industry/sector hierarchy doesn’t work well for me.  TC stripped off the Hemscott macroeconomic Sector Level (8 Sectors) of the hierarchy and uses the bottom two levels of the Hemscott hierarchy – Business Segment and Industry Group.   Unfortunately, TC refers to the “Business Segment” level as the “Sector” level.   IMO, the 31 TC “Sectors” provide too much granularity and are not useful as macroeconomic indicators.  

 

Quotes Plus apparently uses the Reuters Industry and Sector hierarchy which I now find more useful.

 

·         Now that I’ve gone through the process of creating my own indexes, I find that it’s an advantage.  Using “AddToComposite” I can create custom indexes that meet my needs and do not have to depend on the TC definition.  

 

·         While I don’t invest in Mutual Funds, I do like to use them sometimes as economic indicators.   With TC, they are an added cost item.  With Quotes Plus, they come as part of the standard package.

 

·         Except for Money Stream and BOP, TC provides little additional data to AB other than price and volume.  Quotes Plus has a wide variety of fundamental data and “other” data.  For example, it provides market cap data and the percent shares held by institutions – which I use in my system.

 

·         My scans run much faster with QP data.  Accessing TC’s data from AB is slower than accessing QP data.  I haven’t quantified how fast the scans run, but scans running against QP data appear to run 50 to 100% faster.

 

One final issue with TC is more emotional in nature... 

 

TC is a VERY marketing oriented company.  Although TC’s trainers seem like pretty good folks, asking a basic question to TC management get a marketing hype response.  In some cases, the answers are quite insulting.   At one point, I posted a question on forum about the Worden Studio product (a web-based product) and how it related to Telechart.   Instead of a clear answer, I got marketing hype.   When I complained that I couldn’t see any value with Worden Studio, they condescendingly stated that I just didn’t know how to use it!  

 

I’m a Data Warehouse Architect by profession (fancy name for database developer) and have developed analytical software for 34 years.    I don’t claim perfection, but I do understand a fair amount about analytical systems.   For TC management to try to explain away their products’ deficiencies by telling me that I just don’t know how to use it is extremely insulting!  What’s worse is that it displays a lack of sensitivity for customer needs and requirements.   

 

OK, flame off! 

 

Because I’m cautious, I’ll keep the TC subscription for another month or so to ensure that I haven’t missed anything.   From this point forward, Quotes Plus is my primary EOD data source.

 

I hope you’ve found this report useful.

 

Best Regards,

 

Dan.

 

 




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





YAHOO! GROUPS LINKS