The Most Rapid Essay Writing Service For Your Academic Success

Become a better student and get high grades with our professional writers.

Welcome to the #1 paper writing service, where each essay writer knows your needs and saves you from endless tasks!

  • We cover all disciplines and academic styles.
  • We meet your deadlines and formatting requirements.
  • We ask nothing but your “thank you” in return.

Entrust our essay writing service with your homework today—and forget about dull tasks and poor grades forever.

VBA Historical VaR, ES, EVT with Risk Factors

2. Write a VBA Procedure that, assuming uniform historical scenario weights, calculates
– Historical VaR,
– Expected Shortfall
– and EVT Tail VaR of DFL Bank’s Trading Portfolio while at the same time…

A) Give user flexibility to choose confidence interval and time horizon (max=5 days) as number of days; as well as critical cut point required by EVT

Assume DFL Bank’s total trading portfolio consists of derivatives, stocks and bond instruments and only considers risk arising from FX, IR and EQ risk factors and reporting Currency is in USD.

The worksheet: RFSeries contains historical riskfactor scenario time series of all risk factors, including IR, EQ, FX risk factors (risk factor symbols are consistent to my class notes). In the worksheet: RFSeries, the 3rd row contains Base scenario (i.e. risk factors’ values as of today), 4th row contains the past one day historical observations, 5th row contains the past two days historical observations, etc. There are 76 historical observations in total. IR series are returns per annual.

You can leave a response, or trackback from your own site.
Powered by WordPress | Designed by: Premium WordPress Themes | Thanks to Themes Gallery, Bromoney and Wordpress Themes