A tool for Fundamental Analysis

#63
I have enclosed the result sheet1 and the data sheet2 for Maharashtra semmless

as you can see from the second sheet I have cut past the details from the URL http://*********/finance/equity/quotes/eqquotes.php?code=MYSM.B&charttype=OneYear&duration=365 and have taken the current price DPS and EPS details to sheet 1

In the second part of the sheet2 the details are from URL for ratios http://*********/finance/equity/quotes/ratios.php?code=MYSM.B

5year EPS DPS and Book value are taken to sheet 1 (the data have a blank space which needs to be removed manually to make them work in the equations)

the year high low details are in the first page copied from URL http://*********/finance/equity/quotes/yearhilo.php?code=MYSM.B

If there is any split adjustment needs to be made manually,

if the above required information can be downloaded in the the sheet automatically from any source it will be great and will save lot of time in short listing
 

tanewbie

Well-Known Member
#65
Thanks Suresh for giving the urls.

As I see from the url, only symbol name changes rest all part of URL remains the same. So to attempt to automate we need the symbols used by sify. IF it is hte same used by nse then it should be eay. Else we need to find out their logic of giving the symbol name.

Till we get to this, you can short list companies for which you want data. I willtry to automate the process of downlaoding. Meanwhile have a look at the format of data I hv attached earlier for all nifty stocks. If tht format is ok with you let me know.

Regards
 

tanewbie

Well-Known Member
#66
Hi Suresh

you did not reply regarding the format of the data of nifty stocks which I had attached earlier. with the help of a friend I am trying to automate the downloading data for 5 years easily.

Just request any company data I will provide it to u.
 
#68
analysis of GRASIM

Hi friends,
here is an analysis of Grasim using excel sheet by Suresh. The 2001 price datas are assumed as I couldnt get them anywhere. Rest all datas are fairly accurate mostly got from way2wealth, *****,etc. Kindly give your comments after carefully studying the sheet. Please throw light whether it is a good value buy.
dinesh
 

columbus

Well-Known Member
#69
Re: analysis of GRASIM

Hi friends,
here is an analysis of Grasim using excel sheet by Suresh. The 2001 price datas are assumed as I couldnt get them anywhere. Rest all datas are fairly accurate mostly got from way2wealth, *****,etc. Kindly give your comments after carefully studying the sheet. Please throw light whether it is a good value buy.
dinesh

GRASIM is a good stock with bookvalue 887 and with EPS at 214. At the same time a costly stock at 1936/- .Since it is losing value continuously ,better to WAIT.
 
#70
Please find the link below that will give you the theory behind the tool

http://www.sigma-cap.com/wwwhome2/warren_buffet.htm


please use if you find it useful only as a stock screener, In one glance you can get some critical info about the status of the company and stock price.

1. it tells you the current PE and historical PE highs and lows
2. gives the ROE, PBV, Dividend yield current and historical
3. With little additional work one can calculate EPS growth rate
4. A simple Projection based on historical growth
5. and a projection based on ROE and reinvested capital

In most cases the model tells you clearly reasons for a stock quoting at the price that it is quoting

Please bear in mind
1. All the calculations are based on historical values and with no consideration for future
2. Needs adjustments if the stock had bonus/split in the last 7 years
3. You will need many years to realize if the model works or not

Regards
Suresh Kumar
Hi! Suresh
I don't know what people call it! But i think should be called Social Work!
Keep up the tempo!
Thank you!