VBA Consultancy in NYC

Importing csv:
http://www.homeandlearn.org/open_a_text_file_in_vba.html

Charts:
http://www.homeandlearn.org/vba_charts_sheets.html

List of Files:
https://trumpexcel.com/list-of-file-names-from-a-folder-in-excel/



Excel VBA Course Lesson 1: Introduction to VBA and Recording Macros
 Lesson 2: The VB Editor
Lesson 3: Writing VB Code - Introduction to Variables, Decision and Looping Controls Lesson
4: Graceful Error Handling Lesson
5: Excel Functions, User Defined Functions, and Workbook Events Lesson
6: Object Variables, Array Variables, Indefinite Loops Lesson
7: User Forms and Controls Lesson
8: Excel Resources

Vba (Visual Basic) Programming.
Custom Access Database Design And Development.
Spreadsheet Design And Editing.
We Can Build Your Solution In Excel, Access, Mssql, Mysql, Oracle, And More.
Output Reports In Almost Any Format. (Pdf , Excel, Word, Etc)
Automate Time-Consuming Process In Excel Or Access
With Macros And Vba (Visual Basic For Applications)
Routines, Saving You Hours Of Time Doing Labor Intensive
Tasks.


We Assist Small Businesses By Creating Solutions In Microsoft Excel And Access.
• Automate Reporting
• Write Macros To Improve Your Workflow
• Cleanup Outdated Data
• Create Custom Forms Or Surveys (For Internal Or External Use)
• Build Customer Relationship Management (Crm) Systems
• Build Databases

Over Five Years' Experience Creating Solutions For Companies Large And Small.

Successful Projects Include Building A Tracking Database For A Start-Up Drug-Testing Laboratory, Creating A Customer Relationship Management System For An Oil & Gas Services Company, And Developing A Custom Macro To Assist With The Collection Of Data And Automation Of Processes.

Key Words: Excel, Access, Word, Outlook, Vba, Sql, Programming, Programmer, Customized, Ms, Mso, Microsoft, Solutions, Graph, Chart, Module, Report, Designer, Design, Writing, Report Writing, Automate, Workbook, Worksheet, Database, Code, Function, Consultant, Free-Lance, Macro, Analysis, Query, Spreadsheet, Tool, Table, Crm, Customer Relationship Management

Do you need your business to run more efficiently?

I have been developing custom Microsoft Access datatbase and SQL Server database applications in and around the New York area for over 15 years. From small businesses to Not For Profit Organizations to large corporations, my work has saved my client's time and money. I have done work for such companies as ABC, among others. I have experience in the following fields: Accounting, CRM Systems, Hedge Funds, Trading Systems, Budgeting, Inventory, Medical Recordkeeping, and many other diversified experiences.

Many companies have their business spread out in different formats using different programs. I will combine your business into one program, thus making your business run more efficiently. A professionally developed client server Access application can save your company time and money.

For most small and medium projects, Access provides all the tools and facilitates rapid development. Many times companies try to develop these type of applications in-house and run into multiple problems. I can take a project that was started and complete it in a timely fashion. I can develop applications from scratch, or upgrade existing applications, or convert a current program into Access.

My applications are solidly coded using object-oriented VBA techniques, DAO, ADO, ODBC, etc. not a collection of macros. This includes installation of the program and I will provide training and documentation if requested.

My work will save your company time and money and that is the bottom line. Also include a brief description of your project.

EXCEL FOCUSED
*** Automatic emails sent utilizing excel and outlook with the ability to send 100s at a time.
*** Macros to reduce daily processes spent on timely tasks.
*** Customized, automated, & streamlined reporting from small and large data sets

FINANCE FOCUSED
*** Financial modeling and analysis
*** Preparing business analysis and building valuation models to receive capital
*** Quoting and pricing tools that incorporate the use of forms

STUDENT/NEW JOB FOCUSED
*** Projects and assignment
*** Prove-It Tests
*** Tutoring

