User:Lalala666

Stock Indices

I went to [2] 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 "<g..." line. I added/removed horizontal and vertical lines as necessary to make it pretty, and then changed the stroke width at the top of the file so that the lines were clear but not horrendously thick. I then went all the way to the bottom of the file and added labels for the axes (this is really tedious), and finally went back to the top and translated the whole thing (first <g...") until the borders were padded about the same. Done!

Pictures

Gallery of indices (and my two comparison graphs!)
Wilshire 5000
Russell 3000
NASDAQ
S&P 500 linear
S&P 500 logarithmic
DJIA linear
DJIA logarithmic
Comparison of DJIA, NASDAQ Composite and S&P 500 after 1975
Comparison of DJIA, NASDAQ Composite and S&P 500. The Wikipedia SVG rasterizer wouldn't let me send up a prettier [1] graph with daily data :(

Gallery of crashes
DJIA during 9/11.
DJIA on Black Monday (1987).
Dot com bubble illustration on the NASDAQ
Wall Street Crash of 1929, with the October stock crash highlighted. Preludes the Great Depression.