Basic fundas of all cos in 1 excel sheet

[tanewbie]

fundas as of 06/09/08


Import with the same format file we created earlier.

 

[deepakpaij]

hi,
Could anybody tell me where i have gone wrong, i have attached a SS,im getting the data perfectly for the (fundamental data of other companies) but when i do it for Nifty cos and otheres including the most recent funda , im getting all '0".no error messages,just zeros every where.i have copied the parameters separately as mentioned and no where were they cross matched,,,so the problem is something which i could not understand, could anybody help please.

 

[deepakpaij]

fundas as of 06/09/08


Import with the same format file we created earlier.

Sir,
could you please give the format again, i think im getting it wrong,im getting the bse code in the plce of face value.

 

[deepakpaij]

hi Ken

the syntax is
GetFnData("ReturnOnEquity");
GetFnData("ProfitMargin");

Put the following just above the filter and below r1

r2=GetFnData("ReturnOnEquity");
r3=GetFnData("{ProfitMargin");

In the title section u can add

+" RONW= "+WriteVal(r2,1.2)+"%"+ " ROCE= "+WriteVal(r3,1.2)+"%"



cheers

Thanks a lot guys,,but it would be a great favour if you could load the whole afl, messed up the whole thing, heard of all taxes not syntax, please guys, do this favor please.

Warm regards,

 

[tanewbie]

here is the afl for viewing fundas in amibroker.Unzip it and use it.

 

[deepakpaij]

hi,
Thank you so much for the prompt help,, could you please check the attached file and tell me if i got the values right..i think i have the last updated qtr date in ROCE.Please let me know what to do,..

Thanks a lot for the help.

 

[tanewbie]

i think u hv imported it wrongly
post the format file and we can see where is the problem

 

[tanewbie]

hi deepak
go to http://www.traderji.com/fundamental...ndas-all-cos-1-excel-sheet-17.html#post209123

and import the nifty companies ratios again. use th e format given in the link

 

[tanewbie]

Hi
here is update of fundas (finance and some cos not included) as of 190908
next update 25 oct 2008.

Format to be used:
# 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,RETURN_ON_ASSETS


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

 

[tanewbie]

FOR those who want the excel file,
download from:
http:// zurl.ws/eu