4shared

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@qcfinance.in

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

Class Modules

Error Correction Model

Developing Excel Utilities with VBA

Manipulating Files with VBA

Understanding Excel Events

Userforms Working with Ribbon

VBA Coding Standards

Error Handling

Loops

Data Table

MC Framework 

Loops

VBA Combined Resources

Vlookupreverse

Range Class with EH

Charting Excel Export 

Examples

Indices and Returns

Business Accounting & Analysis

BBC-Interest Rates

Bayesvsfreq

BMA.csv

BMA.pdf 

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 Class 1

VBA Coding Standards

Alternatives To Custom Dialog Box

VBA Sub Procedures

Manipulating Files with VBA

Important Features of Excel Introduction to VBA

User Forms

VBA Programming Fundamentals

Class Modules

Working With The Ribbon

Add-Ins

Understanding Excel Events

Developing Excel Utilities with VBA

Regression in VBA

Delimiters

Vlookup & Hlookup

Data Types & Files in VBA

VBA – Loops, Error Validation & Data Validation Functions

Normal Distribution & Microsoft Excel

Quant ETF

Loops, Errors in VBA

Data Pulling into Excel Error Handling

VBA Programs

Program to Import ranges from other file

Chart Reset Code Sorting & Copying Charts

Unused Cells VBA

VBA Class

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)

Elemental

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

Retreive Data

Stock Market

Importing From 

Excel Function

Checkcolor

Introduction to Excel

UK SignUp Month Approved Countifs

Trading Dashboard 

MC Framework 

VAR

Trading Dashboard 

Regression

Put Call Strategy

MC Framework

Projections

Loops Added Range exist

Put Call Strategy 

VAR

VAR

VAR

Importing To

MC Framework

Loops

Regression

Vlookup with Datable

Regression

Regression

Regression

Regression

Record Pivot Table

Convert to Matrix Choksley

MC Framework

Put Call Strategy 

Black Sholes Greeks

Testing Loops

Range Class

Pri Class

Planning

Monte Carlo

Loops

Loan Ammortization

If Else for Do while Loops

Count Non Bold Blank

Error Handling

Econometrics Model for Real Estate Valuation

Delimiter and IS Error

Data Tables Correlations

Monte Carlo Mean Reversion on Margin

Regression

Regression

2013-SIGMETRICS-Heavytails 

Put Call Strategy

Portfolio

Portfolio

Geometric Brownian Motion

Volatility

Log Normal Distribution

Grang Causality

Vasicek Model

Nested Loops in VBA

GARCH Invest Excel

SQL VBA 

Project Planner vF

sql vba code

SQL VBA 1

 

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

Carr-Salzman

Black Scholes VBA fx Option Price R MonteCarlo Simulation

http://qcfinance.in/14.15%20-%20Ian%20Wallace.ppt

http://qcfinance.in/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://qcfinance.in/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@qcfinance.in

Skype Id: qcfinancein

Comments are closed.