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

[amibroker] Re: Symbol Info. From Excel



PureBytes Links

Trading Reference Links

--- In amibroker@xxxxxxxxxxxxxxx, "eyeofbrain" <eyeofbrain@xxx> wrote:
>
> Hello every one , I want to import the "Symbol Information"  data 
from 
> an Excel File , Can any one help .
> I  don't want to link a real time data from Excel , just a static 
> information about Symbols to be displayed  in "Symbol Information" 
> Window .
> 
> Thanx
>
Hello
Save the data in excel as csv file and use File/import ascii to 
import the data.
u have to define the parameters in format file.
The formar file I use is:
# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
#$FORMAT Skip, Skip, Ticker, Fullname, Skip, Skip, Skip, Skip, Skip, 
Skip, Skip, Skip
$FORMAT Ticker, RETURN_ON_ASSETS, SHARES_OUT, BOOK_VALUE_PER_SHARE, 
DIVIDEND, FREE_CASH_FLOW, EPS, OPERATING_MARGIN, 
EPS_EST_CUR_YEAR,FULLNAME,QTRLY_EARNINGS_GROWTH

$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 255
$DEBUG 1
$NOQUOTES 1
$ALLOWNEG 1
$OVERWRITE 1

See this pic of the data displayed in the title itself.
http://img516.imageshack.us/my.php?image=infyvm8.png

Hope this is of help to you,
cheers




Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
 
Yahoo! Groups Links

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

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> 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/