0% found this document useful (0 votes)
23 views46 pages

IF Functions

The document outlines various investment, grading, purchasing, and sales performance scenarios, providing formulas for decision-making based on specific criteria. It includes stock investment decisions based on past returns, student grading based on scores, purchasing costs based on order quantities, and sales bonuses based on performance against targets. Additionally, it discusses revenue tracking and trading strategies using moving averages.

Uploaded by

mapinduziumojat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
23 views46 pages

IF Functions

The document outlines various investment, grading, purchasing, and sales performance scenarios, providing formulas for decision-making based on specific criteria. It includes stock investment decisions based on past returns, student grading based on scores, purchasing costs based on order quantities, and sales bonuses based on performance against targets. Additionally, it discusses revenue tracking and trading strategies using moving averages.

Uploaded by

mapinduziumojat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

A fund manager invests in stocks with returns of 15% or more in the previous year.

Create a formula that determines if they shall in


Stock Return Inv or Not
CRDB 12% NO
NMB 18% INVEST
TWIGA 14.99% NO
TOL 20% INVEST
TATEPA 17% INVEST
DSE 16% INVEST
SWALA 10% NO
DCB -3% NO

If a student scores 0%-20% they are graded F, above 20%-40% they are graded D, Above 40%-60%, they are graded C, Above 60%-80
Score Grade
20.1 D
49 C
91 A
43 C

If I order up to 500 units of a product, I pay TZS 2500 per unit. If I order from 501 through 1,200 units, I pay TZS 2200 per unit. If I ord
order more than 2,000 units, I pay TZS 1800 per unit. How can I write a formula that expresses the purchase cost as a function of the
Cutoff Point Price
500 2500
1200 2200
2000 2000
>2000 1800
Order Quantity Total Cost Price per Unit
2001 1800
hat determines if they shall invest in a stock or not given their returns.

y are graded C, Above 60%-80%, they are graded B and above 80%, they are graded A.

pay TZS 2200 per unit. If I order from 1,201 through 2,000 units, I pay TZS 2000 per unit. If I
chase cost as a function of the number of units purchased?
A salesman will get bonus only if they perform above targets in both, sales and retantion. How do you determine if a salesman shal
Retantion Budget 85%
Sales Budget (TZS Mln) 300

Salesman Sales (TZS Mln) Retention Rate Bonus/No Bonus


Salesman A 274 73% NO BONUS
Salesman B 550 70% NO BONUS
Salesman C 450 87% BONUS
Salesman D 153 71% NO BONUS
Salesman E 353 90% BONUS
Salesman F 182 75% NO BONUS
Salesman G 589 72% NO BONUS
Salesman H 310 89% BONUS
Salesman I 163 81% NO BONUS
Salesman J 243 70% NO BONUS
Salesman K 588 67% NO BONUS
Salesman L 320 88% BONUS

In the scenario above, assume a salesman will get bonus if they surpass any of the budgets (Retention or Sales). Create a formula to determi
Salesman Sales (TZS Mln) Retention Rate Bonus/No Bonus
Salesman A 274 73% NO BONUS
Salesman B 550 70% BONUS
Salesman C 450 87% BONUS
Salesman D 153 71% NO BONUS
Salesman E 353 90% BONUS
Salesman F 182 75% NO BONUS
Salesman G 589 72% BONUS
Salesman H 310 89% BONUS
Salesman I 163 81% NO BONUS
Salesman J 243 70% NO BONUS
Salesman K 588 67% BONUS
Salesman L 320 88% BONUS
etermine if a salesman shall get bonus given their performances against budgets?

. Create a formula to determine if a salesman shall be awarded or not.


TOL Revenue
Revenu Annual
e (TZS revenue
Year Quarter Mln) s
2004 1 185
2004 2 127
2004 3 65
2004 4 52 429
2005 1 200
2005 2 191
2005 3 66
2005 4 72 529
2006 1 74
2006 2 155
2006 3 106
2006 4 75 410
2007 1 63
2007 2 205
2007 3 54
2007 4 94 416
2008 1 121
2008 2 58
2008 3 101
2008 4 67 347
2009 1 78
2009 2 177
2009 3 127
2009 4 62 444
2010 1 193
2010 2 140
2010 3 134
2010 4 127 594
2011 1 116
2011 2 124
2011 3 64
2011 4 132 436
2012 1 124
2012 2 162
2012 3 53
2012 4 86 425
2013 1 106
2013 2 104
2013 3 143
2013 4 85 438
2014 1 56
2014 2 138
2014 3 150
2014 4 195 539
2015 1 79
2015 2 137
2015 3 194
2015 4 196 606
2016 1 141
2016 2 134
2016 3 174
2016 4 202 651
2017 1 187
A market Analyst belives that, using moving average strategy can beat buy and hold strategy. A commonly suggested moving-average trading
stock’s price moves above the average of the previous 15 months
and to sell a stock when the stock’s price moves below the average of the previous 15 months’ price. How would this trading rule perform aga

MA profit

