Financial Modeling

MarketXLS Review (2026): Features, Pros & Cons, and a 20% Promo Code Welcome to my no-fluff MarketXLS review. If you’re a data-driven investor or trader tired of manually copying financial data into spreadsheets, MarketXLS aims to replace that chaos with a powerful, Excel-native research platform. Below I break down who it’s for, the core features […]

In this blog article, we will demonstrate how to calculate the Value at Risk (VaR) for a portfolio of stocks using the parametric method, also known as the variance-covariance method. The parametric method estimates VaR by assuming that portfolio returns follow a normal distribution. We will use Python and the yfinance library to download historical […]

In this blog post, we will demonstrate how to perform Value at Risk (VaR) calculations using the historical method for a portfolio of stocks. We’ll use Python and the yfinance library to download historical stock price data and then calculate VaR for an equally weighted portfolio. Setting Time Range and Tickers First, let’s set the […]

In this blog post, we will demonstrate how to perform a Value at Risk (VaR) simulation based on the Monte Carlo Method for a portfolio of stocks using Python and the yfinance library. We will use historical stock prices to calculate the expected return and standard deviation of the portfolio, and then run a Monte […]

In this blog post, we will demonstrate how to download historical stock prices using the yfinance library and Python, and then export to Excel file. Automating the yfinance export to excel process can streamline your financial data workflow. We will create a list of stock tickers, define a time range, download the closing prices for […]

Welcome to this intro to Python for finance tutorial where we will introduce some Python basics, including variable types, control flow statements, and importing libraries. After that, we will dive into stock analysis using the Yahoo Finance library to retrieve stock data, calculate returns, and visualize the results. Let’s begin by looking at some basic […]

In this blog post, we’ll explore how to analyze company financials using a DuPont Analysis in Python. We’ll retrieve financial data using the AlphaVantage API, parse the data, and calculate key financial ratios to evaluate a company’s performance. To get started, let’s take a look at the code and understand the python for financial analysis […]