I have been doing daily this type of job.
Bombay stock exchange releasing csv file daily about the transactions done on all scrips which were loaded in to excel worksheets and data analysis such as scripwise movements, graph, year high and low calculations being done.