A tool for Fundamental Analysis

dinesh26 · #41 5th October 2007, 09:21 PM

Quote:

Originally Posted by faltub

Hey Gyes
Is there any tool for mental analysis ?

Want to analyze mine.

F

Hi
Your portfolio analysis is itself a tool for your mental analysis.This is because successful investing is 10% analysis and 90% attitude.

sureshk123 · #42 11th October 2007, 12:06 PM

Rane Engine Valves

The positives are in the numbers attached have also added a few more statistics, the negatives are as below

The 1st qtr results was very bad with a EPS of 2.54 and if the poor performance continues then the year end EPS could end up at approx 10 which means the stock is trading at high 27-28 times FY2008 earnings and might get lot more cheaper during the year or till turnaround for the company and the Auto Industry

According to a news article : At the end of FY08 Rane Engine shareholders will get 100 shares in the spun-off firm and 56 shares in Rane Holdings for every 100 held.) Don’t know if this is going to add value to Rane Engine Valves.

Regards

Suresh Kuamr

BULLpit · #43 11th October 2007, 02:00 PM

hi

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

venkat1926 · #44 11th October 2007, 03:49 PM

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 · #45 4th December 2007, 10:13 PM

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 · #46 6th December 2007, 05:05 AM

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 · #47 6th March 2008, 01:33 AM

Quote:

Originally Posted by sureshk123

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 · #48 9th March 2008, 08:02 PM

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 · #49 9th March 2008, 10:14 PM

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 · #50 12th March 2008, 06:47 PM

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.

Similar Threads for: A tool for Fundamental Analysis
Thread	Thread Starter	Forum	Replies	Last Post
Tool for tech analysis	younggenius	Technical Analysis	3	16th December 2006 02:31 PM
Technical Analysis Vs Fundamental Analysis	omega	Technical Analysis	1	28th September 2006 02:49 AM
Please check this Free Technical Analysis Tool	ping_manoj	Technical Analysis	1	10th August 2006 07:27 PM
Which is the best free charting n technical analysis tool available?	Sanjay123	Data Feeds	4	15th June 2006 07:59 PM
MS analysis tool	cmlee	MetaStock	3	2nd April 2005 09:45 PM