Python Classes Consulting (312) 285-6886 Big Data Science

VBA Fin.Engg.(Premium)

PREMIUM PAGE FOR VBA FOR FINANCIAL ENGINEERING & MODELING COURSE

THANKS FOR JOINING WITH US

THIS PAGE CONSISTS OF ALL THE CLASS RECORDINGS, TUTORIALS & TESTS LINKS

PREMIUM MEMBERS GET 4 HOURS OF LIVE ONE ON ONE DOUBT CLEARING OR SPECIFIC TOPIC CLASSES AT YOUR CONVENIENT TIMINGS

Now ask for as low as just one customized session (1 hour) from qcfinance.in at $50.

CONTACT US FOR ANY QUERIES – info@learnprogrammingnyc.com

New York City/ Gurgaon / Indore / Online

Links To Class Recordings (Class 7 & 8 links will be added soon):

Class 0: How To Use Course/VBA Class 0

Class 1: Introduction To Course (Some Basics Covered)

Class 1: Introduction To VBA

Class 1: Introduction To Quant Corporate Finance

Class 2: VLOOKUP, HLOOKUP, INDEX

Class 2: VLOOKUP, HLOOKUP, INDEX (CONTD….)

Class 3: Ranges

Class 3: Applying Ranges

Class 3: Data Types, Ranges & Cell Arrays

Class 3: Data Types, Ranges & Cell Arrays (Contd…)

Class 4: Loops

Class 5: Naming Conventions, Errors & Doubt Clearing

Class 5: Sensitization To Data Cleaning & Delimiters In Excel

Class 6: Error Handling

Class 6: Using Add-Ins

Class 9: Sensitization To Monte Carlo

Class 9: Sensitization To Monte Carlo (Data Table)

Class 9: Monte Carlo (Contd…)

Class 10: Interview Question For VBA

Class 10: Interview Questions For VBA (Contd…)

Some Additional Class Recordings (Miscellaneous Topics)

http://www.wiziq.com/online-class/1293250-vba-class

http://www.wiziq.com/online-class/1293447-vba-interview-prep

http://www.wiziq.com/online-class/1563850-class-for-vba

http://www.wiziq.com/online-class/1609361-class-for-vba-andy

http://www.wiziq.com/online-class/1612685-class-for-vba-andy

http://www.wiziq.com/online-class/1565843-class-for-vba

http://www.wiziq.com/online-class/1605235-class-for-vba-andy

http://www.wiziq.com/online-class/1603278-class-for-vba-andy

http://www.wiziq.com/online-class/1602225-class-for-vba

http://www.wiziq.com/online-class/1599991-vba-class-andy

http://www.wiziq.com/online-class/1596341-class-for-vba

http://www.wiziq.com/online-class/1592443-class-for-vba

http://www.wiziq.com/online-class/1588056-class-for-vba

http://www.wiziq.com/online-class/1586632-class-for-vba

http://www.wiziq.com/online-class/1595107-class-for-vba

http://www.wiziq.com/online-class/1586645-class-for-vba

http://www.wiziq.com/online-class/1586632-class-for-vba

http://www.wiziq.com/online-class/1586645-class-for-vba

http://www.wiziq.com/online-class/1585440-class-for-vba

http://www.wiziq.com/online-class/1577963-class-for-vba

http://www.wiziq.com/online-class/1584252-class-for-vba

http://www.wiziq.com/online-class/1583739-class-for-vba

http://www.wiziq.com/online-class/1581939-class-for-vba

http://www.wiziq.com/online-class/1576379-introductory-class-for-vba

http://www.wiziq.com/online-class/1574260-class-for-vba

http://www.wiziq.com/online-class/1568939-class-for-vba

http://www.wiziq.com/online-class/1696920-class-for-andy

http://www.wiziq.com/online-class/1699678-temp-class-andy

http://www.wiziq.com/online-class/1699809-class-for-andy

http://www.wiziq.com/online-class/1703294-class-for-andy

http://www.wiziq.com/online-class/1709445-class-for-andy

http://www.wiziq.com/online-class/1714238-class-for-andy

http://www.wiziq.com/online-class/1724780-class-for-andy

http://www.wiziq.com/online-class/1729977-class-for-andy

