Gold historical data download in 5 easy steps

-
One of the most complete set of gold's historical data can be downloaded from Stooq.com. Stooq.com's data of gold goes back until 1793 (!). Of course you can not await full EOD data for the 18th century, but it is still quite interesting...
Stooq.com is a Polish website, but some parts of it is transleted into English. Do not be afraid of it, you can download gold data without knowing anything about Polish language! (You can also try using Google translate. Google Chrome will offer automatic translation as soon as you visit Stooq.com.)
Alternatively, you can check out gold's 5 year chart or the historical charts of gold.



Step2: Click "Historical data" link (marked with red on the image below).
 
the place of gold historical data download link on Stooq.com

Step3: Scroll down to the bottom of the next page and click "Download data in .csv file...". (Leave dates, radio buttons and checkboxes unchanged.)

link to download data in csv file


Step4: if a window pops up requesting for an antibot code, enter the anti-bot code into the text-field marked with red and click "Approve" (antibot will probably not be LYGD in your case... this is just a screenshot). 
 
enter antibot code before downloading historical data

Step5: Click "Download file..." link in the pop-up window. Your browser should offer to choose where to download the data file

finally download file link appears

If data file is automatically opened with MS Excel or similar software (eg.: Libre Office Calca), it may cause problems when loading data file into a particular analysis software. In this case you should right-click on "Download data in .csv file..." link (like in Step 3) and choose "Save file as..." or similar in the context menu (depending on your browser).

You can analyze this data using eg.: Chartoasis Sesame or this free technicalanalysis software.

Popular posts from this blog

S&P 500 (GSPC) index historical data download

-
Image
The Standard and Poor's 500 (S&P 500) index has been introduced in its current form on 4 March 1957, but it existed previously as well. From Quandl you can download free S&P 500 data back until 3 January 1950. Steps for downloading S&P 500 market data Step1 : visit Quandl'sS&P 500 data download page ( http://www.quandl.com/YAHOO-Yahoo-Finance/INDEX_GSPC-S-P-500-Index ) It may happen that you meet Quandl's tutorial first (see below). Press " Skip "! (Tutorial introduces all features of Quandl – a lot of them is not required for getting data.)
Read more

FTSE 100 historical data download

-
Image
FTSE 100 index has been introduced on 3 January 1984 at the base level of 1000. From Yahoo! Finance you can download FTSE 100 data back until 2 April 1984. Alternatively you can check out these 5 year charts of FTSE or 10 year charts of FTSE . Steps for downloading FTSE 100 market data Step1: visit http://finance.yahoo.com/q/hp?s=%5EFTSE+Historical+Prices You should see a page similar to this:
Read more

Dow Jones (DJIA) index historical data download

-
Image
The Dow Jones Industrial Average index has been introduced on 26 May 1896 at the base level near 30. From Stooq.com you can download DJIA data back until 27 May 1896!  Of course you can not await full EOD data for the 19th century (data must have been recorded manually from old newspapers), but it is still quite interesting... Stooq.com is a Polish website, but some parts of it is transleted into English. Do not be afraid of it, you can download Dow Jones data without knowing anything about Polish language! (You can also try using Google translate. Google Chrome will offer automatic translation as soon as you visit Stooq.com.) Alternatively, you can check out  Dow Jones's 5 year chart  or Dow Jones's 10 year chart . You can also find a quick guide for Dow Jones' 10 years historical data here .
Read more