Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #4  
Old 03-31-2007, 01:31 PM
WB
Guest
 
Posts: n/a
Default Re: Multiple currencies OFX statement import problem.

Hi,
I have tested again with the conversion rate for USD defined in program
settings. There is no effect (the same fault as before).

WB
"Bob Peel, MVP" <bob_peel[at]kiandra.freeserve.co.uk.INVALID> schrieb im
Newsbeitrag news:eyzohXucHHA.3632[at]TK2MSFTNGP02.phx.gbl...
Money supports this, even in 2005. You have to pre-define a conversion rate
between your file's base currency and each of the downloaded currencies.
This is particularly true if the account you are downloading has a default
currency which is not defined in your file. The error message in 2006 was
improved to help users realize they need to set that conversion rate and
then setup a second time.


--
Regards
Bob Peel,
Microsoft MVP - Money

For UK tips & fixes see
http://support.microsoft.com/default...d=fh;EN-GB;mny.


I do not respond to any emails that I have not specifically asked for.

"WB" <wolfgbaudisch[at]hotmail.com> wrote in message
news:%23Bb8sppcHHA.5052[at]TK2MSFTNGP05.phx.gbl...
- quote -

> To whom it may concern:
> Does Money 2007 support this?
> I use MNY 2005 and it does NOT!!!
> Thanks in advance for any help.
> Wolfgang



  #3  
Old 03-31-2007, 09:21 AM
WB
Guest
 
Posts: n/a
Default Re: Multiple currencies OFX statement import problem.

Dear Cal,
thanks for your kind reply.
I have tried the following:

Setting up an investment account with EUR as base currency.
Importing an OFX statement from my broker that contains stock positions in
EUR and USD. The broker account base is EUR also. So the CURDEF value in the
statement is EUR.
For the investment positions, the conversion rates (CURRATE) are included in
the OFX file. For EUR it is 1, for USD it is for example 0.75255. The
currency symbols (CURSYM) are also included.

Then I observed the following:
Money imported all position (Add Shares) as if they where EUR. It ignored
the CURRATE, setting it to 1. So for example it calculated one GOOG share to
be worth 460 EUR that is about 610 $. Pity that this is not true in the
moment!!!

If MNY does not calculate the currencies, would it help to set up one
account for every currency and import selectively only those positions that
match the base currency of the account?

It is a good suggestion to try MNY2007 on a new computer as I do not want to
get additional problems by upgrading ;-)

Today, many people replace a running XP by a not yet finished Vista system.
For what?

Thanks in advance for any help.
WB


  #2  
Old 03-31-2007, 09:05 AM
WB
Guest
 
Posts: n/a
Default Re: Multiple currencies OFX statement import problem.

Dear Bob,
thanks for your kind reply.
I have tried the following:

Setting up an investment account with EUR as base currency.
Importing an OFX statement from my broker that contains stock positions in
EUR and USD. The broker account base is EUR also. So the CURDEF value in the
statement is EUR.
For the investment positions, the conversion rates (CURRATE) are included in
the OFX file. For EUR it is 1, for USD it is for example 0.75255. The
currency symbols (CURSYM) are also included.

Then I observed the following:
Money imported all position (Add Shares) as if they where EUR. It ignored
the CURRATE, setting it to 1. So for example it calculated one GOOG share to
be worth 460 EUR that is about 610 $. Pity that this is not true in the
moment!!!

If MNY does not calculate the currencies, would it help to set up one
account for every currency and import selectively only those positions that
match the base currency of the account?

Thanks in advance for any help.
WB
"Bob Peel, MVP" <bob_peel[at]kiandra.freeserve.co.uk.INVALID> schrieb im
Newsbeitrag news:eyzohXucHHA.3632[at]TK2MSFTNGP02.phx.gbl...
Money supports this, even in 2005. You have to pre-define a conversion rate
between your file's base currency and each of the downloaded currencies.
This is particularly true if the account you are downloading has a default
currency which is not defined in your file. The error message in 2006 was
improved to help users realize they need to set that conversion rate and
then setup a second time.