VBA Excel Classes in New York

Instructor led onsite VBA Class offers Excel classes in NYC for beginners, advanced Excel training, and Excel VBA training courses. Email or Call VBA Class to learn more about Excel.

VBA Consultant New York

Email us at new_york@Qcfinance.in / (929) 356-5046

We offer onsite lessons in NY and have tutors who are working with our team to be available in New York City, including Manhattan and also uptown.

VBA Class with no Prerequisites
We also offer a VBA Class online …
Excel Visual Basic Applications Class objectives:
Macros: Strengths and Weaknesses
How to Debug and Fix Macros, How to Handle Errors when they come
How to Utilize Variables and Arrays
How to Write Programs With the Visual Basic Editor
How to Use If/Then and For/Next Conditional Control Structures to Loop from Row to Row and Sheet to Sheet and Make Decisions
How to Call Excel Functions and Write New Functions
How to Create User Forms and Call Excel Dialogs
Helpful Resources And Much More

VBA Private Training

VBA Private Training We recognize that many clients have one-time projects for which they need specific assistance. Excel Training NYC offers private VBA training upon request. Hourly rates start at $30 (mixed of online and on location). More hours would qualify for a discount! These are mixed rates for onsite and online mix in New York / Manhattan areas.

Class Tags:
New York excel
New York visual basic
Union Square classes
Manhattan classes

We Serving New York and surrounding area.

A part of classes is taken onsite at a location in New York, a part online with the help of offshore team, and most of assignments are executed on your own system.

Locations that you are request are:
Mid Town, New York
Lower Mahatten, New York City
East Village New York City
Garment District in New York City

Offerings: I might help you to outsource some of the automation, programming and analytical tasks to Qcfinance India (I am one of the co-founders of the company since 2012). QCFinance helps startups with limited resource to be more efficient by providing solution aimed to enhancing valuations of small companies (5-20). Since I am in NYC, I will make sure that you are completely satisfied, and since I was a part of the team I know the team in India very well. In India, I have worked in Captives and 3rd Party service providers for various banks like: Deutsche bank (Index quant team), Wells Fargo (CIB), XL Catlin Investments (New York team).

Demo Pricing: You may even outsource a very small pilot project / training assistance @ $30-50/hour to start with! With mix of training and project outsourcing, you can make your employees more productive, also the automation of mundane task will enhance the value of your startup! All top investment banks and companies today have their offices in India hence India has become an important place to do business more than ever.

I have a strong belief that once you understand more about the Indian outsourcing industry you will have a better chance of using it to add value to your company.

How Qcfinance.in work with small companies:

How many times have you seen problems or opportunities for improvement in your workflow and promised to fix them if you only had the time or if you only could train your employees with such expertise?

Unforeseen, undocumented, forgiven, hidden cost of issues like below are bringing your valuations down:
Poorly-understood, legacy framework mostly into excel--dilapidated on unknown, unstated assumptions
Slow process of calculations
Un-scalable excel models that are difficult to maintain, improve, replicate or extend
Increased pressure, requiring added reporting and enhanced auditing
Lack of in-house research resources for SQL and R -- both of which are open source (free -- with no extra burden)
Over-reliance on external novel untested software from vendors

QCFin provide quant automation and programming solutions for removing tech hurdles, enabling financial and consulting companies to create more value in their systems and employers which increases the valuation for the firm.

Technologies: MATLAB, R, VBA, SAS, Latex, SQL others.

Analysis: From simple office tasks like automation of excel and latex reports to more complex tasks like Monte carlo simulations

Sample course:
LEVEL 1: EXCEL FUNCTIONS
1.1: INTRODUCTION
1.2: WORKSHEET FUNCTIONS
1.3: MATH/LOOKUP FUNCTIONS
1.4: COMPOUNDING
1.5: INTEREST RATES
1.6: DISCOUNT FACTORS
1.7: BOND PRICING
1.8: OFFSET
1.9: PIVOT TABLES
1.10: HOMEWORK PREP

