Systematic Finance
Systematic Finance
Home
Systematic Finance Home
Books
Training
Consulting
Software and Templates
Author
Links
Online Store
Contact Us

Links

Financial Modelling Links 

Books, add-ins, auditing, simulation and general links

Financial Times links at www.business-minds.com

Please send us an email if you would like to be added to the list.  Download a copy of sudoku as a modelling example.

Books 

  1. Mastering Financial Modelling by Alastair Day for superior modelling published by the Financial Times
  2. Mastering Financial Mathematics in Excel in the Mastering Series for the Financial Times
  3. Mastering Risk Modelling by Alastair Day for applied risk in Excel published by the Financial Times
  4. Data Analysis with Microsoft Excel by Berk and Carey including the StatPlus add-in www.duxbury.com or www.thomsonlearning.com
  5. Advanced Modelling in Finance using Excel and VBA by M Jackson and M Staunton published by Wiley at www.wiley.com
  6. Financial Modeling is a book and disk combination by Simon Benninga at wharton.upenn.edu/~benninga/mit.html
  7. Insight.xla modelling book and disk combination www.analycorp.com
  8. Guide to Business Modelling (no CD provided) by John Tennent and Graham Friend at www.economist.com
  9. MBA's Guide to Microsoft Excel by Stephen Nelson published by Redmond Technology Press at www.redtechpress.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 Power Programming with VBA by John Walkenbach published by M&T Books at www.j-walk.com/ss/books/xlbook25.htm.
  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. Business Analysis with Microsoft Excel by Conrad Carlberg published by Que at www.quehelp.com
  17. Financial Modeling using Excel and VBA by Chandan Sengupta published by Wiley at www.wileyfinance.com
  18. Excel For Dummies, 2nd Edition by Greg Harve published by Wiley at www.dummies.com
  19. Excel VBA For Dummies on John Walkenbach published by Wiley at www.dummies.com
  20. Excel 2003 Bible by John Walkenbach published by Wiley at www.j-walk.com
  21. Microsoft Excel für Fortgestrittene (German) by Cornelia Nicol published by Microsoft Press at www.microsoft.com/germany/mspress
  22. Microsoft Excel 2003 Formeln und Funktionen (German) by Bernd Held published by Buch AG & CO KG at www.vmi-Buch.de
  23. The Oxford Guide to Financial Modeling Applications for Capital Markets, Corporate Finance, Risk Management and Financial Institutions by Thomas Ho and Sang Bin Lee
  24. Excel Data Analysis by Jinjer Simon published by Wiley
  25. Excel Sales Forecasting for Dummies by Conrad Carlberg published by Wiley
  26. Pivot Table Data Crunching by Bill Jelen published by Que Publishing
  27. Statistical Analysis with Excel for Dummies by Joseph Schmuller published by Wiley
  28. Building Financial Models with Microsoft Excel by K Scott Proctor published by Wiley
  29. Dealmaking using Real Options and Monte Carlo Analysis by Richard Razgaitas published by Wiley
  30. Principles of Finance with Excel by Simon Benninga published by Oxford University Press
  31. Applied Simulation Modeling by Seila, Ceric and Tadikamalla published by Duxbury
  32. The Definitive Guide to Managing the Numbers by Richard Stutely published by FT Prentice Hall

2007 Books and Links  

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

< Back To Top

Links to Sites and Software

Add-Ins

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

< Back To Top

Auditing

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

< Back To Top

Simulation

  1. @RISK simulation add-in and other tools www.palisade.com
  2. Crystal Ball simulation add-in www.crystalball.com
  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. Financial Planning Monte Carlo system from Bill Swerbenski at www.portfoliosurvival.com
  6. Primavera who publish Monte Carlo as an add-in to the Primavera project planning software
  7. Simulación 4.0 at www.cema.edu.ar/~jvarela/index_eng.htm
  8. SimulAr simulation for Excel at www.simularsoft.com.ar
  9. MonteCarlito is a free Excel-add-in for Monte-Carlo-simulations at qse.ifs.tuwien.ac.at/~auer/montecarlito

< Back To Top

General

  1. History of Excel at http://en.wikipedia.org/wiki/Microsoft_Excel
  2. Microsoft Excel quizzes at http://office.microsoft.com/en-us/FX010380471033.aspx
  3. Raymond Panko at the University of Hawaii on spreadsheet errors at http://panko.cba.hawaii.edu/ssr/Mypapers/whatknow.htm and www.panko.com
  4. European spreadsheet group at www.eusprig.org
  5. Excel Nexus - Excel information at www.vertex42.com/ExcelLinks
  6. Excel Everywhere for putting Excel into web pages at www.exceleverywhere.com
  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. Office add-ins and links at www.office-addins.com
  9. MS Excel XML file conversion utility XML to XLS at www.forgram.com
  10. SuperModeller for development of financial and reporting applications at www.econsult.com.au
  11. Mathmatical finance group - Oxford University www.maths.ox.ac.uk/mfg/mfg/activ.htm
  12. Statistics in Excel from www.practicalstats.com/pages/excelstats.html
  13. NAG for Excel add-ins www.nag.com/local/excel.asp
  14. Vanguard software for decision tree and simulation applications www.vanguardsw.com
  15. Lumina Decision Systems, the publishers of Analytica software
  16. A project risk analysis application called Pertmaster for project planning and project risks
  17. Project Finance Models is a financial models resource at www.project-finance-models.com
  18. Plum Solutions for modelling solutions at www.plumsolutions.com.au
  19. Strategic Modeling for option models at www.strategicmodeling.com
  20. Excel mathematics www.man.deakin.edu.au/rodneyc/XLMath.htm
  21. Derivicom develops financial add-ins and developer libraries that evaluate derivatives www.derivicom.com
  22. Spreadsheet Aided Engineering Analysis at www.spreadsheetworld.com
  23. Wiley valuation home page http://wileyvaluation.com
  24. Corporate Performance Systems for valuation and consulting www.cpshome.com
  25. Visual DSS financial modelling at www.trueblue.com.au
  26. Stern Stewart www.sternstewart.com
  27. Risk Grades for risk information and scores www.riskgrades.com
  28. Bayesian networks with Hugin lite at www.hugin.com
  29. Decision tree add-in at www.treeplan.com
  30. Chris Mead for Excel on the web www.meadinkent.co.uk
  31. Ozgrid.com business applications at www.ozgrid.com
  32. Mailbarrow at www.mailbarrow.com for Excel development and spreadsheet best practice consulting
  33. Stephen Aldridge's financial modelling site at www.financialmodelling.net
  34. Useful and time saving add-ins for Microsoft Excel, Outlook and MS Word at www.ablebits.com
  35. ACBA for computing and business analysis at www.acba.co.uk
  36. Micro charts at BoneVista Systems at www.bonavistasystems.com/index.html
  37. Dan Bricklin’s web site at www.bricklin.com
  38. Excel problems and fixes at www.daheiser.info/excel/frontpage.html
  39. Easter eggs archive at http://www.eeggs.com/tree/279.html
  40. Excel tips at http://exceltips.vitalnews.com
  41. Mr Excel at www.mrexcel.com/pressbio.shtml
  42. Thomas Ho site at www.thomasho.com/mainpages/homepage.asp
  43. Damodaran online at http://pages.stern.nyu.edu/~adamodaran
  44. London Business School Risk Measurement Service at www.london.edu/riskmeasurementservice.html
  45. Mathtools at www.mathtools.net
  46. Risk and contingency Analysis websites at www.contingencyanalysis.com
  47. Wachowicz’s Web World at http://web.utk.edu/~jwachowi/wacho_world.html
  48. Wiillmott quantitative finance at www.wilmott.com
  49. Navigator project finance modelling at www.navigatorpf.com
  50. Software for business and finance at www.allbusinesstools.com
  51. Infinity Software for PowerOne calculator for Windows, Windows Mobile and Blackberries
  52. DataSafeXL spreadsheet security - secure Microsoft EXCEL files, protect VBA code,
  53. Museum of HP calculators for details of all Hewlett-Packard's present and former calculators www.hpmuseum.org
  54. Microsoft Crabby Office Lady Quiz at http://office.microsoft.com/en-us/help/HA010429661033.aspx
  55. Spreadsheet humour from j-walk at http://j-walk.com/ss/jokes/
  56. In case this is getting too heavy - the Dilbert zone www.unitedmedia.com/comics/dilbert or the cartoon web at http://cartoonweb.com
  57. KAL business cartoons at www.baltimoresun.com/news/opinion/cartoons

< Back To Top

 
 
site designed by footprint