Systematic Finance

Financial Times links at www.business-minds.com

Mastering Financial Modelling : Mastering Risk Modelling : Mastering Financial Mathematics : Mastering Cash Flow Modelling

Please send us an email if you would like to be added to the list or if any of the links have stopped working due to website updates.

Books

Mastering Financial Modelling by Alastair Day for financial modelling published by the Financial Times
Mastering Risk Modelling by Alastair Day for applied risk in Excel published by the Financial Times
Mastering Financial Mathematics in Excel in the Mastering Series for the Financial Times
Mastering Cash Flow and Valuation Modelling in the Mastering Series for the Financial Times
Data Analysis with Microsoft Excel by Berk and Carey including the StatPlus add-in www.duxbury.com or www.thomsonlearning.com
Advanced Modelling in Finance using Excel and VBA by M Jackson and M Staunton published by Wiley at www.wiley.com
Financial Modeling is a book and disk combination by Simon Benninga at wharton.upenn.edu/~benninga/mit.html
Guide to Business Modelling (no CD provided) by John Tennent and Graham Friend at www.economist.com
MBA's Guide to Microsoft Excel by Stephen Nelson published by Redmond Technology Press at www.redtechpress.com
Risk Analysis by David Vose and published by Wiley at www.wiley.com
Financial Models using Simulation and Optimization by Wayne Winston published by Palisade at www.palisade.com
Simulation Modelling using @RISK by Wayne Winston and published by Duxbury at www.duxbury.com
Excel Power Programming with VBA by John Walkenbach published by M&T Books at www.j-walk.com/ss/books/xlbook25.htm.
Data Analysis and Decision Making with Microsoft Excel by S Albright, W Winston and C Zappe published by Duxbury at www.duxbury.com
Business Forecasting with Accompanying ForecastX Software by J Holton Wilson and Barry Keating published by McGraw-Hill Higher Education at www.johngalt.com
Business Analysis with Microsoft Excel by Conrad Carlberg published by Que at www.quehelp.com
Financial Modeling using Excel and VBA by Chandan Sengupta published by Wiley at www.wileyfinance.com
Excel For Dummies, 2nd Edition by Greg Harve published by Wiley at www.dummies.com
Excel VBA For Dummies on John Walkenbach published by Wiley at www.dummies.com
Microsoft Excel für Fortgestrittene (German) by Cornelia Nicol published by Microsoft Press at www.microsoft.com/germany/mspress
Microsoft Excel 2003 Formeln und Funktionen (German) by Bernd Held published by Buch AG & CO KG at www.vmi-Buch.de
The Oxford Guide to Financial Modeling Applications for Capital Markets, Corporate Finance, Risk Management and Financial Institutions by Thomas Ho and Sang Bin Lee
Excel Data Analysis by Jinjer Simon published by Wiley
Excel Sales Forecasting for Dummies by Conrad Carlberg published by Wiley
Pivot Table Data Crunching by Bill Jelen published by Que Publishing
Statistical Analysis with Excel for Dummies by Joseph Schmuller published by Wiley
Building Financial Models with Microsoft Excel by K Scott Proctor published by Wiley
Dealmaking using Real Options and Monte Carlo Analysis by Richard Razgaitas published by Wiley
Principles of Finance with Excel by Simon Benninga published by Oxford University Press
Applied Simulation Modeling by Seila, Ceric and Tadikamalla published by Duxbury
The Definitive Guide to Business Finance by Richard Stutely published by FT Prentice Hall

2007/2010 Links

Excel 2010 Bible by John Walkenbach published by Wiley
Excel 2010 Power Programming with VBA by John Walkenbach at eu.wiley.com
Excel 2010 Formulas by John Walkenbach published at www.wiley.com
Excel VBA Programming for Dummies by Dr Greg Harvey published by Wiley
Microsoft interactive website at Excel 2007 interactive guide . There are similar sites for the Word 2007 interactive guide and the PowerPoint 2007 interactive guide.

Software

