course bg
EduPristine>Blog>FRM Success: Xcel FRM Series

FRM Success: Xcel FRM Series

November 7, 2012

Dear FRM Candidate, hope your preparation so far has been smooth! With D-Day just around the corner, many students tend to start cramming just about now!

That’s why we thought we would extend a helping hand. We at EduPristine have demystified a few tough topics through our new series "Xcel FRM Series".

This series would be especially helpful if you:

  • Learn Better Hands-On
  • Are trying to get through tough topics quickly
  • Wonder how the concepts taught in FRM are applicable in real life
  • Want to learn a thing or two in MS Excel.

The Xcel FRM Series is a 3 day series where you will receive MS Excel Sheets absolutely FREE!

Today, let’s focus on the areas of Foundations of Risk Management and Quantitative Analysis. We have included 4 Workbooks that cover the following topics:

  • Effect of Correlation on Portfolio Risk and Return – using form control: Here, you will learn visually how correlation impacts the performance of a two asset portfolio. Check out how the shape of the portfolio possibilities curve is formed. After the exam, you can learn how to use form controls.
  • Efficient Frontier: You can see how the efficient frontier is actually constructed. After the exam, learn how the array function "MMULT" is used.
  • Regression Analysis: Find the Beta of a stock by regressing the Stock return’s against a benchmark’s. See how regression analysis is performed using the OLS tool in Excel.
  • Two Asset Correlation: Learn how to calculate correlation using a Step by Step Approach.

Feel free to share these sheets with your friends!

Stay tuned for Day 2 of Financial Markets and Products. 
Till then, happy studying!

About Author

avatar EduPristine

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.

Tags
Excel FRM tips xcel frm

Comments

Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

Post ID = 21661