Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 04-05-2005, 07:16 PM
Dave
Guest
 
Posts: n/a
Default Re: Importing Trade Transactions

I am having the same problem, which I posted back in March without any
resolution. I'm reposting just in case any new info is available. Going back
to 2004 is not an option:

----------------------------

I'm using Money 2005 Small Business. I do some day trading (a lot of
transactions in one day) and when I try to download transactions from my
broker they are always imported into Money in the wrong order. For example,
I have an OFX with one day's transactions. The transactions 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....


 
Old 03-31-2005, 08:16 PM
Won Lee
Guest
 
Posts: n/a
Default Re: Importing Trade Transactions

Won Lee wrote:
- quote -

> I DLed an OFX file containing my trades. When I try to import it into
> Money 2005 Standard, I have several problems.
> 1) It wants me to OK every trade. The way this broker's statment is
> formated, each transaction is also reported. IE if I B 1000 MSFT:
> bought 100 shares at 24.21, and 100 shares at 24.20. etc etc. Each
> piece is reported. So for a trade of a 1000 shares I'm pressing NEXT
> about 5 times for each side.
> 2) I imports the sells before the buys. This forces Money to add
> shares. Which is distorting my position. Example: I buy 1000 CSCO
> today and sell 1000. Money sees S 1000 CSCO. Adds 1000 shares of CSCO.
> Sells 1000 CSCO. Sees B 1000 CSCO and adds 1000 shares of CSCO. And
> it thinks I have a position in CSCO when I should be flat.
> Any idea what I can do to deal with this problem?



Just in case someone else had the same problems I had. I fixed the
problem by chucking out Money 2005 and using Money 2004.
  #-1  
Old 03-31-2005, 06:44 PM
Won Lee
Guest
 
Posts: n/a
Default Importing Trade Transactions

I DLed an OFX file containing my trades. When I try to import it into
Money 2005 Standard, I have several problems.

1) It wants me to OK every trade. The way this broker's statment is
formated, each transaction is also reported. IE if I B 1000 MSFT:
bought 100 shares at 24.21, and 100 shares at 24.20. etc etc. Each
piece is reported. So for a trade of a 1000 shares I'm pressing NEXT
about 5 times for each side.

2) I imports the sells before the buys. This forces Money to add
shares. Which is distorting my position. Example: I buy 1000 CSCO
today and sell 1000. Money sees S 1000 CSCO. Adds 1000 shares of CSCO.
Sells 1000 CSCO. Sees B 1000 CSCO and adds 1000 shares of CSCO. And
it thinks I have a position in CSCO when I should be flat.


Any idea what I can do to deal with this problem?
 

Tags
importing, trade, transactions
Similar Threads
Thread Forum Replies Last Post
Separate transactions being merged when importing QIF file
Chris Crites: I downloaded a QIF file from my bank dating back to 01/01/2004. When I imported this file into Money 2005 the balance was way off compared to the...
Microsoft Money 3 02-23-2005 07:33 PM
Importing share prices and transactions into money
John D.: Is there a way of importing share or unit trust prices into Money? I would like to update the historical value of some investments which are not...
Microsoft Money 2 11-16-2004 06:27 PM
Importing Transfer Transactions
CJS: I have been working all day manually doing all the transfer transactions during my last import. I am getting nowhere fast! When I imported my...
Microsoft Money 6 04-08-2004 04:17 AM
Importing investment transactions
Tom G: I am having trouble importing a qif file containing buy and sell data for shares. Importing of the cash portion of the investment account appears...
Microsoft Money 4 12-03-2003 05:08 AM



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 07:02 AM.