Closed

Monte Carlo simulation for Excel for risk analysis - repost

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

- etc

The target is the Hedging Strategy Optimisation, i.e. determine the mix of derivative contracts to achieve an optimal risk / return outcome:

• Mark-to-market

• Profit & Loss

• Margin calls

• Exposure calculations

• VaR

• CVar

• 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.

Evner: Excel, Finans, Økonomiske Markeder, Matlab and Mathematica, Statistikker

Se mere: monte carlo simulation excel, monte carlo risk simulation, monte carlo analysis using excel, monte carlo var excel, var cvar par, risk excel, monte carlo simulation var excel, monte carlo risk analysis, monte carlo risk, monte carlo simulation excel risk, monte carlo analysis excel, simulation tool excel, loss simulation excel, monte carlo risk analysis excel, risk margin simulation, simulation excel, excel energy, define algorithm in c, define algorithm, algorithm tool

Om arbejdsgiveren:
( 5 bedømmelser ) Paterna, Spain

Projekt ID: #4712383

13 freelancere byder i gennemsnit $759 på dette job

MikroStar

hi, i am an electrical engineer and i am proficient in Matlab and simulink. i can help you with this project.

$1800 USD in 45 dage
(32 bedømmelser)
6.2
mastermatlab

hi check msg plz

$833 USD in 20 dage
(29 bedømmelser)
5.1
techhelp56935

Can you please share or message a document or flow diagram for this project?

$250 USD in 5 dage
(6 bedømmelser)
3.6
OriolAM

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.

$277 USD in 5 dage
(5 bedømmelser)
3.5
alphaedge999

Interested in this project.

$1666 USD in 30 dage
(1 bedømmelse)
3.5
JScottArnold

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!

$500 USD in 3 dage
(2 bedømmelser)
3.1
drevak

Dear Sir or Madam, I have a great deal of experience in simulation using different types of software. Could you kindly check your PM for more details?

$833 USD in 20 dage
(2 bedømmelser)
3.0
experttesting11

I am pretty much interested on this

$250 USD på 1 dag
(0 bedømmelser)
0.0
riki888vw

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.

$740 USD in 10 dage
(0 bedømmelser)
0.0
accountplus

I can do this job.

$580 USD in 3 dage
(0 bedømmelser)
0.0
Punar

Hi, I am new to the website and that is the reason for no feedback/ rating. However, I guarantee that the work will be completed in time.

$555 USD in 10 dage
(0 bedømmelser)
0.0
elqueabandona

I have experience using montecarlo simulation. I have examples of prior simulations

$750 USD in 5 dage
(0 bedømmelser)
0.0
wyliechan

Commodities Technology at Bank. Familiar with energy markets, Australian Power. Developed risk monitoring [login to view URL] engines using Monte Carlo simulation in Excel/Matlab. Hedging Optimization of Bond Portfolio to Flere

$833 USD in 30 dage
(0 bedømmelser)
1.8
betaenergy

Dear Sir, I'm 15 year experienced Electronics Engineer whose working area is directly related to your project. I have designed several system which is related to your project. I have high level experience about hard Flere

$555 USD in 3 dage
(3 bedømmelser)
0.0