#!/usr/bin/gnuplot
# gnuplot 4.2 / Ubuntu 8.10 
# gnuplot script for plotting eurofxref-hist.csv as obtained from
#  https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html

# download and unzip data if not available - delete eurofxref* to force new download.
# remove or comment out these lines in Windows/MacOS.
! [ -f eurofxref-hist.csv ] || wget https://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist.zip
! [ -f eurofxref-hist.csv ] || unzip eurofxref-hist.zip

#input
set timefmt "%Y-%m-%d"
set datafile missing 'N/A'
set datafile separator ','
 
#output
set key top left
set style data lines
set grid
 
set xdata time
set format x '%Y'
set xrange ['1999-01-01':*]
set mxtics 4
#set xlabel 'Date'
 
set ylabel 'CHF'
set format y '%.2f'
 
set term svg size 800,400 font "Arial,10"
 
set outp 'Euro exchange rate to CHF.svg'
set style line 1 lt rgb 'blue' lw 1
 
#available currencies:
#first one is $2, second $3 and so on
#USD,JPY,BGN,CYP,CZK,DKK,EEK,GBP,HUF,LTL,LVL,MTL,PLN,ROL,RON,SEK,SIT,SKK,CHF,ISK,NOK,HRK,RUB,TRL,TRY,AUD,BRL,CAD,CNY,HKD,IDR,ILS,INR,KRW,MXN,MYR,NZD,PHP,SGD,THB,ZAR																				
 
plot 'eurofxref-hist.csv' usi 1:($20) title '1 Euro in CHF' ls 1