LEVEL 2: VBA BASICS
2.1: SUBS/FUNCTIONS
2.2: VARIABLES
2.3: VECTORS
2.4: LOOPS
2.5: BOND PRICING
2.6: STATEMENTS
2.7: LINEAR INTERPOLATION
2.8: LINEAR INTERPOLATION - CODE
2.9: FORWARD RATE CURVE
2.10: FORWARD RATE CURVE – CODE
2.11: HOMEWORK PREP

LEVEL 3: OPTION PRICING
3.1: OPTION PAYOFF MODEL
3.2: BINOMIAL ASSET PRICING MODEL
3.3: BINOMIAL ASSET PRICING MODEL - CODE
3.4: BLACK SCHOLES

3.5: HOMEWORK PREP
LEVEL 4: CLASSES
4.1: CELL VS RANGE
4.2: USER DATA TYPES
4.3: COLLECTIONS
4.4 CLASSES
4.5: PORTFOLIO ANALYSIS
4.6: VALUE AT RISK
4.7: HOMEWORK PREP

LEVEL 5: DATA STRUCTURING
5.1: SELECTION
5.2: CHARTS
5.3: FILE MANIPULATION
5.4: USERFORMS
5.5: PIVOT TABLES - CODE
5.6: SQL IN VBA
5.8: INTERVIEW TIPS

5.9: CASE STUDY 



https://youtu.be/1Rk6FmpqVk0

https://youtu.be/z-EuWqEWVH8

http://www.tutoringhelp.org/tutors/NY/New-York/357241


Importing csv:
http://www.homeandlearn.org/open_a_text_file_in_vba.html

Charts:
http://www.homeandlearn.org/vba_charts_sheets.html

List of Files:
https://trumpexcel.com/list-of-file-names-from-a-folder-in-excel/

Workbook play:
https://analysistabs.com/excel-vba/open-close-existing-workbook/

Option Explicit:
https://wellsr.com/vba/excel/vba-option-explicit/

Screen Updating:
https://stackoverflow.com/questions/38122480/application-screenupdating-in-subroutine-called-within-subroutine

Run when worksheet is activated:
https://ccm.net/faq/5675-excel-run-a-macro-when-opening-a-sheet

Workbook open then activate:
https://www.mrexcel.com/forum/excel-questions/39172-auto-run-macro-when-open-worksheet.html

Addin VBA

Important links to study Addins in VBA

http://www.cpearson.com/excel/createaddin.aspx

http://www.me.utexas.edu/~me353/computation/addins/index.html

http://www.wiseowl.co.uk/blog/s238/using-addins.htm

http://fontstuff.com/vba/vbatut08.htm

www.natecarrier.com/module-3-creating-an-excel-add-in.html

Join our VBA for financial engineering course (http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling) & get 15% discount.

Ask for discount code, email - info@qcfinance.in.

Contact Us for More details: info@qcfinance.in

VB.net for Financial Engineering Links

VB.net for Financial Engineering Links:

http://www.quantcode.com/quantfinancejobs/csharp-dot-net

http://downloads.nevron.com/company/Modulus_Financial.pdf

http://www.prometeia.com/en/people/job-opportunities/-strong-junior-cenbsp-net-software-developer-strong--financial-risk-management.aspx?idC=63403&idO=15352&LN=en-US

http://www.amazon.com/Modeling-Financial-Markets-Management-McGraw-Hill/dp/0071417729

http://msfe.illinois.edu/msfe-courses

http://www.apress.com/9781852338329

Extreme optimization library: http://www.extremeoptimization.com/

Book: Benjamin Van Vliet - 2004 - Modeling Financial Markets Using Visual Basic Net And Databases To C.pdf

Join our VBA for financial engineering course (http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling) & get 15% discount. Ask for discount code, email - info@qcfinance.in.

VBA Missing Data

IF is number
IF is blank
IF is formula

Looping

