Skip to content
  • Privacy Policy
  • About Me
  • Questions About The Spreadsheets?
  • Premium Excel Tools
  • Somerset Immigration
Invest Excel
0
  • Business Analysis
  • Portfolio Analysis
  • Option Pricing
  • Technical Trading
  • Buy Spreadsheets
  • Commentary
  • Shop
  • 0

Portfolio Analysis

Latest Cryptocurrency Quotes in Excel

This VBA-powered spreadsheet give you live exchange rates for Bitcoin, Etherium, Monero, Dogecoin and 1500 other cryptocurrencies.

VBA for the Macaulay Duration

The Macaulay Duration is a fundamental characteristic of a bond, and is the weighted average of the time until each payment is received.

Stocks Traded on German Exchanges

Get a comprehensive list of companies traded on all German stock exchanges – over 21000 tickers! This spreadsheet contains companies …

Companies Listed on the Stock Exchange of Thailand

Historical Volatility Excel

A list of companies traded on the Stock Exchange of Thailand.

VBA to Calculate Yield to Maturity of a Bond

Calculate the redemption yield of a bond via the bisection method and VBA.

Deriving the Bond Pricing Formula

Want to know where the bond pricing equation comes from?

Dow 30 Stocks – Latest Financial Data in Excel

Get the latest financial data for the stocks in the Dow Jones Industrial Average. After clicking a button, Excel connects to the Internet and downloads the latest data.

Find Cheap Dividend Stocks on the NYSE

Find cheap income shares with a free Internet-connected spreadsheet.

Click a single button to analyze the entire NYSE and get the best-value buys.

Calculate Beta With Historical Market Data

This tool calculates beta across any time frame for any stock against any benchmark. It uses historical stock quotes downloaded from Yahoo Finance.

Calculate Dividend Growth Rate in Excel

This Excel spreadsheet downloads historical dividend data and calculates annual dividend growth rates for a set of user-specified stock tickers.

The Gordon Growth Model

This is a simple but remarkably insightful method of valuing stocks.

Fair Value of Oil Stocks

Discover which oil stocks are undervalued with the Graham number.

Valuing Electric Utility Stocks with the Graham Number

Screen for undervalued utilities with the Graham Number and a web-connected spreadsheet with live financial updates.

Calculating the Correlation Between the S&P 500 and Crude Oil

Learn how I calculated the rolling correlation of two key players in my retirement fund, and get a calculation spreadsheet.

OPEC Basket Price History in Excel

Standard deviation of OPEC Basket prices over a 10 day window, from 2009-01-01 to 2015-01-01

This VBA-charged spreadsheet downloads the price of a barrel of OPEC Basket crude oil between two dates.

Older posts
Page1 Page2 … Page6 Next →

Like the Free Spreadsheets?

This site takes time to develop. Want more?
Need new features? Then donate!

Master Knowledge Base

Option Pricing

Personal Finance

Portfolio Analysis

Technical Trading

Web Services for Financial Data

Recent Posts

  • Latest Cryptocurrency Quotes in Excel
  • Calculate the Money Flow Index in Excel
  • VBA for the Macaulay Duration
  • Stocks Traded on German Exchanges
  • Historical Volatility ExcelCompanies Listed on the Stock Exchange of Thailand
©2023 Invest Excel
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT