MarketQuote function

Actuarial Excel Addin

See the tutorial on Youtube Download the 'Cheat Sheet' (pdf)

The MarketQuote function returns the month-end financial markets indices at month-end (exchange rates, Canadian T-Bills and bonds and stocks). Any date in a given month will return the same value.

* : Required parameter

Parameters
Default
Description
Date *
--
.....
Code
1
See table below

Code
Description
From
1
$CAN / $US (source: Bank of Canada)
1969-Dec
2
$CAN / Euro (source: Bank of Canada)
1991-Jan
3
$CAN / $US (source: MSCI)
1969-Dec
4
$US / $CAN (source: MSCI)
1969-Dec
5
S&P/TSX
1919-Jan
6
S&P/TSX total return
1956-Jan
7
S&P 500
1989-Sep
8
S&P 500 total return
1989-Sep
9
Short bonds (FTSE Russel)
1979-Dec
10
Mid bonds (FTSE Russel)
1979-Dec
11
Long bonds (FTSE Russel)
1979-Dec
12
Universe bonds (FTSE Russel)
1979-Dec
13
Real return bonds (FTSE Russel)
1991-Dec
14
91-day Tbills (FTSE Russel)
1979-Dec
15
World ($US, MSCI)
1969-Dec
16
World ex. USA ($US, MSCI)
1969-Dec
17
EAFE ($US, MSCI)
1969-Dec
18
Europe ($US, MSCI)
1969-Dec
19
Pacific ($US, MSCI)
1969-Dec
20
Emerging markets ($US, MSCI)
2000-Dec
21
Canada ($CAN, MSCI)
1969-Dec
22
Canada ($US, MSCI)
1969-Dec
23
USA ($US, MSCI)
1969-Dec
24
BRIC ($US, MSCI)
2012-Jan
25
World ex. Canada ($US, MSCI)
2012-Oct
26
World Small Cap ($US, MSCI)
2013-May
27
World (local currency, MSCI)
2015-May
28
30-day Tbills (FTSE Russel)
2018-Dec
29
60-day Tbills (FTSE Russel)
2018-Dec
30
182-day TB (FTSE Russel)
2018-Dec
31
365-day TB (FTSE Russel)
2018-Dec