|
PureBytes Links
Trading Reference Links
|
Hi,
In addition to my last message.
A) Alternate method for point 4.
- Go to yahoo finance:In the box enter symbol enter ^NDX .
- On the subsequent page you click on components.
- On subsequent page select and copy all columns related to tickers
- Open MS Excel and past on first cell.
- Select and copy two first columns.
- Open MS Notepad and past text. The result is 2 columns of Tickers
and names separated by TAB.
- Save de text file (p.e. NDX.txt).
- Use this file to import data on AB (wizard import).
- wizard settings: ticker, full name, skip, skip, skip, skip, skip;
separator: tab; no quotation data.
B) Option to save symbols in tls format.
after point 7) use Amiquote to save symbols in tls format.
Kind regards,
Angelo
--- In amibroker@xxxxxxxxxxxxxxx, "Angelo Fonseca"
<angelo.fonseca@xxxx> wrote:
>
> Hi,
>
> I use the following procedure:
> 1- Open a new AB database
> 2- Create a new market (p.e. NDX) with categories (Symbol menu)
> 4- Create a cvs file with ^NDX stocks (see Natasha reply)
> 5- Read carefully the AB import wizard help and import the first 2
> columns (symbol and name)of the cvs file
> 6- If necessary use assignments organizer (symbol menu) to copy
> imported symbols to market defined in 2), etc.
> 7- Use auto-update quotes (tools menu) to import historical data
> from Yahoo. You can select the period in Amiquote menus.
> 8- Save the AB database
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, Natasha !!
<dynomitedoll_ddd@xxxx>
> wrote:
> > Hello Scott,
> > ___________________________________________________________
> > Scott <sworcester@xxxx> wrote:
> >
> >
> > Hello -
> > New user here. I am trying to import NDX historical quotes from
> yahoo.
> > I added the NDX symbol with Symbol/New (just like that, not
> ^NDX). I
> > saved the historical quotes file to my desktop, and then
activated
> the
> > Import Wizard and successfully imported it, but now I can't find
> the
> > file. I click on ^Ndx and it isnt there. Also, I must have messed
> > something up because I now see now graphs at all, not even for
the
> > DJI. Can someone help me? I am combtace on Yahoo if you are
online.
> >
> > Thanks,
> > Scott
> > --------------------------------------------------------
> >
> > Try this out,
> >
> > Go to yahoo finance:In the box enter symbol enter ^NDX .
> >
> > ON the subsequent page(top left hand side) you click on
> components.>> ON subsequent page bottom click add to portfolio.Do
> the same for the next 50 stocks also now you have your portfolio
for
> ^Ndx.Then for this portfolio at bottom click download to
spreadsheet
> and on your comp you have a csv file for the ^NDX.Open this csv
file
> and select the first column of the tickers and copy and paste in
> microsoft frontpage.Paste special as formatted paragraph.Then
using
> yourdown arrow key on keyboard and comma go thru the whole list
and
> add commas at end of tickers ( shouldnt take long maybe a
> minute).Again select all and cut and now paste special as normal
> paragraph.Now you have tickers as one paragraph.
> >
> > In your amibroker open SYmbol>>> watchlist >>>Type in
> symbols .Here you select a watchlist and copy paste your paragraph
> of symbols from front page.Then use amiquote to import data from
> yahoo.
> >
> > Hope this solves your problem .(Use ms-frontpage it is
> more convenient and has more features for text manipulation)
> >
> > -- N !!
> >
> >
> >
> > Warm regards,
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Do you Yahoo!?
> > Read only the mail you want - Yahoo! Mail SpamGuard.
------------------------ Yahoo! Groups Sponsor --------------------~-->
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~->
Check AmiBroker web page at:
http://www.amibroker.com/
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/
|