User:Lalala666
__FORCETOC__
Stock Indices
I went to [http://www.econstats.com/eqty/index.htm] to grab the daily data for the index (get the .csv version). I then loaded it into Excel, where I grabbed the date and daily closings and put them in columns a and b in a new worksheet. I applied the formula "=YEAR(A2)+(MONTH(A2)-1)/12+(DAY(A2)-1)/365" to turn the date into a number that the SVGizer could work with. I then ran the macro:
Sub deleteNA()
Dim i As Integer
For i = 10000 To 1 Step -1
If (Sheet14.Cells(i, 2).Value Like " na") Then
Sheet14.Rows(i).EntireRow.Delete
End If
Next i
End Sub
to get rid of days for which we do not have data (holidays I guess?). You need to tweak it so the sheet's right, and so that "i" covers all your data (this one won't for the DJIA). Then, I copied the decimalized date column, and pasted into a new column as values (right click on the column header, select "Paste special...", and click values). I pasted the closing data in the column after it. I then inserted a row above the top value, made the date whatever the last date was plus a tiny amount, and set the closing price to zero (this is because the graph is really a polygon, and it gets confused if you don't close it with zero--or at least it does in Inkscape.) I put the letter "M" in the row in the cell before of the first date, and "L" in every cell below it (some SVG thing, I dunno).
I then copied the data into a template (one of the previous indices I worked on). Using Firefox as my debugger (it renders about the same way as Wikipedia does), I scaled the data correctly on that second "
Pictures
Image:Wilshire 5000 historical graph.svg|Wilshire 5000
Image:Russell 3000 historical graph.svg|Russell 3000
Image:Nasdaq historical graph.svg|NASDAQ
Image:SP500FF.svg|S&P 500 linear
Image:SandP 500 Historical Graph.svg|S&P 500 logarithmic
Image:DJIA historical graph.svg|DJIA linear
Image:DJIA historical graph (log).svg|DJIA logarithmic
Image:Comparison of three stock indices after 1975.svg|Comparison of DJIA, NASDAQ Composite and S&P 500 after 1975
Image:Comparison of three stock indices.svg|Comparison of DJIA, NASDAQ Composite and S&P 500. The Wikipedia SVG rasterizer wouldn't let me send up a prettier [http://upload.wikimedia.org/wikipedia/en/archive/9/9f/20070428153320%21Comparison_of_three_stock_indices.svg] graph with daily data :(
Image:DJIA during 911.svg|DJIA during 9/11.
Image:DJIA Black Monday 1987.svg|DJIA on Black Monday (1987).
Image:Nasdaq Composite dot-com bubble.svg|Dot com bubble illustration on the NASDAQ
Image:1929 wall street crash graph.svg|Wall Street Crash of 1929, with the October stock crash highlighted. Preludes the Great Depression.
Image:History of US federal minimum wage increases.svg|Federal minimum wage increases
Image:US Postage History.svg|History of United States Postal Service rates
Image:US Historical Inflation.svg|Historical inflation in the U.S.
Image:US Historical Inflation Ancient.svg|Historical inflation in the U.S.
Image:US housing slump.svg|US existing-home sales (US housing bubble)
Image:Historical price of gold.png|Commodity price of gold
Image:Historical median personal income by education attainment in the US.png|Graph of the history of education vs. income in the US
Graph test
{{Side box
| style="direction: ltr"
| text=
{{Graph:Chart
| type=rect
| width=120 | height=150
| showValues=format:$,d
| yAxisFormat=$,d
| yGrid=
| yAxisMax=70000
| xAxisTitle=All workers
| x=All,Men,Women
| y=41535,49389,35838
| colors=#800000aa
}}
{{Graph:Chart
| type=rect
| width=120 | height=150
| yAxisFormat=$,d
| yGrid=
| yAxisMax=70000
| xAxisTitle=Full-time workers
| x=All,Men,Women
| y=56287,61417,50982
| colors=#800000aa
}}
| below=
}}
{{Bar chart
| title = 2020 median personal income, ages 15 years or older{{cite web|url=https://www.census.gov/library/publications/2021/demo/p60-273.html|title=Table A-6: Earnings Summary Measures by Selected Characteristics: 2019 and 2020|website=www.census.gov|access-date=2022-04-26}}
| float = right
| bar_width = 15
| width_units = em
| label_type =
| label1 = All
| label2 = Men
| label3 = Women
| data_type = All workers
| data_max = 50000
| data1 = 41535
| data2 = 49389
| data3 = 35838
| col2_data_type = Full-time workers
| col2_data_max = 62000
| col2_data1 = 56287
| col2_data2 = 61417
| col2_data3 = 50982
}}