Oracle Financial Services Market Risk User Guide
Contents
1. Lona BSEHP HP INR Spot Equity 43 Long g 2 User Info User MR Y25USER Creation Date 5 8 2009 15 34 17 Last Modified By MR Y25USER Last Modified Date 05 08 2008 l Done Local intranet Incremental VaR Edit Screen 3 7 Process Description Following is the description of processes in Market Risk version 8 0 0 0 0 This module loads the positions data from stage table to Population POPULATION FACT table if positions data is given as download Population POPULATION FACT table if market data is given as download Commodity COMMODITY FUTURE This module loads the commodity future curve from stage Future Curve CURVE POPULATION table to FACT table if commodity future curve is given as Population download Equity Corporate CORPORATE ACTIONS This module loads the corporate action data from Stage Actions Data DATA POPULATION table to FACT table Population Instruments OBLIGORS DATA This module loads the obligors details from stage table to Obligors Data POPULATION FACT table Population Instruments INSTRUMENT SCHEDULE This module loads the Instruments Schedule from stage Schedule Data POPULATION table to FACT table Population MR VaR Data Currency and Interest Rate This module does the Instrument Reclassification of Preparation Instruments Re classification instruments with risk factor type as Currency and Interest Rate Commodity and Equity This module does the Instrument Reclassification of Preparation Instruments R2. 2008 l Done Local intranet Incremental VaR View Screen 3 6 3 Incremental VaR Edit Screen In order to edit an Incremental VaR screen first select a defined Incremental VaR portfolio that needs to be edited by clicking the select button iw then click the Edit button LA present at the RHS corner of the Incremental VaR Display Screen Under Edit screen you can change the execution date and check for incremental VaR All the dimensions under position specification column can be edited or deleted for a given Incremental VaR portfolio The reference portfolio and VaR model name once defined cannot be edited You are free to make changes to the number of units and position type for a particular instrument mapped to the defined portfolio Once the changes are made the screen needs to be saved using the Save button displayed at the end of the page Oracle Financial Software Services Confidential Restricted 27 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 Incremental VaR Specification for Edit Microsoft Internet Explorer E m incremental VaR Details Incremental Portfolio Name te sttt Reference Portfolio Run Execution Date 05 07 2008 Market Risk VaR Model Name ss Position Specification sE Instrument ID Instrument llame Instrument Type Units Position Type INSTCMOPTSVAN13 CMOP 1700 2036 USD CALL NCDEXRMSEEDJPR 6 2 2009 Commodity Option 2 BSEMADRASCEM MADRASCEM INR Spot Equity 23 Short
3. 21 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 e MR Bank Asset Class The dimensions for defining a portfolio are configurable as per your preference Accordingly a position may belong to more than one portfolio You may define a portfolio as a combination of multiple levels under each dimension 2 Define New Portfolio Microsoft Internet Explorer Portfolio Definition Portfolio Name Portfolio Description 2 Dimension Browser Web Page Dialog Filter Specificatior Dimensions Pera Available Hierarchies Selected Hierarchies Currency Market Risk Asset Class Line of Business Trading Desk Legal Reporting Bank Instrument Type Market Risk Instrument Types Counterparty Market Risk Asset MR Bank Asset Class Close http 10 184 74 54 1985 reveleus MarketRisk hierTree jsp infodom MRV25INFO amp strLocale en LISe a Local intranet 2 User Info MR 25USER Creation Date 24 Apr 2009 41 iavaccrink l eJ neal intr anat Portfolio Management Add Screen Under each dimension one or multiple nodes can be selected A combination of different dimensions and different nodes make a unique portfolio Once the dimensions are selected from the Dimension browser depending upon the selection leaf nodes of each dimension needs to be selected For example from Bank Instrument Type Browser you need to select one or more instruments which need to be included in a particular portfolio O
4. Risk ORACCE Infodom CRE amp Market Risk E Reference Data Management Time Vertex Specification E Equity Risk Factor Selection Time Vertex Specification ZCYC Estimation Method Selection Interest Rate Model Selection patria Incremental VaR O RiskMetrics Time Vertices Custom Time Vertices Time Vertex Specification Risk Matrices Screen 3 2 2 Custom Time vertices As per the specification you can change the standard time vertex to customized time vertex The custom time vertices need to be entered on the basis of maturity and time unit The first time vertex is always spot which cannot be edited These custom time vertices should be specified in the ascending order and they are editable Apart from the default 16 rows provided for entering custom time vertex You can add new rows to the custom time vertices screen and provide the additional input data 3 3 ZCYC Estimation Method Selection Zero Coupon Yield Curve is selected for each and every interest rate for asset class and currency combination The ZCYC Estimation Method Selection must be preceded by Time Vertex Specification This screen is divided into 2 sections e Interest Rate Selection e ZCYC Method selection Oracle Financial Software Services Confidential Restricted 9 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 Oracle Financial Services Market Risk Wind
5. any one to the other model Once the changes are made the screen needs to be saved using the Save button displayed at the end of the page Oracle Financial Software Services Confidential Restricted 19 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 Edit Interest Rate Model Microsoft Internet Explorer Currency Selection Currency Interest Rate Model Mapping Interest Rate Asset Class Interest Rate Model Government Agency Black Process Sovereign Rating Hull White Rating BBB Rating 44 Rating C AAA Swap Rating B Rating amp Rating AAA Money Market Rating CCC Rating D Rating CC Rating BB lt lt lt Ie Ie I We 1 He Ie lt 2 User Info Created By MRY25USER Creation Date 05 04 2009 Last Modified By Last Modified Date Interest Rate Model Selection Edit Screen 3 5 Portfolio Management Under this screen a portfolio needs to be defined on the basis of multiple dimensions A portfolio will be a combination of currency MR asset class Line of business Trading Desk Legal Reporting Bank Instrument Type Market Risk Instrument Type Counterparty Market Risk Asset and MR Bank Asset Class A portfolio will be defined on 1 or more dimensions along with one or more leaf nodes Once a portfolio is defined it can be deleted but it cannot be edited Oracle Financial Software Services Confidential Restricted 20 User Guide Oracle Financial Services M
6. 2010 EQFYYOP 125 826 INR CALL INSTEQFYYDSFYVD22 1119 2010 ge EQFYVOP 2290 026 INR PUT INSTEGFWWDSPYWD17 2 User Info Liser MRY25USER Creation Date 24 Apr 2009 Last Modified By Last Modified Date 1 Done 4 Local intranet Incremental VaR Add Screen 3 6 2 Incremental VaR View Screen The Incremental VaR view screen 1s displayed in the view mode To view an existing defined Incremental VaR Portfolio click the View button which is present on the RHS corner of the Incremental VaR Screen In order to View first select an existing record by activating the select button e then click the View button present on the RHS corner of the screen The chosen Incremental VaR Portfolio is displayed and it cannot be edited Oracle Financial Software Services Confidential Restricted 26 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 A Incremental VaR Specification for View Microsoft Internet Explorer Incremental VaR Details Incremental Portfolio Name te stttt Reference Portfolio Run Execution Date 05 07 2008 Market Risk VaR Model Name Position Specification s Instrument ID Instrument Hame Instrument Type Position Type INSTCMOPTS V AN13 CMOP 1700 2036 USD CALL NCDEXRMSEEDJPR 6 2 2009 Commodity Option Short BSE MADRASCEM MADRASCEM INR Spot Equity Long BSE HP HP INR Spot Equity Long User Info User MRY25USER Creation Date 5 8 2009 15 34 17 Last Modified By MRV25USER Last Modified Date 05 08
7. Component VaR Marginal VaR Incremental VaR and so on It covers estimation of risk arising out of movements of multiple risk factors like interest rates equity prices commodity prices and exchange rates Oracle Financial Services Market Risk Release 8 0 0 0 0 serves the following additional functionalities to the product e Enhanced instrument coverage Calculation of Implied volatility for instrument pricing Calculation of additional risk measures Marginal and Incremental VaR Calculation of mean reversion rate and speed Calculation of Option Greeks Impact of corporate action e Use of GARCH 1 1 for volatility computation Calculation of Modified Duration In addition it also renders use of Oracle Financial Services Modeling framework for stress testing of market risk estimates 1 1 Purpose The objective of this document is to provide a detailed procedure for working on Oracle Financial Services Market Risk 8 0 0 0 0 The specifications include details on installation loading user interface inputs execution and the outputs reported It enables the user of the document to understand and use Oracle Financial Services Market Risk 8 0 0 0 0 product effectively The target audiences for the following User Guide are s Intended User Customer e Functional Engineering Group e Product Management Group SQA e Project Manager Team e Senior Management 1 2 Scope Oracle Financial Services Market Risk i
8. Method Selection Edit Screen sesenta nna 334 Spred OVES OVN EIO nente eT ett ta n d cL ban t eL 33 5 BootstraD Yield CUVE d duse a niet UR Fe eda he Qu AAA eut A ud ce e dade EU QUI IR PUER 33 D Externa DOO se AA AAA hoe deste doa od deste vetu d de Ta ON 3 4 INTEREST RATE IVIODEL SELECTION ti A SOS 34 1 hterest Rate Mode Add CENA A AAA AAA AAA RA AAA A e 3 4 2 Interest Rate Model Selection View SCION ccccccccsccceccceccveccucccecscececcscucsvecsesseucssessecseucesesenssuucenes 3 43 Jhterest Rate Model Edit SC Ni bera Dodd ovo a 3 5 PORTEOUO MANAGEMENT aria 3 5 1 Portfolio Management Add CCE ii 3 5 2 Portfolio Management View Screen cccsseececccsseseecccsneseecccsuussecessueneecessaueecsssauneesesaauneeesssaensesenes 3 59 4Porgollo Management Delete SCI COM cases cius teo teda D Or a 3 6 INCREMENTAL VA mM 3 041 ARCKEMENUG VaR AS MEN da URN aeai 3 6 2 Incremental VaR View SCI CEN ali 3 06 37 JIncremebtol VOR EDESA AAA E ARA TA A O ais 3 7 PROCESS DESCRIPTION Gives dies MIR ASA AO O D 3 8 EXAMINING RESULTS carac ANNEXURE A GENERATING DOWNLOAD SPECIFICATIONS eere eene enne Oracle Financial Software Services Confidential Restricted li User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 1 Introduction Oracle Financial Services Market Risk estimates the market risk of a portfolio through the estimation of loss distribution based risk measures such as VaR CVaR
9. Oracle Financial Services Market Risk User Guide Release 8 0 0 0 0 January 2015 ORACLE FINANCIAL SERVICES User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 Contents la INTRODUCTION ud 1 1 PURPOSE NER TUR e a KM Tur 1 2 SCOPE ciate ease cara eMe E M MM MM MM LEMMA E 25 ANSIALLING THE SOLUTION ad CINE 2 1 DIODE NET SIEG Up A A A EE EE E E aus EA EE E TA EEA AE E A T EEE TA 2 2 LOADING THE DATA RE 3 ORACLE FINANCIAL SERVICES MARKET RISK SOLUTION UI AND PROCESS DESCRIPTION ce ae ewe ceedces 3 1 EQUITY RISK FACTOR SELECTION taa ae Lube TO eub AO Ute ved dr gu Um ume rU I OS 3d Eguity RISK Factor Ada SCEeen sore iore beet aora Ju EQUITY RISK Factor VIEW SCION ueste nose uenerit te tme odisti s e EMEN 34 9 FOUY RISK Factor Edit SCre6H us aep ar A RT WR IW 3 2 TIME VERTEX SPECIFICATION o dee E reese caste nese ete NI Le aeu uda Ds ie Mod eco Ad Mac ead ed eed AE te AM LI ae 32 Ris Metrics TIme vertice S sero eid Dux RE amo nM usta a ca Jui CUSTOM THINS Velit GS eoo NAAA seal ove detta eder pite OREN ae vei RIT 33 ZCYC ESTIMATION METHOD SELECTION esto ona iui eU INO cesa s Veen aac rn uet t n e oui o Un das 3 3 1 ZCYC Estimation Method Selection Add Screen eee eere eene thon eos pras nasa opa ao eae anos 3 3 2 ZCYC Estimation Method Selection View SCreeni ccccccccsecccecceccceccvecceccecscecscsscucesessesseucesessueseucenes 3 3 3 ZCYC Estimation
10. Position specific details like number of units and position type are required for each instrument mapped to the portfolio Oracle Financial Software Services Confidential Restricted 24 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 Oracle Financial Services Market Risk Windows Internet Explorer JE Financial Services Market Risk User gluser ORACLE infodom C Incremental VaR Y Search and Filter 4 Market Risk El Reference Data Management Equity Risk Factor Selection Run Execution Date Market Risk VaR Model Name Time Vertex Specification ZCYC Estimation Method Selection 5 tal VaR Detail Interest Rate Model Selection MED E LEE NE S 2 Portfolio Management Incremental Portfolio Name Reference Portfolio scopes Created By Creation Date Last Modified By Incremental Portfolio Name Reference Portfolio Incremental VaR Incremental VaR Display Screen 3 6 1 Incremental VaR Add Screen In order to add or define a new Incremental VaR portfolio click the Add button B in the Incremental VaR Screen Incremental Portfolio Name Give an appropriate incremental portfolio name Run Execution Date Select an appropriate Run Execution date from the calendar browser which will be the fic mis date for you Reference Portfolio For a specific incremental portfolio single existing por
11. arket Risk Release 8 0 0 0 0 Oracle Financial Services Market Risk Windows Internet Explorer PE Financial Services Market Risk User gluser ORACLE Infodom CRECINFC Portfolio Management v Search and Filter 4 Market Risk El Reference Data Management i Equity Risk Factor Selection Time Vertex Specification v ZCYC Estimation Method Selection Interest Rate Model Selection Portfolio Management Incremental VaR Portfolio Name List of Portfolios y E NEN Es Portfolio Name Portfolio Description Creation Date Portfolio Management Display Screen 3 5 1 Portfolio Management Add Screen In order to add or define a new Portfolio Management click the Add button B in the Portfolio Management Screen Portfolio Name Give an appropriate portfolio name Portfolio Description Describe the portfolio in brief Dimensions In order to add the dimensions to the portfolio click the Add button 4 in the Filter Specification section in Portfolio Management Add Screen Once you click the add button Dimension Hierarchy Browser will open A portfolio is a combination of one or more following dimensions e Currency Market Risk Asset Class Line of Business Trading Desk e Legal Reporting e Bank Instrument Type e Market Risk Instrument Types e Counterparty Market Risk Asset Oracle Financial Software Services Confidential Restricted
12. ces Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this User Manual and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes All company and product names are trademarks of the respective companies with which they are associated Oracle Financial Software Services Confidential Restricted 32
13. ck the View button present on the right hand corner of the Equity Risk Factor Screen The chosen Equity risk factor will be in view mode and cannot be edited Oracle Financial Software Services Confidential Restricted 6 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 2 Equity Risk Factor View Microsoft Internet Explorer Currency Selection Currency Benchmark Stock Index Mapping Benchmark Stock Index New York Stock Exchange Custom Equity Risk Factor Selection List of Equity Risk Factors ETT 4 A 2 User Info User MR Y25USER Creation Date 05 05 2009 Last Modified By Last Modified Date Equity Risk Factor Selection View Screen 3 1 3 Equity Risk Factor Edit Screen To edit Equity Risk Factor first select single currency that needs to be edited by clicking the select button UA then click the Edit button LA present at the right hand corner of the Equity Risk Factor Screen Under the Edit screen you can change the Benchmark Stock Index for that particular currency and can also add or delete the Equity Risk Factors as per the requirements To add the Equity Risk Factors in the Edit screen click the add button 4 in the Equity Risk Factor Edit Screen To delete the Equity Risk Factor first you need to select a particular custom equity which needs to be deleted by clicking the select button then click the delete button im to delete a selected Custom Equity Once the changes are made the scree
14. cord by activating the select button v then click the View button present on the RHS corner of the screen The chosen portfolio will be displayed in view mode and it cannot be edited Oracle Financial Software Services Confidential Restricted 23 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 View Portfolio Microsoft Internet Explorer Portfolio Definition Portfolio Name Non Exotic Simple Instruments Portfolio es Mon Exotic Simple Instruments Portfolio Portfolio Description Filter Specification Dimensions Market Risk Instrument Types 150121 WS Commodity Futures Commodity forward Commodity Option Spot Commodity Equity Futures User Info MR Y25USER Creation Date 05 07 2009 41 Dna l aral intr sneak Portfolio Management View Screen 3 5 3 Portfolio Management Delete Screen In order to delete a particular portfolio first select an existing record by activating the select button e and then click the delete button mi present on the RHS corner of the screen The selected portfolio will get deleted a multiple deletion is not allowed under this screen 3 6 Incremental VaR Incremental VaR is calculated for all portfolios which are previously defined under portfolio management screen and for which risk measures have been calculated An incremental portfolio is defined based on the following parameters reference portfolio execution date VaR model and instruments
15. e classification instruments with risk factor type as Commodity and Equity Preparation Classification with risk factor type as Currency Oracle Financial Software Services Confidential Restricted 28 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 Preparation Classification Preparation Quanto Options Preparation Classification MR VaR Data Asset Class Classification This set of modules does the Reclassification of Asset Class Preparation Simple Derivatives on Sovereign MR VaR Data Asset Class Classification This set of modules does the Reclassification of Asset Class Preparation Compound Derivatives on Sovereign Preparation Preparation based on Rating MR VaR Data Asset Class Classification on This set of modules does the Reclassification of Asset Class Preparation Rating for Simple Derivatives MR VaR Data Asset Class Classification on This set of modules does the Reclassification of Asset Class Preparation Rating for Compound Derivative MR VaR Data Asset Class Reclassification This set of modules does the Reclassification of Asset Class Preparation for Equity MR VaR Data Asset Class Reclassification This set of modules does the Reclassification of Asset Class Preparation for Simple Equity Derivatives MR VaR Data Asset Class Reclassification This set of modules does the Reclassification of Asset Class Preparation for Compound Equity Derivatives MR VaR Data Asset Class Reclassification This set
16. e following selection needs to be made Currency A single currency needs to be selected from the currency browser Benchmark Stock Index The indices corresponding to the selected currency will display in the benchmark stock index browser A single Benchmark Stock Index needs to be selected from the browser Custom Equity Risk Factor Selection It will display all the custom equities denominated in the selected currency in equity browser You are authorized to make multiple selections or deletions of custom equities Oracle Financial Software Services Confidential Restricted 5 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 En Equity Risk Factor Selection Microsoft Internet Explorer Currency Selection Currency Benchmark Stock Index Mapping Benchmark Stock Index Custom Equity Risk Factor Selection MZ Il 1 lll NN Equity User Info User MR Y25USER Creation Date 24 Apr 2009 Last Modified By Last Modified Date Equity Risk Factor Selection Add Screen Benchmark stock index mapping and custom equities selection are editable under this screen Once an Equity Risk Factor is defined under this screen it cannot be deleted 3 1 2 Equity Risk Factor View Screen To view an existing Equity Risk Factor click the View button EI which is present in the Equity Risk Factor Screen In order to View first select an existing record by activating the select button e then cli
17. ertex11 4 Year 200 User Info Created By MRY25USER Creation Date 05 04 2008 Last Modified By Last Modified Date l Done J Local intranet ZCYC Estimation Method Selection Edit Screen 3 3 4 Spread Over Sovereign The first method is spread over sovereign once this is selected further selection needs to be made from Time vertex spread 9 Parallel Spread It specifies the type of spread to be applied to the sovereign yield curve These spreads can be applied only to the standard time vertex Time vertex spread Under time vertex spread multiple spread value needs to be inserted for each standard time vertex The spread value will be in basis points Parallel spread A single value needs to be inserted which will be applied to all time standard vertices Oracle Financial Software Services Confidential Restricted 13 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 e Define ZCYC Eztimation Method Microsoft Internet Explorer Interest Rate Selection Currency PP Interest Rate Asset Class Rating CCC ZCYC Estimation Method Selection Spread over Sovereign Yield Curve Bootstrap Yield Curve External Data Spread Specification O Time Vertex Spread Parallel Spread User Info Created By MRY25USER Creation Date 11 May 2009 Last Modified By Last Modified Date l Done J Local intranet ZCYC Estimation Method Selec
18. est Rate Model click the Add button 4 in the Interest Rate Model Screen Currency Selection From the currency browser a single currency needs to be selected Multiple selections are not allowed Once a particular currency selected then all the interest rates available in that currency will be displayed Interest Rate Model Mapping For each Interest Rate Asset Class one Interest Rate Model needs to be selected from the following Black Model Hull White Model Ho lee Model Ornstein Uhlenback Model Oracle Financial Software Services Confidential Restricted 17 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 3 New Interest Rate Model Selection Microsoft Internet Explorer la Currency Selection Currency T Interest Rate Model Mapping Interest Rate Asset Class Interest Rate Model amp User Into Created By MRY25USER Creation Date 24 Apr 2009 Last Modified By Last Modified Date Interest Rate Model Selection Add Screen Once a model is defined for a particular interest rate currency combination it can be edited and a different model can be selected The selection will not be allowed to save unless an interest rate model is mapped to every Interest Rate Asset Class for the selected currency If spread over sovereign yield curve is specified for any Currency Interest Rate Asset Class combination then a separate Interest Rate Model is not allowed to be selected for tha
19. ethod Selection Spread over Sovereign Yield Curve Bootstrap Yield Curve 9 External Data User Info Created By MRY25USER Creation Date 11 May 2009 Last Modified By Last Modified Date Local intranet ZCYC Estimation Method Selection External Data Screen 3 4 Interest Rate Model Selection Under this screen an interest rate model needs to be mapped for each currency interest rate combination If a Zero Coupon Yield Curve Estimation Method has not been specified for all the Interest Rate Asset Classes in a particular currency then that currency should not appear for selection in the Currency Browser Oracle Financial Software Services Confidential Restricted 16 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 Oracle Financial Services Market Risk Windows Internet Explorer JE Financial Services Market Risk User gluser ORACLE Infodom Ic CINFC Interest Rate Model Selection Y Search and Filter 4 Market Risk El Reference Data Management i Equity Risk Factor Selection i Time Vertex Specification List of Selected Interest Rate Models ES 44D GE ZCYC Estimation Method Selection Created By Creation Date Last Modified By Last Modified Date Currency Interest Rate Model Selection Portfolio Management Incremental VaR Interest Rate Model Selection Display Screen 3 4 1 Interest Rate Model Add Screen In order to add or define a new Inter
20. ial Restricted 3 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 3 Oracle Financial Services Market Risk Solution UI and Process Description Oracle Financial Services Market Risk Release 8 0 0 0 0 estimates the market risk of a portfolio through the estimation of loss distribution based risk measures such as VaR CVaR Component VaR Marginal VaR Incremental VaR and so on It covers estimation of risk arising out of movements of multiple risk factors like interest rates equity prices commodity prices and exchange rates Once you have accessed the Oracle Financial Services Analytical Application Infrastructure OFSAAT product click Market Risk which is present on the left hand side LHS of the screen The Oracle Financial Services Market Risk Display Screen shows the list of modules related to Market Risk Solution on the left hand side LHS corner Oracle Financial Services Market Risk Windows Internet Explorer PE Financial Services Market Risk User gluser ORACCE Infodom amp Market Risk Reference Data Management Equity Risk Factor Selection Time Vertex Specification ZCYC Estimation Method Selection Interest Rate Model Selection Portfolio Management Incremental VaR Oracle Market Risk Display Screen 3 1 Equity Risk Factor Selection The first screen that comes up after clicking Equity Risk Factor Selection is the Equity Risk Factor Selection Display Scree
21. imation Method first select a defined estimation method that needs to be edited by clicking the select button iw then click the Edit button L4 present at the right hand corner of the ZCYC Estimation Method Screen Under Edit screen you can only modify ZCYC Estimation Method Selection the changes can only be done to the previously defined ZCYC Estimation Method The Interest Rate Selection part cannot be edited or changed You are free to change the estimation method from spread over sovereign to any other Bootstrap or External Data or can change the defined spread specification from time vertex spread to parallel spread Once the changes are made the screen needs to be saved using the Save button displayed at the end of the page Oracle Financial Software Services Confidential Restricted 12 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 2 Edit ZCYC Eztimation Method Microsoft Internet Explorer Interest Rate Selection Currency Interest Rate Asset Class Rating ASA ZCYC Estimation Method Selection Spread over Sovereign Yield Curve Bootstrap Yield Curve External Data Spread Specification Time Vertex Spread Parallel Spread Time Vertex Maturity Spread in basis points Vertex Spot 50 Vertex2 1 Month 100 Wertex3 3 Month 125 Vertex4 6 Month 100 Vertex5 12 Month 140 Wertexb 15 Month 160 Wertex 18 Month 150 Wertex 24 Month 170 Wertex9 27 Month 180 Vertex10 35 Month 180 V
22. inancial Services Market Risk Release 8 0 0 0 0 Risk Factors is required for Calculating of VaR and other Risk Measures MR VaR Data RISK FACTOR This module loads the Variance Co variance Mean and Preparation STATISTICS Correlation Data between all the Risk Factors from stage POPULATION table to FACT table This module will be useful if you want to give the Variance Co variance Mean and Correlation data as download MR VaR Data RunningAccCalc This module calculates the Running Accumulator for Asian Preparation Option and updates the value for the corresponding instrument MR VaR Data ZCY CEstimation This module calculates the Yield Curve for all the Rating Preparation and Currency combinations for which you have selected either Bootstrap method or choose to apply spread over Sovereign Yield Term Structure Preparation all the Commodity futures traded in the market Interest Rate IRMeanReversion This module calculates the Mean Reversion Rate for Mean Reversion Interest Rate instrument Estimation Risk Factor EWMA 0 94 This module first fetches the historical data of all the Risk Volatility Factors given by you and applies the corporate action if Correlation available to the equities Once the corporate action has been Estimation applied then the module will check for the missing value and fill up the missing values using the method as selected by you Thereafter the module calculates the Variance Co variance Mean and Correlati
23. l Software Services Confidential Restricted User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 2 Installing the Solution Once the OFSAAI Infrastructure has been loaded the Market Risk solution has to be loaded To install Oracle Financial Services Market Risk refer to the Oracle Market Risk Solution Installer Manual 2 1 Model Upload In order to carry out the Model Upload click Unified Metadata Manager on the left pane of the OFSAAI Infrastructure Under that click Import Model to open the Business Model Upload screen Choose the type of Upload as New Upload Enter the Erwin XML File Path and click Upload and the model will get uploaded 2 2 Loading the data The uploading of data involves the loading of all the Stage tables The Stage tables that have to be loaded are stg_dim_bank_instrument_type stg_dim_commodity stg_dim_instrument_contract stg dim mr asset e stg dim stock index stg_equity_corporate_actions stg_fct_bank_positions stg_fct_cds_spreads o stg_interest_rate_parameters stg mkt instrument contract stg mr risk factor statistics stg commodity future curve e stg fct equity indices stg_fct_instrument_schedule e stg fct funds composition stg_fct_obligors_details stg_fct_portfolio_data stg_fct_yield_curve You have to run the Slowly Changing Dimensions SCDs to populate the required DIM and FCT tables Oracle Financial Software Services Confident
24. n It displays the list of equity risk factors that are already defined in a particular currency In this screen all equity risk factors which are specific to you will be displayed corresponding to a particular currency Oracle Financial Software Services Confidential Restricted 4 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 Oracle Financial Services Market Risk Windows Internet Explorer Sel Financial Services Market Risk User gluser ORACLE infodom c Equity Risk Factor Selection amp Market Risk El Reference Data Management Equity Risk Factor Selection Time Vertex Specification ZCYC Estimation Method Selection Interest Rate Model Selection Portfolio Management Incremental VaR GONE Created By Creation Date Last Modified By Last Modified Date Equity Risk Factor List ES Equity Risk Factor Selection Display Screen The screen also gives the search option for finding or filtering the risk factor on the basis of currency selected from the currency browser A particular currency can be entered or selected from the currency browser in order to filter the search Once the selection is made from the currency browser all the Equity risk factors denominated in that particular currency 1s displayed 3 1 1 Equity Risk Factor Add Screen In order to add or define a new Equity Risk Factor click the Add button in the Equity Risk Factor Screen Th
25. n needs to be saved using the Save button displayed at the end of the page Oracle Financial Software Services Confidential Restricted 7 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 a Equity Risk Factor Edit Microsoft Internet Explorer Currency Selection Benchmark Stock Index Mapping Benchmark Stock Index NASDAG je Custom Equity Risk Factor Selection List of Equity Risk Factors ES 1103 of 3 M E D A NASDAQ Zoran Crop O L NASDAQ Apple User MR VY25USER Creation Date 0445 2009 Last Modified By MR Y25USER Last Modified Date 6 May 2009 Equity Risk Factor Selection Edit Screen 3 2 Time Vertex Specification This particular screen provides the choice of selecting the time vertex for all the risk factors One of the following time vertexes needs to be selected e Risk Metrics Time vertices e Custom Time vertices 3 2 1 Risk Metrics Time vertices The risk matrices time vertex screen is the default display screen for the time vertex specification screen The risk matrices are the standard time vertices which are not allowed to be edited It specifies the time on 18 standard time vertices following the specific time unit that is days month and year Oracle Financial Software Services Confidential Restricted 8 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 Oracle Financial Services Market Risk Windows Internet Explorer Financial Services Market
26. nal Data Save Close ZCYC Estimation Method Selection Add Screen 3 3 2 ZCYC Estimation Method Selection View Screen To view an existing ZCYC Estimation Method click the View button El which is present as the ZCYC Estimation Method In order to View first select an existing record by activating the select button v then click the View button present on the right hand corner of the ZCYC Estimation Method The chosen ZCYC Estimation Method will be displayed in view mode and it cannot be edited Oracle Financial Software Services Confidential Restricted 11 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 3 View ZCYC Eztimation Method Microsoft Internet Explorer Interest Rate Selection Currency ZCYC Estimation Method Selection Spread over Sovereign Yield Curve Bootstrap Yield Curve External Data Spread Specification Time Vertex Spread Parallel Spread Time Vertex Maturity Spread in basis points Vertex Spot Vertex2 1 Month Wertex3 3 Month Vertex4 6 Month Wertex5 12 Month Wertexb 15 Month Wertex 18 Month Vertexa 24 Month Wertex9 27 Month Vertex10 36 Month Vertex11 4 Year User Info Created By MRY 25USER Creation Date 05 04 2009 Last Modified By Last Modified Date 4 amp 1 none oral intranet ZCYC Estimation Method Selection View Screen 3 3 3 ZCYC Estimation Method Selection Edit Screen In order to edit ZCYC Est
27. nsight and then click Viewer to view all the reports Oracle Financial Software Services Confidential Restricted 30 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 Annexure A GENERATING DOWNLOAD SPECIFICATIONS Data Model for Market Risk Release 8 0 0 0 0 is available on customer request as an ERwin file Download Specifications can be extracted from this model Refer the whitepaper present in OTN for more details Oracle Financial Software Services Confidential Restricted 31 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 ORACLE Oracle Financial Services Market Risk 8 0 0 0 0 User Guide January 2015 Version number 1 0 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial_services Copyright 2015 Oracle and or its affiliates All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this Oracle Financial Services Market Risk User Guide and accompanying software package as accurate as possible However Oracle Financial Servi
28. of modules does the Reclassification of Asset Class pe ase cc MR VaR Data Asset Class Reclassification This set of modules does the Reclassification of Asset Class MR VaR Data POSITION DATA This module loads the Position Data of Instruments from MR VaR Data MARKET INSTRUMENT This module loads the Instrument Parameter from stage MR VaR Data EQUITY INDEX DATA This module loads the Equity Index Data from stage Table MR VaR Data PORTFOLIO DATA This module loads the Portfolio data like VaR Limit and Actual P amp L from Stage Table to FACT Table MR VaR Data YIELD CURVE This module loads the Yield Curve Data from stage table to Preparation POPULATION FACT Table for all the Rating and Currency combinations for which you have selected the download option MR VaR Data CDS SPREAD This module loads the CDS Spread data from stage Table to Preparation POPULATION FACT Table MR VaR Data Interpolate_CDS_Spreads This module maps the given CDS spread to the standard Preparation time vertices as specified by you If the standard time vertices are not in the downloaded CDS Spread then spread values are interpolated for the intermediate time vertices MR VaR Data Pop_Correlation_AC This module populates the Funds and Benchmark Codes as Preparation Asset Class this module is purely for calculation purposes where correlation between Benchmark Codes Funds and Oracle Financial Software Services Confidential Restricted 29 User Guide Oracle F
29. on for all the Risk Factors Pricing OTC OTCPricing This module uses the output of Risk Factor Volatility Instruments Correlation Estimation Module and calculates the price of all the OTC Instruments available with the bank Along with the price calculation module also calculates the Greeks for all the option instruments and Modified Duration for all the bonds Estimation Model Monte Carlo Model for the model as defined by you Market Risk VaR Simulated PL Bucketing This module buckets the P amp L distribution as generated in Estimation Monte Carlo or Historical VaR Estimation Methodology for plotting the curve of P amp L distribution VaR Estimation defined by you added in the selected portfolio Table 1 Process Description 3 6 Examining Results Creating and viewing of reports are described in detail in the Active Portal User Manual In order to examine results you have to check in the corresponding tables After execution is completed check the T2T logs and the Run Rule logs It can be found out from the log files whether the execution is a success or failed Errors will be displayed in the same log files The logs will also mention the name of the table in which the Output is populated You have to access the particular table to view the results The final outputs can also be viewed in the Reports section This can be accessed by clicking Information Delivery on the left pane of the OFSAAI Infrastructure Under that click I
30. ows Internet Explorer Sel Financial Services Market Risk User gluser ORACLE ICYC Estimation Method Selection Infodom amp Market Risk Reference Data Management Currency Interest Rate Asset Class Equity Risk Factor Selection ZCYC Estimation Method Time Vertex Specification ZCYC Estimation Method Selection ZCYC Estimation Method ES y Interest Rate Model Selection Created By Creation Date Xm IE AX C M J Incremental VaR ZCYC Estimation Method Selection Display Screen The screen also gives the option for searching or filtering the ZCYC estimation method selection on the basis of currency Interest Rate Asset Class and ZCYC Estimation Method The search can be done by selecting any one or more parameters from the above 3 and then by clicking the search button A particular currency can be entered or selected from the currency browser or a particular Interest Rate Asset Class can be selected from the drop down or a particular ZCYC method can be selected from the drop down in order to filter the search Once the selection is made from the currency browser all the ZCYC Estimation Method defined in that particular currency is displayed Once the selection is made from Interest Rate Asset Class dropdown it displays all the ZCYC Estimation Method defined in that Asset Class Once the selection is made from Interest Rate A
31. racle Financial Software Services Confidential Restricted 22 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 2 Define New Portfolio Microsoft Internet Explorer Portfolio Definition Portfolio Name 3 Bank Instrument Type Browser Web Page Dialog Filter Specificatior Hierarchy Dimensions Hierarchical Bank Instr Available Bank Instrument Type Selected Bank Instrument Type Line of Bu iscrete Asian Option on Commodity a Bank Instrument Type CliquetRatchet Option on Commodity Currency i Commodity Forward Option Commodity forward forward Commodity Futures Option Commodity Futures Commodity forward Continuous Asian Option on Commodity Discrete Asian Option on Commodity Barrier Option on Commodity Commodity Basket Option Cliquet Ratchet Option on Commodity Digital Option on Commodity Fixed Lookback Option on Commodity Floating Lookback Option on Commodity Commodity Quanto Option Shout Options on Commodity Commodity Option Snot Commonite Portfolio Description MRY25USER Creation Date 77 May 2009 Portfolio Management Dimensions Screen Bank Instrument Type Browser 3 5 2 Portfolio Management View Screen The portfolio management view screen is displayed in the view mode To view an existing Portfolio click the View button Portfolio Management Screen 1 which is present on the right hand side RHS corner of the In order to View first select an existing re
32. s concerned with the estimation of market risk for the portfolios held by the bank These portfolios may belong to the trading book or the banking book Oracle Financial Services Market Risk enables a bank to estimate the market risk of a portfolio based on its underlying positions through the estimation of risk measures such as Value at Risk Conditional Value at Risk and so on It also enables a bank to carry out Stress Testing and Back Testing procedures for validation Risk measures based on VaR have multiple applications the scope of Oracle Financial Services Market Risk is not only restricted to Regulatory Reporting but also extends to the internal reporting needs of the bank Oracle Financial Services Market Risk supports the estimation of market risk of user defined portfolios covering a wide range of instruments The scope of Market Risk Release 8 0 0 0 0 will be restricted to the testing following areas Oracle Financial Software Services Confidential Restricted 1 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 e Analytic Method Cash flows Estimation and mapping Back testing e Constant Maturity Function e Daily Pricing Historical Simulation Incremental VaR Mean Reversion Rate Monte Carlo Simulation Scenario VaR Calculation e Stress Testing e VaR Model Pricing Volatility Model Zero Coupon Yield Curve e Functional Verification e Performance Issues Oracle Financia
33. sset Class drop down it displays all the ZCYC Estimation Methods defined in that Asset Class 3 3 1 ZCYC Estimation Method Selection Add Screen In order to add or define a new ZCYC Estimation Method click the Add button E in the ZCYC Estimation Method Display Screen Currency Selection The currency browser will display all available currencies for selection A single currency needs to be selected from the currency browser multiple selection of currency is not allowed Interest Rate Asset Class The Interest Rate Asset Class drop down list will display all the interest rates defined in the currency selected A single asset class needs to be selected from the drop down The Available Interest Rate Asset Classes are AAA AA A BBB BB B CCC D Government Agency Money Market Sovereign Swap Oracle Financial Software Services Confidential Restricted 10 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 e ZCYC Estimation Method Selection There are 3 methods available for ZCYC estimation Spread Over Sovereign Bootstrap Yield Curve External Data From the above 3 methods a single method needs to be selected for the defined currency interest rate combination de Interest Rate Selection Currency scs Interest Rate Asset Class Rating AAA bd sic ZCYC Estimation Method Selection Spread over Sovereign Yield Curve O Bootstrap Yield Curve O Exter
34. t combination 3 4 2 Interest Rate Model Selection View Screen To view an existing Interest Rate Model click the View button which is present on the right hand corner of the Interest Rate Model Selection Screen In order to View first select an existing record by activating the select button then click the View button present on the right hand corner of the screen The chosen Interest Rate Model will be displayed in view mode and it cannot be edited Oracle Financial Software Services Confidential Restricted 18 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 A View Interest Rate Model Microsoft Internet Explorer lo Currency Selection Currency Interest Rate Model Mapping Interest Rate Asset Class Interest Rate Model Sovereign Rating Hull mite Government Agency Black Process 2 User Info Created By MRY25USER Creation Date 05 04 2008 Last Modified By Last Modified Date Interest Rate Model Selection View Screen 3 4 3 Interest Rate Model Edit Screen In order to edit an Interest Rate Model first select a defined Interest Rate model that needs to be edited by clicking the select button Iw then click the Edit button L present at the right hand corner of the Interest Rate Model Selection Screen Under Edit screen you can only add or modify the already defined models for a particular Asset Class The currency once defined cannot be edited You are free to change the model from
35. tfolio can be selected along with multiple instruments mapped to it from the hierarchy browser Market Risk VaR Model Name Select single market risk VaR model name from the market risk VaR model hierarchy browser to which this particular Incremental VaR model will be mapped Position Specifications In order to select position specifications click the Add button 1 situated on the RHS corner of the Position Specifications section in the Incremental VaR screen Multiple instruments mapped to the portfolio can be selected from the hierarchy browser but only one instrument at a time can be selected The following parameters of each instrument need to be specified for the purpose of computing incremental VaR Units Position Type Oracle Financial Software Services Confidential Restricted 25 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 A Incremental VaR Specification Microsoft Internet Explorer 3 Hierarchy Browser Microsoft Internet Expl E3 Search Reference Portfolio RE Instruments 1 to 50 of 2266 Instruments Market Risk VaR Model Name EL Instruments HP INR MADRASCEM INR ORA CLEFIN INR S SUBEXLTD INR EGFWWOP 133 426 USD PUT INSTEGFV DSFVVD24 1 27 2010 EGFWWOP 245 526 INR CALL INSTEQFYYDSFYVD1 5 24 2010 EQFYYOP 2290 026 INR PUT INSTEGFVVDSFVVD18 124 9 2009 EQFYVOP 133 426 USD PUT INSTEQFWWDSFWwD8 8 29 2009 EQFYVOP 26 086 USD CALL INSTEQPADSPAD22 8 10
36. tion Spread Over Sovereign Screen 3 3 5 Bootstrap Yield Curve Spread specification is not applicable if the Bootstrap Yield Curve is selected Sovereign and Money Market Asset Classes are always estimated using a bootstrapping procedure or obtained as a download On selection of either of these Interest Rate Asset Classes Spread over Sovereign Yield Curve icon will get de activated Oracle Financial Software Services Confidential Restricted 14 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 Define ZCYC Eztimation Method Microsoft Internet Explorer Interest Rate Selection Currency Interest Rate amp sset Class Rating CCC ZCYC Estimation Method Selection Spread over Sovereign Yield Curve Bootstrap Yield Curve External Data 2 User Info Created By MRYW25USER Creation Date 11 May 2009 Last Modified By Last Modified Date ZCYC Estimation Method Selection Bootstrap Yield Curve Screen 3 3 6 External Data You can provide Zero Coupon Yield Curve as a download by selecting the External Data Spread specification is not applicable if the external data is selected Oracle Financial Software Services Confidential Restricted 15 User Guide Oracle Financial Services Market Risk Release 8 0 0 0 0 e Define ZCYC Eztimation Method Microsoft Internet Explorer Interest Rate Selection Currency xad Interest Rate Asset Class Rating CCC ZCYC Estimation M
Download Pdf Manuals
Related Search