investexcel.net
Maximum Drawdown in VBA
http://investexcel.net/2450/maximum-drawdown-vba
Questions About The Spreadsheets? Maximum Drawdown in VBA. This VBA function and the accompanying Excel spreadsheet calculate the maximum drawdown of a series of investment returns. The maximum drawdown is the largest percentage drop in asset price over a specified time period. In other words, it is the greatest peak-to-trough of the asset returns. It is a measure of downside risk, and is used when calculating the Calmar Ratio. TS = returns n = UBound. TS) Min = 0 For. N temp = TS(j, 1) / TS(i, 1) - 1 If.
investexcel.net
Personal Finance - Invest Excel
http://investexcel.net/personal-finance
Questions About The Spreadsheets? Calculate your mortgage payments and generate a payment schedule. Step-by-step guide to calculate mortgage payments in Excel. Calculating Accelerated Mortgage Payments. Effect of Payment Frequency on Mortgage Balance at Term. Auto Loan Payment Calculator. Produces a complete payment schedule, and contains all common payment options. Leave a Reply Cancel reply. Your email address will not be published. Required fields are marked *. What is 2 12? Like the Free Spreadsheets?
investexcel.net
Fair Value of Oil Stocks
http://investexcel.net/fair-value-of-oil-stocks
Questions About The Spreadsheets? Fair Value of Oil Stocks. Discover which oil stocks are undervalued with the Graham number. The Graham Number offers a simple method of estimating the fair value of a stock, given only the EPS and book value per share. You’ll find many other articles across the web discussing the formula. And its limitations, so we won’t retread familiar material here. You’ll find a similar spreadsheet that values electric utility companies here. Leave a Reply Cancel reply. What is 2 8?
investexcel.net
Business Analysis - Invest Excel
http://investexcel.net/category/business-analysis-in-excel
Questions About The Spreadsheets? Find Financial Fraud with Benford’s Law. Discover how a peculiar concept called Benford’s Law helps detect accounting and business fraud, and get an Excel spreadsheet to help with your financial sleuthing. Value Shares with Graham’s Formula. Discover Graham’s formula, a simple method for predicting the fair values of shares, and download a spreadsheet. Download Finviz Data into Excel. Like the Free Spreadsheets? This site takes time to develop. Want more? This website us...
investexcel.net
Calculate Dividend Growth Rate in Excel
http://investexcel.net/calculate-dividend-growth-rate-in-excel
Questions About The Spreadsheets? 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. You can analyze a single company, or a hundred companies – you just need their ticker symbols. Additionally, the dividend discount method. Of stock valuation requires estimates of long-term dividend growth rates. Watch me use this spreadsheet in this video. January of the start year to 31.
investexcel.net
Option Pricing - Invest Excel
http://investexcel.net/category/option-pricing-2
Questions About The Spreadsheets? This article teaches you how to calculate the implied dividend of an option via put-call parity, illustrated with an Excel spreadsheet. Learn about European strike reset options, and download a pricing spreadsheet. Option Pricing with Skew and Kurtosis. Learn about the Corrado and Su (1996) model for pricing options with excess skew and kurtosis, and get a pricing spreadsheet. Probability of a Successful Option Trade. Roll-Geske-Whaley Method to Price American Options.
investexcel.net
Commentary - Invest Excel
http://investexcel.net/category/commentary
Questions About The Spreadsheets? How does Yahoo Finance Calculate Beta? Yahoo Finance gives beta values for stocks. But how are these values calculated? Find out how with a detailed step-by-step explanation. Sometimes I just want stock market data in Excel, and I don’t want to spin my wheels hacking about with VBA. Calculating the Value of Scrap Gold. If you have scrap gold at home and decided to sell it, you might want to do your own estimations first. Sources of Intraday Stock Data. I’d heard good thi...
investexcel.net
Invest Excel - 2/16 -
http://investexcel.net/page/2
Questions About The Spreadsheets? 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. This VBA-charged spreadsheet downloads the price of a barrel of OPEC Basket crude oil between two dates. Live Stock Quotes in Excel. Get live financial data, streamed from the web, in Excel with this VBA function. Sources of Intraday Stock Data. This E...
investexcel.net
Valuing Electric Utility Stocks with the Graham Number
http://investexcel.net/valuing-electric-utility-stocks-with-the-graham-number
Questions About The Spreadsheets? 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. Utility companies are a core component of long-term investment planning. They’re stable, pay consistent dividends and sell a product that people will always want. Here’s a summary of the results, correct as of 21st February 2015. Pacific Gas and Ele. NRG Yield, Inc. C. Spark Energy, Inc. Of course, th...