Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #6  
Old 03-08-2007, 02:53 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How to track costs when changing investments within IRA stock

In microsoft.public.money, Howard Kaikow wrote:

- quote -

> 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.


The Total Return columns of the Portfolio view do that.

- quote -

> 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.ultrasoft.com/MoneyLink/overview.shtml would probably be
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  
Old 03-08-2007, 02:27 PM
Howard Kaikow
Guest
 
Posts: n/a
Default Re: How to track costs when changing investments within IRA stock

"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  
Old 03-06-2007, 12:47 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How to track costs when changing investments within IRA stock

In microsoft.public.money, Frustrated wrote:

- 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.


Split the shares 19853 shares for every 43417 shares
The error factor is a negligible 0.50059 parts per Billion.
  #3  
Old 03-06-2007, 12:05 AM
Frustrated
Guest
 
Posts: n/a
Default Re: How to track costs when changing investments within IRA stock

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  
Old 03-05-2007, 05:14 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How to track costs when changing investments within IRA stock

In microsoft.public.money, Frustrated wrote:

- quote -

> 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.



- 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  
Old 03-05-2007, 04:52 PM
Frustrated
Guest
 
Posts: n/a
Default Re: How to track costs when changing investments within IRA stock

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?

 
Old 03-03-2007, 04:29 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How to track costs when changing investments within IRA stock acct

In microsoft.public.money, Frustrated wrote:

- quote -

> 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  
Old 03-03-2007, 04:15 PM
Frustrated
Guest
 
Posts: n/a
Default How to track costs when changing investments within IRA stock acct

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

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 09:16 PM.