if it used?

Range check

Change background

http://www.mrexcel.com/forum/excel-questions/466692-visual-basic-applications-code-return-missing-values.html


Other checks

Join our VBA for financial engineering course (http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling) & get 15% discount. Ask for discount code, email - info@qcfinance.in.

Avoiding On Error Resume next statements in VBA what is the road ahead then?

Avoiding Error statements in VBA what is the road ahead then?



Blank vs "" vs 0
Keeping there nothing
Keeping there ""
Formula giving "" or 0

NA is error
Div/0

All of them have their importance and implcation.

0 is different from isblank ... iszero.... is function... is date ... etc


These might become useful at times...

Also you can use 0 1 + etc while dealing with boolean which means true false 1 0 & and 



Explicitly handling error and not using error handlers is the key..

Sub errorp1()

Dim i, j As Double
For i = 1 To 5 Step 1
j = 1 / (i - 2)
On Error Resume Next
MsgBox j
'ignore the error and move ahead keeping last value
Next i
End Sub

Sub errorp2()

Dim i, j As Variant
For i = 1 To 5 Step 1
j = 1 / ((i - 2) * (i - 3))
MsgBox j
On Error GoTo ER
GoTo ER2
ER:
On Error GoTo 0
MsgBox "error"
Resume Next

ER2:
Next i

End Sub

'Notes
'http://stackoverflow.com/questions/...tween-on-error-goto-0-and-on-error-goto-1-vba
'http://www.excelfox.com/forum/f23/difference-between-on-error-goto-0-and-on-error-goto-1-a-894/
'On Error GoTo 0 disables any error trapping currently present in the procedure.
'On Error GoTo -1 clears the error handling and sets it to nothing which allows you to create another error trap.

Sub ErrorTest()

Dim dblValue As Double

On Error GoTo ErrHandler1
dblValue = 1 / 0
ErrHandler1:
MsgBox "Exception Caught"
On Error GoTo -1 'Comment this line to check the effect
On Error GoTo ErrHandler2
dblValue = 1 / 0
ErrHandler2:
MsgBox "Again caught it."

End Sub
Sub ErrorTestUserHandler()

Dim dblValue As Double

For lngloop = 1 To 10
On Error GoTo ErrHandler
dblValue = 1 / 0
ErrHandler:
MsgBox "Caught it."

On Error GoTo -1 'Comment this line and run it again to see the effect
Next

End Sub


Join our VBA for financial engineering course (http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling) & get 15% discount. Ask for discount code, email - info@qcfinance.in.

VBA Coding Style

http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/bf247ff3-a496-400c-9bbe-d2477c6d33f6/

http://en.wikibooks.org/wiki/Programming:Visual_Basic_Classic/Coding_Standards

http://www.ee.columbia.edu/~marios/matlab/MatlabStyle1p5.pdf

http://www.exceluser.com/explore/vbastds.htm


Following consistent type and scope for the variables
Using inline comments where required

http://www.xoc.net/standards/rvbanc.asp

http://www.fincad.com/pdfs/vba_coding.pdf

good 2 page summary

http://en.wikipedia.org/wiki/Programming_style

http://en.wikipedia.org/wiki/Coding_conventions

Nothing on youtube

http://msdn.microsoft.com/en-us/library/aa240822(v=vs.60).aspx

Talks about division: Naming convention, commenting and indenting.

