StatPro Revolution Web API


The Interactive Risk Analysis Resource


Overview

The Interactive Risk Analysis resource represents a set of analytics risk results that have been calculated interactively on-the-fly given a user provided query. A single interactive risk analysis query comprises a request for one or more tables of risk results and each table representing a collection of measures calculated at total/segment/security level (or any combination dependent on the levels supported by the chosen measures).

The key to understanding the Interactive Risk Analysis resource is knowing what data can be included in any one request and how to formulate a query for that data. To this end, please see the documentation for the interactive-risk-analysis-query link relation, which contains the full details.

See the annotated representations below for details of how the requested information is contained in XML and JSON representations of the resource.


Media types

The Interactive Risk Analysis resource is exposed via XML and JSON representations, which have the following media type names:-

application/vnd.statpro.revolution.api.interactive-risk-analysis+json

application/vnd.statpro.revolution.api.interactive-risk-analysis+xml

When a response is received from the web service with status 200 (= OK), the fact that the response contains an Interactive Risk Analysis resource representation is indicated by the presence of one of these two response headers:-

Content-Type: application/vnd.statpro.revolution.api.interactive-risk-analysis+json; charset=utf-8

Content-Type: application/vnd.statpro.revolution.api.interactive-risk-analysis+xml; charset=utf-8


Related resources

The Interactive Risk Analysis resource always links to the Service and Porfolios resources (and to itself). These resources are exposed via the following link relations :-

  • self
  • service
  • portfolios-query

The self link relation identifies the Interactive Risk Analysis resource link for the same analysis. Note that, unlike almost all other self links, the original query data is not contained in the link's URI. For a new request, the query data must be included in the POSTed entity body.

The service link relation identifies the Service resource link.

The portfolios-query link relation identifies the link that allows a new query for portfolios to be made.


Processing Errors/Messages

Within a single Interactive Risk Analysis resource there can exist zero or more informational messages or errors relating to issues that have occurred in the processing of the interactive risk query. Most issues with the query are picked up by the validation of the well-formedness of the Xml and by the schema validation that takes place when pre-processing the request. In such circumstances we have the following error response codes that can be returned:

867 - InteractiveRiskQueryRequestDataMissing: Occurs when no interactive risk query is submitted,

868 - InteractiveRiskQueryRequestDataNotXml: Occurs when the interactive risk query submitted is not well-formed Xml.

869 - InteractiveRiskQueryRequestFailedSchemaValidation: Occurs when the interactive risk query submitted doesn't conform to the published schema document (XSD).

839 - PortfolioNotFound: Occurs when an attempt is made to access a portfolio that cannot be found.

840 - AnalysisNotFound: Occurs when an invalid analysis code is specified for the portfolio.

Assuming the interactive risk query has passed all of these validations then it is still possible for messages or errors to be produced. These will be evident by the existence of messages returned in the resource representation. Messages can exist at the top-level underneath the interactiveRiskAnalysis element/property or under a specific table element/property. The ones at the top-level affect all tables in the query, whereas the ones under a specific table relate just to the associated table. Associated with any message or error will be a unique identifier and the message text. Here is a list of the possible messages:

Message 'class' Attribute

The class attribute of a message is related to the client action that is recommended in response to the message. This is of particular value in responding appropriately to the large and growing number of possible messages, as it means that specific responses don't need to be developed for each new specific message (see id attribute).

'class' Attribute Meaning Client Action
ReasonValueIsNotApplicableThe result is benignly null. As the issue is benign, it does not need to be solved and is not an error. Example: When the measure 'Maximum Loss' is null, the reason provided is 'The value is N/A because there is no loss.').No client action is expected. As a result, it is appropriate to hide such exceptions from the user until the user requires greater understanding of the result set.
BusinessWarningThe result is not null, however a functional warning is applicable for this result.Administrative awareness is required so as to determine whether further steps need to be taken.
QueryValidationErrorThe query is invalid, due to a schema validation error of the XML query, or due to invalidity of one of the values within the query.Client developer input is required to fix the query.
BusinessCriticalExceptionThe result is null due to an unexpected error of functional rather than technical origin. This is often related to configuration or data.Client administrative input is required to fix the issue.
TechnicalExceptionThe result is null due to an unexpected error of technical rather than functional origin.StatPro technical support is required to resolve the issue.

Message 'id' Attribute

The value of the id attribute is unique to each message. Here is a list of the possible messages:

'id' Attribute Message 'dataCsv' Attribute Fields
BenchmarkIsUnclassified The attribution results are N/A because the benchmark is unclassified.
ClassifierNotFound One or more of the classifiers specified are not found.
DayOffsetNotDefined No dayOffset has been provided. It must be provided as a parameter of either a columnNode or a rowNode.
DuplicateColumnName A duplicate table name has been specified. Ensure all table names are unique.
DuplicateTableName A duplicate column name has been specified. Ensure all column names are unique.
ExceededMaxBenchmarkHoldingsCount Risk cannot be computed as the tenancy maximum benchmark holdings count was exceeded for this portfolio's benchmark.
ExceededMaxPortfolioHoldingsCount Risk cannot be computed as the tenancy maximum portfolio holdings count for risk was exceeded for this portfolio.
InappropriateMeasure The security-level measure is N/A because security level measures were not requested.
InvalidColumnNameThe table filter / orderBy / skip / top could not be applied, as the name of columnNode '{0}' does not comply with the OData field name specification for TSimpleIdentifier, which is based on the regular expression: "[\p{L}\p{Nl}_][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}".columnName
InvalidMeasureId The measureId provided is invalid.
InvalidStressTestCode The stressTestCode provided is invalid.
LiquidityScenarioNotDefined No liquidityScenario has been provided. It must be provided as a parameter of either a columnNode or a rowNode.
MissingBenchmark There is no constituent level benchmark associated to the portfolio.
MissingHoldings The portfolio has no holdings.
RiskFactorDecompositionNotSupportedForHorizonGt1Day A horizon other than daily is not yet supported for Risk Factor Decomposition.
ScenarioIndexNotDefined No dayOffset has been provided. It must be provided as a parameter of either a columnNode or a rowNode.
StressTestCodeNotDefined No stressTestCode has been provided. It must be provided as a parameter of either a columnNode or a rowNode.
UnexpectedError An unexpected error occurred processing the request (Code: {0}, Class: {1}). errorCode, errorClass
UnlicensedBenchmark The associated benchmark is unlicensed for the portfolio owner.
UnsupportedFeatureMultiRowNodeFilter The rowNode Filter, Orderby, Skip and Top feature does not yet support tables with more than one rowNode. Please contact StatPro Support to register your interest in extending this feature if you require it. Internal ref: SAAS-18219.
UnsupportedFilterOrderbyTableType The rowfilter is not yet supported for table type '{0}'. Please contact StatPro Support to request its addition. tableType
UnsupportedMeasureDataType The rowfilter could not be applied to column '{0}' as it has an unsupported data type. columnName


