Currency history issue

Hi,

I have a excel table for different transaction with different date and currency.

Now i have to search one by one in internet to find the currency with the specify date.

My question is, how can i do this easily? For example using some way to find the currency with specify date in web-site automatically and update the table?

Best regards

Andrew

Currency issue.xlsx

Hi EleGault,

Thank you very much for your kindly help and understand your advise.

I should build and maintain and exchange rate table update day by day by myself, i think i can make a table like column is Date and row is currencies.

In this case, I am not sure how can the transaction to lookup the specify date of currency in my table.

Please find my file attached.

Best Regards

Andrew


Currency issue - Copy.xlsx

Originally Posted by ELeGault

I don't know any off hand but I am sure you can find currency exchange rate history or a database to pull from periodically..

Or you just build it out your self... Make a table of exchange rate from X date to Y date. Add a new record when it changes

Should be a table like this

Date FROM | Date TO | Currency Type | Exchange Value |

Now obviously you would place the Exchange Value in the currency you would like to convert it to so that you can pull the exchange rate at the time of transaction and multiply it times the originating currency to get your converted amount.

This requires you to maintain a data base of Currency and if it falls behind you need only but update the table with a From To date.

Keep in mind, your latest currency have a =Today() formula inside of it along with CF to flag 2 things. One if it is considered todays date just so you can see that it has an open ended date because that is the current rate. And 2 if 2 or more have a current date with the same originating currency type as this would be a conflict of exchange rates for the varying locations.