For other rules please refer the coding standard reference (Primary):
(http://en.wikibooks.org/wiki/Programming:Visual_Basic_Classic/Coding_Standards) is a reference for VBA standards

VBA Coding Standards for reference only (Secondary):
1. http://www.exceluser.com/explore/vbastds.htm
2. http://www.xoc.net/standards/rvbanc.asp
3. http://www.fincad.com/pdfs/vba_coding.pdf
4. http://en.wikipedia.org/wiki/Programming_style
5. http://en.wikipedia.org/wiki/Coding_conventions
6. http://msdn.microsoft.com/en-us/library/aa240822(v=vs.60).aspx


Join our VBA for financial engineering course (http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling) & get 15% discount. Ask for discount code, email - info@qcfinance.in.

VBA Important Programs Class 1-5 Proposal

Course Link on Wiziq - http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling

Qutting a Loop after taking users permission

VBA programs outline:

VBA Class 1.2 (VBA for Financial Engineering)

Uploaded by Shivgan on WizIQ Tutorials

Class 2:
Copying data validation using range
for and while loop in the same program
param array
exporting file contents into a new file
creating dynamic data tables
clearing values of range selectively based on logic
Using capital IQ, factset data bases


Class 3:
Concepts of Financial Engineering
10k
Adjustment to data


Class 4:
Intro to Monte Carlo in Excel
Cho decomposition


Class 5:
Revision Project open session / Pulling data from yahoo case study (Ref: )

http://www.youtube.com/watch?v=iSlBE3CWg5Q


Areas that we will talk on:
On erro goto next should be avoided use goto in case you need to. on error goto 0 removes the effect for Future of on erro resume next
Named ranges all cases that could happen, seaching, copying, string, address not found, etc.Resetting charts Where required, ignore charts that is not there.
Correlated residuals to be used on the future values, why residual smatter in monte carlo? how to get these Correlated residuals in Monte Carlo...
Interview questions in VBA
#na from local us #na from a link?
Factset codes, sources, and adjustments
Searching #NA picked from toher values, power of NA()
Updates in term of both pages e and i
Example of array formula f ctr shift enter (matrix multiplication)
VBA notes on linking with power point
Power point advanced charting, flow charts,etc
OFFset function (example): http://support.microsoft.com/kb/324991



Some codes that we will discuss:

------------------------------------------

Option Explicit

Sub SetFormat()

    Dim ws As Worksheet

    For Each ws In ActiveWorkbook.Worksheets

    With ws

              ws.Cells.Font.Name = "Arial"

        End With

    Next ws

    End Sub

----------------

m = Range("range").Count

For j = 0 To m

      If Range("range")(j).Value = "O" Then

      Range("range2")(j, 0).EntireRow.Clear

       Range("range")(j).Value = "O"

       End If

   Next j

------------------------------------

Private Sub Reset()

   Dim objCht As ChartObject

   For Each objCht In ActiveSheet.ChartObjects

   With objCht.Chart

        With .Axes(xlValue)

       .MinimumScaleIsAuto = True

      .MaximumScaleIsAuto = True

  End With

      End With

   Next objCht

End Sub

-------------------------------------------------

Sub Highlight_Cells_With_Text_or_Formulas()

'Highlights all cells with text or formulas on the active sheet

'Will remove color from cells without formulas or text

Dim r As Range

With ActiveSheet.UsedRange

    .Interior.ColorIndex = xlNone

    For Each r In .Cells

        If r.Value <> "" Then r.Interior.ColorIndex = 3

        Next

End With

End Sub

-----------------------------------

Code for playing with data validation

Private Sub Worksheet_Activate2()

    Dim rng As Range, cell As Range

    With Range("BL38:BL38")

        Set rng = Intersect(.SpecialCells(xlCellTypeAllValidation), .SpecialCells(xlCellTypeBlanks))

    End With

    If Not rng Is Nothing Then

        Application.EnableEvents = False

        For Each cell In rng

            cell.Value = Sheets("Assumptions").Range("B7:B9")(1).Value

        Next cell

        Application.EnableEvents = True

    End If

End Sub

--------------------------------

Private Sub Set_Default_values() 

  Dim rng As Range

  

    Set rng = Range("Default_Values").SpecialCells(xlCellTypeAllValidation)

  

   Range("Range_name").Value = Range("Default_Values")(1).Value

    

End Sub

------------------------------------------

Sub AddNewWBKs()

Dim myWB As Workbook, newWB As Workbook

Dim myWS As Worksheet

Set myWB = ThisWorkbook

Application.ScreenUpdating = False

Set myWS = myWB.Sheets("Assumptions")

Set newWB = Workbooks.Add

myWS.Range("Coverage_Data").Copy

Range("A1").PasteSpecial xlPasteValues

 Range("A1").PasteSpecial xlPasteFormats

Application.CutCopyMode = False

ActiveSheet.UsedRange.EntireColumn.AutoFit

Application.DisplayAlerts = False

 newWB.SaveAs Filename:="C:\Documents and Settings\shivgan\My Documents\Exported Spreadsheet.xls"

Application.DisplayAlerts = True

newWB.Close

Application.ScreenUpdating = True

End Sub

--------------------------------------------------



Public Sub Count()
  Dim count_columns_selection, i, iReply As Integer
  Dim range_name_string As String
   
  For i = 1 To Range("Range_X").Rows.Count

Code for anything that may cause trouble

    On Error GoTo Error_control
    ContinueLoop:
  Next i

Do While i < Range("Range_X").Rows.Count
Error_control:
    
   iReply = MsgBox(Prompt:="Foudn Error?", _
            Buttons:=vbYesNoCancel, Title:="BLANK???")
   On Error GoTo -1
    If iReply = vbYes Then
     GoTo ContinueLoop
    ElseIf iReply = vbNo Then
      Exit Sub
    Else
       Exit Sub
    End If
    
 Loop
 
  
End Sub


-------------------------------------



Range("G6").GoalSeek Goal:=0, ChangingCell:=Range("G7")


End Sub



Sub reset()



Range("G7").Value = 0


End Sub

-------------------------------------------------

Join our VBA for financial engineering course (http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling) & get 15% discount. Ask for discount code, email - info@qcfinance.in.

Course Link on Wiziq - http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling

VBA For Financial Engineering & Modeling - Online 20 Hours Course

VBA For Financial Engineering & Modeling - Online 20 Hours Course

LINK: http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling

Join our VBA for financial engineering course (http://www.wiziq.com/course/19620-vba-for-financial-engineering-and-modeling) & 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:

1. Quant Corporate Finance (Investment Banking).
2. Quant Equity (Equity strategies and indices).
3. Time Series.
4. Yield curve/Fixed Income/ABS.
5. Binomial pricing MC/Hull white/BS/exotic options KMV.
6. Portfolio at risk.

From VBA Programming point of view (Divided into following areas):

1. Dependencies and removing arrows.
2. Picking non blank cells.
3. Selecting sheet and changing color.
4. Selection vs. entire sheet.
5. For loops, if end if loops, exiting loop, placing end, nestled for loop.
6. Importing values from another sheet, without opening.
7. Change manual to automatic formula computation.
8. Data tables with one and two variables using VBA.
9. With Command.
10. Set Command.
11. := used where?
12. Selecting cell with specific values.
13. Data tables.
14. Combining array in a single cell using delimiter.
15. type data validation, playing with ranges.
16. VBA editing of data validation.
17. playing with string to get the last value.
18. playing with axis of charts formatting.
19. Functions with many inputs.
20. On Error.
21. Option Explicit others.
22. 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 (10-50 % Quant Finance & 10-50% 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 Monte-Carlo, 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 self-study:
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/en-us/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.

With Command: Use to act several attributes to an object in one go: http://msdn.microsoft.com/en-us/library/wc500chb(v=vs.80).aspx

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/en-us/library/sxz296wz(v=vs.80).aspx

http://msdn.microsoft.com/en-us/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/en-us/library/dz1z94ha(v=vs.80).aspx

.activate
http://msdn.microsoft.com/en-us/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/en-us/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/byref-and-byval/

.add
http://msdn.microsoft.com/en-us/library/office/aa221688(v=office.11).aspx


Other courses that you can refer to:Demo Course structure:
http://www.vtc.com/products/Microsoft-Visual-Basic-for-Applications-(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.