Message 'columns' Attribute

The columns attribute contains a comma-delimited list of output column positions (as opposed to column node positions) to which the message applies.

Update history

  • Added rowNode attributes filter, orderby, skip and top - August 2017
  • Added message ids: "InvalidColumnName", "DuplicateColumnName", "UnsupportedFeatureMultiRowNodeFilter", "UnsupportedFilterOrderbyTableType", "UnsupportedMeasureDataType", "RiskFactorDecompositionNotSupportedForHorizonGt1Day" - August 2017
  • Message id "ExponentialDecayIsTotalOnly" is no longer valid and was removed - January 2017
  • Initial Version - August 2015

Annotated Representation (JSON)

Legend

{
  "interactiveRiskAnalysis": {
    "links": {
      "service": {
        "rel": "service",
        "href": "...",
        "type": "application/vnd.statpro.revolution.api.service+json"
      },
      "portfoliosQuery": {
        "rel": "portfolios-query",
        "href": "...?$filter={filter}&$orderby={orderby}&$skip={skip}&$top={top}&includePublishedPortfolios=false&portfolioClassifierCode=",
        "type": "application/vnd.statpro.revolution.api.portfolios+json"
      },
      "self": {
        "rel": "self",
        "href": "...",
        "type": "application/vnd.statpro.revolution.api.interactive-risk-analysis+json"
      }
    },
    "messages": [
      {
        "class": "QueryValidationError",
        "id": "DuplicateTableName",
        "message": "A duplicate table name has been specified.  Ensure all table names are unique."
      }
    ],
    "tables": [
      {
        "name": "StressTests and Liquidity Risk",
        "messages": [
          {
            "class": "ReasonValueIsNotApplicable",
            "id": "LiquidityTestIdNotDefined",
            "message": "No liquidityScenario has been provided.  It must be provided as a parameter of either a columnNode or a rowNode. Scope: C3,C4"
          }
        ],
        "resultsCsv": [
          "Name,StressValue.Cash,Total Liquidity Risk - Normal Override,Total Liquidity Risk - Stressed",
          "TOTAL,-13.6161556,,",
          "Energy,-18.30479,,",
          "Materials,-18.3748627,,",
          "Industrials,-19.4054565,,",
          "Consumer Discretionary,-17.6861286,,",
          "Consumer Staples,-4.212372,,",
          "Health Care,-6.48675776,,",
          "Financials,-21.1418,,",
          "Information Technology,-14.3950815,,",
          "Telecommunication Services,1.76095724,,",
          "Utilities,-10.83098,,"
        ]
      },
      {
        "name": "RelativeDecomposition",
        "messages": [],
        "resultsCsv": [
          "Name,VarCash,VarPercent,VarCashRel,VarPercentRel",
          "2015-06-17,-72425.88,-0.334854662,-20734.25,-0.0958629549",
          "2015-06-18,68342.2,0.3159741,-39610.07,-0.183133647",
          "2015-06-19,37326.69,0.172576636,-98442.21,-0.455138832",
          "2015-06-22,590660.16,2.730865,342230.11,1.58227062",
          "2015-06-23,239877.71,1.10905337,1824.62,0.008435984",
          "2015-06-24,-31195.47,-0.144229472,-79950.88,-0.3696458",
          "2015-06-25,-105122.23,-0.4860233,5189.55,0.0239934232",
          "2015-06-26,-70180.23,-0.32447207,110487.54,0.5108294",
          "2015-06-29,-603562.78,-2.790519,-292620.12,-1.35290313",
          "2015-06-30,-306768.97,-1.41831911,113804.69,0.5261659",
          "2015-07-01,417081.79,1.92834067,73397.92,0.339348763",
          "2015-07-02,-61712.14,-0.28532058,-102990.07,-0.476165473",
          "2015-07-03,-168826.43,-0.780554056,6497.54,0.03004078",
          "2015-07-06,-263901.22,-1.22012389,-191899.96,-0.8872325",
          "2015-07-07,-249091.59,-1.15165293,64390.23,0.297702521",
          "2015-07-08,68574.13,0.3170464,194460.92,0.8990728",
          "2015-07-09,432106.38,1.9978056,128162.2,0.5925466",
          "2015-07-10,457918,2.11714339,259307.74,1.19888639",
          "2015-07-13,365478.1,1.68975568,-135420.92,-0.6261066",
          "2015-07-14,165040.82,0.7630516,-25261.3,-0.116793387",
          "2015-07-15,158351.66,0.732124865,32189.98,0.148827508",
          "2015-07-16,336314.12,1.55491853,4391.84,0.0203052741",
          "2015-07-17,-54123.28,-0.2502342,-26481.77,-0.122436114",
          "2015-07-20,106588.63,0.492803067,40390.87,0.1867436",
          "2015-07-21,-186966.03,-0.8644209,-65794.84,-0.3041966",
          "2015-07-22,-95622.91,-0.442104071,-111181.24,-0.5140366",
          "2015-07-23,-200068.41,-0.9249985,359944.46,1.66417134",
          "2015-07-24,-263255.16,-1.21713686,10397.19,0.0480705053",
          "2015-07-27,-459357.75,-2.1237998,-16224.66,-0.07501329",
          "2015-07-28,230344.92,1.06497931,-90578.42,-0.4187813",
          "2015-07-29,185624.34,0.8582177,-118706.46,-0.5488288",
          "2015-07-30,152640.17,0.7057183,-70078.88,-0.3240035",
          "2015-07-31,59887.73,0.2768856,55696.63,0.257508457",
          "2015-08-03,204846.63,0.947090268,232932.05,1.07694066",
          "2015-08-04,22432.57,0.10371498,-2023.03,-0.009353282",
          "2015-08-05,270717.16,1.25163674,-113577.82,-0.525117"
        ]
      },
      {
        "name": "AttributionExample",
        "messages": [],
        "resultsCsv": [
          "Id,ParentId,SortOrder,Name,AverageVar.EffectAlloc.Cash,AverageVar.EffectSel.PcTotal,RiskWeightComputableAssets,RiskWeightComputableAssets,RiskExposure,RiskExposure",
          "TOTAL,,0,TOTAL,44550.13,0.4585252,100,100,21629050.89,21549212.83",
          "87511,TOTAL,1,Energy,3226.48,0.08779604,6.97210264,11.1901731,1507999.64,2411394.19",
          "234583_1,87511,,BG GROUP PLC,,,0.723795235,2.30344224,156550.04,496373.68",
          "234496_1,87511,,BP PLC,,,0.251686335,4.42193127,54437.36,952891.38",
          "241298_1,87511,,ENI SPA,,,0.740208149,,160100,",
          "124233_1,87511,,ROYAL DUTCH SHELL PLC - A,,,1.23051763,4.4647994,266149.28,962129.13",
          "124234_1,87511,,ROYAL DUTCH SHELL PLC - B,,,1.23807085,,267782.97,",
          "55418_1,87511,,STATOIL ASA,,,0.693650365,,150029.99,",
          "234590_1,87511,,TOTAL,,,2.09417415,,452950,",
          "87522,TOTAL,12,Materials,13400.3,0.00130634,13.8758192,8.010497,3001208.01,1726199.13",
          "231499_1,87522,,AIR LIQUIDE,,,0.0281103421,,6080,",
          "231499_8,87522,,AIR LIQUIDE,,,5.62206841,,1216000,",
          "234504_1,87522,,JOHNSON MATTHEY PLC,,,,0.370161355,,79766.86",
          "231831_1,87522,,BASF SE,,,3.76669335,,814700,",
          "658786_1,87522,,GLENCORE PLC,,,,1.62804508,,350830.89",
          "231468_1,87522,,REXAM PLC,,,,0.239624232,,51637.13",
          "234170_1,87522,,BHP BILLITON LIMITED,,,0.8307627,,179686.09,",
          "250043_1,87522,,BHP BILLITON PLC,,,0.772070169,1.55177486,166991.45,334395.28",
          "840083_1,87522,,POLYUS GOLD INTERNATIONAL LTD,,,,0.323992968,,69817.94",
          "181754_1,87522,,FRESNILLO PLC,,,,0.292394549,,63008.72",
          "161906_1,87522,,MONDI PLC,,,,0.3584501,,77243.18",
          "270718_1,87522,,ANGLO AMERICAN PLC,,,0.5092839,0.6850842,110153.27,147630.26",
          "63363_1,87522,,ARCELORMITTAL SA,,,0.400664836,,86660,",
          "234533_1,87522,,RIO TINTO PLC,,,1.69159222,2.204198,365875.35,474987.32",
          "234032_1,87522,,SHIN-ETSU CHEMICAL,,,0.2545736,,55061.86,",
          "236061_1,87522,,ANTOFAGASTA PLC,,,,0.356772,,76881.56",
          "87544,TOTAL,34,Industrials,1700.59,0.04244409,8.701464,6.64937067,1882043.95,1432887.09",
          "64569_1,87544,,INTERTEK GROUP PLC,,,,0.271720767,,58553.69",
          "141160_1,87544,,EXPERIAN PLC,,,,0.7274703,,156764.12",
          "266779_1,87544,,TRAVIS PERKINS PLC,,,,0.329146862,,70928.55",
          "103668_1,87544,,G4S PLC,,,,0.260801464,,56200.66",
          "245465_1,87544,,BABCOCK INTERNATIONAL GROUP,,,,0.312984347,,67445.66",
          "238859_1,87544,,CAPITA PLC,,,,0.535891,,115480.29",
          "516397_1,87544,,WOLSELEY PLC,,,,0.6773687,,145967.62",
          "662448_1,87544,,ROLLS-ROYCE HOLDINGS PLC,,,,0.9203936,,198337.57",
          "285145_1,87544,,EASYJET PLC,,,,0.4154277,,89521.4",
          "235751_1,87544,,ASHTEAD GROUP PLC,,,,0.297736079,,64159.78",
          "236046_1,87544,,BUNZL PLC,,,,0.3775304,,81354.83",
          "1208679_1,87544,,ROYAL MAIL PLC,,,,0.316700667,,68246.5",
          "278706_1,87544,,KLONINKLIJKE PHILIPS ELECTRONI,,,1.18243742,,255750,",
          "232048_1,87544,,MITSUBISHI CORP.,,,0.0818684846,,17707.38,",
          "232426_1,87544,,MITSUI & COMPANY LTD.,,,0.0558811836,,12086.57,",
          "234123_1,87544,,SIEMENS AG,,,4.632658,,1002000,",
          "249118_1,87544,,VINCI,,,2.74861813,,594500,",
          "235202_1,87544,,SMITHS GROUP PLC,,,,0.288905323,,62256.83",
          "234495_1,87544,,BAE SYSTEMS PLC,,,,0.917293668,,197669.57",
          "87589,TOTAL,79,Consumer Discretionary,-2374.85,0.08854784,3.8536458,11.8339205,833507.03,2550116.8",
          "239545_1,87589,,BARRATT DEVELOPMENTS PLC,,,,0.390722245,,84197.56",
          "233093_1,87589,,GKN PLC,,,,0.3229398,,69590.99",
          "234527_1,87589,,RELX PLC,,,,0.769864857,,165899.82",
          "126003_1,87589,,INTERCONTINENTAL HOTELS GROUP,,,,0.3843016,,82813.97",
          "1217462_1,87589,,MERLIN ENTERTAINMENTS PLC,,,,0.252460152,,54403.17",
          "233105_1,87589,,TAYLOR WIMPEY,,,,0.390871644,,84229.76",
          "72330_1,87589,,BURBERRY GROUP,,,,0.446547,,96227.37",
          "234505_1,87589,,KINGFISHER PLC,,,,0.527854145,,113748.41",
          "231345_1,87589,,COMPASS GROUP PLC,,,,1.04331839,,224826.89",
          "152230_1,87589,,SPORTS DIRECT INTERNATIONAL,,,,0.294451654,,63452.02",
          "94546_1,87589,,ITV,,,,0.681658149,,146891.97",
          "62787_1,87589,,MARKS & SPENCER GROUP,,,,0.554848,,119565.38",
          "472118_1,87589,,BERKELEY GROUP HOLDINGS,,,,0.283759058,,61147.84",
          "236040_1,87589,,SKY PLC,,,,1.190508,,256545.1",
          "469373_1,87589,,DIXONS CARPHONE PLC,,,,0.3267344,,70408.69",
          "77452_1,87589,,NEXT PLC,,,,0.7642139,,164682.08",
          "235402_1,87589,,PEARSON PLC,,,,0.6017561,,129673.71",
          "234134_1,87589,,WHITBREAD PLC,,,,0.58377105,,125798.07",
          "200260_1,87589,,WPP PLC,,,,1.17174923,,252502.74",
          "81846_1,87589,,CARNIVAL PLC,,,,0.4660339,,100426.64",
          "231409_1,87589,,HENNES & MAURITZ - B,,,1.70278013,,368295.19,",
          "233961_1,87589,,HONDA MOTOR CO., LTD.,,,0.152390867,,32960.7,",
          "232806_1,87589,,PANASONIC CORP,,,0.04856058,,10503.19,",
          "234040_1,87589,,SONY CORPORATION,,,0.113392942,,24525.82,",
          "234069_1,87589,,Toyota Motor Corp,,,0.272883624,,59022.14,",
          "236682_1,87589,,VIVENDI SA,,,1.12441361,,243200,",
          "234125_1,87589,,VOLKSWAGEN AG,,,0.4392241,,95000,",
          "240469_1,87589,,PERSIMMON PLC,,,,0.385557622,,83084.63",
          "87643,TOTAL,133,Consumer Staples,17724.01,-0.01248921,29.5990677,18.804985,6401997.29,4052326.08",
          "236548_1,87643,,ASSOCIATED BRITISH FOODS,,,,1.56920135,,338150.53",
          "234519_1,87643,,MORRISON (WM.) SUPERMARKETS,,,,0.262952179,,56664.13",
          "234482_1,87643,,SAINSBURY (J) PLC,,,,0.311607122,,67148.88",
          "235476_1,87643,,SABMILLER PLC,,,,3.4092958,,734676.4",
          "231565_1,87643,,BRITISH AMERICAN TOBACCO,,,2.51554966,4.37025738,544089.53,941756.04",
          "249965_1,87643,,DANONE,,,2.92523241,,632700,",
          "233252_1,87643,,DIAGEO PLC,,,1.20720112,2.80444551,261106.15,604335.94",
          "244877_1,87643,,IMPERIAL TOBACCO GROUP PLC,,,2.21867537,1.97561085,479878.44,425728.59",
          "285664_1,87643,,ANHEUSER-BUSCH INBEV,,,10.3240776,,2233000,",
          "168160_1,87643,,RECKITT BENCKISER GROUP PLC,,,4.118802,2.73305964,890857.81,588952.83",
          "234585_1,87643,,TESCO PLC,,,0.143773839,1.07321084,31096.92,231268.49",
          "234821_1,87643,,UNILEVER NV,,,1.95639658,,423150,",
          "234547_1,87643,,UNILEVER PLC,,,1.94807327,,421349.75,",
          "264281_1,87643,,WESFARMERS LTD,,,1.322248,,285989.7,",
          "235399_1,87643,,WOOLWORTHS LTD,,,0.9190371,,198779,",
          "1142544_1,87643,,COCA COLA HBC AG,,,,0.2953438,,63644.26",
          "87666,TOTAL,156,Health Care,273.92,0.02941702,10.8731718,10.5810289,2351763.84,2280128.48",
          "168430_1,87666,,SHIRE PLC,,,,1.98251271,,427215.89",
          "234539_1,87666,,SMITH & NEPHEW PLC,,,,0.6588856,,141984.66",
          "131228_1,87666,,HIKMA PHARMACEUTICALS PLC,,,,0.287647337,,61985.74",
          "278797_1,87666,,GLAXOSMITHKLINE PLC,,,0.9569598,4.228426,206981.32,911192.56",
          "245945_1,87666,,NOVARTIS AG,,,4.34579325,,939953.84,",
          "231595_1,87666,,NOVO-NORDISK AS - B,,,2.45687628,,531399.02,",
          "234050_1,87666,,TAKEDA CHEMICAL INDS,,,0.215405822,,46590.24,",
          "236537_1,87666,,ASTRAZENECA PLC,,,2.89813662,3.42355728,626839.43,737749.64",
          "87685,TOTAL,175,Financials,573.53,0.172553644,21.1278286,20.0980339,4569748.63,4330967.91",
          "235956_1,87685,,BANCO SANTANDER BANCORP SA,,,0.289240628,,62560,",
          "231424_1,87685,,ST. JAMES`S PLACE PLC,,,,0.316729784,,68252.77",
          "234507_1,87685,,LEGAL & GENERAL GROUP PLC,,,,0.9855671,,212381.95",
          "234582_1,87685,,BARCLAYS PLC,,,0.185218021,2.89640641,40060.9,624152.79",
          "903448_1,87685,,DIRECT LINE INSURANCE,,,,0.323818356,,69780.31",
          "149982_1,87685,,STANDARD LIFE PLC,,,,0.531781,,114594.62",
          "50721_1,87685,,LONDON STOCK EXCHANGE GROUP,,,,0.558866858,,120431.41",
          "103708_1,87685,,ADMIRAL GROUP,,,,0.257387221,,55464.92",
          "271731_1,87685,,INTU PROPERTIES PLC,,,,0.27118516,,58438.27",
          "18198_1,87685,,ABERDEEN ASSET MANAGEMENT,,,,0.292319119,,62992.47",
          "72058_1,87685,,LAND SECURITIES GROUP,,,,0.6375338,,137383.51",
          "236526_1,87685,,HAMMERSON PLC,,,,0.32421416,,69865.6",
          "235201_1,87685,,RSA INSURANCE GROUP PLC,,,,0.326274037,,70309.48",
          "244507_1,87685,,3I GROUP PLC,,,,0.323365629,,69682.75",
          "234523_1,87685,,PRUDENTIAL PLC,,,,2.4087615,,519069.16",
          "234500_1,87685,,AVIVA PLC,,,,1.306805,,281606.2",
          "158299_1,87685,,HARGREAVES LANSDOWN PLC,,,,0.34678793,,74730.07",
          "232468_1,87685,,BRITISH LAND CO PLC,,,,0.5415296,,116695.37",
          "234532_1,87685,,ROYAL BANK OF SCOTLAND GROUP,,,,1.37348676,,295975.59",
          "264479_1,87685,,DERWENT LONDON PLC,,,,0.251635432,,54225.46",
          "235204_1,87685,,COMMONWEALTH BANK OF AUSTRALIA,,,2.63173437,,569219.14,",
          "231859_1,87685,,ALLIANZ SE,,,7.16628742,,1550000,",
          "274440_1,87685,,HSBC HOLDINGS PLC,,,0.3877756,,83872.18,",
          "231493_1,87685,,ING GROEP NV,,,0.6962857,,150600,",
          "235366_1,87685,,LLOYDS BANKING GROUP PLC,,,0.0547115654,3.62311769,11833.59,780753.34",
          "13976_1,87685,,MITSUBISHI UFJ FINL GRP INC.,,,0.0301146917,,6513.52,",
          "80646_1,87685,,MIZUHO FINANCIAL GROUP INC.,,,0.00448748,,970.6,",
          "231878_1,87685,,MUENCHENER RUECKVERS,,,0.400503,,86625,",
          "235200_1,87685,,NATIONAL AUSTRALIA BANK LTD.,,,1.04553461,,226139.22,",
          "234012_1,87685,,NOMURA HOLDINGS,,,0.029673079,,6418.01,",
          "251746_1,87685,,NORDEA BK AB,,,0.5190577,,112267.26,",
          "231465_1,87685,,ASSICURAZIONE GENERALI,,,0.8285153,,179200,",
          "235235_1,87685,,SOCIETE GENERALE,,,2.22362971,,480950,",
          "234569_1,87685,,STANDARD CHARTERED PLC,,,0.6161455,1.4887886,133266.42,320822.22",
          "70856_1,87685,,SUMITOMO MITSUI FINANCIAL GRP,,,0.09491309,,20528.8,",
          "62632_1,87685,,TOKIO MARINE HOLDINGS INC,,,0.1770873,,38302.3,",
          "266487_1,87685,,UBS AG,,,0.968848646,,209552.77,",
          "232515_1,87685,,UNICREDIT SPA,,,0.294511318,,63700,",
          "234165_1,87685,,AUSTRALIA & NEW ZEALAND BK GRP,,,1.014097,,219339.56,",
          "234572_1,87685,,WESTPAC BANKING CORP,,,1.04086566,,225129.37,",
          "231410_1,87685,,SCHRODERS,,,,0.4441306,,95706.65",
          "231512_1,87685,,BANCO BILBAO VIZCAYA ARGENT,,,0.428590238,,92700,",
          "236559_1,87685,,PROVIDENT FINANCIAL PLC,,,,0.26754114,,57653.01",
          "87728,TOTAL,218,Information Technology,7744.61,-0.01840167,4.724284,1.17443109,1021817.87,253080.66",
          "239661_1,87728,,SAGE GROUP PLC,,,,0.3488017,,75164.02",
          "262896_1,87728,,ARM HOLDINGS PLC,,,,0.8256294,,177916.64",
          "234556_1,87728,,CANON INC (JAPAN),,,0.137732685,,29790.27,",
          "237860_1,87728,,ERICSSON - B,,,0.4392399,,95003.42,",
          "233994_1,87728,,NINTENDO,,,0.7796189,,168624.18,",
          "232559_1,87728,,NOKIA OYJ,,,0.2912749,,63000,",
          "235942_1,87728,,SAP SE,,,3.076418,,665400,",
          "87760,TOTAL,250,Telecommunication Services,2698.78,0.04755852,2.51998258,6.628824,545048.34,1428459.4",
          "62423_1,87760,,BT GROUP PLC,,,,2.38703728,,514387.72",
          "124230_1,87760,,INMARSAT PLC,,,,0.246798873,,53183.21",
          "244964_1,87760,,DEUTSCHE TELEKOM AG,,,0.7855176,,169900,",
          "231622_1,87760,,KONINKLIJKE KPN NV,,,0.167552426,,36240,",
          "269161_1,87760,,NTT DOCOMO Inc,,,0.04605527,,9961.32,",
          "249946_1,87760,,ORANGE.,,,0.705763757,,152650,",
          "235199_1,87760,,TELEFONICA SA,,,0.65375036,,141400,",
          "234551_1,87760,,VODAFONE GROUP PLC,,,0.161343291,3.994988,34897.02,860888.46",
          "87767,TOTAL,257,Utilities,-320.99,0.0178269,3.37470317,4.4581356,729916.29,960693.14",
          "197939_1,87767,,UNITED UTILITIES GROUP PLC - A,,,,0.374537438,,80709.87",
          "248820_1,87767,,CENTRICA PLC,,,,0.838127851,,180609.96",
          "236580_1,87767,,SSE PLC,,,,0.9673026,,208446.1",
          "234534_1,87767,,SEVERN TRENT PLC,,,,0.322161317,,69423.22",
          "235946_1,87767,,E.ON SE,,,0.5670614,,122650,",
          "276214_1,87767,,ENEL SPA,,,0.201765671,,43640,",
          "119379_1,87767,,ENGIE,,,0.8206555,,177500,",
          "240124_1,87767,,IBERDROLA,,,0.298210025,,64500,",
          "122322_1,87767,,NATIONAL GRID PLC,,,0.5666883,1.95600641,122569.31,421503.99",
          "231884_1,87767,,RWE AG - A,,,0.8907002,,192650,",
          "234578_1,87767,,TOKYO ELECTRIC POWER CO.,,,0.0296221226,,6406.98,",
          "87821,TOTAL,9999999,Cash,0,0,-5.62206841,,-1216000,",
          "1082662_8,87821,,FUTADJ-AIR LIQUIDE,,,-5.62206841,,-1216000,",
          "87787,TOTAL,999999999,Unclassified,-96.25,0.00196568,,0.5706006,,122959.95",
          "691430_1,87787,,BANK OF IRELAND 13.375 PERP,,,,0.5706006,,122959.95"
        ]
      }
    ]
  }
}


