VBA For Financial Engineering & Modeling  Online 20 Hours Course
Join our VBA for financial engineering course (http://www.wiziq.com/course/19620vbaforfinancialengineeringandmodeling) & get 15% discount. Ask for discount code, email  info@qcfinance.in.
Website  http://qcfinance.in/
Youtube Channel  http://www.youtube.com/user/shivbhaktajoshi
With the above registration, you will also get access to all updates and premium membership at Qcfinance.in.
Class

Topic
 Duration 

1  Introduction to Programming in VBA  2 Hours 
2  Introduction to Quant Corporate Finance  2 Hours 
3  Data Types, Ranges & Cell Arrays  2 Hours 
4  Logical Operators & Control Flow  2 Hours 
5  Distributions, FRM, VAR  2 Hours 
6  Techniques For Handling Missing Data  2 Hours 
7  Investment Banking Quant  2 Hours 
8  Data Pulling Into Excel  2 Hours 
9  Portfolio Optimization  2 Hours 
10  Econometrics: Multiple Regression and Logistic Regression  2 Hours 
Course highlights:
 Learn VBA without learning programming.
 Feel the same as you are on an IB desk.
 A demo class can be registered as per convenience.
 Doubt clearing classes available.
 Option for one on one classes available on requests.
Course plan:
 Quant Corporate Finance (Investment Banking).
 Quant Equity (Equity strategies and indices).
 Time Series.
 Yield curve/Fixed Income/ABS.
 Binomial pricing MC/Hull white/BS/exotic options KMV.
 Portfolio at risk.
From VBA Programming point of view (Divided into following areas):
 Dependencies and removing arrows.
 Picking non blank cells.
 Selecting sheet and changing color.
 Selection vs. entire sheet.
 For loops, if end if loops, exiting loop, placing end, nestled for loop.
 Importing values from another sheet, without opening.
 Change manual to automatic formula computation.
 Data tables with one and two variables using VBA.
 With Command.
 Set Command.
 := used where?
 Selecting cell with specific values.
 Data tables.
 Combining array in a single cell using delimiter.
 type data validation, playing with ranges.
 VBA editing of data validation.
 playing with string to get the last value.
 playing with axis of charts formatting.
 Functions with many inputs.
 On Error.
 Option Explicit others.
 Selective clearing arrays rows ranges by clear command.
Some key points about the course:
 Requires absolutely no knowledge of programming.
 Provide introduction about all Quantitative roles in Investment Banking.
 Highly flexible and tailored as per needs of individual (1050 % Quant Finance & 1050% VBA).
 Sensitization on derivative, Quant Equity corporate IB, fixed income, Monte Carlo.
 Feel the same as you while you are on the IB desk.
 Examples with real data to enhance your Financial IQ.
 Under the applicability and use on Bloomberg or Reuters websites (Introduction to tickers, RIC).
 Real recent examples and real cases which are hot in the market.
 New Interpretation, terminologies, and basic IQ for the subject covered.
 Helpful for passing FRM, CFA, BAT exams also prepares for Master level studies in Finance or career change.
 Right mix of data handling, scripting, mathematical skills.
 Contains right blend of learning and practice (Ratio 6:4).
Below are the video description of the course and the ppts used:
Addon Module on Quant Corporate Equity. This could include quant index, beta computations, different style of index, equity derivatives, importance of volume traded, value growth differences, emerging and developed markets relations, how index are made, using ric ticker, etc equity database research, etc.
Addon Module on Financial Risk: This could include MonteCarlo, VAR, BS, Copulas pricing cdo, pricing exotic options, Modified BS models, EVT distributions, VLOOKUP, long data tables etc.
List of commands that we will use with references for selfstudy:
Param Array: Challenges and use of param array for dynamic number of inputs. Param array is itself added with GOTO command.
GOTO: Referring string named ranges Application.
GOTO Reference:=abc2
'Range("qrs").Value = Selection Value
Application GOTO.
http://msdn.microsoft.com/enus/library/office/ff839232.aspx.
The above command is used to go to a named range and select it. This is slower way to do the same.
Data Tables: Making data tables in vba, how to clear all update values, in other words enable/disable tables.
Setting default values from range to other named ranges: 2 column range and going to name using goto command and also storing value as string... clearing old values and difference between if error go to next and if error go to ext.
The On Error Statement: http://www.cpearson.com/excel/errorhandling.htm.
Application.Union: Takes union of ranges.
This can be used to take union of ranges that are defined at different places.
http://www.cpearson.com/excel/BetterUnion.aspx
Call function in VBA is used to call functions based on name and parameters
http://msdn.microsoft.com/enus/library/sxz296wz(v=vs.80).aspx
http://msdn.microsoft.com/enus/library/office/aa204537(v=office.11).aspx
Expression will calculate the range means I think it is like replacing = with =
Sub procedure
http://msdn.microsoft.com/enus/library/dz1z94ha(v=vs.80).aspx
.activate
http://msdn.microsoft.com/enus/library/office/ff194565.aspx.
Function overloading in MATLAB is an interesting area, it is like defining function adhoc that will be used that time only and I think activated during the lines are used
Referencing in VBA (byRef ByVal):
http://msdn.microsoft.com/enus/library/bb190882(office.11).aspx
Excel functions used commonly:
By val / reference
http://www.techonthenet.com/excel/formulas/index_vba.php
http://roymacleanvba.wordpress.com/2009/05/01/byrefandbyval/
.add
http://msdn.microsoft.com/enus/library/office/aa221688(v=office.11).aspx
Other courses that you can refer to:Demo Course structure:
http://www.vtc.com/products/MicrosoftVisualBasicforApplications(VBA)Tutorials.htm
Given below is the playlist that will have all the videos related the course:
Contact Details: shivgan@qcfinance.in, arpit@qcfinance.in (Arpit).
Contact Us for more details: info@qcfinance.in.
Difference between range and arrays and how to count, access, arrange, play with them is a thing that you need to eb careful.
ReplyDeleteFor i = n To 1 Step 1
ReplyDeleteIf IsNumeric(rng(i)) And Not IsEmpty(rng(i)) Then
WFI9 = rng(i)
Exit For
Exit For
Else: WFI9 = ""
End If
The sequence in which For For End if and blank assigned is very imp.
Exiting loop
ReplyDeleteusing text book
checking values otuside
usign goto
using exit function
cascaded loops
Param array
ReplyDeleteQuant Investment banking VBA course
run Quant methods for IB things
serchin two dimensiosn in nelsted loop
ReplyDeleteoverridei valeus from avtriou palces
stock adjuemetns spitl on ivesamten bnanong data
Synenrgy modeling, ev/ebitda modeling, other quant methods to optimize and look at scnerios.
ReplyDeleteThis comment has been removed by the author.
ReplyDelete.goddardconsulting financialengineering.htmlCached
ReplyDeletecan rohit makit liek that?
can you use forwarder wit qc finance in?
can you email rohit to make th website int hat formt using thigns bernatim
we should not use yahoo or gmail ids
we shoudl qcfinancl.in ids
Indpende session on param arrays...
ReplyDeletehwo to sue them
passsig by valeu by rpeference..
examles to compute alstnumber, indexing etc...
Bigges rreouces,
ReplyDeleteembedding onw esbite
VBA Class 1 and 2
abb astra gof papers to the qcfinacne
focus on research publications that i the key
linking gt with mc
logical end of all papers
This comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDelete