We are a Power Retailer operating on a deregulated energy market, and we need to develop a tool for evaluation of risk exposure on the existing and / or forecasted portfolio using Monte Carlo simulation for Excel..
The tool has to allow us to:
- define risk scenarios, such as hedging contracts, books, demand curves, price indexes, selling contracts
- define the algorithm variables
The target is the Hedging Strategy Optimisation, i.e. determine the mix of derivative contracts to achieve an optimal risk / return outcome:
• Profit & Loss
• Margin calls
• Exposure calculations
• PaR etc.
In other words, given different scenarios and variables, we’d like to perform a simulation to determine the possible outcomes, and how likely are they to occur.
13 freelancers are bidding on average $759 for this job
Hi, I think I can help you in this project. I have done several projects involving MC methods, among others in risk forecasting (we can discuss that). Besides, I hold a MSc in Finance. Regards, Oriol.
Good afternoon! I am a statistical and analytical consultant with years of experience developing solutions. I'd love to chat with you more about your project and what you want it to look like!
Hi ferbelgui, I have experience with financial market - Forex technical analyzes, including portfolio optimisation and risk management. I think can help you for this project.