http://www.wiziq.com/online-class/1737990-class-for-vba-chandni

http://www.wiziq.com/online-class/1738044-class-for-andy

http://www.wiziq.com/online-class/1747738-class-for-andy

http://www.wiziq.com/online-class/1747707-class-for-chandni

http://www.wiziq.com/online-class/1754383-class-for-chandni-vba

http://www.wiziq.com/online-class/1754122-class-for-andy

http://www.wiziq.com/online-class/1757721-class-for-andy

http://www.wiziq.com/online-class/1761013-class-for-chandni-vba

http://www.wiziq.com/online-class/1763809-class-on-vba

http://www.wiziq.com/online-class/1765658-class-for-andy

http://www.wiziq.com/online-class/1798795-class-on-vba-for-financial-engineering

http://www.wiziq.com/online-class/1799043-class-on-vba-for-financial-engineering

http://www.wiziq.com/online-class/1831670-class-on-vba-for-financial-engineering

http://www.wiziq.com/online-class/1971841-class-for-andy-vba

http://www.wiziq.com/online-class/1955000-class-for-andy

http://www.wiziq.com/online-class/1964514-class-for-andy-vba

http://www.wiziq.com/online-class/1954869-class-for-georgia-vba

http://www.wiziq.com/online-class/1921516-class-for-andy-vba

http://www.wiziq.com/online-class/1943617-class-for-sachin-vba

http://www.wiziq.com/online-class/1910272-class-for-andy

http://www.wiziq.com/online-class/1909411-class-for-sachin-vba

http://www.wiziq.com/online-class/1902964-class-for-andy-vba

http://www.wiziq.com/online-class/1865952-class-for-andy

http://www.wiziq.com/online-class/1847715-class-for-andy-vba

http://www.wiziq.com/online-class/1827472-class-for-andy-vba

http://www.wiziq.com/online-class/1802249-class-for-andy

http://www.wiziq.com/online-class/1802246-class-for-chandni-vba

http://www.wiziq.com/online-class/1797752-class-for-andy

http://www.wiziq.com/online-class/1789178-class-for-andy

http://www.wiziq.com/online-class/1783812-class-for-andy-vba

http://www.wiziq.com/online-class/2015438-class-for-andy-vba

http://www.wiziq.com/online-class/2009793-class-for-andy-vba

http://www.wiziq.com/online-class/2003510-class-for-andy-vba

http://www.wiziq.com/online-class/1998678-class-for-andy-vba

http://www.wiziq.com/online-class/1998598-excel-session-for-andy

http://www.wiziq.com/online-class/1996157-class-for-andy-vba

http://www.wiziq.com/online-class/1993507-class-for-andy-vba

http://www.wiziq.com/online-class/1991160-class-for-andy-vba

http://www.wiziq.com/online-class/1990548-andy

http://www.wiziq.com/online-class/1987973-class-for-andy-vba

Derivatives Class

Derivatives Class

Derivatives Class

Derivatives Class

VBA For Financial Engineering

Tutorial Links For Download:

Data Pulling into excel

Storing live Data From Excel VBA

How to maintain constant debt EBTIDA for the same work

Best set of Factors in Valuation

VBA Self Learning Path

Valuation Using Multiple Regression

Distributions in Excel Functions

Excel 2010 Power Programming with VBA

Introduction to Excel Introduction to VBA

Programs in VBA Matrix Multiplication in Excel VBA

Monte Carlo Simulation Regression in Excel

VBA Function Procedures VBA Programming Fundamentals

VBA Sub Procedures

VLOOKUP HLOOKUP

Alternatives to Custom Dialog Box

Error Correction Model

Developing Excel Utilities with VBA

Manipulating Files with VBA

Understanding Excel Events

Userforms Working with Ribbon

VBA Coding Standards

VBA Combined Resources

Range Class with EH

Charting Excel Export

Indices and Returns

Business Accounting & Analysis

BBC-Interest Rates

Package- BMS.pdf

Stock Price Predictability

Links To Tutorials (On Wiziq):

VBA Code – Import Function

VBA Code – Color Change

VBA Code – Error Handling

VBA Code – Is not Zero

VBA Code – Resetting Data Tables

VBA – Some Important Links

VBA Code – Different Cases of Error Control