Buy and
hold
Comp. profit
Date P MA Own? Buy? Sell? Cash flow Moving Average Profit
1871.01 4.44 Buy and Hold Profit
1871.02 4.5
1871.03 4.61
1871.04 4.74
1871.05 4.86
1871.06 4.82
1871.07 4.73
1871.08 4.79
1871.09 4.84
1871.10 4.59
1871.11 4.64
1871.12 4.74
1872.01 4.86
1872.02 4.88
1872.03 5.04
1872.04 5.18
1872.05 5.18
1872.06 5.13
1872.07 5.1
1872.08 5.04
1872.09 4.95
1872.10 4.97
1872.11 4.95
1872.12 5.07
1873.01 5.11
1873.02 5.15
1873.03 5.11
1873.04 5.04
1873.05 5.05
1873.06 4.98
1873.07 4.97
1873.08 4.97
1873.09 4.59
1873.10 4.19
1873.11 4.04
1873.12 4.42
1874.01 4.66
1874.02 4.8
1874.03 4.73
1874.04 4.6
1874.05 4.48
1874.06 4.46
1874.07 4.46
1874.08 4.47
1874.09 4.54
1874.10 4.53
1874.11 4.57
1874.12 4.54
1875.01 4.54
1875.02 4.53
1875.03 4.59
1875.04 4.65
1875.05 4.47
1875.06 4.38
1875.07 4.39
1875.08 4.41
1875.09 4.37
1875.10 4.3
1875.11 4.37
1875.12 4.37
1876.01 4.46
1876.02 4.52
1876.03 4.51
1876.04 4.34
1876.05 4.18
1876.06 4.15
1876.07 4.1
1876.08 3.93
1876.09 3.69
1876.10 3.67
1876.11 3.6
1876.12 3.58
1877.01 3.55
1877.02 3.34
1877.03 3.17
1877.04 2.94
1877.05 2.94
1877.06 2.73
1877.07 2.85
1877.08 3.05
1877.09 3.24
1877.10 3.31
1877.11 3.26
1877.12 3.25
1878.01 3.25
1878.02 3.18
1878.03 3.24
1878.04 3.33
1878.05 3.34
1878.06 3.41
1878.07 3.48
1878.08 3.45
1878.09 3.52
1878.10 3.48
1878.11 3.47
1878.12 3.45
1879.01 3.58
1879.02 3.71
1879.03 3.65
1879.04 3.77
1879.05 3.94
1879.06 3.96
1879.07 4.04
1879.08 4.07
1879.09 4.22
1879.10 4.68
1879.11 4.93
1879.12 4.92
1880.01 5.11
1880.02 5.2
1880.03 5.3
1880.04 5.18
1880.05 4.77
1880.06 4.79
1880.07 5.01
1880.08 5.19
1880.09 5.18
1880.10 5.33
1880.11 5.61
1880.12 5.84
1881.01 6.19
1881.02 6.17
1881.03 6.24
1881.04 6.22
1881.05 6.5
1881.06 6.58
1881.07 6.35
1881.08 6.2
1881.09 6.25
1881.10 6.15
1881.11 6.19
1881.12 6.01
1882.01 5.92
1882.02 5.79
1882.03 5.78
1882.04 5.78
1882.05 5.71
1882.06 5.68
1882.07 6
1882.08 6.18
1882.09 6.24
1882.10 6.07
1882.11 5.81
1882.12 5.84
1883.01 5.81
1883.02 5.68
1883.03 5.75
1883.04 5.87
1883.05 5.77
1883.06 5.82
1883.07 5.73
1883.08 5.47
1883.09 5.53
1883.10 5.38
1883.11 5.46
1883.12 5.34
1884.01 5.18
1884.02 5.32
1884.03 5.3
1884.04 5.06
1884.05 4.65
1884.06 4.46
1884.07 4.46
1884.08 4.74
1884.09 4.59
1884.10 4.44
1884.11 4.35
1884.12 4.34
1885.01 4.24
1885.02 4.37
1885.03 4.38
1885.04 4.37
1885.05 4.32
1885.06 4.3
1885.07 4.46
1885.08 4.71
1885.09 4.65
1885.10 4.92
1885.11 5.24
1885.12 5.2
1886.01 5.2
1886.02 5.3
1886.03 5.19
1886.04 5.12
1886.05 5.02
1886.06 5.25
1886.07 5.33
1886.08 5.37
1886.09 5.51
1886.10 5.65
1886.11 5.79
1886.12 5.64
1887.01 5.58
1887.02 5.54
1887.03 5.67
1887.04 5.8
1887.05 5.9
1887.06 5.73
1887.07 5.59
1887.08 5.45
1887.09 5.38
1887.10 5.2
1887.11 5.3
1887.12 5.27
1888.01 5.31
1888.02 5.28
1888.03 5.08
1888.04 5.1
1888.05 5.17
1888.06 5.01
1888.07 5.14
1888.08 5.25
1888.09 5.38
1888.10 5.35
1888.11 5.24
1888.12 5.14
1889.01 5.24
1889.02 5.3
1889.03 5.19
1889.04 5.18
1889.05 5.32
1889.06 5.41
1889.07 5.3
1889.08 5.37
1889.09 5.5
1889.10 5.4
1889.11 5.35
1889.12 5.32
1890.01 5.38
1890.02 5.32
1890.03 5.28
1890.04 5.39
1890.05 5.62
1890.06 5.58
1890.07 5.54
1890.08 5.41
1890.09 5.32
1890.10 5.08
1890.11 4.71
1890.12 4.6
1891.01 4.84
1891.02 4.9
1891.03 4.81
1891.04 4.97
1891.05 4.95
1891.06 4.85
1891.07 4.77
1891.08 4.93
1891.09 5.33
1891.10 5.33
1891.11 5.25
1891.12 5.41
1892.01 5.51
1892.02 5.52
1892.03 5.58
1892.04 5.57
1892.05 5.57
1892.06 5.54
1892.07 5.54
1892.08 5.62
1892.09 5.48
1892.10 5.59
1892.11 5.57
1892.12 5.51
1893.01 5.61
1893.02 5.51
1893.03 5.31
1893.04 5.31
1893.05 4.84
1893.06 4.61
1893.07 4.18
1893.08 4.08
1893.09 4.37
1893.10 4.5
1893.11 4.57
1893.12 4.41
1894.01 4.32
1894.02 4.38
1894.03 4.51
1894.04 4.57
1894.05 4.4
1894.06 4.34
1894.07 4.25
1894.08 4.41
1894.09 4.48
1894.10 4.34
1894.11 4.34
1894.12 4.3
1895.01 4.25
1895.02 4.19
1895.03 4.19
1895.04 4.37
1895.05 4.61
1895.06 4.7
1895.07 4.72
1895.08 4.79
1895.09 4.82
1895.10 4.75
1895.11 4.59
1895.12 4.32
1896.01 4.27
1896.02 4.45
1896.03 4.38
1896.04 4.42
1896.05 4.4
1896.06 4.32
1896.07 4.04
1896.08 3.81
1896.09 4.01
1896.10 4.1
1896.11 4.38
1896.12 4.22
1897.01 4.22
1897.02 4.18
1897.03 4.19
1897.04 4.06
1897.05 4.08
1897.06 4.27
1897.07 4.46
1897.08 4.75
1897.09 4.98
1897.10 4.82
1897.11 4.65
1897.12 4.75
1898.01 4.88
1898.02 4.87
1898.03 4.65
1898.04 4.57
1898.05 4.87
1898.06 5.06
1898.07 5.08
1898.08 5.27
1898.09 5.26
1898.10 5.15
1898.11 5.32
1898.12 5.65
1899.01 6.08
1899.02 6.31
1899.03 6.4
1899.04 6.48
1899.05 6.21
1899.06 6.07
1899.07 6.28
1899.08 6.44
1899.09 6.37
1899.10 6.34
1899.11 6.46
1899.12 6.02
1900.01 6.1
1900.02 6.21
1900.03 6.26
1900.04 6.34
1900.05 6.04
1900.06 5.86
1900.07 5.86
1900.08 5.94
1900.09 5.8
1900.10 6.01
1900.11 6.48
1900.12 6.87
1901.01 7.07
1901.02 7.25
1901.03 7.51
1901.04 8.14
1901.05 7.73
1901.06 8.5
1901.07 7.93
1901.08 8.04
1901.09 8
1901.10 7.91
1901.11 8.08
1901.12 7.95
1902.01 8.12
1902.02 8.19
1902.03 8.2
1902.04 8.48
1902.05 8.46
1902.06 8.41
1902.07 8.6
1902.08 8.83
1902.09 8.85
1902.10 8.57
1902.11 8.24
1902.12 8.05
1903.01 8.46
1903.02 8.41
1903.03 8.08
1903.04 7.75
1903.05 7.6
1903.06 7.18
1903.07 6.85
1903.08 6.63
1903.09 6.47
1903.10 6.26
1903.11 6.28
1903.12 6.57
1904.01 6.68
1904.02 6.5
1904.03 6.48
1904.04 6.64
1904.05 6.5
1904.06 6.51
1904.07 6.78
1904.08 7.01
1904.09 7.32
1904.10 7.75
1904.11 8.17
1904.12 8.25
1905.01 8.43
1905.02 8.8
1905.03 9.05
1905.04 8.94
1905.05 8.5
1905.06 8.6
1905.07 8.87
1905.08 9.2
1905.09 9.23
1905.10 9.36
1905.11 9.31
1905.12 9.54
1906.01 9.87
1906.02 9.8
1906.03 9.56
1906.04 9.43
1906.05 9.18
1906.06 9.3
1906.07 9.06
1906.08 9.73
1906.09 10.03
1906.10 9.73
1906.11 9.93
1906.12 9.84
1907.01 9.56
1907.02 9.26
1907.03 8.35
1907.04 8.39
1907.05 8.1
1907.06 7.84
1907.07 8.14
1907.08 7.53
1907.09 7.45
1907.10 6.64
1907.11 6.25
1907.12 6.57
1908.01 6.85
1908.02 6.6
1908.03 6.87
1908.04 7.24
1908.05 7.63
1908.06 7.64
1908.07 7.92
1908.08 8.26
1908.09 8.17
1908.10 8.27
1908.11 8.83
1908.12 9.03
1909.01 9.06
1909.02 8.8
1909.03 8.92
1909.04 9.32
1909.05 9.63
1909.06 9.8
1909.07 9.94
1909.08 10.18
1909.09 10.19
1909.10 10.23
1909.11 10.18
1909.12 10.3
1910.01 10.08
1910.02 9.72
1910.03 9.96
1910.04 9.72
1910.05 9.56
1910.06 9.1
1910.07 8.64
1910.08 8.85
1910.09 8.91
1910.10 9.32
1910.11 9.31
1910.12 9.05
1911.01 9.27
1911.02 9.43
1911.03 9.32
1911.04 9.28
1911.05 9.48
1911.06 9.67
1911.07 9.63
1911.08 9.17
1911.09 8.67
1911.10 8.72
1911.11 9.07
1911.12 9.11
1912.01 9.12
1912.02 9.04
1912.03 9.3
1912.04 9.59
1912.05 9.58
1912.06 9.58
1912.07 9.59
1912.08 9.81
1912.09 9.86
1912.10 9.84
1912.11 9.73
1912.12 9.38
1913.01 9.3
1913.02 8.97
1913.03 8.8
1913.04 8.79
1913.05 8.55
1913.06 8.12
1913.07 8.23
1913.08 8.45
1913.09 8.53
1913.10 8.26
1913.11 8.05
1913.12 8.04
1914.01 8.37
1914.02 8.48
1914.03 8.32
1914.04 8.12
1914.05 8.17
1914.06 8.13
1914.07 7.68
1914.08 7.68
1914.09 7.68
1914.10 7.68
1914.11 7.68
1914.12 7.35
1915.01 7.48
1915.02 7.38
1915.03 7.57
1915.04 8.14
1915.05 7.95
1915.06 8.04
1915.07 8.01
1915.08 8.35
1915.09 8.66
1915.10 9.14
1915.11 9.46
1915.12 9.48
1916.01 9.33
1916.02 9.2
1916.03 9.17
1916.04 9.07
1916.05 9.27
1916.06 9.36
1916.07 9.23
1916.08 9.3
1916.09 9.68
1916.10 9.98
1916.11 10.21
1916.12 9.8
1917.01 9.57
1917.02 9.03
1917.03 9.31
1917.04 9.17
1917.05 8.86
1917.06 9.04
1917.07 8.79
1917.08 8.53
1917.09 8.12
1917.10 7.68
1917.11 7.04
1917.12 6.8
1918.01 7.21
1918.02 7.43
1918.03 7.28
1918.04 7.21
1918.05 7.44
1918.06 7.45
1918.07 7.51
1918.08 7.58
1918.09 7.54
1918.10 7.86
1918.11 8.06
1918.12 7.9
1919.01 7.85
1919.02 7.88
1919.03 8.12
1919.04 8.39
1919.05 8.97
1919.06 9.21
1919.07 9.51
1919.08 8.87
1919.09 9.01
1919.10 9.47
1919.11 9.19
1919.12 8.92
1920.01 8.83
1920.02 8.1
1920.03 8.67
1920.04 8.6
1920.05 8.06
1920.06 7.92
1920.07 7.91
1920.08 7.6
1920.09 7.87
1920.10 7.88
1920.11 7.48
1920.12 6.81
1921.01 7.11
1921.02 7.06
1921.03 6.88
1921.04 6.91
1921.05 7.12
1921.06 6.55
1921.07 6.53
1921.08 6.45
1921.09 6.61
1921.10 6.7
1921.11 7.06
1921.12 7.31
1922.01 7.3
1922.02 7.46
1922.03 7.74
1922.04 8.21
1922.05 8.53
1922.06 8.45
1922.07 8.51
1922.08 8.83
1922.09 9.06
1922.10 9.26
1922.11 8.8
1922.12 8.78
1923.01 8.9
1923.02 9.28
1923.03 9.43
1923.04 9.1
1923.05 8.67
1923.06 8.34
1923.07 8.06
1923.08 8.1
1923.09 8.15
1923.10 8.03
1923.11 8.27
1923.12 8.55
1924.01 8.83
1924.02 8.87
1924.03 8.7
1924.04 8.5
1924.05 8.47
1924.06 8.63
1924.07 9.03
1924.08 9.34
1924.09 9.25
1924.10 9.13
1924.11 9.64
1924.12 10.16
1925.01 10.58
1925.02 10.67
1925.03 10.39
1925.04 10.28
1925.05 10.61
1925.06 10.8
1925.07 11.1
1925.08 11.25
1925.09 11.51
1925.10 11.89
1925.11 12.26
1925.12 12.46
1926.01 12.65
1926.02 12.67
1926.03 11.81
1926.04 11.48
1926.05 11.56
1926.06 12.11
1926.07 12.62
1926.08 13.12
1926.09 13.32
1926.10 13.02
1926.11 13.19
1926.12 13.49
1927.01 13.4
1927.02 13.66
1927.03 13.87
1927.04 14.21
1927.05 14.7
1927.06 14.89
1927.07 15.22
1927.08 16.03
1927.09 16.94
1927.10 16.68
1927.11 17.06
1927.12 17.46
1928.01 17.53
1928.02 17.32
1928.03 18.25
1928.04 19.4
1928.05 20
1928.06 19.02
1928.07 19.16
1928.08 19.78
1928.09 21.17
1928.10 21.6
1928.11 23.06
1928.12 23.15
1929.01 24.86
1929.02 24.99
1929.03 25.43
1929.04 25.28
1929.05 25.66
1929.06 26.15
1929.07 28.48
1929.08 30.1
1929.09 31.3
1929.10 27.99
1929.11 20.58
1929.12 21.4
1930.01 21.71
1930.02 23.07
1930.03 23.94
1930.04 25.46
1930.05 23.94
1930.06 21.52
1930.07 21.06
1930.08 20.79
1930.09 20.78
1930.10 17.92
1930.11 16.62
1930.12 15.51
1931.01 15.98
1931.02 17.2
1931.03 17.53
1931.04 15.86
1931.05 14.33
1931.06 13.87
1931.07 14.33
1931.08 13.9
1931.09 11.83
1931.10 10.25
1931.11 10.39
1931.12 8.44
1932.01 8.3
1932.02 8.23
1932.03 8.26
1932.04 6.28
1932.05 5.51
1932.06 4.77
1932.07 5.01
1932.08 7.53
1932.09 8.26
1932.10 7.12
1932.11 7.05
1932.12 6.82
1933.01 7.09
1933.02 6.25
1933.03 6.23
1933.04 6.89
1933.05 8.87
1933.06 10.39
1933.07 11.23
1933.08 10.67
1933.09 10.58
1933.10 9.55
1933.11 9.78
1933.12 9.97
1934.01 10.54
1934.02 11.32
1934.03 10.74
1934.04 10.92
1934.05 9.81
1934.06 9.94
1934.07 9.47
1934.08 9.1
1934.09 8.88
1934.10 8.95
1934.11 9.2
1934.12 9.26
1935.01 9.26
1935.02 8.98
1935.03 8.41
1935.04 9.04
1935.05 9.75
1935.06 10.12
1935.07 10.65
1935.08 11.37
1935.09 11.61
1935.10 11.92
1935.11 13.04
1935.12 13.04
1936.01 13.76
1936.02 14.55
1936.03 14.86
1936.04 14.88
1936.05 14.09
1936.06 14.69
1936.07 15.56
1936.08 15.87
1936.09 16.05
1936.10 16.89
1936.11 17.36
1936.12 17.06
1937.01 17.59
1937.02 18.11
1937.03 18.09
1937.04 17.01
1937.05 16.25
1937.06 15.64
1937.07 16.57
1937.08 16.74
1937.09 14.37
1937.10 12.28
1937.11 11.2
1937.12 11.02
1938.01 11.31
1938.02 11.04
1938.03 10.31
1938.04 9.89
1938.05 9.98
1938.06 10.21
1938.07 12.24
1938.08 12.31
1938.09 11.75
1938.10 13.06
1938.11 13.07
1938.12 12.69
1939.01 12.5
1939.02 12.4
1939.03 12.39
1939.04 10.83
1939.05 11.23
1939.06 11.43
1939.07 11.71
1939.08 11.54
1939.09 12.77
1939.10 12.9
1939.11 12.67
1939.12 12.37
1940.01 12.3
1940.02 12.22
1940.03 12.15
1940.04 12.27
1940.05 10.58
1940.06 9.67
1940.07 9.99
1940.08 10.2
1940.09 10.63
1940.10 10.73
1940.11 10.98
1940.12 10.53
1941.01 10.55
1941.02 9.89
1941.03 9.95
1941.04 9.64
1941.05 9.43
1941.06 9.76
1941.07 10.26
1941.08 10.21
1941.09 10.24
1941.10 9.83
1941.11 9.37
1941.12 8.76
1942.01 8.93
1942.02 8.65
1942.03 8.18
1942.04 7.84
1942.05 7.93
1942.06 8.33
1942.07 8.64
1942.08 8.59
1942.09 8.68
1942.10 9.32
1942.11 9.47
1942.12 9.52
1943.01 10.09
1943.02 10.69
1943.03 11.07
1943.04 11.44
1943.05 11.89
1943.06 12.1
1943.07 12.35
1943.08 11.74
1943.09 11.99
1943.10 11.88
1943.11 11.33
1943.12 11.48
1944.01 11.85
1944.02 11.77
1944.03 12.1
1944.04 11.89
1944.05 12.1
1944.06 12.67
1944.07 13
1944.08 12.81
1944.09 12.6
1944.10 12.91
1944.11 12.82
1944.12 13.1
1945.01 13.49
1945.02 13.94
1945.03 13.93
1945.04 14.28
1945.05 14.82
1945.06 15.09
1945.07 14.78
1945.08 14.83
1945.09 15.84
1945.10 16.5
1945.11 17.04
1945.12 17.33
1946.01 18.02
1946.02 18.07
1946.03 17.53
1946.04 18.66
1946.05 18.7
1946.06 18.58
1946.07 18.05
1946.08 17.7
1946.09 15.09
1946.10 14.75
1946.11 14.69
1946.12 15.13
1947.01 15.21
1947.02 15.8
1947.03 15.16
1947.04 14.6
1947.05 14.34
1947.06 14.84
1947.07 15.77
1947.08 15.46
1947.09 15.06
1947.10 15.45
1947.11 15.27
1947.12 15.03
1948.01 14.83
1948.02 14.1
1948.03 14.3
1948.04 15.4
1948.05 16.15
1948.06 16.82
1948.07 16.42
1948.08 15.94
1948.09 15.76
1948.10 16.19
1948.11 15.29
1948.12 15.19
1949.01 15.36
1949.02 14.77
1949.03 14.91
1949.04 14.89
1949.05 14.78
1949.06 13.97
1949.07 14.76
1949.08 15.29
1949.09 15.49
1949.10 15.89
1949.11 16.11
1949.12 16.54
1950.01 16.88
1950.02 17.21
1950.03 17.35
1950.04 17.84
1950.05 18.44
1950.06 18.74
1950.07 17.38
1950.08 18.43
1950.09 19.08
1950.10 19.87
1950.11 19.83
1950.12 19.75
1951.01 21.21
1951.02 22
1951.03 21.63
1951.04 21.92
1951.05 21.93
1951.06 21.55
1951.07 21.93
1951.08 22.89
1951.09 23.48
1951.10 23.36
1951.11 22.71
1951.12 23.41
1952.01 24.19
1952.02 23.75
1952.03 23.81
1952.04 23.74
1952.05 23.73
1952.06 24.38
1952.07 25.08
1952.08 25.18
1952.09 24.78
1952.10 24.26
1952.11 25.03
1952.12 26.04
1953.01 26.18
1953.02 25.86
1953.03 25.99
1953.04 24.71
1953.05 24.84
1953.06 23.95
1953.07 24.29
1953.08 24.39
1953.09 23.27
1953.10 23.97
1953.11 24.5
1953.12 24.83
1954.01 25.46
1954.02 26.02
1954.03 26.57
1954.04 27.63
1954.05 28.73
1954.06 28.96
1954.07 30.13
1954.08 30.73
1954.09 31.45
1954.10 32.18
1954.11 33.44
1954.12 34.97
1955.01 35.6
1955.02 36.79
1955.03 36.5
1955.04 37.76
1955.05 37.6
1955.06 39.78
1955.07 42.69
1955.08 42.43
1955.09 44.34
1955.10 42.11
1955.11 44.95
1955.12 45.37
1956.01 44.15
1956.02 44.43
1956.03 47.49
1956.04 48.05
1956.05 46.54
1956.06 46.27
1956.07 48.78
1956.08 48.49
1956.09 46.84
1956.10 46.24
1956.11 45.76
1956.12 46.44
1957.01 45.43
1957.02 43.47
1957.03 44.03
1957.04 45.05
1957.05 46.78
1957.06 47.55
1957.07 48.51
1957.08 45.84
1957.09 43.98
1957.10 41.24
1957.11 40.35
1957.12 40.33
1958.01 41.12
1958.02 41.26
1958.03 42.11
1958.04 42.34
1958.05 43.7
1958.06 44.75
1958.07 45.98
1958.08 47.7
1958.09 48.96
1958.10 50.95
1958.11 52.5
1958.12 53.49
1959.01 55.62
1959.02 54.77
1959.03 56.16
1959.04 57.1
1959.05 57.96
1959.06 57.46
1959.07 59.74
1959.08 59.4
1959.09 57.05
1959.10 57
1959.11 57.23
1959.12 59.06
1960.01 58.03
1960.02 55.78
1960.03 55.02
1960.04 55.73
1960.05 55.22
1960.06 57.26
1960.07 55.84
1960.08 56.51
1960.09 54.81
1960.10 53.73
1960.11 55.47
1960.12 56.8
1961.01 59.72
1961.02 62.17
1961.03 64.12
1961.04 65.83
1961.05 66.5
1961.06 65.62
1961.07 65.44
1961.08 67.79
1961.09 67.26
1961.10 68
1961.11 71.08
1961.12 71.74
1962.01 69.07
1962.02 70.22
1962.03 70.29
1962.04 68.05
1962.05 62.99
1962.06 55.63
1962.07 56.97
1962.08 58.52
1962.09 58
1962.10 56.17
1962.11 60.04
1962.12 62.64
1963.01 65.06
1963.02 65.92
1963.03 65.67
1963.04 68.76
1963.05 70.14
1963.06 70.11
1963.07 69.07
1963.08 70.98
1963.09 72.85
1963.10 73.03
1963.11 72.62
1963.12 74.17
1964.01 76.45
1964.02 77.39
1964.03 78.8
1964.04 79.94
1964.05 80.72
1964.06 80.24
1964.07 83.22
1964.08 82
1964.09 83.41
1964.10 84.85
1964.11 85.44
1964.12 83.96
1965.01 86.12
1965.02 86.75
1965.03 86.83
1965.04 87.97
1965.05 89.28
1965.06 85.04
1965.07 84.91
1965.08 86.49
1965.09 89.38
1965.10 91.39
1965.11 92.15
1965.12 91.73
1966.01 93.32
1966.02 92.69
1966.03 88.88
1966.04 91.6
1966.05 86.78
1966.06 86.06
1966.07 85.84
1966.08 80.65
1966.09 77.81
1966.10 77.13
1966.11 80.99
1966.12 81.33
1967.01 84.45
1967.02 87.36
1967.03 89.42
1967.04 90.96
1967.05 92.59
1967.06 91.43
1967.07 93.01
1967.08 94.49
1967.09 95.81
1967.10 95.66
1967.11 92.66
1967.12 95.3
1968.01 95.04
1968.02 90.75
1968.03 89.09
1968.04 95.67
1968.05 97.87
1968.06 100.5
1968.07 100.3
1968.08 98.11
1968.09 101.3
1968.10 103.8
1968.11 105.4
1968.12 106.5
1969.01 102
1969.02 101.5
1969.03 99.3
1969.04 101.3
1969.05 104.6
1969.06 99.14
1969.07 94.71
1969.08 94.18
1969.09 94.51
1969.10 95.52
1969.11 96.21
1969.12 91.11
1970.01 90.31
1970.02 87.16
1970.03 88.65
1970.04 85.95
1970.05 76.06
1970.06 75.59
1970.07 75.72
1970.08 77.92
1970.09 82.58
1970.10 84.37
1970.11 84.28
1970.12 90.05
1971.01 93.49
1971.02 97.11
1971.03 99.6
1971.04 103
1971.05 101.6
1971.06 99.72
1971.07 99
1971.08 97.24
1971.09 99.4
1971.10 97.29
1971.11 92.78
1971.12 99.17
1972.01 103.3
1972.02 105.2
1972.03 107.7
1972.04 108.8
1972.05 107.7
1972.06 108
1972.07 107.2
1972.08 111
1972.09 109.4
1972.10 109.6
1972.11 115.1
1972.12 117.5
1973.01 118.4
1973.02 114.2
1973.03 112.4
1973.04 110.3
1973.05 107.2
1973.06 104.8
1973.07 105.8
1973.08 103.8
1973.09 105.6
1973.10 109.8
1973.11 102
1973.12 94.78
1974.01 96.11
1974.02 93.45
1974.03 97.44
1974.04 92.46
1974.05 89.67
1974.06 89.79
1974.07 79.31
1974.08 76.03
1974.09 68.12
1974.10 69.44
1974.11 71.74
1974.12 67.07
1975.01 72.56
1975.02 80.1
1975.03 83.78
1975.04 84.72
1975.05 90.1
1975.06 92.4
1975.07 92.49
1975.08 85.71
1975.09 84.67
1975.10 88.57
1975.11 90.07
1975.12 88.7
1976.01 96.86
1976.02 100.6
1976.03 101.1
1976.04 101.9
1976.05 101.2
1976.06 101.8
1976.07 104.2
1976.08 103.3
1976.09 105.5
1976.10 101.9
1976.11 101.2
1976.12 104.7
1977.01 103.8
1977.02 101
1977.03 100.6
1977.04 99.05
1977.05 98.76
1977.06 99.29
1977.07 100.2
1977.08 97.75
1977.09 96.23
1977.10 93.74
1977.11 94.28
1977.12 93.82
1978.01 90.25
1978.02 88.98
1978.03 88.82
1978.04 92.71
1978.05 97.41
1978.06 97.66
1978.07 97.19
1978.08 103.9
1978.09 103.9
1978.10 100.6
1978.11 94.71
1978.12 96.11
1979.01 99.71
1979.02 98.23
1979.03 100.1
1979.04 102.1
1979.05 99.73
1979.06 101.7
1979.07 102.7
1979.08 107.4
1979.09 108.6
1979.10 104.5
1979.11 103.7
1979.12 107.8
1980.01 110.9
1980.02 115.3
1980.03 104.7
1980.04 103
1980.05 107.7
1980.06 114.6
1980.07 119.8
1980.08 123.5
1980.09 126.5
1980.10 130.2
1980.11 135.7
1980.12 133.5
1981.01 133
1981.02 128.4
1981.03 133.2
1981.04 134.4
1981.05 131.7
1981.06 132.3
1981.07 129.1
1981.08 129.6
1981.09 118.3
1981.10 119.8
1981.11 122.9
1981.12 123.8
1982.01 117.3
1982.02 114.5
1982.03 110.8
1982.04 116.3
1982.05 116.4
1982.06 109.7
1982.07 109.4
1982.08 109.7
1982.09 122.4
1982.10 132.7
1982.11 138.1
1982.12 139.4
1983.01 144.3
1983.02 146.8
1983.03 151.9
1983.04 157.7
1983.05 164.1
1983.06 166.4
1983.07 167
1983.08 162.4
1983.09 167.2
1983.10 167.7
1983.11 165.2
1983.12 164.4
1984.01 166.4
1984.02 157.3
1984.03 157.4
1984.04 157.6
1984.05 156.6
1984.06 153.1
1984.07 151.1
1984.08 164.4
1984.09 166.1
1984.10 164.8
1984.11 166.3
1984.12 164.5
1985.01 171.6
1985.02 180.9
1985.03 179.4
1985.04 180.6
1985.05 184.9
1985.06 188.9
1985.07 192.5
1985.08 188.3
1985.09 184.1
1985.10 186.2
1985.11 197.5
1985.12 207.3
1986.01 208.2
1986.02 219.4
1986.03 232.3
1986.04 238
1986.05 238.5
1986.06 245.3
1986.07 240.2
1986.08 245
1986.09 238.3
1986.10 237.4
1986.11 245.1
1986.12 248.6
1987.01 264.5
1987.02 280.9
1987.03 292.5
1987.04 289.3
1987.05 289.1
1987.06 301.4
1987.07 310.1
1987.08 329.4
1987.09 318.7
1987.10 280.2
1987.11 245
1987.12 241
1988.01 250.5
1988.02 258.1
1988.03 265.7
1988.04 262.6
1988.05 256.1
1988.06 270.7
1988.07 269.1
1988.08 263.7
1988.09 268
1988.10 277.4
1988.11 271
1988.12 276.5
1989.01 285.4
1989.02 294
1989.03 292.7
1989.04 302.3
1989.05 313.9
1989.06 323.7
1989.07 331.9
1989.08 346.6
1989.09 347.3
1989.10 347.4
1989.11 340.2
1989.12 348.6
1990.01 339.97
1990.02 330.45
1990.03 338.46
1990.04 338.18
1990.05 350.25
1990.06 360.39
1990.07 360.03
1990.08 330.75
1990.09 315.41
1990.10 307.12
1990.11 315.29
1990.12 328.75
1991.01 325.49
1991.02 362.26
1991.03 372.28
1991.04 379.68
1991.05 377.99
1991.06 378.29
1991.07 380.23
1991.08 389.4
1991.09 387.2
1991.10 386.88
1991.11 385.92
1991.12 388.51
1992.01 416.08
1992.02 412.56
1992.03 407.36
1992.04 407.41
1992.05 414.81
1992.06 408.27
1992.07 415.05
1992.08 417.93
1992.09 418.48
1992.10 412.5
1992.11 422.84
1992.12 435.64
1993.01 435.23
1993.02 441.7
1993.03 450.16
1993.04 443.08
1993.05 445.25
1993.06 448.06
1993.07 447.29
1993.08 454.13
1993.09 459.24
1993.10 463.9
1993.11 462.89
1993.12 465.95
1994.01 472.99
1994.02 471.58
1994.03 463.81
1994.04 447.23
1994.05 450.9
1994.06 454.83
1994.07 451.4
1994.08 464.24
1994.09 466.96
1994.10 463.81
1994.11 461.01
1994.12 455.19
1995.01 465.25
1995.02 481.92
1995.03 493.15
1995.04 507.91
1995.05 523.81
1995.06 539.35
1995.07 557.37
1995.08 559.11
1995.09 578.77
1995.10 582.92
1995.11 595.53
1995.12 614.57
1996.01 614.42
1996.02 649.54
1996.03 647.07
1996.04 647.17
1996.05 661.23
1996.06 668.5
1996.07 644.07
1996.08 662.68
1996.09 674.88
1996.10 701.46
1996.11 735.67
1996.12 743.25
1997.01 766.22
1997.02 798.39
1997.03 792.16
1997.04 763.93
1997.05 833.09
1997.06 876.29
1997.07 925.29
1997.08 927.24
1997.09 937.02
1997.10 951.16
1997.11 938.92
1997.12 962.37
1998.01 963.36
1998.02 1023.74
1998.03 1076.83
1998.04 1112.2
1998.05 1108.42
1998.06 1108.39
1998.07 1156.58
1998.08 1074.62
1998.09 1020.64
1998.10 1032.47
1998.11 1144.43
1998.12 1190.05
1999.01 1248.77
1999.02 1246.58
1999.03 1281.66
1999.04 1334.76
1999.05 1332.07
1999.06 1322.55
1999.07 1380.99
1999.08 1327.49
1999.09 1318.17
1999.10 1300.01
1999.11 1391
1999.12 1428.68
2000.01 1425.59
2000.02 1388.87
2000.03 1442.21
2000.04 1461.36
2000.05 1418.48
2000.06 1461.96
2000.07 1473
2000.08 1485.46
2000.09 1468.05
2000.10 1390.14
2000.11 1378.04
2000.12 1330.93
2001.01 1335.63
2001.02 1305.75
2001.03 1185.85
2001.04 1189.84
2001.05 1270.37
2001.06 1238.71
2001.07 1204.45
2001.08 1178.5
2001.09 1044.64
2001.10 1076.59
2001.11 1129.68
2001.12 1144.93
2002.01 1140.21
2002.02 1100.67
2002.03 1153.79
2002.04 1112.04
2002.05 1079.06
2002.06 1015.28
2002.07 903.59
2002.08 912.55
2002.09 867.81
2002.10 854.63
ggested moving-average trading rule is to buy a stock when the

uld this trading rule perform against buy and hold strategy ignoring transaction costs?

You might also like