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

Re: [amibroker] Re: Amiquote Import does not import a few symbols



PureBytes Links

Trading Reference Links

They've done something inconvenient, that's for sure.  I get a
historical download (US) for Friday, but no import.  Format is:

$NAME ^GSPC
2007-01-19,1426.35,1431.57,1425.19,1430.50,2777480000,1430.50

Yuki

Monday, January 22, 2007, 3:26:57 PM, you wrote:

g> Looks like they changed it and changed it back once again...i
g> downloaded this aqh file around 1am EST sunday monday morning

g> $NAME AACC
g> 2007-01-19,15.51,15.66,15.33,15.63,78000,15.63
g> 2007-01-18,15.73,15.86,15.54,15.60,67500,15.60
g> 2007-01-17,15.57,16.13,15.56,15.72,68500,15.72
g> 2007-01-16,16.39,16.68,15.60,15.67,125700,15.67

g> and about half an hour later downloaded this aqh file:

g> $NAME AACC
g> 19-Jan-07,15.51,15.66,15.33,15.63,78000,15.63
g> 18-Jan-07,15.73,15.86,15.54,15.60,67500,15.60
g> 17-Jan-07,15.57,16.13,15.56,15.72,68500,15.72
g> 16-Jan-07,16.39,16.68,15.60,15.67,125700,15.67



g> --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <groups@xxx> wrote:
>>
>> Hello,
>> 
>> See previous response ... they apparently changed it and reversed
g> the change quickly today.
>> 
>> 
>> Best regards,
>> Tomasz Janeczko
>> amibroker.com
>>   ----- Original Message ----- 
>>   From: Graham 
>>   To: amibroker@xxxxxxxxxxxxxxx 
>>   Sent: Friday, January 19, 2007 9:44 PM
>>   Subject: Re: [amibroker] Re: Amiquote Import does not import a few
g> symbols
>> 
>> 
>>   Interesting because I did a history download yesteday and the data
g> did not appear in AB.
>>   my aqh files show 2007-01-18,
>> 
>>   10 days ago the data format was 8-Jan-07
>> 
>>   -- 
>>   Cheers
>>   Graham
>>   AB-Write >< Professional AFL Writing Service 
>>   Yes, I write AFL code to your requirements
>>   http://www.aflwriting.com 
>> 
>> 
>> 
>>   On 20/01/07, Mark Jarvis <mark.jarvis@xxx> wrote:
>>     Just another issue with Yahoo.  The date format DEFINITELY
g> changed as I opened the *.aqh files and checked.  If it's back to
g> d-m-y, I'll change the format file back.
>> 
>> 
>> 
>>     On 20/01/07, giggollo99 <giggollo@xxx> wrote:
>>       I also don't think its a date issue, Mark, although I am also
g> having 
>>       trouble with yahoo data lately. Yesterday while trying to 
>>       download using Amiquote from Yahoo, I got "Failed" for many
g> symbols 
>>       in my 3000 stock database. It was around 4am so maybe there
g> was some 
>>       kind of maintenance downtime going on..In addition to that and
g> for 
>>       several weeks, i have noticed that some symbols which used to
g> have 
>>       historical data available for them have no data available for
g> them or 
>>       their data disappears and reappears briefly then disappears.
g> Examples:
>> 
>>       http://finance.yahoo.com/q/hp?
>>       a=00&b=1&c=2006&d=00&e=19&f=2007&g=d&s=vsth
>> 
>>       http://finance.yahoo.com/q/hp?
>>       a=00&b=1&c=2006&d=00&e=19&f=2007&g=d&s=whit
>> 
>>       http://finance.yahoo.com/q/hp?
>>       a=00&b=1&c=2006&d=00&e=19&f=2007&g=d&s=qcom
>> 
>>       VSTH and WHIT do not work for me, i get the following message:
>> 
>>       "Historical quote data is unavailable for the specified date
g> range."
>> 
>>       but QCOM works, and its the exact same link. VSTH and WHIT are
g> valid 
>>       US stocks and there are others but i am giving a couple of
g> examples 
>>       only.
>> 
>>       I contacted Yahoo about this problem but they referred me to
g> CSI data 
>>       and did not indicate they would be addressing the problem. I 
>>       contacted CSI data but got no response from them. Is anyone else 
>>       noticing this?
>> 
>>       --- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <groups@> 
>> 
>> 
>>       wrote:
>>       >
>>       > Hello,
>>       > 
>>       > That's interesting - I just tried to download now and the date 
>>       format is still DD-MMM-YY !
>>       > You should really double check this because it does not look as 
>>       there was ANY change in the format of Yahoo Historical.
>>       > 
>>       > Example MSFT:
>>       > $NAME MSFT
>>       > 18-Jan-07,31.15,31.37,30.80,31.00,56364300,31.00
>>       > 17-Jan-07,31.26,31.44,31.01,31.10,58519600,31.10
>>       > 16-Jan-07,31.26,31.45,31.03,31.16,62379600,31.16
>>       > 12-Jan-07,30.65,31.39,30.64,31.21,103972496,31.21
>>       > 11-Jan-07,29.76,30.75,29.65,30.70,99464304,30.70
>>       > 10-Jan-07,29.80,29.89,29.43,29.66,55017400,29.66
>>       > 9-Jan-07,30.00,30.18,29.73,29.96,44636600,29.96
>>       > 8-Jan-07,29.65,30.10,29.53,29.93,50220200,29.93
>>       > 5-Jan-07,29.63,29.75,29.45,29.64,44607200,29.64
>>       > 4-Jan-07,29.70,29.97,29.44,29.81,45774500,29.81
>>       > 
>>       > Best regards,
>>       > Tomasz Janeczko
>>       > amibroker.com
>>       > ----- Original Message ----- 
>>       > From: Mark Jarvis 
>>       > To: amibroker@xxxxxxxxxxxxxxx 
>>       > Sent: Friday, January 19, 2007 2:16 PM
>>       > Subject: Re: [amibroker] Amiquote Import does not import a few 
>>       symbols
>>       > 
>>       > 
>>       > I had a problem with Amiquote tonight. Yahoo have changed the 
>>       date format from dd-mm-yy to yy-mm-dd. Changing the *.AQH format 
>>       file in c:\program files\amibroker\formats fixed the problem..
>>       > 
>>       > 
>> 
>>       > On 19/01/07, giggollo99 <giggollo@> wrote:
>>       > Using Amiquote 1.92, Amibroker 4.89, i do a historical download 
>>       of 3000
>>       > symbols with "Automatic Import" unchecked. Then i do "Tools-
>>       >Import
>>       > into Amibroker". When I do this I notice that a few symbols are 
>>       not
>>       > imported, but the vast majority of symbols are imported fine. 
>>       When I
>>       > redownload the data for those few symbols using Amiquote and 
>>       then
>>       > do "Tools->Import into Amibroker" for the second time, they are
>>       > imported correctly. To identify which symbols had not been 
>>       imported, I
>>       > used filter=1 and "N last days, n=1" in AA settings, did an 
>>       exploration
>>       > then sorted by date to see which symbols did not have today's 
>>       date.
>>       > Because only a few symbols are not imported, I guess this is 
>>       something
>>       > that normally wouldn't be noticed by the user, unless youre 
>>       updating a
>>       > large database (thousands of symbols) and really analyse the 
>>       data to
>>       > see what has been imported and what hasnt.



Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.3/642 - Release Date: 1/20/2007 10:31 PM