With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, May 19, 2012
yogi_Convert Specified Currency To US Dollar Using www.oanda.com
user Pete Cutter said: Single date historical currency exchange rate from OANDA I'm looking for a spreadsheet function to bring a single historical exchange rate for a particular currency into a single spreadsheet cell.
I've tried some of the more user-friendly strings such as (apologies for my cell references--I've checked and these are all valid):
I have requested Pete Cutter to share his spreadsheet with me so I can see how his data is laid out and specifically what is housed in cell I39 and some other cells ... in the mean time following is my convoluted solution