Solver optimisation add-in for Excel and information at www.frontsys.com or www.solver.com
Financial CAD for a library of advanced Excel financial functions www.financialcad.com
ForecastX software from John Galt at www.forecastx.com
ForecastPro at www.forecastpro.com
Mathtools for a massive library of links www.mathtools.net
IntelligentApps for OLAP reporting applications in Excel at www.intelligentapps.com
Business Functions for a range of Excel formatting and other utilities at www.businessfunctions.co.uk
Excel tips from www.exceltip.com
Excel assistance from www.mrexcel.com
Excel downloads and add-ins from www.tushar-mehta.com
Excel statistics add-in at www.xlstat.com
StatistiXL, a data analysis package for Excel at www.statistixl.com
Excel classroom tools and templates at www.qualitylogoproducts
Statistical and decision analysis tree Excel add-In add-in from Luminaut at www.lumenaut.com
Statistics add-in at www.winstat.com
Simulation and decision add-ins at www.decisiontoolpak.com
OLAP in Excel at www.xlcubed.com
Compare Excel workbooks at www.4tops.com/compare_excel_files.htm
EstateMaster real estate add-in at http://www.estatemaster.net
Excellaneous add-in for Scientists at www.bowdoin.edu/~rdelevie/excellaneous
Maths in Excel at http://digilander.libero.it/foxes/SoftwareDownload.htm
Office add-ins at www.office-addins.com/index.html
Project Analyzer at www.aivosto.com/project/vba.html
Cashflow Wizard at www.cashflowwizard.com
Jabsoft Model Assistant Suite as a collection of modelling tools
Rate yield curve model at www.yieldcurve.com/default.asp
Spider Financial for analytical and statistical software tools and services for securities trading, risk management and financial operations
EZplot for plotting and data calculation.

Auditing

Spreadsheet Detective auditing tools www.spreadsheetdetective.com
Navigator utilities at www.navigatorutilities.com/
Spreadsheet Professional audit tool http://www.exceleratedconsulting.com.au/software.htm
PopTools statistical add-in http://www.cse.csiro.au/poptools
XDrill for cell and model auditing from www.sheetware.com
J Walk and Associates for Excel add-ins such the Power Utility Pack at www.j-walk.com
TheModelAnswer financial modelling and Rainbow Analyst auditing software www.themodelanswer.com
Spreadsheet Navigator for relationships between cells in a graphical format at www.brandywine-software.com
Audit Excel at www.auditexcel.co.za
The Excel Auditor and Tools at www.bygsoftware.com/default.htm
Spreadsheet checklist at www.chacocanyon.com/essays/spreadsheetchecklist.shtml
XL Analyst from Codematic from www.XLanalyst.co.uk
Excel tool for comparing Excel spreadsheets and Excel databases at www.synkronizer.com
Spreadsheet Professional at www.spreadsheetinnovations.com
Stand-alone Excel checker from www.spreadsheetauditing.com EXChecker
Formlist auditing tool at home.uchicago.edu/~rmyerson/addins.htm
Spreadsheet Selector Object Library for extracting data and formulae at www.addix.com
SpACE, the UK Customs and Excise Audit methodology, at www.hmce.gov.uk/business/services/space.htm
Synkronizer to compare update and synchronize spreadsheets at www.synkronizer.com
Explode auditing tool at www.xl-logic.com/pages/explode.html
Spreadsheet compliance issues relating to the use and control of spreadsheets at www.wimmersystems.com
Named ranges information at www.cpearson.com/excel/named.htm
ScanXLS software for Spreadsheet Inventory and cross-reference links mapping
Byg Software for the Excel Auditor at www.bygsoftware.com/auditor/auditor.htm
Louise Pryor’s site for auditing and error discovery at www.louisepryor.com/show.do?page=home
Spreadsheet Advantage at www.spreadsheetadvantage.com

Simulation

@RISK simulation add-in and other tools www.palisade.com
Crystal Ball simulation add-in www.crystalball.com
Risk Analyzer simulation at www.add-ins.com/analyzer
Simtools and Formlist add-ins for Excel home.uchicago.edu/~rmyerson/addins.htm
Financial Planning Monte Carlo system from Bill Swerbenski at www.portfoliosurvival.com
Primavera who publish Monte Carlo as an add-in to the Primavera project planning software
Simulación 4.0 at www.cema.edu.ar/~jvarela/index_eng.htm
SimulAr simulation for Excel at www.simularsoft.com.ar
MonteCarlito is a free Excel-add-in for Monte-Carlo-simulations at qse.ifs.tuwien.ac.at/~auer/montecarlito

General

