|
|
Re: problems retrieving transactions[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ] Posted by Tom on June 22, 2005 at 13:24:18:In Reply to: Re: problems retrieving transactions posted by Mark on June 21, 2005 at 16:18:30: : : : : 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. : : : : : : 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, Thank you for the exceptionally quick reply. I still have the problem. Here is some additional data. : : 1. The ofxretr.txt file seems to contain all the transactions. From what I have seen it matches the report I can get directly from Fidelity for the account there. : : 2. In FM I have three sub-portfolios: stocks, MF and bonds. All of them have the same account number and password. I performed a 'retrieve transactions' for the dates 6/1 - 6/21/2005 for each of the sob-portfolios and once for the entire portfolio. In each case I did not check the box to skip transactions already in an FM investment, so that I could see more of what was returned. No matter which sub-portfolio I specified I get the same three entries in the preview screen - distributions for TGT, PEO and MSFT - all of which actually happened in the time period. When I retrieved for the whole portfolio I got three instances of each of the three distributions. : : What I fail to see in the preview screen is a BUY transaction for FINPX and four distributions for it. They are in the ofxretr.txt file. : : When I specify the check box to skip transactions already in an FM investment, then the preview screen does not contain the transaction for MSFT or TGT. However, it does contain the transaction for PEO, even though that transaction is already recorded in the stock sub-portfolio. : : When I use reports or graphs I seem to have no confusion about what is in a sub-portfolio e.g. reports subtotal on the subportfolios correctly. : : What exactly does FM use to determine if an OFX transaction pertains to the portfolio for which transactions are being retrieved? Perhaps I have done something to mess this up inadvertently. : : Thanks for your offer of the utility - I will send a note. And thanks for working me through this. : : Tom : : Thanks for the email, I just sent you the parsing utility. : Maybe it would be easiest to debug this if you tried a retrieve for each of your 4 sub-portfolios using these settings: : Also Retrieve All Sub-Portfolios (Off) : All Dates (Selected) : Skip Transactions Already In Fund Manager (Off) : Create New Investments As Needed (On) : Import "Investment Banking" Transactions (On) : When using these settings you should see all the transactions in the ofxretr.txt file show up in the Preview screen. You can just "Cancel" at the Preview screen. You should see the same set of transactions, no matter which sub-portfolio you retrieved. : When FM looks for a matching investment it matches on the symbol. If the symbol is empty, it matches on the name. Since you're looking in the ofxretr.txt file, you'll notice that for each transaction it reports a CUSIP (not a symbol). Down below though, it will have a list of securities, and report a symbol (called TICKER in the ofx file) for each CUSIP. Some OFX servers leave the symbol blank, and only report the name, which is why FM matches the way it does. In a future version we plan to add a CUSIP field into all versions (it is there in the Advisor version today), and then allow FM to match investments on the CUSIP, which will eliminate some matching troubles. : Thanks, Mark, Thank you for your help. The parsing utility was exactly what I sought. I did the four retrievals as you described and the results were that in each case 63 transactions were displayed in the preview. The 63 displayed were also the entire [transactions] content of the ofxretr.txt file. This included the FINPX transactions I had trouble with yesterday. Everything was accounted for. I then did a number of additional runs to eliminate the variables. Reducing the time period for the retrievals executed correctly and showed all the transactions. That is, the preview screen showed 10 transactions for the time period 6/1/2005 to 6/21/2005. [TGT, MSFT, PEO and 7 FINPX) This worked the same regardless of the subportfolio specified. I then repeated the retrieval for the restricted time, but setting the option to skip transactions already in FM. 8 transactions were listed in the preview. TGT and MSFT were eliminated and rightly so, since those transactions were already recorded. However, the dividend for PEO was also in FM and I could not account [at this time] for why it remained listed. The 7 FINPX transactions were the ones I have been trying all along to retrieve, but I did not apply them at this time, since I wanted to conduct more experiments. By this time I concluded: 1) selecting a subportfolio on the retrieve transaction dialog box determines to which portfolio the transactions will be applied, if they are selected in the preview screen. It does NOT determine which transactions will appear in the preview screen. Therefore the user needs to know which investment is in which subportfolio. Is this correct? 2) one could inadvertently retrieve a transaction into the wrong portfolio. I think the user should watch out for the "new" flag and be very careful in using the option to create a new investment for the transaction if one does not exist in the portfolio listed in the retrieve dialog. [It would be useful to see the portfolio name in the preview screen - i.e. the name specified by the user in the previous screen.] 3) I cannot account for why I couldn't see the 7 FINPX transactions yesterday. I must have got myself confused by the various option settings. Conclusion - I now have my new FINPX transactions recorded. I finally figured out why FM thought the PEO transaction was not recorded. I apparently entered it manually, but with the reinvestment flag set. The actual transaction was not re-invested. I finally noticed this, deleted it, and completed the correct retrieval. Mark, FM is an excellent product and your help was useful to get me through this hurdle.
|
| FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy |
| Copyright ©1993-2025 Beiley Software, Inc. All rights reserved. |