StatPro Revolution Web API


The Interactive Statistics Analysis Resource


Overview

The Interactive Statistics Analysis resource is identical to the Interactive Risk Analysis resource except for the set of error messages that may be returned. The resource represents a set of ex-post risk, performance and raw data measures that have been calculated interactively on-the-fly given a user provided query. A single Interactive Statistics Analysis query comprises a request for one or more tables of statistics results and each table representing a collection of measures calculated at total level.

The key to understanding the Interactive Statistics 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-statistics-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 Statistics Analysis resource is exposed via XML and JSON representations, which have the following media type names:-

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

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

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

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

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


Related resources

The Interactive Statistics 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 Statistics 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 Statistics Analysis resource there can exist zero or more informational messages or errors relating to issues that have occurred in the processing of the interactive statistics 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:

895 - InteractiveStatisticsQueryRequestDataMissing: Occurs when no interactive statistics query is submitted,

896 - InteractiveStatisticsQueryRequestDataNotXml: Occurs when the interactive statistics query submitted is not well-formed Xml.

897 - InteractiveStatisticsQueryRequestFailedSchemaValidation: Occurs when the interactive statistics 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 statistics 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 interactiveStatisticsAnalysis 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.

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
BadCalendarThe value is N/A because the Calendar has no dates.
Benchmark1UndefinedThe value is N/A because Benchmark1 is not specified for {performerName}.performerId
Benchmark2UndefinedThe value is N/A because Benchmark2 is not specified for {performerName}.performerId
Benchmark3UndefinedThe value is N/A because Benchmark3 is not specified for {performerName}.performerId
Benchmark4UndefinedThe value is N/A because Benchmark4 is not specified for {performerName}.performerId
CalendarMaxDateExceededThe period was N/A as a date later than the calendar's latest date was requested.calendarMaxDate
CalendarMinDateExceededThe period was N/A as a date earlier than the calendar's earliest date was requested.calendarMinDate
CurrencyNotFoundCurrency not found.currencyId
DailyFrequencyNotSupportedThe value is N/A because Daily frequency is not supported by the this statistic
DuplicateColumnNameThe columnNode name '{0}' is duplicated.columnName
DuplicateTableNameA duplicate table name has been specified.
EndNotCalendarAlignedThe value is N/A because the statistic requires a {frequencyAdjective} History, and the end date is not a {frequencyAdjective} date.frequencyAdjective
IllegalPartialPeriodThe value is N/A because the date range is a partial period and partial periods are not allowed
InappropriateMeasureThe security-level measure is N/A because security level measures were not requested.
InsufficientGainsThe Bull Statistic is N/A because there are too few gains during the period. (Ex-Post Risk Statistics require a minimum of {minResultsForStdDev} {frequencyAdjective} samples).minResultsForStdDev, frequencyAdjective
InsufficientLossesThe Bear Statistic is N/A because there are too few losses during the period. (Ex-Post Risk Statistics require a minimum of {minResultsForStdDev} {frequencyAdjective} samples).minResultsForStdDev, frequencyAdjective
InsufficientSamplesThe Risk Statistic is N/A because the calculation period is too short (Ex-Post Risk Statistics require a minimum of {minResultsForStdDev} {frequencyAdjective} samples).minResultsForStdDev, frequencyAdjective
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
InvalidMeasureIdThe measureId provided is invalid.measureId
InvalidPeriodBaseIdThe period baseId '{baseId}' is not recognised. For a list of recognised period baseIds, see the Web API resource for 'Periods for use with Interactive Statistics;.baseId
LessThanYearThe annualised statistic is N/A because the requested period is < 1 year.
MeasureScopeNaThe measure '{seedMeasure}' cannot be interpreted and is not valid at levels higher than Table level.seedMeasure
MissingBenchmarkPerfSeriesThe value is N/A as benchmark '{performerName}' has no performance series.performerId
MissingPortfolioInternalMvSeriesThe value of the 'Internal Market Value' measure is N / A as the portfolio has no internal Market Value series.performerId
MissingPortfolioPerfSeriesThe value is N/A as portfolio '{performerName}' has no performance series for share class '{shareType}' with return type '{returnType}'.performerId, shareClass, returnType
MissingPortfolioQuantitySeriesThe value of the 'Units' measure is N/A as the portfolio has no portfolio-level 'Quantity' time series.performerId
MissingPortfolioTotalAssetsSeriesThe value of the 'External Market Value' measure is N/A as the portfolio has no 'Total Assets' series.performerId
MissingValuationsThe value is N/A because the benchmark does not have valuations for all dates of the main entity.
MultipleParametersInThisNodeCreateChildrenOnly one parameter in a node may create children.
NaForRiskFreeThe measure is N/A as it never applies to risk free rates.
NoBenchmarkGainsThe Bull Return is N/A because there are no benchmark gains during the period.
NoBenchmarkLossesThe Bear Return is N/A because there are no benchmark losses during the period.
NoBmarkThe value is N/A because no benchmark is set for {performerName}.performerId
NoDateThe value is N/A because the start or end date is not specified.
NoHighestFrequencyThe value is N/A because a contiguous set of quarterly, monthly or weekly returns does not exist for the period.
NoHistoryThe value is N/A because no performance history is available for {performerName}.performerId
NoLossThe value is N/A because there is no loss.
NoPerfThisDateThe value is N/A because no performance history is present for the date requested for {performerName}. A calendar, if applied, may also cause certain dates to be ignored.performerId
NoPerfCalendarClosedThisDateThe value is N/A because the calendar is closed for the requested date and with the requested date tolerance.
NoRiskFreeThe value is N/A because no risk free series is specified for {performerName}.performerId
NoValueThisDateThe value was N/A as no history is present for the requested date.performerId
NotANumberThe value is N/A as it is infinite or not a number.
NotRecoveredThe value is N/A because a full recovery did not occur following the maximum loss.
OutsideThisBlockThe value is N/A because the request date is outside of the current Performance Block.
PartialPeriodicDataThe Performance Statistic is N/A because the Performance History is not a complete {frequencyAdjective} series for the specified period for {performerName}.frequencyAdjective, performerId
PerformerNotFoundThe value is N/A because {performerName} was not found.performerId
PeriodHiddenUponRuleThe period is configured to be not applicable for this overall reporting period.
ReturnTypeNotFoundThe value is N/A as {performerName} doesn't support return type '{returnType}'.performerId, returnType
RiskFreeUndefinedThe value is N/A because a Risk Free rate was not specified.
ShareClassNotFoundThe value is N/A as {performerName} doesn't support share class '{shareType}'.performerId, shareClass
StartAfterEndThe period is N/A as the Start Date is after the End Date.
StartNotBeforeEndThe value is N/A because the Start Date is not before the End Date.
TestedStatNotSignificantThe value is N/A because the Tested Statistic is outside its range of significance.
TotalMeasureInTableWithoutTotalTotal-Level measure requested in table not displaying Total Level. Please delete the measure, or add total-level.
UnchainablePeriodThe value is N/A because the Peformance History for {performerName} forms two or more unchainable blocks for the specified period.performerId
UnexpectedErrorAn unexpected error occurred processing the request (Code: {0}, Class: {1}).errorCode, errorClass
UnitPriceNaForInternalReturnThe value is N/A as the Unit Price is always N/A when Return Type = Internal.
UnlicensedBenchmarkThe associated benchmark is unlicensed for the portfolio owner.
UnsupportedFeatureMultiRowNodeFilterThe 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.
UnsupportedFilterOrderbyTableTypeThe rowfilter is not yet supported for table type '{0}'. Please contact StatPro Support to request its addition.
UnsupportedMeasureDataTypeThe rowfilter could not be applied to column {0} as it has an unsupported data type.

Message 'dataCsv' Attribute

The dataCsv attribute contains a CSV encoded and escaped array of data items. The selection of data items returned depends on the message id.

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. Added message ids "DuplicateColumnName", "DuplicateTableName" and "InvalidColumnName" - August 2017
  • Added message ids "NoPerfCalendarClosedThisDate" and "UnitPriceNaForInternalReturn" - March 2017
  • Initial Version - December 2016

Annotated Representation (JSON)

Legend

{
  "interactiveStatisticsAnalysis": {
    "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-statistics-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 Statistics",
        "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"?>
<interactiveStatisticsAnalysis 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-statistics-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 Statistics">
      <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>
</interactiveStatisticsAnalysis>


Last updated: August 2017


To Top