History of Excel at http://en.wikipedia.org/wiki/Microsoft_Excel
Microsoft Excel quizzes at http://office.microsoft.com/en-us/FX010380471033.aspx
Raymond Panko at the University of Hawaii on spreadsheet errors at http://panko.cba.hawaii.edu/ssr/Mypapers/whatknow.htm and www.panko.com
European spreadsheet group at www.eusprig.org
Excel Nexus - Excel information at www.vertex42.com/ExcelLinks
Excel Everywhere for putting Excel into web pages at www.exceleverywhere.com
Excel Everest - an interactive program for a hands-on Excel learning experience
Addix Selector for the ability to extract data and formulae from Excel spreadsheets without the need to open the spreadsheets using Excel at www.addix.com/products/selector/overview.html
Office add-ins and links at www.office-addins.com
MS Excel XML file conversion utility XML to XLS at www.forgram.com
SuperModeller for development of financial and reporting applications at www.econsult.com.au
Mathmatical finance group - Oxford University www.maths.ox.ac.uk/mfg/mfg/activ.htm
Statistics in Excel from www.practicalstats.com/pages/excelstats.html
NAG for Excel add-ins www.nag.com/local/excel.asp
Vanguard software for decision tree and simulation applications www.vanguardsw.com
Lumina Decision Systems, the publishers of Analytica software
A project risk analysis application called Pertmaster for project planning and project risks
Project Finance Models is a financial models resource at www.project-finance-models.com
Plum Solutions for modelling solutions at www.plumsolutions.com.au
Strategic Modeling for option models at www.strategicmodeling.com
Excel mathematics www.man.deakin.edu.au/rodneyc/XLMath.htm
Derivicom develops financial add-ins and developer libraries that evaluate derivatives www.derivicom.com
Spreadsheet Aided Engineering Analysis at www.spreadsheetworld.com
Wiley valuation home page http://wileyvaluation.com
Corporate Performance Systems for valuation and consulting www.cpshome.com
Visual DSS financial modelling at www.trueblue.com.au
Stern Stewart www.sternstewart.com
Risk Grades for risk information and scores www.riskgrades.com
Bayesian networks with Hugin lite at www.hugin.com
Decision tree add-in at www.treeplan.com
Chris Mead for Excel on the web www.meadinkent.co.uk
Ozgrid.com business applications at www.ozgrid.com
Access Analytic providing financial modelling, management reporting, spreadsheet auditing and training
Stephen Aldridge's financial modelling site at www.financialmodelling.net
Useful and time saving add-ins for Microsoft Excel, Outlook and MS Word at www.ablebits.com
ACBA for computing and business analysis at www.acba.co.uk
Micro charts at BoneVista Systems at www.bonavistasystems.com/index.html
Dan Bricklin’s web site at www.bricklin.com
Excel problems and fixes at www.daheiser.info/excel/frontpage.html
Easter eggs archive at http://www.eeggs.com/tree/279.html
Excel tips at http://exceltips.vitalnews.com
Mr Excel at www.mrexcel.com/pressbio.shtml
Thomas Ho site at www.thomasho.com/mainpages/homepage.asp
Damodaran online at http://pages.stern.nyu.edu/~adamodaran
London Business School Risk Measurement Service at www.london.edu/riskmeasurementservice.html
Mathtools at www.mathtools.net
Risk and contingency Analysis websites at www.contingencyanalysis.com
Wachowicz’s Web World at http://web.utk.edu/~jwachowi/wacho_world.html
Wiillmott quantitative finance at www.wilmott.com
Navigator project finance modelling at www.navigatorpf.com
Software for business and finance at www.allbusinesstools.com
Infinity Software for PowerOne calculator for Windows, Windows Mobile and Blackberries
DataSafeXL spreadsheet security - secure Microsoft Excel files, protect VBA code,
Museum of HP calculators for details of all Hewlett-Packard's present and former calculators www.hpmuseum.org
Microsoft Crabby Office Lady Quiz at http://office.microsoft.com/en-us/help/HA010429661033.aspx
Spreadsheet humour from j-walk at http://j-walk.com/ss/jokes/
In case this is getting too heavy - the Dilbert zone www.unitedmedia.com/comics/dilbert or the cartoon web at http://cartoonweb.com
KAL business cartoons at www.baltimoresun.com/news/opinion/cartoons