Tom, I do not use QuotesPlus, but i assume that if you configure the database right you could use Amiquote to retrieve Yahoo fundamentals. Those are what I was referring to below when I gave you the AFL code snipped relating to OneYearTargetPrice. If worst came to worst, you could retrieve OneYearTargetPrice using Yahoo/amiquote in a separate database, save these to Amibroker Notes, then open your QuotesPlus database and then request the targetprice using NoteGet. Good luck. If you want some more help about retrieving Yahoo fundamentals, I've spent a great deal of time on this subject recently and I'm happy to lend a hand. Chris ----- Original Message ----- From: trb0428 To: [email protected] Sent: Friday, December 08, 2006 10:56 AM Subject: [amibroker] Re: Access to fundamental data using QuotesPlus
Chris, Thanks for the suggestions....I will try them. However with QuotesPlus as my data source, I do not have access to "OneYearTargetPrice" and do not use the GetFnData call. I am limited to the fields supported by the GetExtraData() function. Perhaps Tomasz will consider expanding the QP plugin to support the additional fields in the QP download? Thanks, Tom --- In [email protected], "Chris DePuy" <[EMAIL PROTECTED]> wrote: > > Tom, > > 1) Perhaps "OneYearTargetPrice" will suffice? I've heard some folks using quant/tech strategies use this as a potential resistance level. > http://www.amibroker.com/devlog/wp- content/uploads/2006/06/ReadMe4810.html. You could try: OneYearTargetPrice = GetFnData("OneYearTargetPrice"); Upside=OneYearTargetPrice/C-1; Addcolumn(Upside,"Upside",1.2); > > 2) You may also notice that when an upgrade happens, very frequently (like 90-95% of the time) estimates go higher (and downgrade/lower). For this you could use any/many of the EPS estimates available from GetFnData. You just have to track it (this is the tough part) to see what it was a day ago, week ago, etc. Some of the most sustainable moves in growth stocks are found using revisions data. > > 3) Another point to consider is that these analyst opinions will sometimes help you buy the stock, but almost never help you get out, so even if you had this information, it would not help you exit the stock. I've done some studies on this (and # of covering analysts, next 12 months EPS estimates, etc) and related topics using thomsononeanalytics.com excel add-in data. Additionally, there have been several unsuccessful fund strategies at brokerage firms that used the buys/sells from the firm's analyst teams. Also, if analyst opinions are important to you, you may want to consider subscribing to Starmine, which ferrets out who are the best analysts and focuses on their moves. > > Chris > > ----- Original Message ----- > From: Joe Landry > To: [email protected] > Sent: Thursday, December 07, 2006 5:31 PM > Subject: Re: [amibroker] Access to fundamental data using QuotesPlus > > > > The GetExtraData functions are supported by the QP plug in, and > the only way I see to do it is to extend the QP plug in, not likely > to happen unless done by someone in the AB user community. > > HTH > Joe > > > ----- Original Message ----- > From: trb0428 > To: [email protected] > Sent: Thursday, December 07, 2006 4:17 PM > Subject: [amibroker] Access to fundamental data using QuotesPlus > > > Hi - > > Does anyone know if there is a way to access the "Analysts > Recommendations" field from within AB when using Quotes Plus as my > data source? I can access other fields using the GetExtraData () AFL > function but "Analysts Recommendation" does not appear on the list. > Any Ideas? > > Thanks, > Tom >
