Basic fundas of all cos in 1 excel sheet

kenneth · #**161** 22nd August 2008, 12:37 AM

Thanks Tanewbie.

Any shortcuts
1. to import F&O watchlist or create one.
2.Create a list
VarSet("ABAN",50);
VarSet("ABB",250);
VarSet("ABIRLANUVO",200);
VarSet("ACC",188);
VarSet("ADLABSFILM",225

VarSet("ABANI",16);
VarSet("ABBI",16);
VarSet("ABIRLANUVOI",16);
VarSet("ACCI",15);
VarSet("ADLABSFILMI",17);

Regads
Ken

kenneth · #**162** 22nd August 2008, 01:10 AM

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

Regards
Ken

kenneth · #**163** 22nd August 2008, 06:22 PM

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 · #**164** 24th August 2008, 10:16 PM

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 · #**165** 25th August 2008, 03:15 PM

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.

Quote:

Originally Posted by 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

kenneth · #**166** 25th August 2008, 04:37 PM

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 · #**167** 25th August 2008, 04:45 PM

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 · #**168** 27th August 2008, 01:15 AM

5 year fundas of 1100 + of cos listed in nse

download from
http ://tiny .cc/wQKz6

tanewbie · #**169** 29th August 2008, 09:15 PM

Hi

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

tanewbie · #**170** 3rd September 2008, 07:34 PM

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

Similar Threads for: Basic fundas of all cos in 1 excel sheet
Thread	Thread Starter	Forum	Replies	Last Post
Excel Sheet	chand	Software	17	31st August 2009 08:03 AM
datas in excel sheet	gopu	General Chit Chat	5	22nd April 2009 04:51 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

The Following User Says Thank You to tanewbie For This Useful Post:
chintan786 (25th August 2008)

The Following 3 Users Say Thank You to tanewbie For This Useful Post:
chintan786 (25th August 2008), deepakpaij (16th September 2008), kenneth (25th August 2008)

The Following 2 Users Say Thank You to tanewbie For This Useful Post:
chintan786 (27th August 2008), J_D (27th August 2008)

The Following 2 Users Say Thank You to tanewbie For This Useful Post:
asterix24 (30th August 2008), chintan786 (29th August 2008)