• 
• 
• 
• 
• 
• 
• 
• 

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, Modeling & Economics at EY - CFA Charterholder and Certified Financial ModellerFollow 10

13 reviews925 views|2 comments|Bookmark download for free

excel modelmonte carlofootballrandomfifa world cuprussia 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 Best Practice includes
1 Excel Model

Rafael Le Saux, CFA, AFM offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Reviews

• • 
    4.8 / 5 (13 votes)

    • 77%
    • 23%
    • -
    • -
    • -
  • Rate this Downloadable Tool
    

    Write a review

• Charles.HA. Chen(last updated: 23/08/2019 01:16)
  
• Choi Tony(last updated: 13/06/2019 01:17)
  
• Syed Nayab Haider(last updated: 24/11/2018 17:46)
  
• Kingsley Valentine Uzogor(last updated: 08/11/2018 02:34)
  
• 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)
  

keyboard_arrow_downShow all

People using this Best Practice also downloaded

Post Comment

• 

  Reto Wernli 1 year ago
  Downloadable 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.

  arrow_drop_uparrow_drop_downReply reply

  • 

    Rafael Le Saux, CFA, AFM 1 year ago
    Downloadable 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