A tool for Fundamental Analysis

[BULLpit]

hi

does anyone have a opinion on the broker firms such as sharekhan i shall gratefull for a reponse

 

[venkat1926]

sureshk123

I was intrested in your earlier posting giving the template for Buffet analaysis. I have done these analysis for some of the scrips I am interested in similar to what you have done on Rane Engines (left hand side of the sheet). I feel that in a fast developing economy like ours this type of analysis gives little too optmisitic valuation of the stock. this type of anallysis, in a develooped economy where EPS and other ratios move steadilly wtihout big jumps either side, may be more useful. these are some of the thoughts those came up. I am not an experienced investor and so my views may be wrong. Anyhow I would be interersted in your comments on my views. thanks.;

 

[dinesh26]

i bought Asian Electronics basedonits goodfundamentals. Since stock has depreciated around 15%. should i exit or add more. Is there any unfavourable news on the company?

 

[deepsa52]

Suresh and everybody else, I am new to trading in Indian Markets.I would appreciate if you can provide me some information on reliable and affordable fundamental data feeds ( for the retail investor ), and on fundamental multi factor screening and back testing softwares available for Indian Markets. If it is possible, I would rather not go through the pain of downloading and uploading weekly data.Otherwise, I will look through your past postings.

I want to combine both fundamental data and basic price momentum factors into a screener and I am primarily looking for filtering by value + momentum factors such as P/E, P/S , P/B, ROE, EPS vs last year., sales growth, and basic momentum factors such price change eg: 30 days ago vs 60 days ago and MAs. Intraday data is not important for me. I understand that some of the ratios I mentioned earlier can be calculated if the engine has an API or a proprietary language.
What would be your recommendation to go about this ?
Thanks,

 

[drshukla]

Hi

I have attached a fundamental anlyais tool and have compleated a sample analysis for ABB. Hope you will find the tool intresting and useful

Please help in validating the results for one and all


regards
Suresh

DeaSuresh,

Thanx for the tool,but i really really dont know how to use it.
i have read all the posts of the thread, visited many link as suggested but still could not fathm how to down load various data from economicstime staight in to your tool ?

kindly let me know step by step if possible.

i m little novoice in excel utility, pl bear with me .

thanx again.

kirti

 

[sureshk123]

Hi Kirti

Economic times website used to have 7+ year data, they have discontinued this and have only 3 year data available now. I don’t have any other data source for 7+ year data

Now I us the 5 year data from *********

I have to cut past the data from the website to do this and don’t have the required knowledge to down load automatically. I can share with you the step by step approach to do this but you should have a very clear understanding of the ratios and calculations used in the excel format. There is a lot of possibilities to include wrong data to get wrong results due to split, bonus etc.,

Regards
Suresh Kumar

 

[dinesh26]

hi,
welcome suresh after a long time. Howare ur investments faring? the index may go up to 14500 some say. So thatll the time to pick great values. i hope ur actively in research.
way2wealth gives good 5yr datas and ratios.

 

[sureshk123]

Hi

I had selected the following shares and made some very small purchases to track them actively. The result as of today is for you to see


Purchase price Current Price Profit / loss %
Automotive axels 496.88 493.75 -0.63
Rane Enginering 268.72 262 -2.5
Merck India 415.76 354 -14.85
Wyeth Ltd 524.16 446 -14.91


Automotive Axels moved up close to 600 but dropped back soon, Rane engineering has gone through de-merger and amalgamation in February my records need to be updated. Merck never moved up but keeps dropping when the market drops and looks more attractive then before. Wyeth was a recent purchase during the market peak in Jan and has fallen lesser then the sensex.

I got 2.5 % return as dividend from automotive axels and merck (would have been 5 % if I had bought Merck before March 07)

Many other stocks that I was tracking also have performed on similar lines. It has been a year now and there is no indication that the model will work or not work.

Regards

Suresh

I continue to invest through index fund SIP while increasing my purchases during major market crashes.

 

[san.man22]

i can't see anything in the attached sheet. can you please guide me how to use this sheet?

 

[Radhakrishnan K.P.]

Dear friends,


from where you can collect the data of a company?