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

[amibroker] Re: NDX import



PureBytes Links

Trading Reference Links


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 --------------------~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/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/