## Pivoting Tables With MySQL

In this tutorial, we will cover pivoting tables with MySQL. Note you can use whatever language that comes with your DBMS that is SQL oriented such as SQL Server. You can think of pivoting tables as selecting unique values and...

## Calculating a Minimum Variance Portfolio Dynamically

Click to Download Workbook: Minimum Variance Portfolio Calculator A minimum variance portfolio is basically a term for the portfolio with the lowest possible expected risk from the for a given rate of return (also expected). On...

## Creating a Custom Histogram Module

Click to Download Workbook: Histogram A histogram is synonymous with a frequency distribution. That is, we simply are plotting the number of times something occurs within a range on a chart, typically a bar graph. These ranges...

## API Interaction With Excel

Click to Download Workbook: API Interaction This post will serve as a two in one tutorial to those who have never used Power Query or UserForms within Excel. The goal will be to try to interact with an API through a get request...

## Examining Twitter Sentiment (The Easy Way)

If you came here to learn the intricacies of sentiment analysis, you came to the wrong post. This is a simple implementation of the TextBlob module using the Twitter API via Tweepy. We will store the tweets as well well as their...

## Dividend Discount Model With Excel VBA

Click to Download Workbook: Gordon Growth Model VBA Dividends are a portion of profits or retained earnings that are dispersed amongst the shareholders of a corporation. Why are dividends important? Why do some companies have a...

## Monte Carlo Simulation (Geometric Brownian Motion) In Excel

Click to Download Workbook: Monte Carlo Simulator (Brownian Motion) This workbook utilizes a Geometric Brownian Motion in order to conduct a Monte Carlo Simulation in order to stochastically model stock prices for a given asset...

## Portfolio Optimization With R

R offers so many benefits to those interested in Quantitative Finance. It makes life super easy in terms of getting data, and in this particular case analyzing the data and constructing an optimal portfolio. Doing this in Excel...