Spreadsheet: 217096d1361983951-help-with-changing-column-references-in-sumproduct-cov
Sheet: Portfolio maandelijks MAD

 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 |  | Varianties
A
AAPL
ABT
CMG
CMI
CMS
CNP
CNX
COF
COG
COH
COL
COP
COST
CPB
CRM
CSC
CSCO
CSX
CTAS
CTL
CTSH
CTXS
CVC
CVH
CVS
CVX
D
DD
DE
DELL
DF
DGX
DHI
DHR
DIS
DISCA
DLTR
DNB
DNR
DO
DOV
DOW
DRI
DTE
DTV
[NAME]
DVA
DVN
EA
EBAY
ECL
ED
EFX
EIX
EL
EMC
EMN
EMR
EOG
EQR
EQT
ESRX
ESV
ETFC
ETN
ETR
EW
EXC
EXPD
EXPE
F
FAST
FCX
FDO
FDX
FE
FFIV
FHN
FII
FIS
FISV
FITB
FLIR
FLR
FLS
FMC
FOSL
FRX
FSLR
FTI
FTR
GAS
GCI
[NAME]
GE
GILD
GIS
GLW
GME
GNW
GOOG
GPC
GPS
GS
GT
GWW
HAL
HAR
HAS
HBAN
HCBK
HCN
HCP
HD
HES
HIG
HNZ
HOG
HON
HOT
HP
HPQ
HRB
HRL
HRS
HSP
HST
HSY
HUM
IBM
ICE
IFF
IGT
INTC
INTU
IP
IPG
IR
IRM
ISRG
ITW
IVZ
JBL
JCI
JCP
JDSU
JEC
JNJ
JNPR
JOY
JPM
JWN
K
KEY
[NAME]
KLAC
KMB
KMX
KO
KR
KSS
L
LEG
LEN
LH
LIFE
LLL
LLTC
LLY
LM
LMT
LNC
LOW
LRCX
LSI
LTD
LUK
LUV
M
MA
MAR
MAS
MAT
MCD
MCHP
MCK
MCO
MDLZ
MDT
MET
MHP
MKC
MMC
MMM
AA
ABC
ACE
ACN
ADBE
ADI
ADM
ADP
ADSK
AEE
AEP
AES
AET
AFL
AGN
AIG
AIV
AIZ
AKAM
ALL
ALTR
ALXN
AMAT
AMD
AMGN
AMP
AMT
AMZN
AN
ANF
AON
APA
APC
APD
APH
APOL
ARG
ATI
AVB
AVP
AVY
AXP
AZO
BA
BAC
BAX
BBBY
BBT
BBY
BCR
BDX
BEAM
[NAME]
BF-B
BHI
BIG
BIIB
BK
BLK
BLL
BMC
BMS
BMY
BRCM
BRK-B
BSX
BTU
BXP
C
CA
CAG
CAH
CAM
CAT
CB
CBE
CBG
CBS
CCE
CCI
CCL
CELG
CERN
CF
CHK
CHRW
CI
CINF
CL
CLF
CLX
CMA
CMCSA
CME
E
MNST
MO
MOLX
MON
MOS
MRK
MRO
MS
MSFT
MSI
MTB
MU
MUR
MWV
MYL
NBL
NBR
NDAQ
NE
NEE
NEM
NFLX
NFX
NI
NKE
NOC
NOV
NRG
NSC
NTAP
NTRS
NU
NUE
NVDA
NWL
NWSA
NYX
OI
OKE
OMC
ORCL
ORLY
OXY
PAYX
PBCT
PBI
PCAR
PCG
PCL
PCLN
PCP
PDCO
PEP
PETM
PFE
PFG
PG
PGR
PH
PHM
PKI
PLD
PLL
PNC
PNR
PNW
POM
PPG
PPL
PRGO
PRU
PSA
PWR
PX
PXD
QCOM
R
RAI
RDC
RF
RHI
RHT
RL
ROK
ROP
ROST
RRC
RRD
RSG
RTN
S
SAI
SBUX
SCG
SCHW
SE
SEE
SHW
SIAL
SJM
SLB
[NAME]
SNA
SNDK
SO
SPG
SPLS
SRCL
SRE
STI
STJ
STT
STX
STZ
SWK
SWN
SWY
SYK
SYMC
SYY
T
TAP
TE
TEG
TER
TGT
THC
TIE
TIF
TJX
TMK
TMO
TROW
TRV
TSN
TSO
TSS
TWX
TXN
TXT
TYC
UNH
UNM
UNP
UPS
URBN
USB
UTX
VAR
VFC
VIAB
VLO
VMC
VRSN
VTR
VZ
WAG
WAT
WDC
WEC
WFC
WFM
WHR
WIN
WLP
WM
WMB
WMT
WPI
WPO
WU
WY
WYN
WYNN
X
XEL
XL
XLNX
XOM
XRAY
[NAME]
YHOO
YUM
ZION
ZMH
Riskfree