Annotated Representation (XML)

Legend

<?xml version="1.0" encoding="utf-8"?>
<interactiveRiskAnalysis xmlns="http://statpro.com/2012/Revolution">
  <link rel="service"
        href="..."
        type="application/vnd.statpro.revolution.api.service+xml" />
  <link rel="portfolios-query"
        href="...?$filter={filter}&amp;$orderby={orderby}&amp;$skip={skip}&amp;$top={top}&amp;includePublishedPortfolios=false&amp;portfolioClassifierCode="
        type="application/vnd.statpro.revolution.api.portfolios+xml" />
  <link rel="self"
        href="..."
        type="application/vnd.statpro.revolution.api.interactive-risk-analysis+xml" />
  <messages>
    <message class="QueryValidationError" id="DuplicateTableName">A duplicate table name has been specified.  Ensure all table names are unique.</message>
  </messages>
  <tables>
    <table name="StressTests and Liquidity Risk">
      <messages>
        <message class="ReasonValueIsNotApplicable" id="LiquidityTestIdNotDefined">No liquidityScenario has been provided.  It must be provided as a parameter of either a columnNode or a rowNode. Scope: C3,C4</message>
      </messages>
      <resultsCsv>Name,StressValue.Cash,Total Liquidity Risk - Normal Override,Total Liquidity Risk - Stressed
