I want to compare all company PE for particular industries in single sheet.?

Which website

www.nofreestuff.com

ss

Well! you are the same person...advertising ur website...
got..u!

Now, asking which website....whats going on..???

Are u out of ur mind??

Traderji must see this.

RON.(POLICE 007)

Police sir Plice sir am not have any website's.
I advert my favorite websites only.

For this:
1) You need to pay for fundamental data
2) Make the data compatible with excel
3) Classify stocks into sectors
4) Calculated a weighted average PE of the stocks which represent the sector.
5) Do PE comparision

The process would have been simplified had you been living in the US (Plenty of data vendors) or Australia (Paritech provides metamarket +).
If you want to do this for Indian stocks, it's going to cost you around 15K a year and hell of a lot of time coding and recoding
Maybe someone has a better solution

or you could just buy the dalal street journal for Rs50/ per issue and use the databank towards the end, which should be sufficient.

Can't help u with the excel bit though but I'm sure some of our techie friends can

Police sir Police sir am not have any website's.
I advert my favorite websites only

try stockscreener in icicidirect.com

Inform Pleasure

I inform my pleasure thre is nobody clear response so i found my own risk.

If any body need this information please click here

This is informed me which is low PE ratio in particular sector.
I believe this ratio is very useful of the fundamental analysister.
Any body want to discuss with me for over bought/sold ratio. EgE

http://www.investsmartindia.com/profile/AboutCompany.aspx?mno=4&index=0&id=12&code=771

My botheration is over.

Compare PE

Eg:
Cement sector which is low pe
Kakatiya Cements 4.08 this PE will move up tend 5.97,13.97 high value PE.

My calculation is TRUE r FALSE
Please discuss with me