• 
• 
• 
• 
• 
• 
• 
• 

Send to a friend

• linkedin
• twitter
• facebook
• google+
• code

Originally published: 13/06/2018 06:34
Publication number: ELQ-21664-1
View all versions & Certificate

FIFA World Cup 18 - Monte Carlo Simulation Model

FIFA World Cup 18 Monte Carlo Simulation Model

by Rafael Le Saux, CFA, AFM
Senior Manager - Valuation & Business Modelling at EY | CFA Charterholder and Certified Financial Modeler

9 reviews758 views|2 comments|Bookmark

excel modelfifa world cupfootballmonte carlorandomrussia 2018

Description
FIFA World Cup 18 Monte Carlo Simulation Model, based on sport betting odds and providing estimated odds of winning for every national squad.

Model includes the combination of RAND function and data tables to create a repetitive stochastic process.

Same combination can be used for other simulation, providing an interesting alternative to more complex programming tools, such as VBA or MATLAB.

This business tool includes
1 Excel Model

Rafael Le Saux, CFA, AFM offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Further information

Reviews

• Loic Velechy(last updated: 12/10/2018 17:33)
  
• Liam Teske(last updated: 01/10/2018 21:40)
  
• Reto Wernli(last updated: 25/09/2018 15:24)
  
• Jerry Li.Jerry(last updated: 31/07/2018 03:00)
  
• Giovanni Quaranta(last updated: 26/07/2018 09:40)
  
• Federico Luttini(last updated: 17/06/2018 14:54)
  
• Shaun Barker(last updated: 15/06/2018 06:09)
  
• Ashish sharma(last updated: 13/06/2018 12:32)
  
• Timothée Demoures(last updated: 13/06/2018 08:50)
  

People using this tool also downloaded

Post Comment

• 

  Reto Wernli 3 weeks ago
  Tool Useredit

  Hi Rafael. I don't seem to get how you initiate the Simulation to fill the Columns C, F, I and L in Sheet "Monte Carlo".
  Thanks for your help.

  1arrow_drop_uparrow_drop_downReply reply

  • 

    Rafael Le Saux, CFA, AFM 3 weeks ago
    Tool Authorstar

    Hi Reto,
    
    Thank you for your message.
    
    Have you tried pressing F9 to recalculate?
    
    Please let me know if that works.
    
    Best Regards

    1arrow_drop_uparrow_drop_downReply reply