This spreadsheet downloads realtime intraday backfill from Google.
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.
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
Learn about the trading indicator that helped turned $100k into $1.1m in twelve months, and get a free automated Excel spreadsheet.
Get historical dividends for many companies, and generate a payout stream cross-referenced against time. Free spreadsheet!
Plot the historical returns histogram from prices automatically downloaded from Yahoo Finance, all in Excel.
Learn how to calculate the exponential moving average in Excel and VBA, and get a free web-connected spreadsheet.
Get financial data for multiple companies in Excel, straight from the web. Retrieve EPS estimates, EBIDTA, dividend yields, PE ratios and more.
Learn how to annualize daily, weekly and monthly volatilities. Plus get free web-connected spreadsheets to calculate the historic volatility of stocks, precious metals and currency pairs.
This spreadsheet imports historical prices for gold, silver, platinum and palladium from the Internet, and plots several technical trading indicators.