A tool for Fundamental Analysis

dinesh26 · #61 16th August 2008, 10:00 PM

hi,
from the standpoint of consistent high ROE the following scrips are at buy levels. Amtek Auto, Maharashtra Seamless, Marico,Blue Star, Gujarat Gas,Pidilite industries and Bharat Electronics. These companies have shown Consistent high Return on Equity and the current PEratios are attractive. Can be accumulated slowly.

sureshk123 · #62 17th August 2008, 11:23 AM

Quote:

Originally Posted by tanewbie

Hi Suresh

You are doing a great job. Let me know from whch site you download the financial data. Ican try to help u automate. Incase you need any specific details of any company please let meknow.

I can try to get the details for you.

Cheers

I am using the data from Sify which has 5 year data. economic times now has 7-8 years data in which case the year high low will still be from sify.

regards

tanewbie · #63 17th August 2008, 11:51 AM

Hi suresh

can you give the exact url of sify and ecotimes.
A sample url of any funda page you have accessed.

cheers

tanewbie · #64 17th August 2008, 11:55 AM

Suresh

I hv attached Financial overview of all nifty stocks.
See if this format is useful.

Till we automate it, u can put your requests for data for any company.

sureshk123 · #65 17th August 2008, 02:51 PM

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/quot...r&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/quot...hp?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/quot...hp?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

sureshk123 · #66 17th August 2008, 02:56 PM

use sify comfor the *

and the attachment is here

tanewbie · #67 17th August 2008, 03:21 PM

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 · #68 25th August 2008, 07:49 AM

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.

dinesh26 · #69 28th August 2008, 09:59 PM

Thanks suresh for your valuable inputs. This is the right time to do Buffet picking as valuations are low maybe lower furthur in coming months.

dinesh26 · #70 28th August 2008, 11:22 PM

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

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

The Following 2 Users Say Thank You to tanewbie For This Useful Post:
kenneth (17th August 2008), praveen taneja (17th August 2008)