VBA Code – On Error

VBA Code – Is NA

VBA Codes – Miscellaneous

VBA Code – Addin Buttons

Ten Excel-VBA Control Structures

VBA Coding Standards

Alternatives To Custom Dialog Box

VBA Sub Procedures

Manipulating Files with VBA

Important Features of Excel Introduction to VBA

VBA Programming Fundamentals

Working With The Ribbon

Understanding Excel Events

Developing Excel Utilities with VBA

Regression in VBA

Vlookup & Hlookup

Data Types & Files in VBA

VBA – Loops, Error Validation & Data Validation Functions

Normal Distribution & Microsoft Excel

Loops, Errors in VBA

Data Pulling into Excel Error Handling

Program to Import ranges from other file

Chart Reset Code Sorting & Copying Charts

Unused Cells VBA

VBA Function Procedures

Tutorial for Risk Models for HFT

Regression in Excel

Distributions in Excel Monte Carlo Simulation in Excel

Central Error Handling – VBA Error Generation Methods – VBA

3M Monte Carlo on Mean Reversion on Margins Importing To

Importing From Regression Valuation using Multiple Regression

VBA Self – Learning path

Best set of factors in Valuation Derivatives Analysis

Computational Finance

Chart with horizontal lines vs vertical lines

Multiple operations, variables, suppressing output, built in functions

QuanDI R SP Arima Model (combined)

A little book of R for time series

Links To Excel Files:

Demo of Time Series

Black Sholes Greek VBA

Chart For Option Pricing

Portfolio Excel

Introduction to Excel

UK SignUp Month Approved Countifs

Trading Dashboard

Trading Dashboard

Put Call Strategy

Loops Added Range exist

Put Call Strategy

Vlookup with Datable

Record Pivot Table

Convert to Matrix Choksley

Put Call Strategy

Black Sholes Greeks

Loan Ammortization

If Else for Do while Loops

Count Non Bold Blank

Econometrics Model for Real Estate Valuation

Delimiter and IS Error

Data Tables Correlations

Monte Carlo Mean Reversion on Margin

2013-SIGMETRICS-Heavytails

Put Call Strategy

Geometric Brownian Motion

Log Normal Distribution

Grang Causality

Nested Loops in VBA

GARCH Invest Excel

Project Planner vF

Third Party References:

Excel: Multiple Regression

Asset Management

Simulation Model

Distribution Fitting

MonteCarlo Simulation in Excel

Support: Risk and Return

Anova: Analysis of Variation

Random Variables and Probability Diatributions

Basic Matrix And Vector Functions In VBA-V1

Black Scholes VBA fx Option Price R MonteCarlo Simulation

http://learnprogrammingnyc.com/14.15%20-%20Ian%20Wallace.ppt

http://learnprogrammingnyc.com/3360n.xls

Logistic Regression

Links To Tests:

VBA Miscellaneous Test 1

VBA Miscellaneous Test 2

VBA Miscellaneous Test 3

VBA Miscellaneous Test 4

VBA Miscellaneous Test 5

VBA Miscellaneous Test 6

VBA Miscellaneous Test 7

VBA Miscellaneous Test 8

VBA Miscellaneous Test 9

VBA Miscellaneous Test 10

VBA Miscellaneous Test 11

VBA Miscellaneous Test 12

VBA Miscellaneous Test 13

VBA Miscellaneous Test 14

VBA Miscellaneous Test 15

Also Check: http://learnprogrammingnyc.com/Quant_Interview_v2.pdf

One on One Customized Training:

qcfinance.in believes in personalized touch so that our clients are completely satisfied with our service. In this regard, we offer One on One Customized Training to our clients.

These Training are provided on requests by our clients & are customized according to their individual needs.

The course structure & timings for these training are highly flexible, classes are scheduled as per the convenience of our clients.

Your Name (required)

Your Email (required)

Request a Topic

Current City (Optional)

Additional information

Note: If you miss a scheduled one on one class, then don’t worry, you can reschedule it at your convenient time & the missed class won’t be counted. You may defer a class any number of time. Also, you get life time access to materials which gets constantly updated.

Contact Us: info@learnprogrammingnyc.com

Skype Id: qcfinancein

Comments are closed.