MODRIKA official training partner of Religare, Indiabulls and Angel Broking is...
Microsoft excel and VBA Programming
The objective is to introduce students with comprehensive aspects of Algorithmic Trading and execution. It is designed for both buy and sell-side industry. This course involves a top-down approach to Algorithmic Trading, in which we will equip students with the identification of target markets and trading styles for Algorithmic Trading, identified the factors driving the growth of electronic trading with an overview of Electronic and Algorithmic Trading, designing trading strategies and their algorithmic components.
Students also get opportunity to work on trading terminals, learn infrastructure requirements, techniques of risk management and portfolio improvement and business strategies to protect the combative provide in Algorithmic Trading.
Students/Corporate cover courses in finance, financial economics, financial econometrics, financial mathematics, stochastic calculus, numerical methods, monte carlo simulation, derivatives modelling, portfolio theory, portfolio optimization, performance analysis and financial risk analysis. You instruct to write financial applications and derivative modelling programs in VBA / C++, C# Sharp, Easy language making use of the theories and methods you have learned. You get hands-on learning session on the commercial Financial Software applications from Thomson Reuters. You also acquire to do assets financial modelling using the advanced features of Excel.
|Introduction to EXCEL||00:00:00|
|Formatting a Workbook||00:00:00|
|Working with Formulas and Functions||00:00:00|
|Working with Charts and Graphics||00:00:00|
|Working with Excel Tables, Pivot Tables, and Pivot Charts||00:00:00|
|Managing Multiple Worksheets and Workbooks||00:00:00|
|Using Advanced Functions, Conditional Formatting, and Filter||00:00:00|
|Developing an Excel Application||00:00:00|
|Developing a Financial Analysis||00:00:00|
|Performing What-If Analyses||00:00:00|
|Connecting to External Data||00:00:00|
|Expanding Excel with Visual Basic for Applications (Excel 1)||00:00:00|
|Expanding Excel with Visual Basic for Applications (Excel 2 VBA)||00:00:00|
|INTRODUCTION TO EXCEL VBA||00:00:00|
|EXCEL VBA OBJECTS||00:00:00|
|SELECT CASE END SELECT||00:00:00|
|USING DECISION STATEMENT IN VBA||00:00:00|
|Excel VBA quiz||00:10:00|
No Reviews found for this course.