currency-exchange-rates

Multi currency – what to store and when to convert?

by

Bear in mind that the answers you receive will be subjective. With that disclaimer out of the way, this is how I would go about setting up such a system. TL;DR: Use a currency rates table to store currency rates for different currencies and dates when they are applicable. Store amounts in both the local … Read more

On Google Spreadsheet how can you query ‘GoogleFinance’ for a past exchange rate?

by

In order to retrieve the historical rate, you have to use the following formula: =GoogleFinance(“eurusd”,”price”,today()-1,today()) where today()-1, today() is the desired time interval, which can be explicitly defined as the static pair of dates, or implicitly, as the dynamically calculated values, like in the example above. This expression returns a two-column array of the dates … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)