Systematic Finance

Systematic Finance - financial modelling services, financial training, financial model audit and review, financial modelling books
Systematic financial modelling books cover everything from basic Excel techniques to advanced mathematics, risk and cash flow modelling mrm
mfmaths
 mcfm

Essential Financial Modelling Books

  1. Mastering Financial Modelling by Alastair Day for financial modelling published by Pearson Higher Education & Professional
  2. Mastering Risk Modelling by Alastair Day for applied risk in Excel published by Pearson Higher Education & Professional
  3. Mastering Financial Mathematics in Excel by Alastair Day in the Mastering Series for Pearson Higher Education & Professional
  4. Mastering Cash Flow and Valuation Modelling by Alastair Day in the Mastering Series for Pearson Higher Education & Professional
  5. Applied Lease Finance by Alastair Day published as an e-book by Systematic
  6. Data Analysis with Microsoft Excel by Berk and Carey including the StatPlus add-in www.cengage.com or learn.thompsonbooks.com
  7. Advanced Modelling in Finance using Excel and VBA by M Jackson and M Staunton published by Wiley at www.wiley.com
  8. Financial Modeling is a book and disk combination by Simon Benninga at simonbenninga.com
  9. Guide to Business Modelling (no CD provided) by John Tennent and Graham Friend at www.economist.com
  10. Risk Analysis by David Vose and published by Wiley at www.wiley.com
  11. Financial Models using Simulation and Optimization by Wayne Winston published by Palisade at www.palisade.com
  12. Simulation Modelling using @RISK by Wayne Winston and published by Duxbury at www.duxbury.com
  13. Excel 2019 Power Programming with VBA by Michael Alexander published by Wiley
  14. Data Analysis and Decision Making with Microsoft Excel by S Albright, W Winston and C Zappe published by Duxbury at www.duxbury.com
  15. Business Forecasting with Accompanying ForecastX Software by J Holton Wilson and Barry Keating published by McGraw-Hill Higher Education at www.johngalt.com
  16. Financial Modeling using Excel and VBA by Chandan Sengupta published by Wiley at www.wileyfinance.com
  17. Excel For Dummies, 2nd Edition by Greg Harve published by Wiley at www.dummies.com
  18. Excel VBA For Dummies on John Walkenbach published by Wiley at www.dummies.com
  19. Microsoft Excel für Fortgestrittene (German) by Cornelia Nicol published by Microsoft Press at www.microsoft-press.de
  20. Microsoft Excel 2003 Formeln und Funktionen (German) by Bernd Held published by Buch AG & CO KG at www.mitp.de/
  21. The Oxford Guide to Financial Modeling Applications for Capital Markets, Corporate Finance, Risk Management and Financial Institutions by Thomas Ho and Sang Bin Lee
  22. Excel Data Analysis by Jinjer Simon published by Wiley
  23. Excel Sales Forecasting for Dummies by Conrad Carlberg published by Wiley
  24. Pivot Table Data Crunching by Bill Jelen published by Que Publishing
  25. Statistical Analysis with Excel for Dummies by Joseph Schmuller published by Wiley
  26. Building Financial Models with Microsoft Excel by K Scott Proctor published by Wiley
  27. Dealmaking using Real Options and Monte Carlo Analysis by Richard Razgaitas published by Wiley
  28. Principles of Finance with Excel by Simon Benninga published by Oxford University Press
  29. Applied Simulation Modeling by Seila, Ceric and Tadikamalla published by Duxbury
  30. The Definitive Guide to Business Finance by Richard Stutely published by FT Prentice Hall
  31. Damodaran Online: home page for Aswath Damodaran

