Email this page | Go To Menu | Go To Content | Sitemap

BMW Downloads


Search by Tag

AllTheBMWStocks AMGN Analysis Bailout BMW BMWM Conference call chart Complaints conference covered calls Earnings Excel Excel Analysis Dividend CAGR RMS finance financial financial statements financials FMD fool formulas high dividend Historic Historical Home Depot image Income index KO log chart market report MHPSheridan MHPSRC Mike's charts MRK timeshift MSFT Neg RMS npi NPI Fool Oppenheimer Option Options P/E Ratio Pareto PE Ratio PEAR Perfect php put PUTs REITS S&P 500 Safari Shiller Skunks of the Dow Spreadsheet table timing timing system signals Trading portfolio visitors WAG wfc wm Yale



Files tagged 'Spreadsheet'

Fafar / Divebomber's spreadsheet w/Magic Formula / Jan 24, 2008

10/18/07 Added free-cash-flow chart at the bottom of the Plots sheet. Edited some of the comments. Also modified the MF calculation so that it more closely matches the results for stocks on MagicFormulaInvesting.

9/26/07
- added a Magic Formula calculation sheet and display the results there and on the Plots sheet. Use TTM and Qtrly figures.

- added 5-year dividend chart.

stockreportv9.3_KC2.xls - 1,755 KB - Preview in new window - Download now


captainccs / Option calculators / Jan 14, 2012

Spreadsheets I use to calculate selling puts and calls.

option-calculators.tgz - 117 KB - Preview in new window - Download now


Fafar / SliceDice_KCv2.zip / Jan 24, 2008

6/29/07
V2 update: Still just split-adjusted data. Pulls 10 yrs of data from MSN and the rest from BigCharts.

This spreadsheet will plot linear and log charts in 2 ways.

Charts Tab: You can have the program plot Hi/Low/Avg CAGRs or just enter your own, along with 2 others. All downloaded data is plotted and used in CAGR calculations.

SliceDice Tab: All downloaded data is plotted on the chart, but you
decide where to start/end each CAGR line. Also, CAGRs are calculated every 5 years (3 yrs for chart with < 15 years) from the present back. Multiperiod CAGRs are calculated too.

Will work with Excel 2002 and up (?), but must have installed: Analysis Toolpak, VBA Toolpak, and MSN StockQuote Functions Addin.

SliceDice_KCv2.zip - 495 KB - Preview in new window - Download now