Basic fundas of all cos in 1 excel sheet

[kenneth]

Created a .TLS file from your spread sheet and imported into the F & O Watchlist.

Regards
Ken

 

[kenneth]

Thanks Tanewbie. Appears like the margin is shown as 25% for all stocks where as it varies from stock to stock. I have attached a spread sheet as per Geojiit margins.

Regards
ken

 

[tanewbie]

hi

Here is a csv with ROCE and RONW for companies included in Nifty only.

Since there is no field for ROCE, we will use PROFIT_Margin field to store ROCE.

Format to be used is:

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, Fullname, PROFIT_MARGIN, RETURN_ON_EQUITY, Skip, Skip, Skip
$SKIPLINES 2
$SEPARATOR ,
$CONT 1
$GROUP 255
$DEBUG 1
$NOQUOTES 1
$ALLOWNEG 1

 

[piyushonline]

hi,
I am not able to download the fundamental data worksheets. What word to be used for replacing the astericks.

Your help will be greatly appreciated.

hi

Here is a csv with ROCE and RONW for companies included in Nifty only.

Since there is no field for ROCE, we will use PROFIT_Margin field to store ROCE.

Format to be used is:

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Ticker, Fullname, PROFIT_MARGIN, RETURN_ON_EQUITY, Skip, Skip, Skip
$SKIPLINES 2
$SEPARATOR ,
$CONT 1
$GROUP 255
$DEBUG 1
$NOQUOTES 1
$ALLOWNEG 1

 

[kenneth]

Thanks Tanewbie. Data has been imported but I am unable to get it in the Title bar.

"RONW="+ WriteVal( RETURN_ON_EQUITY),format=1.2),"%" +"ROCE="+ WriteVal(PROFIT_MARGIN,format=1.2),"%"

gives syntax error. Coul you please correct the error.

Thanks & Regards
ken

 

[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

 

[tanewbie]

5 year fundas of 1100 + of cos listed in nse

download from
http ://tiny .cc/wQKz6

 

[tanewbie]

Hi

Download fundas of all listed banks in a single excel workbook.

 

[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

 

[columbus]

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.