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
Manage Cookie Consent
We use technologies like cookies to store and/or access device information. We do this to improve browsing experience and to show (non-) personalized ads. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}