Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Foreign Currency in a Spreadsheet
Old 03-31-2007, 02:37 AM   #1
Confused about dryer sheets
Join Date: Oct 2006
Posts: 6
Foreign Currency in a Spreadsheet

Hello everyone,

So about half a year ago, inspired by this board, I built myself a personal budget thingie excel spreadsheet, endlessly improving it ever since. Maybe I'm crazy, but I find adding new graphs, options and statistics to be real fun. I basically got hours upon hours of entertainment, polished my excel skills and got to know my money a lot better, and all for free.

There are still a few points where I'm not satisfied, though. The major one is what to do with foreign currency? Most of my money is in USD and naturally, I track all income and expenses in USD as well, but I also have a sizable chunk of money in Euros.

So every month I have 100 dollars in income, 80 dollars in expenses(arbitrary numbers of course) and another 10 euros in income. In the quest of perfection, I want to have two fields totaling my income and expenses for that month. What do I do with the Euros?

Do I use the exchange rate of the day the Euro income came in? But then stuff won't balance. If the Euroollar rate falls, my NW(in USD) will increase, but it won't be reflected in the monthly income/expenses fields.

Do I always use the latest exchange rate? This way the above problem is solved, but having the income of past months fluctuate is pretty weird. It also means that the income field will not represent fairly the situation at the time, since it partially depends on future exchange rates.

Or do I track Dollars and Euros separately, giving up on having a single monthly income field? That might be the most financially exact solution, but it would mess up all my pretty graphs!

Are there other solutions to this problem? Or improvements over the ones I thought of?

Hanno is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Re: Foreign Currency in a Spreadsheet
Old 03-31-2007, 03:03 AM   #2
Full time employment: Posting here.
Join Date: Mar 2005
Posts: 699
Re: Foreign Currency in a Spreadsheet

I'm not sure I completely understand the issue, but here is what I do, if it is of any reference.

In general, I track all currencies separately. For monthly budget purposes, I convert all balances and transactions into one currency at the end-of-the-month exchange rate. Close enough for my purposes. For my daily portfolio tracker, I convert currencies every day, or rather every time that I check. (The frequency of checking fluctuates with my current interest level.) My portfolio tracking spreadsheet gets the conversion rates off the web automatically, along with the prices of portfolio holdings.

bpp is offline   Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Investing in Foreign Currency Markets chinaco FIRE and Money 11 04-02-2007 08:02 AM
Buying into foreign currency. modhatter FIRE and Money 29 02-24-2007 09:39 PM
Chinese Foreign Currency Reserves Maximillion Other topics 2 04-22-2006 07:48 AM
Foreign Exchange Moves- how do you deal with them? Saver FIRE and Money 18 08-30-2004 03:13 PM


All times are GMT -6. The time now is 11:05 PM.
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.