|
PureBytes Links
Trading Reference Links
|
Hello Larry, Jim, Steve, ...
Thanks for the support. After all, with your support, it was a piece
of cake.
Larry, I think everything was sorted correctly but I had the
same "problem" you had, as described in the instructions.
Maybe you can help me with my other problems:
1. For automatic download, I 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."
What did I do wrong?
2. Now I have a complete database with all US stocks, but is there a
website where I can get information about new stocks and deleted
stocks or do I have to check it once in a while in a newspaper
or ...? So, where can a find the current stocks in the markets?
I hope you understand my badly expressions.
Best regards,
Johan
--- In amibroker@xxxx, acs64@xxxx wrote:
> Johan,
>
> That is right. Sorry, forgot that Notepad does not have the
capacity
> to take this large a database. Wordpad is the right one to use.
> When your Amibroker was populated, did it sort correctly by sector,
> industry and market? Did it populate in one continuous operation
or
> did you have the same problem I did as I described in the
> instructions? For you information and others, the .csv file that
has
> all the tickers in it also has numbers associated with them. These
> numbers are to properly sort the stocks by market, sector and
> industry. They have nothing to do with stock prices.
>
> Larry
>
> --- In amibroker@xxxx, ontherail@xxxx wrote:
> > Johan - First, create a new file named Stocks.txt. Don't use
> > Notepad, use Wordpad. Open Stocks.txt up in Wordpad, then go to
> edit
> > and select Paste Special. In the combo box select unformated
text
> (I
> > think its the last choice), NOT the Excel format choice. You
> should
> > be able to get them all pasted this way. Then just save the file
> and
> > close Wordpad. Now re-name Stocks.txt to Stocks.tls. Hope this
> > helps. Regards, Jim Byrd
> >
> >
> > --- In amibroker@xxxx, GEERTS.JOHAN@xxxx wrote:
> > > 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
|