Basic fundas of all cos in 1 excel sheet

columbus · #**171** 3rd September 2008, 08:18 PM

Quote:

Originally Posted by tanewbie

Check the fundas of Chi Investments symbol CHI

Its the holding company of RPG group.
BV 113+ cmp 32+
discount of 71%

I amcollecting info about the market valu of its investments. I expect the discount to be over 80%

keep a close watch and dig deep for info abt its investments.
52 week low is 27

cheers

tanewbie,

Thanks for the info. Apart from watching BV ,it is better to have a look at EPS & OPM also.Certainly CHI deserves to be on the watchlist.

tanewbie · #**172** 6th September 2008, 10:49 PM

fundas as of 06/09/08

Import with the same format file we created earlier.

deepakpaij · #**173** 14th September 2008, 04:47 AM

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 · #**174** 14th September 2008, 02:24 PM

Quote:

Originally Posted by tanewbie

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 · #**175** 16th September 2008, 02:52 AM

Quote:

Originally Posted by tanewbie

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 · #**176** 16th September 2008, 06:51 PM

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

deepakpaij · #**177** 16th September 2008, 08:10 PM

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 · #**178** 16th September 2008, 08:23 PM

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

tanewbie · #**179** 16th September 2008, 08:37 PM

hi deepak
go to http://www.traderji.com/fundamental-...tml#post209123

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

tanewbie · #**180** 20th September 2008, 10:56 PM

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_A SSETS

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

Similar Threads for: Basic fundas of all cos in 1 excel sheet
Thread	Thread Starter	Forum	Replies	Last Post
Excel Sheet	chand	Software	9	2nd May 2007 07:02 PM
Getting live datas from webpage to Excel Sheet	navino87	Software	5	20th February 2007 12:06 AM
CGTax calculation spred sheet	akh024	Taxation Matters	0	30th August 2006 06:24 PM
stock fundas, please!	bhangima	Equities	7	12th June 2005 01:17 PM
datas in excel sheet	gopu	General Chit Chat	1	28th October 2004 08:46 AM

The Following 4 Users Say Thank You to tanewbie For This Useful Post:
chintan786 (6th September 2008), deepakpaij (16th September 2008), kenneth (7th September 2008), ragsid (8th September 2008)

The Following User Says Thank You to tanewbie For This Useful Post:
deepakpaij (16th September 2008)

The Following 2 Users Say Thank You to tanewbie For This Useful Post:
chintan786 (20th September 2008), deepakpaij (20th September 2008)