Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #5  
Old 01-11-2007, 07:32 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Investment re-valuing

Thanks for the feedback. Glad you got this sorted out.

"Jeff Micksch" <jmicksch[at]newsgroups.nospam> wrote in message
news:ulbg0kbNHHA.5016[at]TK2MSFTNGP04.phx.gbl...
- quote -

> Thought I had replied to this a while ago.
> I had the numbers reversed between the old and new values for the split
> functionality. I just needed to use the split functionality correctly.
> After I put the numbers in the correct boxes, it did what I expected.



  #4  
Old 01-11-2007, 06:46 PM
Jeff Micksch
Guest
 
Posts: n/a
Default Re: Investment re-valuing

Thought I had replied to this a while ago.

I had the numbers reversed between the old and new values for the split
functionality. I just needed to use the split functionality correctly.
After I put the numbers in the correct boxes, it did what I expected.

Thanks for your help.

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:OscFTt0KHHA.2232[at]TK2MSFTNGP02.phx.gbl...
- quote -

> Perhaps you don't understand what a split does in Money. It goes in and
> adjusts every transaction prior to the split to compensate for the split
> so that all transactions are now relative to the new price/number of
> shares. This should adjust the sum total number of shares from all of the
> previous transactions to be (with some small error) the post-split total
> number of shares. The total dollar number of each adjusted transaction
> remains the same.
> Example:
> Pre-split txn entered: Buy 10 shares at $10, total txn $100.
> Pre-split txn entered: Buy 10 shares at $15, total txn $150.
> (Total cost basis $250, # shares: 20)
> Enter a 2-1 split
> Prior txn adjusted to: Buy 20 shares at $5, total txn $100.
> Prior txn adjusted to: Buy 20 shares at $7.50, total txn $150.
> (Total cost basis $250, # shares: 40)
> Note that all of the prior prices per share are adjusted and an S (for
> split) is appended when the price is displayed in the register or price
> history to indicate that this is a split-adjusted price.
> "Jeff Micksch" <JeffMicksch[at]discussions.microsoft.com> wrote in message
> news:711588DB-035E-4CD8-B8C1-F575D33B3CF9[at]microsoft.com...
> > I tried the split functionality using the calculator, but it didn't do
> > what I
> > expected. It went back in time and changed all my previous transaction
> > values
> > to be more than they originally were (by the split ratio amount). I was
> > expecting it to keep my total amount constant, adjust the total shares by
> > the
> > split ratio, and then calculate the new price for the new amount of
> > shares so
> > that the total amount does remain constant. Am I missing something here?
> > Maybe I just don't understand the split functionality.



  #3  
Old 12-29-2006, 12:15 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Investment re-valuing

Perhaps you don't understand what a split does in Money. It goes in and
adjusts every transaction prior to the split to compensate for the split so
that all transactions are now relative to the new price/number of shares.
This should adjust the sum total number of shares from all of the previous
transactions to be (with some small error) the post-split total number of
shares. The total dollar number of each adjusted transaction remains the
same.

Example:

Pre-split txn entered: Buy 10 shares at $10, total txn $100.
Pre-split txn entered: Buy 10 shares at $15, total txn $150.
(Total cost basis $250, # shares: 20)

Enter a 2-1 split

Prior txn adjusted to: Buy 20 shares at $5, total txn $100.
Prior txn adjusted to: Buy 20 shares at $7.50, total txn $150.
(Total cost basis $250, # shares: 40)

Note that all of the prior prices per share are adjusted and an S (for
split) is appended when the price is displayed in the register or price
history to indicate that this is a split-adjusted price.

"Jeff Micksch" <JeffMicksch[at]discussions.microsoft.com> wrote in message
news:711588DB-035E-4CD8-B8C1-F575D33B3CF9[at]microsoft.com...
- quote -

> I tried the split functionality using the calculator, but it didn't do what
> I
> expected. It went back in time and changed all my previous transaction
> values
> to be more than they originally were (by the split ratio amount). I was
> expecting it to keep my total amount constant, adjust the total shares by
> the
> split ratio, and then calculate the new price for the new amount of shares
> so
> that the total amount does remain constant. Am I missing something here?
> Maybe I just don't understand the split functionality.



  #2  
Old 12-29-2006, 04:44 AM
Jeff Micksch
Guest
 
Posts: n/a
Default Re: Investment re-valuing

I tried the split functionality using the calculator, but it didn't do what I
expected. It went back in time and changed all my previous transaction values
to be more than they originally were (by the split ratio amount). I was
expecting it to keep my total amount constant, adjust the total shares by the
split ratio, and then calculate the new price for the new amount of shares so
that the total amount does remain constant. Am I missing something here?
Maybe I just don't understand the split functionality.

"Dick Watson" wrote:

- quote -

> 1) If you insist on tracking the shares/values, then I'd do a stock split
> for this one. Use the before amount of shares as the initial value and the
> after amount of shares as the end value. Money insists on integral splits
> with 16-bit numbers. (Why? Who knows? There are many signs nobody who
> develops/specifies the product actually uses it to manage real
> finances/investments so perhaps they just really think all splits are
> integral.) To convert from oddball numbers like, say 98.8649 units before
> split for 206.6546 units after to integers, you can use a calculator
> available at http://umpmfaq.info/IntegralSplits.htm.
> 2) What I do for these oddball private investments is just use $1 shares in
> the amount of the $ value of the investment. When I get a statement or some
> such, I use the Update Account link on the Investment Account|Account
> Summary page. When I poke in the dollar value, it enters Add/Remove Shares
> transactions as appropriate. I maybe lose a little bit of reporting
> capability but save a lot of hassle tracking these bogus numbers. The FIs
> love to do this to obfuscate how much they are scraping off the top of 401k
> plans. It ought to be a scandal.
> "Jeff Micksch" <JeffMicksch[at]discussions.microsoft.com> wrote in message
> news:18A36F61-7B66-4DA5-833F-7356658ED499[at]microsoft.com...
> > My 401(k) company uses fractional shares and fractional values. The
> > accounts
> > they use are not directly referenced on any particular exchange. I had to
> > manually create the accounts, and I have to manually update the prices.
> > recently, two of the investments were "re-valued". They reference it as a
> > "Transfer" but all that really happens is all my shares for a given
> > investment were listed as negative transactions with the current unit
> > value
> > (so that the dollar value of the transaction was negative). Then they
> > immediately followed that with a positive transaction for the new unit
> > value
> > (so that the dollar value of the transaction was positive--for the same
> > amount as the negative transaction). So, if I had 98.8649 units at
> > 2.131789
> > value for a total of 210.76, that is what the negative transaction was.
> > Then
> > the new transaction was for the new value of 1.019866 and 206.6546 units
> > again for a total of 210.76--that is what the positive transaction was.
> > It's
> > kind of like a split, but not in even enough amounts to use the "split"
> > functionality that Money offers. I decided to record it as a sell with a
> > subsequent off-setting buy, but this screws up the realized gains, the
> > purchases, and return. I tried to transfer, but I can't transfer to
> > anywhere
> > but another account (which I don't have). does anyone have any suggestions
> > about how to properly capture this re-valuing?

  #1  
Old 12-27-2006, 01:06 PM
jwbspam@hotmail.com
Guest
 
Posts: n/a
Default Re: Investment re-valuing

I completely agree that the unit values method should be a national
scandal and should be outlawed. My 401k company (Nationwide) does it
this way, and it is entirely impossible to know anything about your own
money or the fees except the bottom line which NEVER matches with
reality no matter how many what-if's you calculate. But like many
employees out there, we have no better pre-tax alternatives and are
helpless to get anything changed on a corporate level.

Having ranted that, I would suggest to the original poster that what
you may be seeing is a perfectly legal end-of-year distribution, where
gains made by a mutual fund during the year are by law distributed to
shareholders. The gains were reinvested for you, but the share price
is adjusted by the amount of the distribution so the total value change
is basically net zero, but you do end up with more shares going forward
which is a good thing. Consider yourself lucky to actually see any of
this. My 401k fund choices have had distributions for years but there
is never the slightest indication of this activity on the paper
statement or on the Web account.

 
Old 12-26-2006, 11:25 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Investment re-valuing

1) If you insist on tracking the shares/values, then I'd do a stock split
for this one. Use the before amount of shares as the initial value and the
after amount of shares as the end value. Money insists on integral splits
with 16-bit numbers. (Why? Who knows? There are many signs nobody who
develops/specifies the product actually uses it to manage real
finances/investments so perhaps they just really think all splits are
integral.) To convert from oddball numbers like, say 98.8649 units before
split for 206.6546 units after to integers, you can use a calculator
available at http://umpmfaq.info/IntegralSplits.htm.

2) What I do for these oddball private investments is just use $1 shares in
the amount of the $ value of the investment. When I get a statement or some
such, I use the Update Account link on the Investment Account|Account
Summary page. When I poke in the dollar value, it enters Add/Remove Shares
transactions as appropriate. I maybe lose a little bit of reporting
capability but save a lot of hassle tracking these bogus numbers. The FIs
love to do this to obfuscate how much they are scraping off the top of 401k
plans. It ought to be a scandal.

"Jeff Micksch" <JeffMicksch[at]discussions.microsoft.com> wrote in message
news:18A36F61-7B66-4DA5-833F-7356658ED499[at]microsoft.com...
- quote -

> My 401(k) company uses fractional shares and fractional values. The
> accounts
> they use are not directly referenced on any particular exchange. I had to
> manually create the accounts, and I have to manually update the prices.
> recently, two of the investments were "re-valued". They reference it as a
> "Transfer" but all that really happens is all my shares for a given
> investment were listed as negative transactions with the current unit
> value
> (so that the dollar value of the transaction was negative). Then they
> immediately followed that with a positive transaction for the new unit
> value
> (so that the dollar value of the transaction was positive--for the same
> amount as the negative transaction). So, if I had 98.8649 units at
> 2.131789
> value for a total of 210.76, that is what the negative transaction was.
> Then
> the new transaction was for the new value of 1.019866 and 206.6546 units
> again for a total of 210.76--that is what the positive transaction was.
> It's
> kind of like a split, but not in even enough amounts to use the "split"
> functionality that Money offers. I decided to record it as a sell with a
> subsequent off-setting buy, but this screws up the realized gains, the
> purchases, and return. I tried to transfer, but I can't transfer to
> anywhere
> but another account (which I don't have). does anyone have any suggestions
> about how to properly capture this re-valuing?



  #-1  
Old 12-26-2006, 10:24 PM
Jeff Micksch
Guest
 
Posts: n/a
Default Investment re-valuing

My 401(k) company uses fractional shares and fractional values. The accounts
they use are not directly referenced on any particular exchange. I had to
manually create the accounts, and I have to manually update the prices.
recently, two of the investments were "re-valued". They reference it as a
"Transfer" but all that really happens is all my shares for a given
investment were listed as negative transactions with the current unit value
(so that the dollar value of the transaction was negative). Then they
immediately followed that with a positive transaction for the new unit value
(so that the dollar value of the transaction was positive--for the same
amount as the negative transaction). So, if I had 98.8649 units at 2.131789
value for a total of 210.76, that is what the negative transaction was. Then
the new transaction was for the new value of 1.019866 and 206.6546 units
again for a total of 210.76--that is what the positive transaction was. It's
kind of like a split, but not in even enough amounts to use the "split"
functionality that Money offers. I decided to record it as a sell with a
subsequent off-setting buy, but this screws up the realized gains, the
purchases, and return. I tried to transfer, but I can't transfer to anywhere
but another account (which I don't have). does anyone have any suggestions
about how to properly capture this re-valuing?
 

Tags
investment, revaluing
Similar Threads
Thread Forum Replies Last Post
Can't delete Money investment; investment gets recreated after every download
RM: Hi, I'm running into an annoying issue with Money 2006: A while ago I accidentally set up two investments for MSFT: one with an associated stock...
Microsoft Money 6 09-06-2005 12:34 PM
Can't rename investment because deleted investment has the same name
Mike: I have an investment that gets downloaded as "Blah Blah (0021)" from my financial institution, and I would like to view the investment as "Blah...
Microsoft Money 4 08-19-2004 11:33 PM



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 10:24 PM.