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

Re: [amibroker] Re: Ticker Lists and Price Histories



PureBytes Links

Trading Reference Links

Jim,

1. Notepad is the best because it works with plain text file,
but you can export to plain ASCII from Excel
and you can also use copy-paste

3. Of course. Just change FROM date as shown in the video:
http://www.amibroker.net/video/amiquote2.html

4. It depends on data source you are using. If you are using
FREE data source like Yahoo or MSN then that's correct for new listings/symbol changes.
If you are using Quotes Plus or TC2000 new listings/symbol changes will be added
automatically ('retrieve' button in 'configure' dialog)

As for delistings - it is enough to run Cleanup script
and it will detect automatically delisted stocks and will give you an
option to remove them.

Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message ----- 
From: "Jim" <bankedout@xxxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Saturday, December 27, 2003 10:36 PM
Subject: [amibroker] Re: Ticker Lists and Price Histories


> For 1) Can I copy and paste from Excel to make a ticker list like 
> that?  Otherwise, how is it done?  What extension do I save it as?  
> Would Microsoft Word work for this?  Otherwise I have Notepad and 
> Wordpad.
> 
> For 3) Will Yahoo or MSN through Amiquote have a feature to get all 
> of the price/volume history rather than just getting the last two 
> years worth?  Will it matter that XYZW has been trading for 1.5 
> years and ABCD has been trading for 7 years?
> 
> For 4) it sounds like you are saying that Amibroker will not 
> automatically deal with ticker symbol changes, new listings, and 
> delistings.  I should do this on my own.  Is that correct?
> 
> Thanks in advance,
> 
> Jim
> ---------------------------------------------------------------------
> --- In amibroker@xxxxxxxxxxxxxxx, "ed2000nl" <pablito@xxxx> wrote:
> > what you could do:
> > 
> > 1) make a list of tickers you want to follow and put it in a file 
> looking
> > for example like:
> > 
> > CSCO
> > MSFT
> > AMAT
> > APOL
> > 
> > 2) then you put these tickers inside a watchlist. Go to Symbol | 
> Watch list
> > | Import
> > and put the symbols in one of the lists that is free.
> > 
> > 3) Now, if you need historical data for this list you can use this 
> same file
> > (with all the symbols) and feed it to Amiquote and use either 
> Yahoo, or MSN
> > to get the free historical quotes.
> > 
> > 4) If you need to update this watchlist regularly you could just 
> delete it
> > and import the updated version.
> > 
> > Ed
> > 
> > 
> > ----- Original Message -----
> > From: "Jim" <bankedout@xxxx>
> > To: <amibroker@xxxxxxxxxxxxxxx>
> > Sent: Saturday, December 27, 2003 8:00 PM
> > Subject: [amibroker] Ticker Lists and Price Histories
> > 
> > 
> > > Hello,
> > >
> > > I have a couple of questions about ticker symbol lists and price
> > > histories.
> > >
> > > With the ticker symbol lists, I want to have my database cover 
> the
> > > Nasdaq National Market and Nasdaq Small Cap Market.  I don't 
> want to
> > > include the OTCBB's or NYSE or AMEX at this time.  Can I do that?
> > > If so, how?  I can get the ticker symbols I want in to Excel no
> > > problem.  They are available at the Nasdaq site or with the 
> Multex
> > > screener.
> > >
> > > Does Amibroker update itself for ticker symbol changes, new
> > > listings, delistings, etc?  Nasdaq posts changes like that here:
> > >
> > > http://www.nasdaq.com/asp/symbolchangehistory.asp
> > >
> > > Or
> > >
> > > http://www.nasdaq.com/reference/ipos.stm
> > >
> > > In building the initial historical databases for my list of
> > > securities, the example given in the User's Guide showed 
> downloading
> > > 2 years of OHLCV from Yahoo.  I want to download the entire price
> > > histories.  Is that possible?  If so, how?  Also, how much space
> > > should I expect to use on my computer to store all of the data 
> that
> > > Amibroker uses?
> > >
> > > Thanks in advance,
> > >
> > > Jim
> > >
> > >
> > >
> > > Send BUG REPORTS to bugs@xxxx
> > > Send SUGGESTIONS to suggest@xxxx
> > > -----------------------------------------
> > > Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> > > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > > --------------------------------------------
> > > Check group FAQ at:
> > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > >
> > >
> > > Yahoo! Groups Links
> > >
> > > To visit your group on the web, go to:
> > >  http://groups.yahoo.com/group/amibroker/
> > >
> > > To unsubscribe from this group, send an email to:
> > >  amibroker-unsubscribe@xxxxxxxxxxxxxxx
> > >
> > > Your use of Yahoo! Groups is subject to:
> > >  http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> 
> 
> 
> Send BUG REPORTS to bugs@xxxxxxxxxxxxx
> Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
> -----------------------------------------
> Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
> 
> 
> Yahoo! Groups Links
> 
> To visit your group on the web, go to:
>  http://groups.yahoo.com/group/amibroker/
> 
> To unsubscribe from this group, send an email to:
>  amibroker-unsubscribe@xxxxxxxxxxxxxxx
> 
> Your use of Yahoo! Groups is subject to:
>  http://docs.yahoo.com/info/terms/ 
> 
> 
> 

Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

Yahoo! Groups Links

To visit your group on the web, go to:
 http://groups.yahoo.com/group/amibroker/

To unsubscribe from this group, send an email to:
 amibroker-unsubscribe@xxxxxxxxxxxxxxx

Your use of Yahoo! Groups is subject to:
 http://docs.yahoo.com/info/terms/