Basic fundas of all cos in 1 excel sheet

[karthikmarar]

Dear Vish

Thanks for your file.

Unfortunately the Fundamental data that can be specified in Amibroker are as follows

DIV_PAY_DATE
EX_DIV_DATE
LAST_SPLIT_DATE
LAST_SPLIT_RATIO
EPS
EPS_EST_CUR_YEAR
EPS_EST_NEXT_YEAR
EPS_EST_NEXT_QTR
FORWARD_EPS
PEG_RATIO
BOOK_VALUE (requires SHARES_OUT to be specified as well)
BOOK_VALUE_PER_SHARE
EBITDA
PRICE_TO_SALES (requires CLOSE to be specified as well)
PRICE_TO_EARNINGS (requires CLOSE to be specified as well)
PRICE_TO_BV (requires CLOSE to be specified as well)
FORWARD_PE (requires CLOSE to be specified as well)
REVENUE
SHARES_SHORT
DIVIDEND
ONE_YEAR_TARGET
MARKET_CAP
SHARES_FLOAT
SHARES_OUT
PROFIT_MARGIN
OPERATING_MARGIN
RETURN_ON_ASSETS
RETURN_ON_EQUITY
QTRLY_REVENUE_GROWTH
GROSS_PROFIT
QTRLY_EARNINGS_GROWTH
INSIDER_HOLD_PERCENT
INSTIT_HOLD_PERCENT
SHARES_SHORT_PREV
FORWARD_DIV
OPERATING_CASH_FLOW
FREE_CASH_FLOW
BETA


Will it be possible to provide similar data, some if not all.

Also please elaborate on CPS and NP(presume Netprofit) in your file

Thanks

Regards

 

[tanewbie]

Dear Karthik
Steps to import fundas:

Create any format file but save the settings as Funda format.

now open funda format file thro notepad and replace all of its contents with

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard

$FORMAT Ticker, FULLNAME, SHARES_SHORT, ALIAS, SHARES_OUT, BOOK_VALUE_PER_SHARE, DIVIDEND, FREE_CASH_FLOW, EPS, OPERATING_MARGIN, EPS_EST_CUR_YEAR,QTRLY_EARNINGS_GROWTH


$SKIPLINES 5
$SEPARATOR ,
$CONT 1
$GROUP 255
$DEBUG 1
$NOQUOTES 1
$ALLOWNEG 1

and save and exit the funda format file. Now go to ami to ile/import ascii and select the nse funda file and the funda format and import.

Thats all to do to import.

Now I am attaching a afl which will display alll fundas int he chart


See attached afl and a sample chart of RIL with fundas

 

[rmike]

Dear tanewbie,

The brilliance and elegance of simplicity!!! Really too good for words. Many thanks

Regards,

 

[kenneth]

Dear tanewbie,

I have created the Funda format file in the Format folder. When I File>import ASCII>nsecfandabhavo010808> Fanda format is not available in Files of type. Could you please advise what need to do.

Thanks & Regards
ken

 

[tanewbie]

hi Ken

when u create a format file, th import ascii picks the last used format file or last created format fie automatically.
You may hv made a mistake while saving the settings.

Steps again:
File/importwizard and select any bhav copy and select the right columns as per the bhav copy and proceed. when u come to saving th settings

tick (or check) add current settings to ASCII importer definitions

description: funda
format file name: funda.format

do these steps and exit by clicking finish

then open the just created funda format file thro notepad and replace the contents of it with what I hv mentioned earlier and save it.

Now u r ready to import the fundas with this format file.

cheers

 

[kenneth]

Dear Tanewbie

Struggled to create Import wizard format.The bhav copy gives the following coloums.
SYMBOL SERIES OPEN HIGH LOW CLOSE LAST PREVCLOSE TOTTRDQTY TOTTRDVAL TIMESTAMP
3IINFOTECH EQ 114.5 119.9 111 115.95 116.6 113.85 730784 85594554.15 7-Aug-08

unable to create.

Could you please give the coloum names to pick.

Thanks & Regards
ken

 

[tanewbie]

select the columns as it appears in the bhav copy.
actually there is a preview of the copy at the bottom.

SYMBOL SERIES OPEN HIGH LOW CLOSE LAST PREVCLOSE TOTTRDQTY TOTTRDVAL TIMESTAMP

will be

TICKER, SKIP,O,H,L,C,SKIP,SKIP,VOL,SKIP,DATE(D/M/YY)

 

[kenneth]

Thank you very much Tanewbie. I have attached chart of Reliance. Face value and marketcap are not seen .What could be the reason.

Thanks & Regards
ken

 

[tanewbie]

u r right Ken

The funda bhav copy though face value but the format file did not hv the field to import it as for some reason it does not import more than 12 fields.

Now create another format file and save it as fundaFV and opn it thro notepad and replace all of its contents with
# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, Fullname, RETURN_ON_ASSETS, Skip, Skip, Skip, Skip

$SKIPLINES 5
$SEPARATOR ,
$CONT 1
$GROUP 255
$DEBUG 1
$NOQUOTES 1
$ALLOWNEG 1

and use the attached fv csv

NB:Right now v r using Return on assets field for storing Face value.


Added
Please reimport the fundas file again as there was error in arranging the columns especially TTM eps column and OPM

 

[renu daga]

i ma concerned if this can be done in meta,,, wonder ..NO

but superb,,, guys u ahve done very good no need to open ET

renu