User:Lalala666

Stock Indices
I went to 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!