Chapter 9 Making Connections: Networks

9.2 Small Worlds

Useful introductory book on networks: http://www.cs.cornell.edu/home/kleinber/networks-book/

9.4 Graphs

What is a graph? It is a picture of a network, a diagram consisting of relationships between entities. We call the entities as vertices or nodes (set $$V$$) and the relationships are called the edges of a graph (set $$E$$). Hence a graph $$G$$ is defined as

$$$G = (V,E)$$$

9.4.1 Types of graphs

If the edges $$e \in E$$ of a graph are not tipped with arrows implying some direction or causality, we call the graph an “undirected” graph. If there are arrows of direction then the graph is a “directed” graph.

If the connections (edges) between vertices $$v \in V$$ have weights on them, then we call the graph a “weighted graph” else it’s “unweighted”. In an unweighted graph, for any pair of vertices $$(u,v)$$, we have

$$$w(u,v) = \left\{ \begin{array}{ll} w(u,v) = 1, & \mbox{ if } (u,v) \in E \\ w(u,v) = 0, & \mbox{ if } (u,v) \ni E \end{array} \right.$$$

In a weighted graph the value of $$w(u,v)$$ is unrestricted, and can also be negative.

Directed graphs can be cyclic or acyclic. In a cyclic graph there is a path from a source node that leads back to the node itself. Not so in an acyclic graph. The term dag is used to connote a “directed acyclic graph”. The binomial option pricing model in finance that you have learnt is an example of a dag.

A graph may be represented by its adjacency matrix. This is simply the matrix $$A = \{w(u,v)\}, \forall u,v$$. You can take the transpose of this matrix as well, which in the case of a directed graph will simply reverse the direction of all edges.

9.6 igraph package

library(igraph)
## Loading required package: methods
##
## Attaching package: 'igraph'
## The following objects are masked from 'package:stats':
##
##     decompose, spectrum
## The following object is masked from 'package:base':
##
##     union
g = erdos.renyi.game(20,1/10)
g
## IGRAPH U--- 20 23 -- Erdos renyi (gnp) graph
## + attr: name (g/c), type (g/c), loops (g/l), p (g/n)
## + edges:
##  [1]  1-- 5  8-- 9  2--10  6--11  7--11  1--12  6--12 10--12 11--12  6--13
## [11]  7--15 12--15  1--16  4--16  8--16  3--17  1--18  1--19 10--19 14--19
## [21] 16--19  5--20  9--20
plot.igraph(g)

print(clusters(g))
## $membership ## [1] 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 ## ##$csize
## [1] 18  2
##
## $no ## [1] 2 g$no[[1]]
## NULL

9.7 Graph Attributes

#GENERATE RANDOM GRAPH
g = erdos.renyi.game(30,0.2)
plot(g)

#COMPUTE DEGREE DISTRIBUTION
dd = degree.distribution(g)
dd = as.matrix(dd)
d = as.matrix(seq(0,max(degree(g))))
plot(d,dd,type="l")

9.8 Dijkstra’s Shortest Paths Algorithm

This is one of the most well-known algorithms in theoretical computer science. Given a source vertex on a weighted, directed graph, it finds the shortest path to all other nodes from source $$s$$. The weight between two vertices is denoted $$w(u,v)$$ as before. Dijkstra’s algorithm works for graphs where $$w(u,v) \geq 0$$. For negative weights, there is the Bellman-Ford algorithm. The algorithm is as follows.

function DIJKSTRA(G,w,s)
S = { }
%S = Set of vertices whose shortest paths from
%source s have been found
Q = V(G)
while Q notequal { } :
u = getMin(Q)
S = S + u
Q = Q - u
for each vertex v in SUCC(u):
if d[v] > d[u]+w(u,v) then:
d[v] = d[u]+w(u,v)
PRED(v) = u

#DIJSKATRA'S SHORTEST PATHS ALGORITHM
e = matrix(nc=3, byrow=TRUE, c(1,2,8, 1,4,4, 2,4,3, 4,2,1, 2,3,1, 2,5,7, 4,5,4, 3,5,1))
e
##      [,1] [,2] [,3]
## [1,]    1    2    8
## [2,]    1    4    4
## [3,]    2    4    3
## [4,]    4    2    1
## [5,]    2    3    1
## [6,]    2    5    7
## [7,]    4    5    4
## [8,]    3    5    1
g = graph.empty(5)
plot(g)

plot(g,edge.width=e[,3],edge.label=e[,3])

get.shortest.paths(g,1)
## $vpath ##$vpath[[1]]
## + 0/5 vertices:
##
## $vpath[[2]] ## + 3/5 vertices: ## [1] 1 4 2 ## ##$vpath[[3]]
## + 4/5 vertices:
## [1] 1 4 2 3
##
## $vpath[[4]] ## + 2/5 vertices: ## [1] 1 4 ## ##$vpath[[5]]
## + 5/5 vertices:
## [1] 1 4 2 3 5
##
##
## $epath ## NULL ## ##$predecessors
## NULL
##
## $inbound_edges ## NULL print(shortest.paths(g)) ## [,1] [,2] [,3] [,4] [,5] ## [1,] 0 5 6 4 7 ## [2,] 5 0 1 1 2 ## [3,] 6 1 0 2 1 ## [4,] 4 1 2 0 3 ## [5,] 7 2 1 3 0 print(average.path.length(g)) ## [1] 1.272727 el <- matrix(nc=3, byrow=TRUE,c(0,1,0, 0,2,2, 0,3,1, 1,2,0, 1,4,5, 1,5,2, 2,1,1, 2,3,1, 2,6,1, 3,2,0, 3,6,2, 4,5,2, 4,7,8, 5,2,2, 5,6,1, 5,8,1, 5,9,3, 7,5,1, 7,8,1, 8,9,4) ) el[,1:2] = el[,1:2]+1 #Note that the zero vertex option does not exist any more, so we added 1 g = add.edges(graph.empty(10), t(el[,1:2]), weight=el[,3]) plot(g) #GRAPHING MAIN NETWORK g = simplify(g) V(g)$name = seq(vcount(g))
#l = layout.fruchterman.reingold(g)
l = layout.circle(g)
l = layout.norm(l, -1,1,-1,1)
#pdf(file="network_plot.pdf")
plot(g, layout=l, vertex.size=10, vertex.label=seq(1,10), vertex.color="#ff000033",
edge.color="grey", edge.arrow.size=0.75, rescale=FALSE,
xlim=range(l[,1]), ylim=range(l[,2]))

9.9 D3 plots

D3 is a well known framework for plotting spring graphs. The following plot shows how one may use javascript in R, using the html widgets framework. See: http://www.htmlwidgets.org/

library(networkD3)

links$value = 1 nodes = data.frame(unique(c(links$target,links$source))) names(nodes) = "name" nodes$group = ceiling(3*runif(length(nodes$name))) forceNetwork(Links = links, Nodes = nodes, Source = "source", Target = "target", Value = "value", NodeID = "name", Group = "group", opacity = 0.8, fontSize = 75) 9.10 Centrality Centrality is a property of vertices in the network. Given the adjacency matrix $$A=\{w(u,v)\}$$, we can obtain a measure of the “influence” of all vertices in the network. Let $$x_i$$ be the influence of vertex $$i$$. Then the column vector $$x$$ contains the influence of each vertex. What is influence? Think of a web page. It has more influence the more links it has both, to the page, and from the page to other pages. Or think of a alumni network. People with more connections have more influence, they are more “central”. It is possible that you might have no connections yourself, but are connected to people with great connections. In this case, you do have influence. Hence, your influence depends on your own influence and that which you derive through others. Hence, the entire system of influence is interdependent, and can be written as the following matrix equation $$$x = A\;x$$$ Now, we can just add a scalar here to this to get $$$\xi \; x = A x$$$ an eigensystem. Decompose this to get the principle eigenvector, and its values give you the influence of each member. In this way you can find the most influential people in any network. There are several applications of this idea to real data. This is eigenvector centrality is exactly what Google trademarked as PageRank, even though they did not invent eigenvector centrality. A = matrix(nc=3, byrow=TRUE, c(0,1,1, 1,0,1, 1,1,0)) print(A) ## [,1] [,2] [,3] ## [1,] 0 1 1 ## [2,] 1 0 1 ## [3,] 1 1 0 g = graph.adjacency(A,mode="undirected",weighted=TRUE,diag=FALSE) res = evcent(g) print(names(res)) ## [1] "vector" "value" "options" res$vector
## [1] 1 1 1
res = evcent(g,scale=FALSE)
res$vector ## [1] 0.5773503 0.5773503 0.5773503 A = matrix(nc=3, byrow=TRUE, c(0,1,1, 1,0,0, 1,0,0)) print(A) ## [,1] [,2] [,3] ## [1,] 0 1 1 ## [2,] 1 0 0 ## [3,] 1 0 0 g = graph.adjacency(A,mode="undirected",weighted=TRUE,diag=FALSE) res = evcent(g,scale=FALSE) res$vector
## [1] 0.7071068 0.5000000 0.5000000
A = matrix(nc=3, byrow=TRUE, c(0,2,1, 2,0,0, 1,0,0))
print(A)
##      [,1] [,2] [,3]
## [1,]    0    2    1
## [2,]    2    0    0
## [3,]    1    0    0
g = graph.adjacency(A,mode="undirected",weighted=TRUE,diag=FALSE)
res = evcent(g,scale=FALSE)
res$vector ## [1] 0.7071068 0.6324555 0.3162278 9.11 Betweenness Another concept of centrality is known as “betweenness”. This is the proportion of shortest paths that go through a node relative to all paths that go through the same node. This may be expressed as $$$B(v) = \sum_{a \neq v \neq b} \frac{n_{a,b}(v)}{n_{a,b}}$$$ where $$n_{a,b}$$ is the number of shortest paths from node $$a$$ to node $$b$$, and $$n_{a,b}(v)$$ are the number of those paths that traverse through vertex $$v$$. Here is an example from an earlier directed graph. el = matrix(nc=3, byrow=TRUE, c(0,1,1, 0,2,2, 0,3,1, 1,2,1, 1,4,5, 1,5,2, 2,1,1, 2,3,1, 2,6,1, 3,2,1, 3,6,2, 4,5,2, 4,7,8, 5,2,2, 5,6,1, 5,8,1, 5,9,3, 7,5,1, 7,8,1, 8,9,4) ) el[,1:2] = el[,1:2] + 1 g = add.edges(graph.empty(10), t(el[,1:2]), weight=el[,3]) plot(g) res = betweenness(g) res ## [1] 0.0000000 18.5833333 18.2500000 0.8333333 5.0000000 20.0000000 ## [7] 0.0000000 0.0000000 0.0000000 0.0000000 g = erdos.renyi.game(30,0.1) d = seq(0,max(degree(g))) dd = degree.distribution(g) plot(g) #DIAMETER print(diameter(g)) ## [1] 6 #FRAGILITY print((t(d^2) %*% dd)/(t(d) %*% dd)) ## [,1] ## [1,] 3.837209 #CENTRALITY res = evcent(g) res$vector
##  [1] 0.13020514 0.10654809 0.50328790 0.53703737 0.22421218 0.23555387
##  [7] 0.33641755 0.09718898 0.07088808 0.61028079 0.37861544 0.27615600
## [13] 0.37620605 0.17105358 1.00000000 0.07332221 0.08635696 0.12932960
## [19] 0.15630895 0.28404621 0.17887855 0.27369218 0.13102918 0.25669577
## [25] 0.25669577 0.72508578 0.23833268 0.69685043 0.25944866 0.41435043

9.12 Communities

Community detection methods partition nodes into clusters that tend to interact together. It is useful to point out the considerable flexibility and realism built into the definition of our community clusters. We do not require all nodes to belong to communities. Nor do we fix the number of communities that may exist at a time, and we also allow each community to have different size.

With this flexibility, the key computational challenge is to find the “best” partition because the number of possible partitions of the nodes is extremely large. Community detection methods attempt to determine a set of clusters that are internally tight-knit. Mathematically, this is equivalent to finding a partition of clusters to maximize the observed number of connections between cluster members minus what is expected conditional on the connections within the cluster, aggregated across all clusters. More formally, we choose partitions with high modularity $$Q$$, where

$$$Q = \frac{1}{2m} \sum_{i,j} \left[ A_{ij} - \frac{d_i \times d_j}{2m} \right] \cdot \delta(i,j)$$$

$$A_{ij}$$ is the $$(i,j)$$-th entry in the adjacency matrix, i.e., the number of connections in which $$i$$ and $$j$$ jointly participated, $$d_i=\sum_j A_{ij}$$ is the total number of transactions that node $$i$$ participated in (or, the degree of $$i$$) and $$m = \frac{1}{2} \sum_{ij} A_{ij}$$ is the sum of all edge weights in matrix $$A$$.

The function $$\delta(i,j)$$ is an indicator equal to 1.0 if nodes $$i$$ and $$j$$ are from the same community, and zero otherwise. $$Q$$ is bounded in [-1, +1]. If $$Q > 0$$, intra-community connections exceed the expected number given deal flow.

Consider a network of five nodes $$\{A,B,C,D,E\}$$, where the edge weights are as follows: $$A:B=6$$, $$A:C=5$$, $$B:C=2$$, $$C:D=2$$, and $$D:E=10$$. Assume that a community detection algorithm assigns $$\{A,B,C\}$$ to one community and $$\{D,E\}$$ to another, i.e., only two communities. The adjacency matrix for this graph is given by matrix $$A$$ below.

A = matrix(c(0,6,5,0,0,6,0,2,0,0,5,2,0,2,0,0,0,2,0,10,0,0,0,10,0),5,5)
print(A)
##      [,1] [,2] [,3] [,4] [,5]
## [1,]    0    6    5    0    0
## [2,]    6    0    2    0    0
## [3,]    5    2    0    2    0
## [4,]    0    0    2    0   10
## [5,]    0    0    0   10    0
g = graph.adjacency(A,mode="undirected",weighted=TRUE,diag=FALSE)
wtc = walktrap.community(g)
res=membership(wtc)
print(res)
## [1] 1 1 1 2 2
g = graph.adjacency(A,mode="undirected",weighted=TRUE,diag=FALSE)
fgc = fastgreedy.community(g,merges=TRUE,modularity=TRUE,
weights=E(g)$weight) res = membership(fgc) res ## [1] 1 1 1 2 2 g = graph.adjacency(A,mode="undirected",diag=FALSE) wtc = walktrap.community(g) res = membership(wtc) print(res) ## [1] 2 2 2 1 1 print(modularity(g,res)) ## [1] 0.4128 #New functions in igraph for walktrap res = cluster_walktrap(g) print(res) ## IGRAPH clustering walktrap, groups: 2, mod: 0.41 ## + groups: ##$1
##   [1] 4 5
##
##   $2 ## [1] 1 2 3 ##  print(modularity(g,res$membership))
## [1] 0.4128

9.14 Risk Networks

#RISK NETWORKS PROGRAM CODE

library(igraph)

#FUNCTION FOR RISK INCREMENT AND DECOMP
NetRisk = function(Ri,X) {
S = sqrt(t(Ri) %*% X %*% Ri)
RiskIncr = 0.5 * (X %*% Ri + t(X) %*% Ri)/S[1,1]
RiskDecomp = RiskIncr * Ri
result = list(S,RiskIncr,RiskDecomp)
}

9.14.1 Example

#READ IN DATA
na = dim(data)[2]-1   #columns (assets)
nc = 20               #Number of controls
m = dim(data)[1]      #rows (first 1 is header, next n are assets, next 20 are controls, remaining are business lines, last line is weights)
nb = m-na-nc-2        #Number of business lines
X = data[2:(1+na),2:(na+1)]
X = matrix(as.numeric(as.matrix(X)),na,na)
controls = data[(2+na):(1+na+nc),2:(na+1)]
controls = matrix(as.numeric(as.matrix(controls)),nc,na)
Ri = matrix(colSums(controls),na,1)    #Aggregate risk by asset
bus = data[(2+na+nc):(m-1),2:(na+1)]
bus = matrix(as.numeric(as.matrix(bus)),nb,na)
bus_names = as.matrix(data[(2+na+nc):(m-1),1])
wts = data[m,2:(1+nb)]
wts = matrix(as.numeric(as.matrix(wts)),nb,1)/100   #percentage weights
#TABLE OF ASSETS: Asset number, Asset name, IP address
tab_assets = cbind(seq(1,na),names(data)[2:(na+1)],t(data[1,2:(na+1)]))
write(t(tab_assets),file="DSTMAA_data/tab_assets.txt",ncolumns=3)
#GRAPH NETWORK: plot of the assets and the links with directed arrows
Y = X; diag(Y)=0
plot.igraph(g,layout=layout.fruchterman.reingold,edge.arrow.size=0.5,vertex.size=15,vertex.label=seq(1,na))

9.14.2 Overall Risk Score

#COMPUTE OVERALL RISK SCORE
#A computation that considers the risk level of each asset (Ri)
#The function S below is homogenous of degree 1, i.e., S(m*Ri) = m*S(Ri)
S = sqrt(t(Ri) %*% X %*% Ri); print(c("Risk Score",S))
## [1] "Risk Score"       "11.6189500386223"
S
##          [,1]
## [1,] 11.61895

9.14.3 Risk Decomposition

#COMPUTE RISK DECOMPOSITION
#Exploits the homogeneity degree 1 property to compute individual asset
#risk contributions, i.e., a risk decomposition.
#Risk increment is the change in total risk score if any one asset's
#risk level increases by 1.
RiskIncr = 0.5 * (X %*% Ri + t(X) %*% Ri)/S[1,1]
RiskDecomp = RiskIncr * Ri
sorted_RiskDecomp = sort(RiskDecomp,decreasing=TRUE,index.return=TRUE)
RD = sorted_RiskDecomp$x idxRD = sorted_RiskDecomp$ix
print("Risk Contribution"); print(RiskDecomp); print(sum(RiskDecomp))
## [1] "Risk Contribution"
##            [,1]
##  [1,] 0.0000000
##  [2,] 0.0000000
##  [3,] 0.6885304
##  [4,] 0.8606630
##  [5,] 1.3770607
##  [6,] 0.6885304
##  [7,] 0.8606630
##  [8,] 1.3770607
##  [9,] 0.7745967
## [10,] 0.0000000
## [11,] 1.2049282
## [12,] 1.2049282
## [13,] 1.2049282
## [14,] 0.5163978
## [15,] 0.1721326
## [16,] 0.0000000
## [17,] 0.5163978
## [18,] 0.1721326
## [1] 11.61895
barplot(t(RD),col="dark green",xlab="Node Number",names.arg=idxRD,cex.names=0.75)

9.14.4 Centrality

#NODE EIGEN VALUE CENTRALITY
#Centrality is a measure of connectedness and influence of a node in a network
#accounting for all its linkages and influence of all other nodes. Centrality
#is based on connections only and not risk scores, and measures the propensity
#of a node to propagate a security breach if the node is compromised.
#It is a score that is normalized to the range (0,1)
cent = evcent(g)$vector print("Normalized Centrality Scores") ## [1] "Normalized Centrality Scores" print(cent) ## [1] 1.0000000 0.4567810 0.4922349 0.3627391 0.3345007 0.1982681 0.3322908 ## [8] 0.4593151 0.5590561 0.5492208 0.5492208 0.5492208 0.5492208 0.3044259 ## [15] 0.2944982 0.5231594 0.4121079 0.2944982 sorted_cent = sort(cent,decreasing=TRUE,index.return=TRUE) Scent = sorted_cent$x
idxScrit = sorted_crit$ix barplot(t(Scrit),col="orange",xlab="Node Number",names.arg=idxScrit,cex.names=0.75) 9.14.7 Cross Risk 9.14.8 Risk Scaling: Spillovers #CROSS IMPACT MATRIX #CHECK FOR SPILLOVER EFFECTS FROM ONE NODE TO ALL OTHERS d_RiskDecomp = NULL n = length(Ri) for (j in 1:n) { Ri2 = Ri Ri2[j] = Ri[j]+1 res = NetRisk(Ri2,X) d_Risk = as.matrix(res[[3]]) - RiskDecomp d_RiskDecomp = cbind(d_RiskDecomp,d_Risk) #Column by column for each asset } #3D plots library("RColorBrewer"); library("lattice"); library("latticeExtra") cloud(d_RiskDecomp, panel.3d.cloud = panel.3dbars, xbase = 0.25, ybase = 0.25, zlim = c(min(d_RiskDecomp), max(d_RiskDecomp)), scales = list(arrows = FALSE, just = "right"), xlab = "On", ylab = "From", zlab = NULL, main="Change in Risk Contribution", col.facet = level.colors(d_RiskDecomp, at = do.breaks(range(d_RiskDecomp), 20), col.regions = cm.colors, colors = TRUE), colorkey = list(col = cm.colors, at = do.breaks(range(d_RiskDecomp), 20)), #screen = list(z = 40, x = -30) ) brewer.div <- colorRampPalette(brewer.pal(11, "Spectral"), interpolate = "spline") levelplot(d_RiskDecomp, aspect = "iso", col.regions = brewer.div(20), ylab="Impact from", xlab="Impact on", main="Change in Risk Contribution") 9.14.9 Risk Scaling with Increased Connectivity #SIMULATION OF EFFECT OF INCREASED CONNECTIVITY #RANDOM GRAPHS n=50; k=100; pvec=seq(0.05,0.50,0.05); svec=NULL; sbarvec=NULL for (p in pvec) { s_temp = NULL sbar_temp = NULL for (j in 1:k) { g = erdos.renyi.game(n,p,directed=TRUE); A = get.adjacency(g) diag(A) = 1 c = as.matrix(round(runif(n,0,2),0)) syscore = as.numeric(sqrt(t(c) %*% A %*% c)) sbarscore = syscore/n s_temp = c(s_temp,syscore) sbar_temp = c(sbar_temp,sbarscore) } svec = c(svec,mean(s_temp)) sbarvec = c(sbarvec,mean(sbar_temp)) } #plot(pvec,svec,type="l",xlab="Prob of connecting to a node",ylab="S",lwd=3,col="red") plot(pvec,sbarvec,type="l",xlab="Prob of connecting to a node",ylab="S_Avg",lwd=3,col="red") 9.14.10 Too Big To Fail The change in risk score $${S}$$ as the number of nodes increases, while keeping the average number of connections between nodes constant. This mimics the case where banks are divided into smaller banks, each of which then contains part of the transacting volume of the previous bank. The plot shows how the risk score increases as the number of nodes increases from 10 to 100, while expected number of total edges in the network remains the same. A compromise vector is also generated with equally likely values $$\{0,1,2\}$$. This is repeated 5000 times for each fixed number of nodes and the mean risk score across 5000 simulations. #SIMULATION OF EFFECT OF INCREASED NODES AND REDUCED CONNECTIVITY nvec=seq(10,100,10); k=100; svec=NULL; sbarvec=NULL for (n in nvec) { s_temp = NULL sbar_temp = NULL p = 5/n for (j in 1:k) { g = erdos.renyi.game(n,p,directed=TRUE); A = get.adjacency(g) diag(A) = 1 c = as.matrix(round(runif(n,0,2),0)) syscore = as.numeric(sqrt(t(c) %*% A %*% c)) sbarscore = syscore/n s_temp = c(s_temp,syscore) sbar_temp = c(sbar_temp,sbarscore) } svec = c(svec,mean(s_temp)) sbarvec = c(sbarvec,mean(sbar_temp)) } plot(nvec,svec,type="l",xlab="Number of nodes",ylab="S",ylim=c(0,max(svec)),lwd=3,col="red") #plot(nvec,sbarvec,type="l",xlab="Number of nodes",ylab="S_Avg",ylim=c(0,max(sbarvec)),lwd=3,col="red") 9.15 Systemic Risk in Indian Banks 9.17 Shiny application The example above may also be embedded in a shiny application for which the code is provided below. The screen will appear as follows. The files below also require the data file systemicR.csv or an upload. #SERVER.R library(shiny) library(plotly) library(igraph) # Define server logic for random distribution application shinyServer(function(input, output) { fData = reactive({ # input$file1 will be NULL initially. After the user selects and uploads a
# file, it will be a data frame with 'name', 'size', 'type', and 'datapath'
# columns. The 'datapath' column will contain the local filenames where the
# data can be found.

inFile <- input$file if (is.null(inFile)){ data = read.csv(file="systemicR.csv",sep=",") } else read.csv(file=inFile$datapath)
})