Standard Excel General Textbooks and Links

  1. Excel 2019 Bible as a standard text by John Walkenbach published by Wiley
  2. Excel 2016 Formulas by Michael Alexander and Richard Kusleika published at www.wiley.com
  3. Excel 2013 Bible by John Walkenbach published by Wiley
  4. Excel 2013 Formulas by John Walkenbach published at www.wiley.com
  5. Excel 2010 Bible by John Walkenbach published by Wiley
  6. Excel 2010 Power Programming with VBA by John Walkenbach at eu.wiley.com
  7. Excel 2010 Formulas by John Walkenbach published at www.wiley.com
  8. Microsoft interactive website at Excel 2007 interactive guide.

Excel Add-ins, Useful Sites and Application Software

  1. Solver optimisation add-in for Excel and information at www.solver.com
  2. Financial CAD for a library of advanced Excel financial functions www.fincad.com
  3. ForecastX software from John Galt at www.johngalt.com/forecastx/
  4. TrumpExcel for tutorials, videos and templates at www.trumpexcel.com
  5. Chandoo forum for Excel resources at www.chandoo.com
  6. Financial Models Dealroom for modelling resources www.firmex.com
  7. ForecastPro at www.forecastpro.com
  8. Financial Models Dealroom for modelling resources www.firmex.com
  9. Easy Unit Converter ! Easy Online Calculator & Metric Conversions
  10. Business Functions for a range of Excel formatting and other utilities at www.businessfunctions.co.uk
  11. Excel tips from www.exceltip.com
  12. Excel assistance from www.mrexcel.com
  13. Excel downloads and add-ins from www.tushar-mehta.com
  14. How to Excel by John MacDougall at www.howtoexcel.org
  15. Officetuts for tutorials, examples and shortcuts
  16. Excel automation services, training, and software at www.automateexcel.com
  17. Excel statistics add-in at www.xlstat.com/en/
  18. StatistiXL, a data analysis package for Excel at www.statistixl.com
  19. Statistics add-in at www.winstat.com
  20. OLAP in Excel at www.xlcubed.com
  22. EstateMaster real estate add-in at www.estatemaster.com
  23. Maths in Excel at http://digilander.libero.it/foxes/SoftwareDownload.htm
  24. Office add-ins at www.office-addins.com
  25. Project Analyzer at www.aivosto.com/project/vba.html
  26. Rate yield curve model at www.yieldcurve.com
  27. Spider Financial for analytical and statistical software tools and services for securities trading, risk management and financial operations
  28. EZplot for plotting and data calculation
  29. Good Calculators for online calculators, such as math and statistics, engineering and conversion calculators
  30. Spreadsheeto Excel blog, tips and tutorials

Excel Auditing Add-ins and Programs

  1. Spreadsheet Detective auditing tools www.spreadsheetdetective.com
  2. Navigator utilities at www.navigatorutilities.com
  3. PopTools statistical add-in poptools.software.informer.com/
  4. J Walk and Associates for Excel add-ins such the Power Utility Pack at www.j-walk.com
  5. TheModelAnswer financial modelling and Rainbow Analyst auditing software www.themodelanswer.com
  6. Spreadsheet Navigator for relationships between cells in a graphical format at www.brandywine-software.com
  7. Audit Excel at www.auditexcel.co.za
  8. The Excel Auditor and Tools at www.bygsoftware.com/default.htm
  9. Spreadsheet checklist at www.chacocanyon.com/essays/spreadsheetchecklist.shtml
  10. Operis Analysis Toolkit (OAK) at www.operisanalysiskit.com/  
  11. Excel tool for comparing Excel spreadsheets and Excel databases at www.synkronizer.com
  12. Formlist auditing tool at home.uchicago.edu/~rmyerson/addins.htm
  13. Spreadsheet Selector Object Library for extracting  data and formulae  at www.addix.com
  14. Synkronizer to compare update and synchronize spreadsheets at www.synkronizer.com
  15. Explode auditing tool at www.xl-logic.com
  16. Named ranges information at www.cpearson.com/excel/named.htm
  17. ScanXLS software for Spreadsheet Inventory and cross-reference links mapping
  18. Byg Software for the Excel Auditor at www.bygsoftware.com/auditor/auditor.htm
  19. Louise Pryor’s site for auditing and error discovery at www.louisepryor.com
  20. Spreadsheet Advantage at www.spreadsheetadvantage.com

