ab-logo

Code. Models. Analysis. Decisions.


Excel

How to Make Amortization Table in Excel
How to Calculate Loan Payment in Excel
How to Payoff a Loan Fast
How to Confidence Intervals in Excel
Correlation in Excel
Command Line Essentials
One Variable Data Table Excel
Two Variable Data Table Excel
Descriptive Statistics with Excel
How to Use T.TEST Function in Excel
How to Use VLOOKUP Function in Excel
How to Calculate Theil's U in Excel
Forecasting Moving Average in Excel
Forecasting Exponential Smoothing Weighted Moving Average
Independent Samples t-test in Excel
Introduction to Excel Pivot Table
Linear Programming Optimization with Solver
Transportation Network Optimization Solver
Linear Regression Shortcuts in Excel
How to do Linear Regression with Excel
Make and Interpret Scatter Plots with Excel
Monte Carlo Simulation with Palisade @Risk
Basic Monte Carlo Simulation of Stock Portfolio
NPV, IRR, ROI and Payback Period with Excel
How to Paired Samples t-test with Excel
Portfolio Optimization in Excel
Portfolio Variance in Excel
Value at Risk Monte Carlo Simulation with Excel
Value at Risk Monte Carlo Simulation with Excel
Value at Risk Monte Carlo Simulation with Excel
how to Value Option with Monte Carlo Simulation

MySQL

Single Table Queries MySQL
Creating Databases and Loading Data
Using CASE WHEN and IF
Make ERD with MySQL
MySQL Foreign Key
INNER & OUTER JOINS
Statistics & Mathematical Functions
Subqueries in MySQL
Text Functions in MySQL

Python

Algorithmic Trading in Python
Mean Reversion - Trading Algorithm
Alpha Vantage Stock Data API
Correlation Correlation Matrix Python
Data Analysis in Python
Data API in Python
Python Loan Analysis Project
Monte Carlo Simulation with Python
Object Oriented Programming with Python
Python NumPy for Beginners
NumPy Financial Basics
Python pandas DataFrame Essentials
How to Use pipenv
Calculate Portfolio Variance
Python pandas_datareader fix-yahoo-finance
Python pandas rolling method
Make a number guessing game with Python
Make an Animated Graphic with Python
How to Read csv files in Python
Quantitative Stock Price Analysis
Stock Price Analysis with Python pandas
Python Streamlit Web App
Use Python Matplotlib for Common Visulaization
Linear Regression with Python

R

Correlation Correlation Matrix in R
Data Analysis with R
Install Jupyter Notebook Support for R
Conduct two-tailed Hypothess test with R

SPSS

How to Make Control Charts in SPSS
Descriptive Statistics with SPSS
How to do Linear Regression with SPSS
How to Paired Samples t-test with SPSS

Other Tools

Command Line Essentials
Command Line Top 10
How to Paired Samples t-test with Minitab