Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
 
Old 03-25-2005, 06:57 AM
Art McClinton
Guest
 
Posts: n/a
Default Re: Investment transactions imported from OFX are in the wrong order.

I agree with you that this is not correct. I would open a support case
with Microsoft.

Art McClinton

Dave wrote:
- quote -

> Hi,
> I'm using Money 2005 Small Business. I do some lite day trading and when I
> try to download transactions from my broker they are always imported into
> Money in the wrong order, which is a real pain. For example, I have an OFX
> with one day's transactions. The transaction appear in the OFX in date/time
> order as follows:
> buy
> sell
> short sell
> cover short
> buy
> sell
> short sell
> cover short
> short sell
> cover short
> However, when I import this OFX into Money and read the statement, the
> transactions appear in this order:
> sell
> short sell
> cover short
> sell
> short sell
> cover short
> short sell
> cover short
> buy
> buy
> When I try to accept the transactions Money starts adding phantom shares in
> order to balance everything out. Note that this is not occuring because of
> FIFO investment tracking. I can reproduce this with an empty money file with
> a single investment account. Can anyone explain why this happens and if
> there is any way to import the transactions in the correct order.
> Thanks....


  #-1  
Old 03-19-2005, 12:51 PM
Dave
Guest
 
Posts: n/a
Default Investment transactions imported from OFX are in the wrong order.

Hi,

I'm using Money 2005 Small Business. I do some lite day trading and when I
try to download transactions from my broker they are always imported into
Money in the wrong order, which is a real pain. For example, I have an OFX
with one day's transactions. The transaction appear in the OFX in date/time
order as follows:

buy
sell
short sell
cover short
buy
sell
short sell
cover short
short sell
cover short

However, when I import this OFX into Money and read the statement, the
transactions appear in this order:

sell
short sell
cover short
sell
short sell
cover short
short sell
cover short
buy
buy

When I try to accept the transactions Money starts adding phantom shares in
order to balance everything out. Note that this is not occuring because of
FIFO investment tracking. I can reproduce this with an empty money file with
a single investment account. Can anyone explain why this happens and if
there is any way to import the transactions in the correct order.

Thanks....


 

Tags
imported, investment, ofx, order, transactions, wrong
Similar Threads
Thread Forum Replies Last Post
Review imported transactions
ej99: I downloaded credit card transactions to a money file (.qif) from my bank (Chase) then imported, and it said it imported correctly. But I am unable...
Microsoft Money 1 02-25-2005 02:29 PM
Banks download file transaction information is in the wrong order
Microsoft: I download from franklin mint and I have to edit every transaction because every transaction puts the info in the memo field and seem to leave the...
Microsoft Money 1 12-26-2004 06:09 PM
Importing QIF File Produces Wrong Date Order
Van G: Just started setting up to use MS Money 2005 Premium. My banking institution(s) does not offer .ofx files for download (Canada) but does offer...
Microsoft Money 4 10-26-2004 03:46 AM
Wrong Investment in Download Activity
Charles Denny: I'm running into a frustrating problem that I'm hoping someone has an idea as to how to solve. For what ever reason, Money is trying to match an...
Microsoft Money 4 08-26-2004 08:35 PM
unable to view downloaded / imported transactions
Norman Reiss: When I download online transactions or if I import transactions from a bank account, they come into Money but I can't view them. When I click on...
Microsoft Money 3 09-01-2003 06:50 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 06:30 AM.