File talk:Historical WSJ Prime Rate 1947 to June 2022.svg

gnuplot

#!/opt/local/bin/gnuplot

# 04-Jan-2001,9.00

set datafile separator '\t'
set timefmt "%m %d, %Y"
set xdata time
set format x "%Y"

set grid
set pointsize .5
set size 1,.75

set title "Historical data for the WSJ prime rate\n1947 to June 2022"
set xlabel "Date"
set ylabel "Percent"

set ytics 2
set mytics 1

set size 1,1
set terminal svg size 640 480
set output 'Historical WSJ Prime Rate 1947 to June 2022.svg'
plot 'prime-changes-all.dat' using 1:2 title "" with lines

Data Prep

- copied from website - table headings removed - empty lines removed - months converted sed -e 's/January/01/g' -e 's/February/02/g' -e 's/March/03/g' -e 's/April/04/g' -e 's/May/05/g' -e 's/June/06/g' -e 's/July/07/g' -e 's/August/08/g' -e 's/September/09/g' -e 's/October/10/g' -e 's/November/11/g' -e 's/December/12/g' - manual fix for outlier: 12-15-2016, 03-06-2017 3.75, 4.00 - append latest data from https://commons.wikimedia.org/w/index.php?title=File_talk%3AWSJ_Prime_Rate_Changes.svg, change format as needed

Data

