Duke, I do not download prices from Yahoo, just from Quotes Plus. I do, however, download the Yahoo Basic Fundamental data and the Yahoo Extra Fundamental data. Since these do not change very much, I only do the Yahoo stuff once a week on Saturday. Here is the way you must have your database set up for this to work. In Database settings have the Quotes Plus plugin enabled. This gets your prices. Also next to Local Database check enabled. This is what allows AmiBroker to save the Fundamental data from Yahoo. Since this information goes into a different part of AmiBroker's fields, it does not over write any of your Quotes Plus data. Thus you now have the best of both worlds. Hope this explanation makes sense. If you have any other questions feel free to ask. Enjoy, Don Lindberg -------Original Message------- From: sectorfund Date: 12/12/2006 6:32:20 AM To: amibroker@yahoogroups.com Subject: [amibroker] Re: Access to fundamental data using QuotesPlus >> AmiQuote Don,
Are you downloading and updating prices from Yahoo as well? I was curious about trying this with the Yahoo fundamental data into the QP database but I ran into the issue that when I tried to maintain longer price histories than what was available from QP by selecting local db setting the updates stopped from the QP API. When converted back to QP as the data source the the shorter period QP data streams were restored and the previous data lost. I thought the same thing would happen with the fundamental data but perhaps I do not have the correct settings to maintain both in the same db. Regards, Duke Jones, CMT --- In amibroker@yahoogroups.com, "Don Lindberg" <[EMAIL PROTECTED]> wrote: > > Joe, > Yes I have both bits of data in the same database. Only necessary to have > database settings to "use local database" enabled. As far as the size of my > database, My total symbols are 9,263, but I only run my scans against a > WatchList that only includes Common Stocks and ADR's which of course QP is > nice enough to separate into groups for us. This watchlist contains a little > over 5,000 symbols. > > Don > > -------Original Message------- > > From: Joe Landry > Date: 12/11/06 09:53:59 > To: amibroker@yahoogroups.com > Subject: Re: [Amibroker] Re: Access to fundamental data using QuotesPlus >> > AmiQuote > > Don, from what I'm reading it looks like you import the Yahoo fundamental > data in the > same AB database as holds the Quotes Plus data. I understand it's not the > same data but > thought that you had to have a separate database. (I should have RTFM again > but didn't before > asking this question) > > Also, how may tickers data are you importing with Amiquote? 6-7000 tickers > worth? > > Guess it would be easy enough to test with a short list and Amiquote. > > Best regards > JOE > > ----- Original Message ----- > From: Don Lindberg > To: amibroker@yahoogroups.com > Sent: Monday, December 11, 2006 11:05 AM > Subject: RE: [Amibroker] Re: Access to fundamental data using QuotesPlus >> > AmiQuote > > > Keith, > I don't have to switch out of Quotes Plus to run AmiQuote to get the Yahoo > Fundamental data. AmiBroker allows both feeds, as long as you have "use > local database" turned in your database settings. > > Mr Valley seems to indicate that the Yahoo data and Quotes Plus data are the > same, but each has different information. I find the Quotes Plus data the > most useful as I follow the CAN SLIM system and Quotes Plus has information > very similar to what O'Neil says to look for. > > Don > > -------Original Message------- > > From: Mr. Valley > Date: 12/10/2006 9:16:08 PM > To: amibroker@yahoogroups.com > Subject: RE: [Amibroker] Re: Access to fundamental data using QuotesPlus >> > AmiQuote > > FYI - It's a lot less expensive to register AmiQuote with the one- time fee > and get fundamental data - Works Great. > > -----Original Message----- > From: amibroker@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of Keith McCombs > Sent: Sunday, December 10, 2006 4:52 PM > To: amibroker@yahoogroups.com > Subject: Re: [amibroker] Re: Access to fundamental data using QuotesPlus > > > Don -- > Do you have some way to view the GetFnData() values while still using QP > data for plotting. Or are you forever switching back an forth between QP > data and Yahoo data? If you don't need to switch back and forth, how come? > > BTW, what's with faint_grain.jpg? > Thanks. > -- Keith > > Don Lindberg wrote: > Chris, > I use Quotes Plus as well, but I also download the Yahoo Fundamental Data > once a week using AmiQuote. This gives you the best of both worlds, as you > can use both GetFnData AND GetExtraData functions. > > Don Lindberg > > -------Original Message------- > > From: trb0428 > Date: 12/08/06 11:03:41 > To: amibroker@yahoogroups.com > 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 amibroker@yahoogroups.com, "Chris DePuy" <cdepuy@> 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"); > Up side=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 unsucc! ess ful 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: amibroker@yahoogroups.com > > 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: amibroker@yahoogroups.com > > 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 > > >
<<attachment: faint_grain.jpg>>
