Learn how I calculated the rolling correlation of two key players in my retirement fund, and get a calculation spreadsheet.
This VBA-charged spreadsheet downloads the price of a barrel of OPEC Basket crude oil between two dates.
Get live financial data, streamed from the web, in Excel with this VBA function.
Get the complete list of Yahoo stock ticker symbols in an Excel spreadsheet – over 158000 ticker symbols for stocks, ETFs, mutual funds, warrants and more, across many international exchanges.
This Excel spreadsheet contains a comprehensive list of ETFs traded over nearly all international exchanges, including NYSE, LSE, NASDAQ, TSO and others worldwide.
Get a list of mutual funds across all countries and exchanges, scraped from Yahoo Finance. It contains over 30000 funds.
Get VBA code and a spreadsheet that automatically downloads historical stock quotes and plots a candlestick chart.
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