What's New Here?

Plot a Candlestick Chart with VBA

Plot a Candlestick Chart with VBA

Get VBA code and a spreadsheet that automatically downloads historical stock quotes and plots a candlestick chart.

Effect of Payment Frequency on Mortgage Balance at Term

Effect of Payment Frequency on Mortgage Balance at Term

Compare the effect of different mortgage payment frequencies with this spreadsheet. A real eye-opener for potential homeowners!

How to Calculate Accelerated Mortgage Payments in Excel

How to Calculate Accelerated Mortgage Payments in Excel

Accelerated mortgage payments can save you thousands of dollars in interest. They’re rapidly becoming the tool of choice for frugal homeowners.

Free Intraday Stock Data in Excel

Free Intraday Stock Data in Excel

This spreadsheet downloads realtime intraday backfill from Google.

Zephyr Pain Index

Zephyr Pain Index

This risk metric captures the time it takes to regain investment losses, and the severity and frequency of those losses. Get a free spreadsheet with open VBA.

How to Calculate Mortgage Payments in Excel

How to Calculate Mortgage Payments in Excel

Like me, you might have used an online mortgage calculator to predict your payments. But how do those tools come up with your payment amount? Well, armed with Excel, you… Read more »

Mortgage Payment Calculator

Mortgage Payment Calculator

Calculate your mortgage payments with this this free Excel spreadsheet. You can pick your payment frequency, and generate a schedule giving you the date of every payment

Trade with Williams %R and Excel

Trade with Williams %R and Excel

Learn about the trading indicator that helped turned $100k into $1.1m in twelve months, and get a free automated Excel spreadsheet.

How to Calculate the Stochastic Oscillator

How to Calculate the Stochastic Oscillator

Discover how to calculate the stochastic oscillator in Excel, and get a web-connected spreadsheet that automatically plots this critical technical indicator.

Bulk Dividend Downloader

Bulk Dividend Downloader

Get historical dividends for many companies, and generate a payout stream cross-referenced against time. Free spreadsheet!

© 2014 Invest Excel. All rights reserved. XHTML / CSS Valid.

Facebook