Stress testing in Excel

ChrisN

Member
Hi guys (and gals),

What does stress testing of pricing functions means? And how can you do that in Excel?
 

ChrisN

Member
Also, how would you test if a model is fit for purpose? What are the criteria?

For example, if a specific mathematical model is used for coupon payment and bond pricing, how would you test if it is fit for purpose?
 

Tsotne

Well-Known Member
I'll send you one excel template for Stress testing when I get home. Are you applying it in VAR? It'd be better if you didn't use excel for it. Since there can be MC simulations requiring to process large amount of data. Excel is not that flexible than customized software for it.
 

ChrisN

Member
For now it will be just Bond pricing. Please do send me the template, it would be really helpful. What would be the ideal software to use for large amount of data?
 

Tsotne

Well-Known Member
For now it will be just Bond pricing. Please do send me the template, it would be really helpful. What would be the ideal software to use for large amount of data?
Yes sure write me an e-mail in private conversation. I have learned some stress testing models in VAR and have come across some Excel templates for stress simulations. As for ideal software, I don't know if there exists such software focusing on stress-testing, what I meant in customized software was creating your own software in C++ for example which makes it by far flexible than excel if you are using such methods frequently rather than to struggle cell-by-cell in excel.

Edit:
http://www.younginc.com/stress/#HELOC
But before, this might be interesting for you. They are quite expensive though. I just outlined that some guys out there are working to create particular stress testing models for various scenarios in Excel.
@ChrisN
 

ChrisN

Member
Thank you very much for that Tsotne... Loads of information and I need to go through the whole thing.

Thanks again,
Chris.
 

YLH

New Member
Yes sure. Write your mail
Hi Tstone,

I have come across this thread and would you mind sending me the templates as well? I am a newbie and I have been struggling with stress testing using excel based. Thanks
 

Ria R

New Member
Hi Tsotne,
Am trying to build a model on stress testing VaR on Currency portfolio using excel. if you could share the stress testing templates, it would be really helpful.

My Email Id: muskaanp@rediffmail.com

Thanks in Advance.

Regards,
Ria R
 

tagoma

Member
Hi all.

I just read this thread.

I am curious to have a look at the spreadsheet you talk about above, Tsotne.
Would you be kind to send it out to me?

Best,
Édouard
 

Jakubo

New Member
Hi Tsone and Edouard,

could you please share the files you talked about?
I sent you an e-mail in private conversation.

All the best,

Jakub
 
Top