|
#6
| |||
| |||
| In microsoft.public.money, Howard Kaikow wrote: - quote - > The number of shares is irrelevant, all you need is the value of the
The Total Return columns of the Portfolio view do that.> security position each day. > I do not yet have MSFT Money (I asked some questions earlier today that will > enable me to decide whether to purchase). > You seem to want the equivalent of the XIRR function in Excel. - quote - > In my case, I download the portfolio positions CSV file from Fidelity just http://www.ultrasoft.com/MoneyLink/overview.shtml would probably be> about every day, then I have a VB program (that I wrote) to grab the values > from the CSV files and plug them into the Excel spreadsheet. very useful to you if you used Money. http://xl2qif.chez-alice.fr/links_en.php references some conversion programs. Perhaps you would find one of use or would want to contribute yours. Money can File-> Import OFX files. |
|
#5
| |||
| |||
| "Frustrated" <Frustrated[at]discussions.microsoft.com> wrote in message news:3CFA0AFF-139E-4B14-B1A6-1525DA6842BA[at]microsoft.com... - quote - > I understand this, but how do I do a negative split? The number of shares > went down instead of up. I went from 1320.305 shares when it was AIM > Aggressive Growth down to 603.727 shares when it changed to AIM > Constellation. By the way, thanks for trying to help out. The number of shares is irrelevant, all you need is the value of the security position each day. I do not yet have MSFT Money (I asked some questions earlier today that will enable me to decide whether to purchase). You seem to want the equivalent of the XIRR function in Excel. In my case, I download the portfolio positions CSV file from Fidelity just about every day, then I have a VB program (that I wrote) to grab the values from the CSV files and plug them into the Excel spreadsheet. -- http://www.standards.com/; See Howard Kaikow's web site. |
|
#4
| |||
| |||
| In microsoft.public.money, Frustrated wrote: - quote - > I understand this, but how do I do a negative split? The number of shares
Split the shares 19853 shares for every 43417 shares> went down instead of up. I went from 1320.305 shares when it was AIM > Aggressive Growth down to 603.727 shares when it changed to AIM > Constellation. The error factor is a negligible 0.50059 parts per Billion. |
|
#3
| |||
| |||
| I understand this, but how do I do a negative split? The number of shares went down instead of up. I went from 1320.305 shares when it was AIM Aggressive Growth down to 603.727 shares when it changed to AIM Constellation. By the way, thanks for trying to help out. "Cal Learner-- MVP" wrote: - quote - > In microsoft.public.money, Frustrated wrote: > > I have one mutual fund in this particular account, AIM Aggressive Growth. In > > 2002, it was reorganized, renamed to AIM Constellation, the stock count > > lowered by more than half and repriced at a higher market rate. The only way > > I found to do this in Money 2007 was to either show a sell of the old name > > (AIM AG) and a buy of the new (AiM Const) which of course then only showed > > the cost of the new purchase as my cost basis) or I could change all the past > > purchase transactions to adjust the stock qty down at each purchase price > > over the prior years (which is the route I ended up taking, the same route > > that my Morgan Keegan account activity shows online). This was the closest > > way I could find to keep an accurate accounting of my actual investment vs. > > gain/loss on the fund. Any suggestions? > Yes, at least if it comes up again. Doing it at this time could be a > chore assuming you are downloading transactions. That doesn't mean > its not worth trying. If you are not downloading, it is only a small > chore. > So before I describe what you might do at this later date, I will > describe what you would want to do if it occurred again for another > fund: > =========================== > Change the symbol, rename the fund, add an appropriate comment, and > do an appropriate split to achieve the ratio you want. Post the > ratio you are trying to achieve if you want a suitable ratio of > integers to enter for the split. > Do this before downloading the new position data, or be prepared to > File-> Restore back to that point. During download, say the fund > already exists as the modified split fund. If there is then a > reference to the old fund, say it is a new fund called ZZZ1 or some > such. If you get it backwards, File-> Restore and try again. > ========================================= > This does not mean that you cannot deal with it today. It will just > be more complex, if you are up to it. > > > "Cal Learner-- MVP" wrote: > > > > In microsoft.public.money, Frustrated wrote: > > > > > > I have an investment account which is classified as an IRA, but I can use it > > > > the same way as a stock market account. However, when I try to track my > > > > total money invested amount vs. total gains, Money Premium 2007 just tracks > > > > the purchase price of the last stock or mutual fund purchased and shows the > > > > closed investment as a total negative. Am I doing something wrong or am I > > > > asking too much of this software? > > > > > Maybe. What are you looking for? > > > > > Suppose for ten months in a row, I buy 100 shares of WXYZ at $10 per > > > share on the first of each month, and I sell 100 shares of WXYZ at > > > $10.10 per share on the fifteenth of each month. What number(s) > > > would you be looking for? > > > > |
|
#2
| |||
| |||
| In microsoft.public.money, Frustrated wrote: - quote - > I have one mutual fund in this particular account, AIM Aggressive Growth. In
Yes, at least if it comes up again. Doing it at this time could be a> 2002, it was reorganized, renamed to AIM Constellation, the stock count > lowered by more than half and repriced at a higher market rate. The only way > I found to do this in Money 2007 was to either show a sell of the old name > (AIM AG) and a buy of the new (AiM Const) which of course then only showed > the cost of the new purchase as my cost basis) or I could change all the past > purchase transactions to adjust the stock qty down at each purchase price > over the prior years (which is the route I ended up taking, the same route > that my Morgan Keegan account activity shows online). This was the closest > way I could find to keep an accurate accounting of my actual investment vs. > gain/loss on the fund. Any suggestions? chore assuming you are downloading transactions. That doesn't mean its not worth trying. If you are not downloading, it is only a small chore. So before I describe what you might do at this later date, I will describe what you would want to do if it occurred again for another fund: =========================== Change the symbol, rename the fund, add an appropriate comment, and do an appropriate split to achieve the ratio you want. Post the ratio you are trying to achieve if you want a suitable ratio of integers to enter for the split. Do this before downloading the new position data, or be prepared to File-> Restore back to that point. During download, say the fund already exists as the modified split fund. If there is then a reference to the old fund, say it is a new fund called ZZZ1 or some such. If you get it backwards, File-> Restore and try again. ========================================= This does not mean that you cannot deal with it today. It will just be more complex, if you are up to it. - quote - > "Cal Learner-- MVP" wrote: > > In microsoft.public.money, Frustrated wrote: > > > > I have an investment account which is classified as an IRA, but I can use it > > > the same way as a stock market account. However, when I try to track my > > > total money invested amount vs. total gains, Money Premium 2007 just tracks > > > the purchase price of the last stock or mutual fund purchased and shows the > > > closed investment as a total negative. Am I doing something wrong or am I > > > asking too much of this software? > > > Maybe. What are you looking for? > > > Suppose for ten months in a row, I buy 100 shares of WXYZ at $10 per > > share on the first of each month, and I sell 100 shares of WXYZ at > > $10.10 per share on the fifteenth of each month. What number(s) > > would you be looking for? > > |
|
#1
| |||
| |||
| I have one mutual fund in this particular account, AIM Aggressive Growth. In 2002, it was reorganized, renamed to AIM Constellation, the stock count lowered by more than half and repriced at a higher market rate. The only way I found to do this in Money 2007 was to either show a sell of the old name (AIM AG) and a buy of the new (AiM Const) which of course then only showed the cost of the new purchase as my cost basis) or I could change all the past purchase transactions to adjust the stock qty down at each purchase price over the prior years (which is the route I ended up taking, the same route that my Morgan Keegan account activity shows online). This was the closest way I could find to keep an accurate accounting of my actual investment vs. gain/loss on the fund. Any suggestions? "Cal Learner-- MVP" wrote: - quote - > In microsoft.public.money, Frustrated wrote: > > I have an investment account which is classified as an IRA, but I can use it > > the same way as a stock market account. However, when I try to track my > > total money invested amount vs. total gains, Money Premium 2007 just tracks > > the purchase price of the last stock or mutual fund purchased and shows the > > closed investment as a total negative. Am I doing something wrong or am I > > asking too much of this software? > Maybe. What are you looking for? > Suppose for ten months in a row, I buy 100 shares of WXYZ at $10 per > share on the first of each month, and I sell 100 shares of WXYZ at > $10.10 per share on the fifteenth of each month. What number(s) > would you be looking for? |
| | |||
| |||
| In microsoft.public.money, Frustrated wrote: - quote - > I have an investment account which is classified as an IRA, but I can use it
Maybe. What are you looking for?> the same way as a stock market account. However, when I try to track my > total money invested amount vs. total gains, Money Premium 2007 just tracks > the purchase price of the last stock or mutual fund purchased and shows the > closed investment as a total negative. Am I doing something wrong or am I > asking too much of this software? Suppose for ten months in a row, I buy 100 shares of WXYZ at $10 per share on the first of each month, and I sell 100 shares of WXYZ at $10.10 per share on the fifteenth of each month. What number(s) would you be looking for? |
|
#-1
| |||
| |||
| I have an investment account which is classified as an IRA, but I can use it the same way as a stock market account. However, when I try to track my total money invested amount vs. total gains, Money Premium 2007 just tracks the purchase price of the last stock or mutual fund purchased and shows the closed investment as a total negative. Am I doing something wrong or am I asking too much of this software? |
| Tags |
| acct, changing, costs, investments, ira, stock, track |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Using Money to keep Track of Mileage Costs Remove ABCD from Email address to reply: Does anyone have an easy way to use Money to keep track of my business mileage costs? Now I use a spreadsheet to keep all of the mileage and then... | Microsoft Money | 2 | 10-09-2006 07:19 PM | |
| How Can I Track Investments by CUSIP Craig: Hello, I have Money 2006 Deluxe and am entering two new investments that are causing me fits. 1) A bond. I have the CUSIP number and I enter... | Microsoft Money | 5 | 01-16-2006 09:08 PM | |
| Changing Stock Ticker Symbols srazook: Is there any way to change the ticker symbol for a stock or mutual fund without having to create a whole new investment? | Microsoft Money | 1 | 08-22-2005 03:05 PM | |
| track ^SPX and add investments to watch ab: Hi, Whenever I try to compare the performance of an investment (stock or fund) with a major index (S&P 500 or DJIA), I get an error saying "You... | Microsoft Money | 8 | 04-04-2005 12:19 AM | |
| Thread Tools | |
| Display Modes | |
| |