Monte Carlo Simulation and Stochastic Modelling

  1. @RISK simulation add-in and other tools www.palisade.com
  2. Crystal Ball simulation add-in www.oracle.com/us/products/applications/crystalball
  3. Risk Analyzer simulation at www.add-ins.com/analyzer/
  4. Simtools and Formlist add-ins for Excel home.uchicago.edu/~rmyerson/addins.htm
  5. Oracle Primavera who publish a Monte Carlo add-in
  6. SimulAr simulation for Excel at www.simularsoft.com.ar
  7. MonteCarlito is a free Excel-add-in for Monte-Carlo-simulations at www.montecarlito.com/

General Modelling Books, Sites and Applications

  1. History of Excel at http://en.wikipedia.org/wiki/Microsoft_Excel
  2. European spreadsheet group at www.eusprig.org
  3. Excel Nexus - Excel information at www.vertex42.com/ExcelLinks
  4. Collection of 200 Excel templates
  5. Excel Everywhere for putting Excel into web pages at www.exceleverywhere.com
  6. Excel Everest - an interactive program for a hands-on Excel learning experience
  7. 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
  8. MS Excel XML file conversion utility XML to XLS at www.forgram.com
  9. SuperModeller for development of financial and reporting applications at www.econsult.com.au
  10. Statistics in Excel from www.practicalstats.com
  11. NAG for Excel add-ins www.nag.com/numeric/nagandexcel.asp
  12. Vanguard software for decision tree and simulation applications www.vanguardsw.com
  13. Lumina Decision Systems, the publishers of Analytica software
  14. Plum Solutions for modelling solutions at www.plumsolutions.com.au
  15. Excel mathematics www.deakin.edu.au/~rodneyc/XLMathematics
  16. Derivicom develops financial add-ins and developer libraries that evaluate derivatives www.derivicom.com
  17. Wiley valuation home page wileyactual.com/valuation
  18. Corporate Performance Systems for valuation and consulting www.cpshome.com
  19. Stern Stewart www.sternstewart.com
  20. Risk Grades for risk information and scores www.nasdaq.com
  21. Bayesian networks with Hugin lite at www.hugin.com
  22. Decision tree add-in at www.treeplan.com
  23. Chris Mead for Excel on the web www.meadinkent.co.uk
  24. Ozgrid.com business applications at www.ozgrid.com
  25. Access Analytic providing financial modelling, management  reporting, spreadsheet auditing and training
  26. Useful and time saving add-ins for Microsoft Excel, Outlook and MS Word at www.ablebits.com
  27. ACBA for computing and business analysis at www.acba.co.uk
  28. Dan Bricklin’s web site at www.bricklin.com
  29. Easter eggs archive at http://www.eeggs.com/tree/279.html
  30. Excel tips at http://exceltips.vitalnews.com
  31. Best Excel Tutorial for basic and advanced tutorials
  32. Mr Excel at www.mrexcel.com/pressbio.shtml
  33. Damodaran online at pages.stern.nyu.edu/~adamodar
  34. London Business School Risk Measurement Service at www.london.edu/faculty-and-research/subject-areas/finance/academic-research
  35. Mathtools at www.mathtools.netbasic
  36. Wachowicz’s Web World at http://web.utk.edu/~jwachowi/wacho_world.html
  37. Wiillmott quantitative finance at www.wilmott.com
  38. Infinity Software for PowerOne calculator for Windows, Windows Mobile and Blackberries
  39. DataSafeXL spreadsheet security - secure Microsoft Excel files, protect VBA code,
  40. Museum of HP calculators for details of all Hewlett-Packard's present and former calculators www.hpmuseum.org
  41. KAL business cartoons at www.baltimoresun.com
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.

© 2024 Systematic Finance : Email: [email protected]

Developed by Systematic