12 1, 1947	1.75
08 1, 1948	2.00
09 22, 1950	2.25
01 8, 1951	2.50
10 17, 1951	2.75
12 19, 1951	3.00
04 27, 1953	3.25
03 17, 1954	3.00
08 4, 1955	3.25
10 14, 1955	3.50
04 13, 1956	3.75
08 21, 1956	4.00
08 6, 1957	4.50
01 22, 1958	4.00
04 21, 1958	3.50
09 11, 1958	4.00
05 18, 1959	4.50
09 1, 1959	5.00
08 23, 1960	4.50
12 6, 1965	5.00
03 10, 1966	5.50
06 29, 1966	5.75
08 16, 1966	6.00
01 27, 1967	5.75
03 27, 1967	5.50
11 20, 1967	6.00
04 19, 1968	6.50
09 25, 1968	6.25
12 2, 1968	6.50
12 18, 1968	6.75
01 7, 1969	7.00
03 17, 1969	7.50
06 9, 1969	8.50
03 25, 1970	8.00
09 21, 1970	7.50
11 12, 1970	7.25
11 23, 1970	7.00
12 22, 1970	6.75
01 6, 1971	6.50
01 15, 1971	6.25
01 18, 1971	6.00
02 16, 1971	5.75
03 11, 1971	5.38
03 19, 1971	5.25
04 23, 1971	5.38
05 11, 1971	5.50
07 6, 1971	5.75
07 7, 1971	6.00
10 20, 1971	5.75
11 4, 1971	5.50
12 31, 1971	5.25
01 24, 1972	5.00
01 31, 1972	4.75
04 5, 1972	5.00
06 26, 1972	5.25
08 29, 1972	5.50
10 4, 1972	5.75
12 27, 1972	6.00
02 27, 1973	6.25
03 26, 1973	6.50
04 18, 1973	6.75
05 7, 1973	7.00
05 25, 1973	7.25
06 8, 1973	7.50
06 25, 1973	7.75
07 3, 1973	8.00
07 9, 1973	8.25
07 18, 1973	8.50
07 30, 1973	8.75
08 6, 1973	9.00
08 13, 1973	9.25
08 22, 1973	9.50
08 28, 1973	9.75
09 18, 1973	10.00
10 24, 1973	9.75
01 29, 1974	9.50
02 11, 1974	9.25
02 19, 1974	9.00
02 25, 1974	8.75
03 22, 1974	9.00
03 29, 1974	9.25
04 3, 1974	9.50
04 5, 1974	9.75
04 11, 1974	10.00
04 19, 1974	10.25
04 25, 1974	10.50
05 2, 1974	10.75
05 6, 1974	11.00
05 10, 1974	11.25
05 17, 1974	11.50
06 26, 1974	11.75
07 5, 1974	12.00
10 7, 1974	11.75
10 21, 1974	11.50
10 28, 1974	11.25
11 4, 1974	11.00
11 14, 1974	10.75
11 25, 1974	10.50
01 9, 1975	10.25
01 15, 1975	10.00
01 20, 1975	9.75
01 28, 1975	9.50
02 3, 1975	9.25
02 10, 1975	9.00
02 18, 1975	8.75
02 24, 1975	8.50
03 5, 1975	8.25
03 10, 1975	8.00
03 18, 1975	7.75
03 24, 1975	7.50
05 20, 1975	7.25
06 9, 1975	7.00
07 18, 1975	7.25
07 28, 1975	7.50
08 12, 1975	7.75
09 15, 1975	8.00
10 27, 1975	7.75
11 5, 1975	7.50
12 2, 1975	7.25
01 12, 1976	7.00
01 21, 1976	6.75
06 1, 1976	7.00
06 7, 1976	7.25
08 2, 1976	7.00
10 4, 1976	6.75
11 1, 1976	6.50
12 13, 1976	6.25
05 13, 1977	6.50
05 31, 1977	6.75
08 22, 1977	7.00
09 16, 1977	7.25
10 7, 1977	7.50
10 24, 1977	7.75
01 10, 1978	8.00
05 5, 1978	8.25
05 26, 1978	8.50
06 16, 1978	8.75
06 30, 1978	9.00
08 31, 1978	9.25
09 15, 1978	9.50
09 28, 1978	9.75
10 13, 1978	10.00
10 27, 1978	10.25
11 1, 1978	10.50
11 6, 1978	10.75
11 17, 1978	11.00
11 24, 1978	11.50
12 26, 1978	11.75
06 19, 1979	11.50
07 27, 1979	11.75
08 16, 1979	12.00
08 28, 1979	12.25
09 14, 1979	13.00
09 21, 1979	13.25
09 28, 1979	13.50
10 9, 1979	14.50
10 23, 1979	15.00
11 1, 1979	15.25
11 9, 1979	15.50
11 16, 1979	15.75
11 30, 1979	15.50
12 7, 1979	15.25
02 19, 1980	15.75
02 22, 1980	16.38
02 29, 1980	16.75
03 4, 1980	17.25
03 7, 1980	17.75
03 14, 1980	18.50
03 19, 1980	19.00
04 2, 1980	20.00
04 18, 1980	19.50
03 28, 1980	19.50
05 1, 1980	18.75
05 2, 1980	18.50
05 7, 1980	17.50
05 16, 1980	16.50
05 23, 1980	14.50
05 30, 1980	14.00
06 6, 1980	13.00
06 13, 1980	12.25
06 20, 1980	12.00
07 7, 1980	11.50
07 25, 1980	11.00
08 22, 1980	11.25
08 27, 1980	11.50
09 8, 1980	12.00
09 12, 1980	12.25
09 19, 1980	12.50
09 26, 1980	13.00
10 1, 1980	13.50
10 17, 1980	14.00
10 29, 1980	14.50
11 6, 1980	15.50
11 17, 1980	16.25
11 21, 1980	17.00
11 26, 1980	17.75
12 2, 1980	18.50
12 5, 1980	19.00
12 10, 1980	20.00
12 16, 1980	21.00
12 19, 1980	21.50
01 2, 1981	20.50
01 9, 1981	20.00
02 3, 1981	19.50
02 23, 1981	19.00
03 10, 1981	18.00
03 17, 1981	17.50
04 2, 1981	17.00
04 24, 1981	17.50
04 30, 1981	18.00
05 4, 1981	19.00
05 11, 1981	19.50
05 19, 1981	20.00
05 22, 1981	20.50
06 3, 1981	20.00
07 8, 1981	20.50
09 15, 1981	19.50
10 5, 1981	19.00
10 13, 1981	18.00
11 3, 1981	17.50
11 9, 1981	17.00
11 17, 1981	16.75
11 20, 1981	16.50
11 24, 1981	16.00
12 3, 1981	15.75
02 8, 1982	16.50
02 18, 1982	17.00
02 23, 1982	16.50
07 20, 1982	16.00
07 29, 1982	15.50
08 2, 1982	15.00
08 16, 1982	14.50
08 18, 1982	14.00
09 3, 1982	13.50
10 7, 1982	13.00
10 13, 1982	12.00
11 22, 1982	11.50
01 11, 1983	11.00
02 21, 1983	10.50
08 8, 1983	11.00
03 19, 1984	11.50
04 5, 1984	12.00
05 8, 1984	12.50
06 26, 1984	13.00
09 27, 1984	12.75
10 16, 1984	12.50
10 24, 1984	12.00
11 9, 1984	11.75
11 28, 1984	11.25
12 20, 1984	10.75
01 15, 1985	10.50
05 20, 1985	10.00
06 18, 1985	9.50
03 7, 1986	9.00
04 23, 1986	8.50
07 16, 1986	8.00
08 27, 1986	7.50
04 1, 1987	7.75
05 8, 1987	8.00
05 15, 1987	8.25
09 4, 1987	8.75
10 5, 1987	9.25
10 23, 1987	9.00
11 12, 1987	8.75
02 2, 1988	8.50
05 10, 1988	9.00
07 15, 1988	9.50
08 11, 1988	10.00
11 28, 1988	10.50
02 10, 1989	11.00
02 24, 1989	11.50
06 5, 1989	11.00
07 31, 1989	10.50
01 8, 1990	10.00
01 2, 1991	9.50
02 4, 1991	9.00
04 24, 1991	9.00
05 1, 1991	8.50
09 13, 1991	8.00
11 6, 1991	7.50
12 23, 1991	6.50
07 2, 1992	6.00
03 24, 1994	6.25
04 19, 1994	6.75
05 17, 1994	7.25
08 16, 1994	7.75
11 15, 1994	8.50
02 1, 1995	9.00
07 7, 1995	8.75
12 20, 1995	8.50
02 1, 1996	8.25
03 26, 1997	8.50
09 30, 1998	8.25
10 16, 1998	8.00
11 18, 1998	7.75
07 1, 1999	8.00
08 25, 1999	8.25
11 17, 1999	8.50
02 3, 2000	8.75
03 22, 2000	9.00
05 17, 2000	9.50
01 4, 2001	9.00
02 1, 2001	8.50
03 21, 2001	8.00
04 19, 2001	7.50
05 16, 2001	7.00
06 28, 2001	6.75
08 22, 2001	6.50
09 18, 2001	6.00
10 3, 2001	5.50
11 7, 2001	5.00
12 12, 2001	4.75
11 7, 2002	4.25
06 27, 2003	4.00
07 1, 2004	4.25
08 11, 2004	4.50
09 21, 2004	4.75
11 11, 2004	5.00
12 15, 2004	5.25
02 3, 2005	5.50
03 22, 2005	5.75
05 3, 2005	6.00
06 30, 2005	6.25
08 9, 2005	6.50
09 20, 2005	6.75
11 1, 2005	7.00
12 13, 2005	7.25
01 31, 2006	7.50
03 28, 2006	7.75
05 11, 2006	8.00
06 29, 2006	8.25
09 18, 2007	7.75
10 31, 2007	7.50
12 11, 2007	7.25
01 22, 2008	6.50
01 30, 2008	6.00
03 18, 2008	5.25
04 30, 2008	5.00
10 8, 2008	4.50
10 29, 2008	4.00
12 16, 2008	3.25
12 17, 2015	3.50
12 15, 2016	3.75
03 06, 2017	4.00
06 15, 2017	4.25
12 14, 2017	4.50
03 22, 2018	4.75
06 14, 2018	5.00
09 27, 2018	5.25
12 20, 2018	5.50
08 01, 2019	5.25
09 19, 2019	5.00
10 31, 2019	4.75
03 04, 2020	4.25
03 16, 2020	3.25
03 17, 2022	3.50
05 05, 2022	4.00
06 16, 2022	4.75

Vlisch (talk) 17:11, 19 June 2022 (UTC)