Hello, FYI: solved in AmiQuote 2.13
Best regards, Tomasz Janeczko amibroker.com On 2010-08-23 18:06, Tomasz Janeczko wrote: > 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&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], "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] >>> 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] >>> 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 >> >> >> >> > > ------------------------------------ > > **** 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 > > > >
