Foreign Exchange Rates - Historical and Current

griddle984

New Member
Joined
Mar 30, 2017
Messages
3
Hello,

I'm building an electricity/utilities monitoring scorecard for a Chinese factory. We want to take a daily electricity meter reading, run formulas to determine the amount of Chinese Renminbi due on the bill, and convert the Renminbi to USD. This scorecard will keep a running tally with historical data from prior days - so each row represents a different day.

I've got a data connection table setup now to pull the foreign exchange rates from x-rates.com for current rates. Then I run a VLOOKUP from that data table to find the corresponding Renminbi value for today's entry. When my data table updates, it pulls the most up-to-date currency conversion just as I want which is great...but my excel formulas also update and the prior day utilizes the current exchange rate instead of the prior exchange rate. I've tried to make it easy and search for a web-link that has dates with each currency conversion rate but that's not yielded any fruit.

This spreadsheet would be used by various people with different computers so Plug-Ins will not work. I'd also like to keep VBA code out if possible -- but I can include if needed.

Any help you can provide is much appreciated!
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,223,894
Messages
6,175,252
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top