TOTAL,-13.6161556,,
Energy,-18.30479,,
Materials,-18.3748627,,
Industrials,-19.4054565,,
Consumer Discretionary,-17.6861286,,
Consumer Staples,-4.212372,,
Health Care,-6.48675776,,
Financials,-21.1418,,
Information Technology,-14.3950815,,
Telecommunication Services,1.76095724,,
Utilities,-10.83098,,</resultsCsv>
    </table>
    <table name="RelativeDecomposition">
      <messages />
      <resultsCsv>Name,VarCash,VarPercent,VarCashRel,VarPercentRel
2015-06-17,-72425.88,-0.334854662,-20734.25,-0.0958629549
2015-06-18,68342.2,0.3159741,-39610.07,-0.183133647
2015-06-19,37326.69,0.172576636,-98442.21,-0.455138832
2015-06-22,590660.16,2.730865,342230.11,1.58227062
2015-06-23,239877.71,1.10905337,1824.62,0.008435984
2015-06-24,-31195.47,-0.144229472,-79950.88,-0.3696458
2015-06-25,-105122.23,-0.4860233,5189.55,0.0239934232
2015-06-26,-70180.23,-0.32447207,110487.54,0.5108294
2015-06-29,-603562.78,-2.790519,-292620.12,-1.35290313
2015-06-30,-306768.97,-1.41831911,113804.69,0.5261659
2015-07-01,417081.79,1.92834067,73397.92,0.339348763
2015-07-02,-61712.14,-0.28532058,-102990.07,-0.476165473
2015-07-03,-168826.43,-0.780554056,6497.54,0.03004078
2015-07-06,-263901.22,-1.22012389,-191899.96,-0.8872325
2015-07-07,-249091.59,-1.15165293,64390.23,0.297702521
2015-07-08,68574.13,0.3170464,194460.92,0.8990728
2015-07-09,432106.38,1.9978056,128162.2,0.5925466
2015-07-10,457918,2.11714339,259307.74,1.19888639
2015-07-13,365478.1,1.68975568,-135420.92,-0.6261066
2015-07-14,165040.82,0.7630516,-25261.3,-0.116793387
2015-07-15,158351.66,0.732124865,32189.98,0.148827508
2015-07-16,336314.12,1.55491853,4391.84,0.0203052741
2015-07-17,-54123.28,-0.2502342,-26481.77,-0.122436114
2015-07-20,106588.63,0.492803067,40390.87,0.1867436
2015-07-21,-186966.03,-0.8644209,-65794.84,-0.3041966
2015-07-22,-95622.91,-0.442104071,-111181.24,-0.5140366
2015-07-23,-200068.41,-0.9249985,359944.46,1.66417134
2015-07-24,-263255.16,-1.21713686,10397.19,0.0480705053
2015-07-27,-459357.75,-2.1237998,-16224.66,-0.07501329
2015-07-28,230344.92,1.06497931,-90578.42,-0.4187813
2015-07-29,185624.34,0.8582177,-118706.46,-0.5488288
2015-07-30,152640.17,0.7057183,-70078.88,-0.3240035
2015-07-31,59887.73,0.2768856,55696.63,0.257508457
2015-08-03,204846.63,0.947090268,232932.05,1.07694066
2015-08-04,22432.57,0.10371498,-2023.03,-0.009353282
2015-08-05,270717.16,1.25163674,-113577.82,-0.525117</resultsCsv>
    </table>
    <table name="AttributionExample">
      <messages />
      <resultsCsv>Id,ParentId,SortOrder,Name,AverageVar.EffectAlloc.Cash,AverageVar.EffectSel.PcTotal,RiskWeightComputableAssets,RiskWeightComputableAssets,RiskExposure,RiskExposure