observeEvent(input$compute, { output$text1 <- renderText({
data = fData()
na = dim(data)[1]   #columns (assets)
Ri = matrix(data[,1],na,1)    #Aggregate risk by asset
X = data[1:na,2:(na+1)]
X = matrix(as.numeric(as.matrix(X)),na,na)
S = as.numeric(sqrt(t(Ri) %*% X %*% Ri))
paste("Overall Risk Score",round(S,2))
})

output$plot <- renderPlot({ data = fData() na = dim(data)[1] #columns (assets) bnames = names(data) Ri = matrix(data[,1],na,1) #Aggregate risk by asset X = data[1:na,2:(na+1)] X = matrix(as.numeric(as.matrix(X)),na,na) #GRAPH NETWORK: plot of the assets and the links with directed arrows Y = X; diag(Y)=0 g = graph.adjacency(Y) V(g)$color = "#ffec78"
V(g)$color[degree(g)==max(degree(g))] = "#ff4040" V(g)$color[degree(g)==min(degree(g))] = "#b4eeb4"
V(g)$size = Ri*8+10 plot.igraph(g,layout=layout.fruchterman.reingold,edge.arrow.size=0.5, vertex.label.color="black",edge.arrow.width=0.8, vertex.label=bnames[1:na+1], vertex.label.cex=0.8) }, height = 550, width = 800) output$text2 <- renderText({
data = fData()
na = dim(data)[1]   #columns (assets)
Ri = matrix(data[,1],na,1)    #Aggregate risk by asset
X = data[1:na,2:(na+1)]
X = matrix(as.numeric(as.matrix(X)),na,na)
Y = X; diag(Y)=0
H = ((sum(degree(g)^2))/na)/((sum(degree(g)))/na)
paste("Fragility of the Network is ",round(H,2))
})

output$plot2 <- renderPlotly({ data = fData() na = dim(data)[1] #columns (assets) Ri = matrix(data[,1],na,1) #Aggregate risk by asset X = data[1:na,2:(na+1)] X = matrix(as.numeric(as.matrix(X)),na,na) S = as.numeric(sqrt(t(Ri) %*% X %*% Ri)) RiskIncr = 0.5 * as.numeric((X %*% Ri + t(X) %*% Ri))/S RiskDecomp = RiskIncr * Ri sorted_RiskDecomp = sort(RiskDecomp,decreasing=TRUE,index.return=TRUE) RD = as.numeric(as.matrix(sorted_RiskDecomp$x))
idxRD = as.character(as.matrix(sorted_RiskDecomp$ix)) idxRD = paste("B",idxRD,sep="") xAx <- list( title = "Node Number" ) yAx <- list( title = "Risk Decomposition") plot_ly(y = RD,x = idxRD,marker = list(color = toRGB("dark green")),type="bar")%>% layout(xaxis = xAx, yaxis = yAx) # barplot(t(RD),col="dark green",xlab="Node Number",names.arg=idxRD,cex.names=0.75) }) output$plot3 <- renderPlotly({
data = fData()
na = dim(data)[1]   #columns (assets)
Ri = matrix(data[,1],na,1)    #Aggregate risk by asset
X = data[1:na,2:(na+1)]
X = matrix(as.numeric(as.matrix(X)),na,na)

#GRAPH NETWORK: plot of the assets and the links with directed arrows
Y = X; diag(Y)=0
cent = evcent(g)$vector # print("Normalized Centrality Scores") sorted_cent = sort(cent,decreasing=TRUE,index.return=TRUE) Scent = sorted_cent$x
idxScent = sorted_cent$ix idxScent = paste("B",idxScent,sep="") xAx <- list( title = "Node Number" ) yAx <- list( title = "Eigen Value Centrality" ) plot_ly(y = as.numeric(t(Scent)),x = idxScent,marker = list(color = toRGB("red")),type="bar")%>% layout(xaxis = xAx, yaxis = yAx) # barplot(t(Scent),col="dark red",xlab="Node Number",names.arg=idxScent,cex.names=0.75) }) output$plot4 <- renderPlotly({
data = fData()
na = dim(data)[1]   #columns (assets)
Ri = matrix(data[,1],na,1)    #Aggregate risk by asset
X = data[1:na,2:(na+1)]
X = matrix(as.numeric(as.matrix(X)),na,na)

S = as.numeric(sqrt(t(Ri) %*% X %*% Ri))
RiskIncr = 0.5 * as.numeric((X %*% Ri + t(X) %*% Ri))/S

#COMPUTE RISK INCREMENTS
sorted_RiskIncr = sort(RiskIncr,decreasing=TRUE,index.return=TRUE)
RI = sorted_RiskIncr$x idxRI = sorted_RiskIncr$ix
idxRI = paste("B",idxRI,sep="")

xAx <- list(
title = "Node Number"
)
yAx <- list(
title = "Risk Increments"
)
plot_ly(y = as.numeric(t(RI)),x = idxRI,marker = list(color = toRGB("green")),type="bar")%>%
layout(xaxis = xAx, yaxis = yAx)

#        barplot(t(RI),col="dark blue",xlab="Node Number",names.arg=idxRI,cex.names=0.75)

})

#CRITICALITY
#Criticality is compromise-weighted centrality.
#This is an element-wise multiplication of vectors $C$ and $x$.

output$plot5 <- renderPlotly({ data = fData() na = dim(data)[1] #columns (assets) Ri = matrix(data[,1],na,1) #Aggregate risk by asset X = data[1:na,2:(na+1)] X = matrix(as.numeric(as.matrix(X)),na,na) #GRAPH NETWORK: plot of the assets and the links with directed arrows Y = X; diag(Y)=0 g = graph.adjacency(Y) cent = evcent(g)$vector

crit = Ri * cent
print("Criticality Vector")
print(crit)
sorted_crit = sort(crit,decreasing=TRUE,index.return=TRUE)
Scrit = sorted_crit$x idxScrit = sorted_crit$ix
idxScrit = paste("B",idxScrit,sep="")

xAx <- list(
title = "Node Number"
)
yAx <- list(
title = "Criticality Vector"
)
plot_ly(y = as.numeric(t(sorted_crit\$x)),x = idxScrit,marker = list(color = toRGB("orange")),type="bar")%>%
layout(xaxis = xAx, yaxis = yAx)

#          barplot(t(Scrit),col="orange",xlab="Node Number",names.arg=idxScrit,cex.names=0.75)
})

})

})
#UI.R

library(plotly)
shinyUI(fluidPage(

titlePanel("Systemic Risk Scoring"),

sidebarLayout(

sidebarPanel(
# Inputs excluded for brevity
p('Upload a .csv file having header as Credit Scores and names of n banks. Dimensions of file will be
fileInput("file", label = h3("File input")),
actionButton("compute","Compute Scores"),
hr(),
textOutput("text1"),
textOutput("text2"),
hr(),
p('Please refer following Paper published for further details',
a("Matrix Metrics: Network-Based Systemic Risk Scoring.",
href = "http://srdas.github.io/Papers/JAI_Das_issue.pdf"))
),

mainPanel(
tabsetPanel(
tabPanel("Network Graph", plotOutput("plot",width="100%")),
tabPanel("Risk Decomposition", plotlyOutput("plot2")),
tabPanel("Node Centrality", plotlyOutput("plot3")),
tabPanel("Risk Increments", plotlyOutput("plot4")),
tabPanel("Criticality", plotlyOutput("plot5"))

)
)
)
))