TJ
I don't know if you are familiar with finviz.com or not. They seem to have the same extended financial information as yahoo and some more. I don't know if it make sense to download the fundamental data from this site or not? Just for your info. It is the best site for financial information that I know of. The following link is provided as an example. http://www.finviz.com/quote.ashx?t=kyn&ty=c&ta=1&p=d From: [email protected] [mailto:[email protected]] On Behalf Of Tomasz Janeczko Sent: Monday, August 23, 2010 9:07 AM To: [email protected] Subject: Re: [amibroker] Re: Don't use AmiQuote ver 2.12 for Fundamental Data Hello, AmiQuote is just the specialized web browser (downloader) that does NOTHING but issue HTTP request and download data from Yahoo. Yahoo Basic and Extended information is a result of TWO different requests coming from two different pages. Yahoo Basic information is coming from "Download Data" link on that page: http://finance.yahoo.com/q?s=KYN i.e.: http://download.finance.yahoo.com/d/quotes.csv?s=KYN <http://download.finance.yahoo.com/d/quotes.csv?s=KYN&f=sl1d1t1c1ohgv&e=.csv > &f=sl1d1t1c1ohgv&e=.csv While Yahoo Extended is coming from "Key Statistics" page here: http://finance.yahoo.com/q/ks?s=KYN+Key+Statistics As you can see first link (Basic) does NOT include "% held by insiders" or "% held by institutions" or "forward dividend" therefore your findings about "Basic" mode are incorrect, because you quote data that do NOT exist in "Basic Fundamental" download. The only that is available from "Basic" source is DIVIDEND and this one is downloaded as it should. Other fields are simply not present in "BASIC" page. What you are telling other people on the list is false, probably left-over from any previous downloads that you did, because fields that DO NOT exist in given data source are left untouched. With regards to "Extended" mode, data are retrieved from http://finance.yahoo.com/q/ks?s=KYN+Key+Statistics UNLIKE all other datas downloaded by AmiQuote, this does NOT come in computer-friendly, comma-separated form. It is instead formatted to be "human readable" and its layout is changed from time to time by Yahoo. Every change Yahoo does on that page may result in problems. The data you got are incorrect simply because of one addition that Yahoo did, they started adding commas as "thousand separator" and because of the fact that COMMA is also field separator, it causes trouble during importing of such file because thousand separator used by Yahoo is interpreted as field separator. In this particular case the problem is because PROFIT MARGIN for KYN is 1,913.39%. Because of that comma in profit margin you get problems (only for symbols that have profit margin higher than 1000%). It is rare, don't you think. Of course this special (rare) case for Extended Fundamental mode needs to be fixed, but how come you go so far to saying that all data downloaded is unreliable is beyond me. I guess that bashing the program makes you happier ? Best regards, Tomasz Janeczko amibroker.com On 2010-08-16 18:07, donangiecarlson wrote: > Bill: I don't believe the problem is looking at different Yahoo servers; because you can use AmiQuote on different days...downloading Basic and Fundamental info and the same errors exist in AB. Here is an example of "some" fundamental info for just one ticker KYN... there are many such data descripencies problems that can be found: > > Yahoo AmiQuote AmiQuote > KYN Basic Extended > 1.92 1.92 0 Current Dividend > N/A 275,140 275,140 Forward Dividend > 0.18% 582,600,000% 582,600,000% % Held by Insiders > 17.50% 0.18% 0.18% % Held by Institutions > 7/2/2010 7/2/2010 7/8/2010 Ex-Dividend Date > 7/8/2010 7/9/2010 7/9/2010 Dividend Date > > o The first column are the value in Yahoo. > o The second column are the values in AB after downloading Basic Fundamental data using AmiQuote. > o The third column are the values in AB after downloading Extended Fundamental data using AmiQuote. > > Ton: Since you seem to use a different download program for retrieving Yahoo fundamental data for AB...what are your results for the above example. Also, what is the alternative program you are using to download yahoo fundamental data into AB? > > Don > > > > > --- In [email protected] <mailto:amibroker%40yahoogroups.com> , "wavemechanic"<olesmi...@...> wrote: >> This could happen if the downloader and the viewed data are not looking at the same server - current and historical. Are apples and apples be compared or apples and oranges? >> >> Bill >> ----- Original Message ----- >> From: Ton Sieverding >> To: [email protected] <mailto:amibroker%40yahoogroups.com> >> Sent: August 16, 2010 3:54 AM >> Subject: Re: [amibroker] Don't use AmiQuote ver 2.12 for Fundamental Data >> >> >> >> >> >> Hi. If AmiQuote is unreliable and if Yahoo gives the correct data than I should not have the same errors when downloading Yahoo data with other downloaders. But I do ... Please prove me why AmiQuote is unreliable just by showing that downloading the same data from Yahoo and a different downloader gives different results. Not by just telling me that AmiQuote is unreliable ... >> >> Regards, Ton. >> >> ----- Original Message ----- >> From: donangiecarlson >> To: [email protected] <mailto:amibroker%40yahoogroups.com> >> Sent: Monday, August 16, 2010 2:21 AM >> Subject: [amibroker] Don't use AmiQuote ver 2.12 for Fundamental Data >> >> >> >> The program is so bad it probably loads incorrect ticker quotes as well. The Basic Data changes/deletes the Extended Data and when Extended Data is loaded it changes/deletes Basic Data. Many people have said that the Yahoo data is unreliable....it's probably more because AmiQuote is unreliabel and doesn't load info correctly. #...@* >> > > > > ------------------------------------ > > **** IMPORTANT PLEASE READ **** > This group is for the discussion between users only. > This is *NOT* technical support channel. > > TO GET TECHNICAL SUPPORT send an e-mail directly to > SUPPORT {at} amibroker.com > > TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at > http://www.amibroker.com/feedback/ > (submissions sent via other channels won't be considered) > > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: > http://www.amibroker.com/devlog/ > > Yahoo! Groups Links > > > >
<<image001.jpg>>
<<image002.jpg>>
