I am using the GOOGLEFINANCE() function in google sheets to get an exchange rate for expenses I am entering in for accounting. The issue is that sometimes I get an #N/A error with the message W...

I need to store currency exchange rate data in the SQL 2008 database. I would like to keep rate as a decimal data type in the database. One thing I am not sure about, is how many decimal places to...

I'd like to know if it is possible to query a past exchange rate on Google Spreadsheet. For example; using formula =GoogleFinance("CURRENCY:USDEUR") will return the USD/EUR rate at this present mo...

I have read different Q&A on SO regarding multi currency but none of them are clear to me or do not provide enough details with regards to my use case. Scenario: Company Raddo has 3 branch lo...

After reading up on how to best handle users in multiple timezones properly, I've learned that the way to go is to store all dates in an normalized, application-wide timezone - UTC and then apply t...