USD / JPY currency rate historical data download

The Japanese Yen (JPY) is the official currency of Japan. From Quandl you can download free USD / JPY historical data back until 5 March 1991.

Steps for downloading USD / JPY market data

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.)

Quandl.com's tutorial. You can skip it

Step2: If everything is OK, you should see something similar to the picture below. Press "Download". (By using default settings you will download EOD USD / JPY data from the broadest date range. If this is not suitable for you, you can modify settings.)
USD / JPY market data page on Quandl.com


Step3: Choose a format for downloading USD / JPY data from the next window.
Hint: ".csv" and ."xls" formats are OK in most cases.
Press "Download Data" to download data to your computer.
Selecting file format for historical data

Possible problems

Number of downloads per day is limited to 50 if you are not a registered user of Quandl.com.
So if you see an error message related to this when downloading USD / JPY historical data, you should either register or wait another day.

DAX German stock index (GDAXI) historical data download

The  DAX index (Deutscher Aktien IndeX) has been started on 30 December 1987 with the base level of 1000. From Yahoo! Finance you can download DAX data back until 26 November 1990.

Steps for downloading DAX market data

You should see a page similar to this:
DAX historical data page on Yahoo! Finance

Step2: Scroll down to the bottom of the page and click "Download to Spreadsheet". (By using default settings you will download EOD DAX data from the broadest date range. If this is not suitable for you, you can modify settings.)
 "Download to Spreadsheet" button on Yahoo! Finance
Step3: Most browsers open a file chooser window to select where to download data. Start downloading market data by selecting a file and a location in this window. (Default file name is "table.csv" which isn't too good for identifying historical data on your computer so renaming file to "dax.csv" or similar is advised.)

If DAX data file is automatically opened with MS Excel or similar software (eg.: Libre Office Calc), it may cause problems when importing data file into a particular analysis software. In this case you should right-click on "Download to Spreadsheet" link (like in Step 2) and choose
  • "Save target as..." in Internet Explorer
  • "Save link As..." in Firefox and Google Chrome
  • or something similar in the context menu (depending on your browser)
You can analyze this data using eg.: Chartoasis Sesame or this free technicalanalysis software.