--
Regards
Bob Peel,
Microsoft MVP - Money

For UK tips & fixes see
http://support.microsoft.com/default...d=fh;EN-GB;mny.


I do not respond to any emails that I have not specifically asked for.

"WB" <wolfgbaudisch[at]hotmail.com> wrote in message
news:%23Bb8sppcHHA.5052[at]TK2MSFTNGP05.phx.gbl...
- quote -

> To whom it may concern:
> Does Money 2007 support this?
> I use MNY 2005 and it does NOT!!!
> Thanks in advance for any help.
> Wolfgang



  #1  
Old 03-30-2007, 04:40 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Multiple currencies OFX statement import problem.

In microsoft.public.money, WB wrote:

- quote -

> Does Money 2007 support this?
> I use MNY 2005 and it does NOT!!!


I don't know. I know that Money 2007 OFX handling was changed to
handle the newer 2.03 and 1.03 OFX versions, but I think those add
primarily multi-factor authentication.

I did not know that Money 2005 would not handle <CURDEF> that have
different currencies in the same file. Each account within the OFX
file would have its own <CURDEF> tag, but I only have worked with
them where the currency is the same.

Are you sure that each of the respective accounts are set up for the
particular currency that the CURDEF for the account is for?

You could try installing the Money 2007 trial on a different
computer without the potential messing up your current installation.
However I suspect they would work the same in that regard.


 
Old 03-30-2007, 04:10 PM
Bob Peel, MVP
Guest
 
Posts: n/a
Default Re: Multiple currencies OFX statement import problem.

Money supports this, even in 2005. You have to pre-define a conversion rate between your file's base currency and each of the downloaded currencies. This is particularly true if the account you are downloading has a default currency which is not defined in your file. The error message in 2006 was improved to help users realize they need to set that conversion rate and then setup a second time.


--
Regards
Bob Peel,
Microsoft MVP - Money

For UK tips & fixes see
http://support.microsoft.com/default...d=fh;EN-GB;mny.


I do not respond to any emails that I have not specifically asked for.

"WB" <wolfgbaudisch[at]hotmail.com> wrote in message news:%23Bb8sppcHHA.5052[at]TK2MSFTNGP05.phx.gbl...
- quote -

> To whom it may concern:
> Does Money 2007 support this?
> I use MNY 2005 and it does NOT!!!
> Thanks in advance for any help.
> Wolfgang

  #-1  
Old 03-30-2007, 06:53 AM
WB
Guest
 
Posts: n/a
Default Multiple currencies OFX statement import problem.

To whom it may concern:

Does Money 2007 support this?
I use MNY 2005 and it does NOT!!!

Thanks in advance for any help.
Wolfgang



 

Tags
currencies, import, multiple, ofx, problem, statement
Similar Threads
Thread Forum Replies Last Post
Money 98 Statement Import Problem
Jacob Buys: Hi, I'm having some trouble with my Money 98 Datafile. Ever since I imported a certain OFC file into money (at least, that's when I think it...
Microsoft Money 4 08-15-2005 11:13 AM
multiple currencies
alastair.moore@etsi.org: Hi all, I'm running Money 2005 and I want to set it up to manage my UK and my French account. I've set it up as € being the base currency and my...
Microsoft Money 2 04-08-2005 12:48 PM
Multiple Currencies
Bartcelona: Just moved to Europe and now have Euro accounts as well as US dollar accounts. How can I handle that with Microsoft Money 04 deluxe. Can somebody...
Microsoft Money 1 11-06-2004 03:25 PM
Multiple currencies
Marcos: I'm getting ready to move overseas but will keep some accounts open in the US. Does anybody have any information about maintaining accounts in...
Microsoft Money 1 08-03-2003 02:15 PM



Thread Tools
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

All times are GMT. The time now is 09:35 PM.