|
PureBytes Links
Trading Reference Links
|
Johan,
Sorry, I cannot help you with either of your latest questions.
Perhaps Tomasz would know. Why would it be important to you to add
or delete a few stocks? I would think with 9,600 plus to pick from,
you could find something you like! There is a function in Amibroker
for cleaning up the database....not sure exactly what it is based on,
but if I were to guess, I would think it would maybe delete, or ask
you to delete, those stocks that are not getting updated on a regular
basis....that is perhaps stocks that are no longer active?
Larry
Larry
--- In amibroker@xxxx, GEERTS.JOHAN@xxxx wrote:
> 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
|