On Sat, Sep 14, 2013 at 11:12 PM, Austin Hook <aus...@computershop.ca> wrote:
> Thanks for the tip. That would probably good although it seems a bit > overkill to work with JSON objects. Fine for those used to playing at > that level. > > One thing about Bank of Canada is that rates there are official for > the Canadian tax dept. > > Actually, just now I have half solved the problem, for current rates at > least. Just fishing around the site a bit more, I realized I can: > > wget -O - http://www.bankofcanada.ca/stats/assets/csv/fx-seven-day.csv > > and go from there. > > Nothing inspires like being public about wishes that one never got around > to getting serious enough about, and then feeling a bit foolish. > > Still, something simple like that to get a table of long term historical > rates would be nice as well. > > Glad you worked out a solution! I can appreciate that CRA would prefer a national agency's record. Looking around, it seems their CSV generator is actually very generous, freely dumping 10 years' (and more) worth data to me. Playwith dF (start) and dT (end, today usually), ensure that sR<=dF: http://www.bankofcanada.ca/stats/results/csv?sF=LOOKUPS_CAD&lP=lookup_currency_converter.php&sR=2003-09-14&sTF=to&sT=LOOKUPS_IEXE0101&co=1.00&dF=2003-09-14&dT=2013-09-14 Without knowing what the backend or language is like, I could only shoot in the dark. Languages like Python, PHP, and Ruby all have native JSON wrappers; there are a handful of libraries for C, albeit JSON objects don't translate easily into a strictly-typed langauge; heck there's even JSON.sh (among others) for bash. On the whole, I find JSON extremely easy to work with. Let us know how the project goes! Regards, Bryce Chidester
