Re: Populate Database.exe

[GEERTS.JOHANkkkkk]

Larry,

I've already tried to copy and paste Column A into Notepad, but I 
become a message that tells me I can't do it, because the memory is 
to little. I only can copy from A to DOW. I use a Pentium III 
800Mhz with 128 MBram, could that be the reason?

Thanks for your support

Johan

--- In amibroker@xxxx, acs64@xxxx wrote:
> Johan,
> 
> Very simple. First make a directory under Amiquote folder and call 
> it something like US Stocks. Then go to the 
> Tick_MktID_Name_IndID.csv file that you unzipped and open it in 
> Excel. Copy column A (the ticker symbols) then paste it into 
> Microsoft Notepad and save the file under the newly created US 
Stocks 
> folder with a .tls extension (you might just call the file 
> stocks.tls). Then start Amiquote, go to the US Stocks folder and 
> open the stocks.tls file and download from Yahoo. Make sure the 
> first time you select historical quotes, and since the database is 
> over 9,600 stocks, you might want to consider not having too long 
of 
> a history. That might depend on the computer you have. Maybe one 
or 
> two years.....It should take quite awhile to download that much 
> historical data so be prepared to wait. After it is finished 
> (several hours maybe), open Amibroker, go to file, import Ascii, 
> select files of type .aqh (historical), go to the US Stocks folder 
> and all the files should appear. Go to the last stock, hold down 
the 
> shift key and click on the last stock. All stocks should then be 
> highlighted. That should do it. Good luck.
> 
> Larry
> 
> --- In amibroker@xxxx, GEERTS.JOHAN@xxxx wrote:
> > Hello,
> > 
> > I've just setup a database with the file "Populate 
Database.exe". 
> It 
> > was a piece of cake, even for me, really a great job from Larry. 
> > There is just one problem, I don't know how to download the 
> > historical quotes. Do I have to make a ticker list by hand (if 
so, 
> > how - tried different ways, but not succeed), or is there a 
better 
> > trick?
> > 
> > I also installed the URLGet program and downloaded the Yahoo 
> > downloader script as presented in AmiBroker Tips, Issue 6/2001, 
but 
> > when I run the script, the following message appears : 
> > 
> > "The database currently loaded into AmiBroker does not have 
^NDX. 
> So 
> > I guess this is not correct database. Update failed."
> > 
> > Please, can someone give me the right instructions. Thanks for 
> > helping me,
> > 
> > Johan