For faster navigation, this Iframe is preloading the Wikiwand page for User:Lalala666.

User:Lalala666

Stock Indices

[edit]

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

[edit]

Graph test

[edit]
2020 median personal income, ages 15 years or older[2]
  All workers Full-time workers
All
41,535
56,287
Men
49,389
61,417
Women
35,838
50,982
  1. ^ "Table A-6: Earnings Summary Measures by Selected Characteristics: 2019 and 2020". www.census.gov. Retrieved 2022-04-26.
  2. ^ "Table A-6: Earnings Summary Measures by Selected Characteristics: 2019 and 2020". www.census.gov. Retrieved 2022-04-26.
{{bottomLinkPreText}} {{bottomLinkText}}
User:Lalala666
Listen to this article

This browser is not supported by Wikiwand :(
Wikiwand requires a browser with modern capabilities in order to provide you with the best reading experience.
Please download and use one of the following browsers:

This article was just edited, click to reload
This article has been deleted on Wikipedia (Why?)

Back to homepage

Please click Add in the dialog above
Please click Allow in the top-left corner,
then click Install Now in the dialog
Please click Open in the download dialog,
then click Install
Please click the "Downloads" icon in the Safari toolbar, open the first download in the list,
then click Install
{{::$root.activation.text}}

Install Wikiwand

Install on Chrome Install on Firefox
Don't forget to rate us

Tell your friends about Wikiwand!

Gmail Facebook Twitter Link

Enjoying Wikiwand?

Tell your friends and spread the love:
Share on Gmail Share on Facebook Share on Twitter Share on Buffer

Our magic isn't perfect

You can help our automatic cover photo selection by reporting an unsuitable photo.

This photo is visually disturbing This photo is not a good choice

Thank you for helping!


Your input will affect cover photo selection, along with input from other users.

X

Get ready for Wikiwand 2.0 ๐ŸŽ‰! the new version arrives on September 1st! Don't want to wait?