TOTAL,,0,TOTAL,44550.13,0.4585252,100,100,21629050.89,21549212.83
87511,TOTAL,1,Energy,3226.48,0.08779604,6.97210264,11.1901731,1507999.64,2411394.19
234583_1,87511,,BG GROUP PLC,,,0.723795235,2.30344224,156550.04,496373.68
234496_1,87511,,BP PLC,,,0.251686335,4.42193127,54437.36,952891.38
241298_1,87511,,ENI SPA,,,0.740208149,,160100,
124233_1,87511,,ROYAL DUTCH SHELL PLC - A,,,1.23051763,4.4647994,266149.28,962129.13
124234_1,87511,,ROYAL DUTCH SHELL PLC - B,,,1.23807085,,267782.97,
55418_1,87511,,STATOIL ASA,,,0.693650365,,150029.99,
234590_1,87511,,TOTAL,,,2.09417415,,452950,
87522,TOTAL,12,Materials,13400.3,0.00130634,13.8758192,8.010497,3001208.01,1726199.13
231499_1,87522,,AIR LIQUIDE,,,0.0281103421,,6080,
231499_8,87522,,AIR LIQUIDE,,,5.62206841,,1216000,
234504_1,87522,,JOHNSON MATTHEY PLC,,,,0.370161355,,79766.86
231831_1,87522,,BASF SE,,,3.76669335,,814700,
658786_1,87522,,GLENCORE PLC,,,,1.62804508,,350830.89
231468_1,87522,,REXAM PLC,,,,0.239624232,,51637.13
234170_1,87522,,BHP BILLITON LIMITED,,,0.8307627,,179686.09,
250043_1,87522,,BHP BILLITON PLC,,,0.772070169,1.55177486,166991.45,334395.28
840083_1,87522,,POLYUS GOLD INTERNATIONAL LTD,,,,0.323992968,,69817.94
181754_1,87522,,FRESNILLO PLC,,,,0.292394549,,63008.72
161906_1,87522,,MONDI PLC,,,,0.3584501,,77243.18
270718_1,87522,,ANGLO AMERICAN PLC,,,0.5092839,0.6850842,110153.27,147630.26
63363_1,87522,,ARCELORMITTAL SA,,,0.400664836,,86660,
234533_1,87522,,RIO TINTO PLC,,,1.69159222,2.204198,365875.35,474987.32
234032_1,87522,,SHIN-ETSU CHEMICAL,,,0.2545736,,55061.86,
236061_1,87522,,ANTOFAGASTA PLC,,,,0.356772,,76881.56
87544,TOTAL,34,Industrials,1700.59,0.04244409,8.701464,6.64937067,1882043.95,1432887.09
64569_1,87544,,INTERTEK GROUP PLC,,,,0.271720767,,58553.69
141160_1,87544,,EXPERIAN PLC,,,,0.7274703,,156764.12
266779_1,87544,,TRAVIS PERKINS PLC,,,,0.329146862,,70928.55
103668_1,87544,,G4S PLC,,,,0.260801464,,56200.66
245465_1,87544,,BABCOCK INTERNATIONAL GROUP,,,,0.312984347,,67445.66
238859_1,87544,,CAPITA PLC,,,,0.535891,,115480.29
516397_1,87544,,WOLSELEY PLC,,,,0.6773687,,145967.62
662448_1,87544,,ROLLS-ROYCE HOLDINGS PLC,,,,0.9203936,,198337.57
285145_1,87544,,EASYJET PLC,,,,0.4154277,,89521.4
235751_1,87544,,ASHTEAD GROUP PLC,,,,0.297736079,,64159.78
236046_1,87544,,BUNZL PLC,,,,0.3775304,,81354.83
1208679_1,87544,,ROYAL MAIL PLC,,,,0.316700667,,68246.5
278706_1,87544,,KLONINKLIJKE PHILIPS ELECTRONI,,,1.18243742,,255750,
232048_1,87544,,MITSUBISHI CORP.,,,0.0818684846,,17707.38,
232426_1,87544,,MITSUI &amp; COMPANY LTD.,,,0.0558811836,,12086.57,
234123_1,87544,,SIEMENS AG,,,4.632658,,1002000,
249118_1,87544,,VINCI,,,2.74861813,,594500,
235202_1,87544,,SMITHS GROUP PLC,,,,0.288905323,,62256.83
234495_1,87544,,BAE SYSTEMS PLC,,,,0.917293668,,197669.57
87589,TOTAL,79,Consumer Discretionary,-2374.85,0.08854784,3.8536458,11.8339205,833507.03,2550116.8
239545_1,87589,,BARRATT DEVELOPMENTS PLC,,,,0.390722245,,84197.56
233093_1,87589,,GKN PLC,,,,0.3229398,,69590.99
234527_1,87589,,RELX PLC,,,,0.769864857,,165899.82
126003_1,87589,,INTERCONTINENTAL HOTELS GROUP,,,,0.3843016,,82813.97
1217462_1,87589,,MERLIN ENTERTAINMENTS PLC,,,,0.252460152,,54403.17
233105_1,87589,,TAYLOR WIMPEY,,,,0.390871644,,84229.76
72330_1,87589,,BURBERRY GROUP,,,,0.446547,,96227.37
234505_1,87589,,KINGFISHER PLC,,,,0.527854145,,113748.41
231345_1,87589,,COMPASS GROUP PLC,,,,1.04331839,,224826.89
152230_1,87589,,SPORTS DIRECT INTERNATIONAL,,,,0.294451654,,63452.02
94546_1,87589,,ITV,,,,0.681658149,,146891.97
62787_1,87589,,MARKS &amp; SPENCER GROUP,,,,0.554848,,119565.38
472118_1,87589,,BERKELEY GROUP HOLDINGS,,,,0.283759058,,61147.84
236040_1,87589,,SKY PLC,,,,1.190508,,256545.1
469373_1,87589,,DIXONS CARPHONE PLC,,,,0.3267344,,70408.69
77452_1,87589,,NEXT PLC,,,,0.7642139,,164682.08
235402_1,87589,,PEARSON PLC,,,,0.6017561,,129673.71
234134_1,87589,,WHITBREAD PLC,,,,0.58377105,,125798.07
200260_1,87589,,WPP PLC,,,,1.17174923,,252502.74
81846_1,87589,,CARNIVAL PLC,,,,0.4660339,,100426.64
231409_1,87589,,HENNES &amp; MAURITZ - B,,,1.70278013,,368295.19,
233961_1,87589,,HONDA MOTOR CO., LTD.,,,0.152390867,,32960.7,
232806_1,87589,,PANASONIC CORP,,,0.04856058,,10503.19,
234040_1,87589,,SONY CORPORATION,,,0.113392942,,24525.82,
234069_1,87589,,Toyota Motor Corp,,,0.272883624,,59022.14,
236682_1,87589,,VIVENDI SA,,,1.12441361,,243200,
234125_1,87589,,VOLKSWAGEN AG,,,0.4392241,,95000,
240469_1,87589,,PERSIMMON PLC,,,,0.385557622,,83084.63
87643,TOTAL,133,Consumer Staples,17724.01,-0.01248921,29.5990677,18.804985,6401997.29,4052326.08
236548_1,87643,,ASSOCIATED BRITISH FOODS,,,,1.56920135,,338150.53
234519_1,87643,,MORRISON (WM.) SUPERMARKETS,,,,0.262952179,,56664.13
234482_1,87643,,SAINSBURY (J) PLC,,,,0.311607122,,67148.88
235476_1,87643,,SABMILLER PLC,,,,3.4092958,,734676.4
231565_1,87643,,BRITISH AMERICAN TOBACCO,,,2.51554966,4.37025738,544089.53,941756.04
249965_1,87643,,DANONE,,,2.92523241,,632700,
233252_1,87643,,DIAGEO PLC,,,1.20720112,2.80444551,261106.15,604335.94
244877_1,87643,,IMPERIAL TOBACCO GROUP PLC,,,2.21867537,1.97561085,479878.44,425728.59
285664_1,87643,,ANHEUSER-BUSCH INBEV,,,10.3240776,,2233000,
168160_1,87643,,RECKITT BENCKISER GROUP PLC,,,4.118802,2.73305964,890857.81,588952.83
234585_1,87643,,TESCO PLC,,,0.143773839,1.07321084,31096.92,231268.49
234821_1,87643,,UNILEVER NV,,,1.95639658,,423150,
234547_1,87643,,UNILEVER PLC,,,1.94807327,,421349.75,
264281_1,87643,,WESFARMERS LTD,,,1.322248,,285989.7,
235399_1,87643,,WOOLWORTHS LTD,,,0.9190371,,198779,
1142544_1,87643,,COCA COLA HBC AG,,,,0.2953438,,63644.26
87666,TOTAL,156,Health Care,273.92,0.02941702,10.8731718,10.5810289,2351763.84,2280128.48
168430_1,87666,,SHIRE PLC,,,,1.98251271,,427215.89
234539_1,87666,,SMITH &amp; NEPHEW PLC,,,,0.6588856,,141984.66
131228_1,87666,,HIKMA PHARMACEUTICALS PLC,,,,0.287647337,,61985.74
278797_1,87666,,GLAXOSMITHKLINE PLC,,,0.9569598,4.228426,206981.32,911192.56
245945_1,87666,,NOVARTIS AG,,,4.34579325,,939953.84,
231595_1,87666,,NOVO-NORDISK AS - B,,,2.45687628,,531399.02,
234050_1,87666,,TAKEDA CHEMICAL INDS,,,0.215405822,,46590.24,
236537_1,87666,,ASTRAZENECA PLC,,,2.89813662,3.42355728,626839.43,737749.64
87685,TOTAL,175,Financials,573.53,0.172553644,21.1278286,20.0980339,4569748.63,4330967.91
235956_1,87685,,BANCO SANTANDER BANCORP SA,,,0.289240628,,62560,
231424_1,87685,,ST. JAMES`S PLACE PLC,,,,0.316729784,,68252.77
234507_1,87685,,LEGAL &amp; GENERAL GROUP PLC,,,,0.9855671,,212381.95
234582_1,87685,,BARCLAYS PLC,,,0.185218021,2.89640641,40060.9,624152.79
903448_1,87685,,DIRECT LINE INSURANCE,,,,0.323818356,,69780.31
149982_1,87685,,STANDARD LIFE PLC,,,,0.531781,,114594.62
50721_1,87685,,LONDON STOCK EXCHANGE GROUP,,,,0.558866858,,120431.41
103708_1,87685,,ADMIRAL GROUP,,,,0.257387221,,55464.92
271731_1,87685,,INTU PROPERTIES PLC,,,,0.27118516,,58438.27
18198_1,87685,,ABERDEEN ASSET MANAGEMENT,,,,0.292319119,,62992.47
72058_1,87685,,LAND SECURITIES GROUP,,,,0.6375338,,137383.51
236526_1,87685,,HAMMERSON PLC,,,,0.32421416,,69865.6
235201_1,87685,,RSA INSURANCE GROUP PLC,,,,0.326274037,,70309.48
244507_1,87685,,3I GROUP PLC,,,,0.323365629,,69682.75
234523_1,87685,,PRUDENTIAL PLC,,,,2.4087615,,519069.16
234500_1,87685,,AVIVA PLC,,,,1.306805,,281606.2
158299_1,87685,,HARGREAVES LANSDOWN PLC,,,,0.34678793,,74730.07
232468_1,87685,,BRITISH LAND CO PLC,,,,0.5415296,,116695.37
234532_1,87685,,ROYAL BANK OF SCOTLAND GROUP,,,,1.37348676,,295975.59
264479_1,87685,,DERWENT LONDON PLC,,,,0.251635432,,54225.46
235204_1,87685,,COMMONWEALTH BANK OF AUSTRALIA,,,2.63173437,,569219.14,
231859_1,87685,,ALLIANZ SE,,,7.16628742,,1550000,
274440_1,87685,,HSBC HOLDINGS PLC,,,0.3877756,,83872.18,
231493_1,87685,,ING GROEP NV,,,0.6962857,,150600,
235366_1,87685,,LLOYDS BANKING GROUP PLC,,,0.0547115654,3.62311769,11833.59,780753.34
13976_1,87685,,MITSUBISHI UFJ FINL GRP INC.,,,0.0301146917,,6513.52,
80646_1,87685,,MIZUHO FINANCIAL GROUP INC.,,,0.00448748,,970.6,
231878_1,87685,,MUENCHENER RUECKVERS,,,0.400503,,86625,
235200_1,87685,,NATIONAL AUSTRALIA BANK LTD.,,,1.04553461,,226139.22,
234012_1,87685,,NOMURA HOLDINGS,,,0.029673079,,6418.01,
251746_1,87685,,NORDEA BK AB,,,0.5190577,,112267.26,
231465_1,87685,,ASSICURAZIONE GENERALI,,,0.8285153,,179200,
235235_1,87685,,SOCIETE GENERALE,,,2.22362971,,480950,
234569_1,87685,,STANDARD CHARTERED PLC,,,0.6161455,1.4887886,133266.42,320822.22
70856_1,87685,,SUMITOMO MITSUI FINANCIAL GRP,,,0.09491309,,20528.8,
62632_1,87685,,TOKIO MARINE HOLDINGS INC,,,0.1770873,,38302.3,
266487_1,87685,,UBS AG,,,0.968848646,,209552.77,
232515_1,87685,,UNICREDIT SPA,,,0.294511318,,63700,
234165_1,87685,,AUSTRALIA &amp; NEW ZEALAND BK GRP,,,1.014097,,219339.56,
234572_1,87685,,WESTPAC BANKING CORP,,,1.04086566,,225129.37,
231410_1,87685,,SCHRODERS,,,,0.4441306,,95706.65
231512_1,87685,,BANCO BILBAO VIZCAYA ARGENT,,,0.428590238,,92700,
236559_1,87685,,PROVIDENT FINANCIAL PLC,,,,0.26754114,,57653.01
87728,TOTAL,218,Information Technology,7744.61,-0.01840167,4.724284,1.17443109,1021817.87,253080.66
239661_1,87728,,SAGE GROUP PLC,,,,0.3488017,,75164.02
262896_1,87728,,ARM HOLDINGS PLC,,,,0.8256294,,177916.64
234556_1,87728,,CANON INC (JAPAN),,,0.137732685,,29790.27,
237860_1,87728,,ERICSSON - B,,,0.4392399,,95003.42,
233994_1,87728,,NINTENDO,,,0.7796189,,168624.18,
232559_1,87728,,NOKIA OYJ,,,0.2912749,,63000,
235942_1,87728,,SAP SE,,,3.076418,,665400,
87760,TOTAL,250,Telecommunication Services,2698.78,0.04755852,2.51998258,6.628824,545048.34,1428459.4
62423_1,87760,,BT GROUP PLC,,,,2.38703728,,514387.72
124230_1,87760,,INMARSAT PLC,,,,0.246798873,,53183.21
244964_1,87760,,DEUTSCHE TELEKOM AG,,,0.7855176,,169900,
231622_1,87760,,KONINKLIJKE KPN NV,,,0.167552426,,36240,
269161_1,87760,,NTT DOCOMO Inc,,,0.04605527,,9961.32,
249946_1,87760,,ORANGE.,,,0.705763757,,152650,
235199_1,87760,,TELEFONICA SA,,,0.65375036,,141400,
234551_1,87760,,VODAFONE GROUP PLC,,,0.161343291,3.994988,34897.02,860888.46
87767,TOTAL,257,Utilities,-320.99,0.0178269,3.37470317,4.4581356,729916.29,960693.14
197939_1,87767,,UNITED UTILITIES GROUP PLC - A,,,,0.374537438,,80709.87
248820_1,87767,,CENTRICA PLC,,,,0.838127851,,180609.96
236580_1,87767,,SSE PLC,,,,0.9673026,,208446.1
234534_1,87767,,SEVERN TRENT PLC,,,,0.322161317,,69423.22
235946_1,87767,,E.ON SE,,,0.5670614,,122650,
276214_1,87767,,ENEL SPA,,,0.201765671,,43640,
119379_1,87767,,ENGIE,,,0.8206555,,177500,
240124_1,87767,,IBERDROLA,,,0.298210025,,64500,
122322_1,87767,,NATIONAL GRID PLC,,,0.5666883,1.95600641,122569.31,421503.99
231884_1,87767,,RWE AG - A,,,0.8907002,,192650,
234578_1,87767,,TOKYO ELECTRIC POWER CO.,,,0.0296221226,,6406.98,
87821,TOTAL,9999999,Cash,0,0,-5.62206841,,-1216000,
1082662_8,87821,,FUTADJ-AIR LIQUIDE,,,-5.62206841,,-1216000,
87787,TOTAL,999999999,Unclassified,-96.25,0.00196568,,0.5706006,,122959.95
691430_1,87787,,BANK OF IRELAND 13.375 PERP,,,,0.5706006,,122959.95</resultsCsv>
    </table>
  </tables>
</interactiveRiskAnalysis>


Last updated: August 2017


To Top