Using Excel

Can any1 tel me how do i calculate the beta,votality ratios for stocks on telecom sector and how can i compare them and kow which stocks can be bought/sold etc using EXCEL

In the absence of CV, send a PM to oxy. He is the boss of excel, we are mere students.

In simple words you can't until you have all the historical data for each stock.
Also writing a Macro for excel will be too complicated.

As a financial engineer working for Hedge fund in NYC I can tell you its not a simple task. Rather than using excel you can use some website to this job for you. Some of these site are bloomberg, ***** finance advance tool, marketsimplified and macroaxis.

this might help you folks

http://exceltrader.blogspot.com/