## Converting a Python Program to an Executable (.exe) with CX_Freeze

In order to actually run a Python script, we must have a copy of python downloaded on our machine with the appropriate interpreter of course. Let’s say we created a program that uses an external library we have to download...

## Solution to Getting Free Stock Data with Excel VBA (No Yahoo API)

Click to download workbook: IEX WB Or visit my GitHub page:  This post will touch on retrieving stock price data in Excel VBA with the IEX API. The full subroutine and link for the workbook are featured below. All dependencies...

## Creating Your First Django Project

Welcome to your first Django tutorial. This will cover the initial setup of Django and the creation of your first project with the framework. Let’s get started. Step 1: Download Python if you haven’t already. You can...

## Web Scraping Fundamental Data For Stocks (No API)

Click to download workbook: VBA Stock Scraper(1) The workbook above contains a subroutine which allows the user to extract data from Yahoo Finance’s website…

## Value at Risk via Variance – Covariance Method

This post presents how to estimate Value at Risk via a variance – covariance method. The following steps outline how to calculate Value at Risk using this method. 1.) Gather stock data and calculate periodic returns...

## Getting Updated Stock Quotes into Excel (Without Google or Yahoo)

Click to Download Workbook: Stock Quotes This is a method to get updated stock quotes from Bloomberg into Excel by parsing JSON. Let’s examine the steps to doing this. For those who don’t know, JSON stands for...

## Tracking a Portfolio With Python

Link to Project: The following Python project allows a user to track their stock portfolio in Python. Since this is a beta version and will continually need adjustments, any changes suggested will be considered. You can also...

## Predicting Stock Prices With Linear Regression

Linear Regression Intuition: Linear regression is widely used throughout Finance in a plethora of applications. In previous tutorials, we calculated a companies’ beta compared to a relative index using the ordinary least...