Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Re: problems retrieving transactions

[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

Posted by Mark on June 21, 2005 at 13:46:49:

In Reply to: problems retrieving transactions posted by Tom on June 21, 2005 at 13:10:15:

: I am a new user of FM and find it very useful. However, now I have lost some ability to automatically retrieve new transactions correctly. I set up a portfolio to represent one Fidelity account. The FM portfolio has three sub-portfolios, one each for stocks, stock mutual funds, and bonds. Originally I set up the data using transaction retrieval into one portfolio - retrieval worked well for this. Then I separated the investments into the three portfolios and I am having trouble.

: If I issue 'retrieve transactions' with the portfolio marked as the active portfolio I can see that there are three separate calls to Fidelity and three returns. The only thing that shows up on the preview screen is a single dividend re-investment, but that is already in one of the sub-portfolios.

: If I mark one of the sub-portfolios as the active portfolio and retrieve transactions, nothing shows on the preview scree. However, if I look at ofxretr.txt at least one purchase and multiple distributions are listed there.

: Could it be that FM is getting confused about which sub-portfolio to check to see if the entry in ofxretr is for an investment in that sub-portfolio?

: What do you suggest I do? Thank you for any help. Since I am a new user, I may have overlooked the obvious.

: PS - Is there a viewer for ofxretr? As a text file it is unreadable. Viewed as an XML file it is readable with difficulty.


Hi Tom,

The easy question first... Please email us a request for our parsing tool by using our contact form:

http://www.fundmanagersoftware.com/contact.html

We do have a simple command line tool that will make reading this ofxretr.txt file easier. It really isn't a production tool, just something we use internally. I'd be happy to email it to you.

To your main question... When you split apart your single portfolio, did you retain the same account number and transaction retrieve settings for each of the 3 sub-portfolios? The "Active" portfolio does not matter when retrieving. When you retrieve the first choice along the top is "Portfolio To Retrieve". This can be any of your portfolios, and there is also an option "Also Retrieve All Sub-Portfolios".

It sounds like you have one account, and 3 sub-portfolios, so you would want to set up each sub-portfolio to do it's own retrieve. When looking for matching investments Fund Manager does not go down into sub-portfolios, it only looks in the portfolio which it is retrieving.

When you look at the ofxretr.txt that is only showing the last portfolio retrieved. If you have the "Also Retrieve All Sub-Portfolios" option on, you may be retrieving multiple portfolios. If you see some transactions in the ofxretr.txt file, but they don't appear in the preview screen, then it is because of the options used for the retrieve. It could either be out of the date range you requested, or there was no matching investment found, and you had the option turned off to automatically create new investments, or those transactions are already recorded, and you have the option to skip transactions already in Fund Manager turned on.

There are a lot of options on the retrieve dialog, and it can be a little tricky sometimes to get them all set how you want. Hopefully some of this explanation helps.

Thanks,
Mark
--
Mark Beiley
Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP/2003



Replies:



FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy