|
PureBytes Links
Trading Reference Links
|
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
|