This course equips the participant to understand the concepts and techniques relating to Technical Analysis of price and volume of securities traded in stock exchanges based on real data with the help of MS Excel and VBA. At the end of the course the participant will have the confidence and skills required to analyse the price movements and to make informed decisions as a prospective analyst or investor.

This program consists of the following modules based on live data.

1. Downloading of Data from the Website of the Stock Exchange
2. Collating the Data
3. Cleaning  the Data
4. Arranging the Data
4. Segmenting the Data
5. Computing the Statistics
6. Preparation of Charts
7. Analysis and Presentation of Data and the Analysis
Application of MS Excel and VBA all throughout the Modules