Most Valuable Skill for Risk Managers?
In terms of marketable expertise for financial risk managers, what counts more: quantitative skills, or the ability to communicate and interpret the results of calculations? “The biggest surprise of our in-depth study is that communication ranked above quant skills,” said Christopher Donohue, Managing Director of Research and Educational Programs at the Global Association of Risk Professionals. On June 30, 2015, he reported on the results of the 2015 Job Task Analysis of GARP members. Survey Design The goal of the survey and analysis was to identify knowledge and skills necessary to support competent performance of tasks and responsibilities that are […]
3 Steps to Liquidity Compliance
Are you scrambling to adjust to new reporting expectations for liquidity risk? Getting good data is key, but “you have to get it right and on time,” said Pierre Mesnard, Director Solutions Specialist at Moody’s Analytics. He was the third of three presenters on liquidity risk compliance at a webinar on June 25, 2015, sponsored by the Global Association of Risk Professionals. Once you have the data, there are three steps to delivering integrated liquidity compliance and business management, said Mesnard. First, you must ensure all financial instruments at your bank can be adequately modelled in order to generate realistic […]
Liquidity: A Change in Governance
Have you noticed that financial risk managers talk and think differently about liquidity risk, compared to pre-crisis days? The 2007-08 financial crisis was a watershed in the evolution of liquidity management, according to Nicolas Kunghehian, Director Solutions Specialist at Moody’s Analytics. He was the second of three presenters on liquidity risk compliance at a webinar on June 25, 2015, sponsored by the Global Association of Risk Professionals. “Before the crisis, there was only one team dedicated to monitoring and managing liquidity,” Kunghehian said. Liquidity risk was assumed to be small, and the Treasury department was chiefly fine-tuning the profit and […]
An Opportunity To Get Things Right
When it comes to forecasting liquidity risk, does your bank follow best practices? It might be tough to do so, because of a “data conundrum,” said Gudni Adalsteinsson, author of The Liquidity Risk Management Guide – from Policy to Pitfalls. Banks carry out a “retrospective analysis” on data that is “not forward looking.” Adalsteinsson, Head of Global Liquidity, Group Treasury at Legal & General Group Plc, was the first of three presenters on liquidity risk compliance, at a webinar on June 25, 2015, sponsored by the Global Association of Risk Professionals. He praised the Basel III regulation on liquidity risk. […]
Effective Risk Reporting
Effective risk reporting means “having the intelligence at your fingertips but exercising the judgment to report only what your company needs,” said Elizabeth Abraham, Director of Professional Services at MetricStream, and the second of two presenters at the June 16, 2015, webinar on Effective Risk Reporting sponsored by the Global Association of Risk Professionals. “Lack of clarity about the reporting objective” is a common barrier to effective enterprise risk management reporting, she said. Make sure you understand what level of information the audience wants. “Data model inconsistencies can lead to an inability to aggregate” the risk estimates, and that’s another […]
One Size Does Not Fit All
When it comes to risk reporting, do you ever feel that you are trying to push a square peg into a round hole? According to Gordon Goodman, that may happen rather often for companies that are not in the finance industry. Goodman, Director of Governance and Enterprise Risk Management at NRG Energy, was the first of two presenters at the June 16, 2015, webinar on Effective Risk Reporting sponsored by the Global Association of Risk Professionals. According to Goodman, there has been a push by banks to “bring their metrics to the marketplace, but this has created problems” for non-financial […]
Old Dog, New Tricks. List of Tricks
The following are a dozen helpful things I learned at a day-long seminar “The Power of Excel – Part 2,” held on location at the offices of the CFA Society of Toronto on June 10, 2015. The seminar was conducted by Jon Zelman of The Marquee Group. 1. Resist the Mouse 2. Best shortcut of the day 3. ALT-ernative Existence 4. If you filter, use SUBTOTAL, not SUM 5. To count the number of visible rows 6. Searching with multiple conditions 7. D is for Database function 8. “Exact” string matching versus “includes” 9. Multiple conditions for SUMIF 10. Weed out bad parameters early with Data Validation 11. Match and Index functions complement […]
Old Dog, New Tricks. 11 & 12
11. Match and Index functions complement each other “The INDEX function is one of the most powerful but also one of the most complex functions in Excel,” Zelman said. Both INDEX and MATCH are Lookup functions in Excel, so whatever comfort you have with VLOOKUP or HLOOKUP will be useful here. Big picture: you use MATCH to find the coordinates, and you use INDEX to apply the coordinates to find a value. The Match function returns the relative position of an item within a column of data (or a row of data). The syntax is MATCH(lookup_value, Lookup_vector, Match_type). Note I […]
Old Dog, New Tricks. 9 & 10
9. Multiple conditions for SUMIF Let’s say a table has a dollar column you want to add up, but only for entries that have “Industry” = “Finance” whose “Lead Underwriter” is “Morgan Stanley”. You could set up Filter and then use SUBTOTAL, as described above. Another way to get the answer is using a type of SUMIF … the type with multiple conditions. To give multiple conditions to a function such as SUMIF or COUNTIF, use the functions SUMIFS or COUNTIFS instead. The general syntax is SUMIFS(dollar column to be summed, column of name1s, name1 criterion, column of name2s, name2 […]
Old Dog, New Tricks. 7 & 8
7. D is for Database function “Excel’s Database functions are some of the most powerful and underutilized functions in Excel,” Zelman said. Those formulas starting with “D” such as DAVERAGE, DCOUNTA, DVAR, and so on, are all set up to work on a database, which is typically shown as a flat table of numbers and text (rows and columns). The Database functions all use the same syntax: DCOUNTA(Database, field, criteria). He specified four steps for setting up a Database function. Ensure the raw data has column headings. Add a few blank rows (“the sandbox”) at the top of the raw […]