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