Microsoft Money Plus: how to disassociate a mutual fund or stock from it's CUSIP


waynekford

Active member
Member
Local time
12:05 PM
Posts
6
OS
Windows 10
I have a set of investment that were first entered into Money a long time ago and appear to have an incorrect CUSIP. When I download transactions Money wants to associate them with a different set of tickers. I know at one time there were instructions on-line on a board on how to disassociate a mutual fund (or a stock?) from its CUSIP so that a new investment could be created with the correct CUSIP. The CUSIP is not accessible to the user; it has to be modified using an OFX file.

Does anyone know of a resource in which I can investigate this process/problem?
 

My Computer My Computer

At a glance

Windows 10Intel Core i7-1065g716 GB
OS
Windows 10
Computer type
Laptop
Manufacturer/Model
Microsoft Surface Laptop 3
CPU
Intel Core i7-1065g7
Memory
16 GB
Screen Resolution
2496 x 1664
Hard Drives
Toshiba 512G
Internet Speed
1 Gbps
Browser
Edge
Antivirus
Defender
I use Money 2005 which is the latest UK version of MS Money. I also use MSMoneyQuotes to download share and fund prices. The site explains how to find the correct stock indices needed.


The links on the site lead to this tool to find the correct stock index.


There is also a Google Group where you can post questions.


I have 25+ years financial transactions in my Money file and fear the day MS Money won't run in Windows. My backup plan is then to run it in a Windows Virtual Machine which I've proven using a Hyper V Windows XP VM!
 
Last edited:

My Computer My Computer

At a glance

Windows 11 ProCore i7-13700K64 GB Kingston Fury Beast DDR5Gigabyte GeForce RTX 2060 Super Gaming OC 8G
OS
Windows 11 Pro
Computer type
PC/Desktop
Manufacturer/Model
Self build
CPU
Core i7-13700K
Motherboard
Asus TUF Gaming Plus WiFi Z790
Memory
64 GB Kingston Fury Beast DDR5
Graphics Card(s)
Gigabyte GeForce RTX 2060 Super Gaming OC 8G
Sound Card
Realtek S1200A
Monitor(s) Displays
Viewsonic VP2770 & Dell (secondary)
Screen Resolution
2560 x 1440
Hard Drives
Kingston KC3000 2TB NVME SSD & SATA HDDs & SSD
PSU
EVGA SuperNova G2 850W
Case
Nanoxia Deep Silence 1
Cooling
Noctua NH-D14
Keyboard
Microsoft Digital Media Pro
Mouse
Logitech Wireless
Internet Speed
80 Mb / s
Browser
Chrome
Antivirus
Defender, Malwarebytes Free & AdwCleaner
Thanks for the link info.

BTW, I've run the app on Windows 11 as well as Windows 10 and it behaves the same way. Certain things don't work or don't work well. I have found that there are easy work arounds, but no brick walls. I really haven't had much problem with new operating systems over the years, though I don't use the full capability of MSMoney that I once did. BTW, eight years ago and with much older hardware I tested MSMoney in a VM. It worked fine. I simply didn't see the need to continue in that fashion.

My basic problem is that MSMoney permits only simple buy and sell transactions when recording a Mutual Fund event. A short sale, for example, is disallowed. Conversely, when in MSMoney I assign an ETF as a stock, then all the transaction types for stocks apply. Years ago, I bought some ETF's and described them as stocks in MSMoney. I could download transactions and quotes directly, though later when quotes were turned off did so via qxf files. Then I moved the account to Vanguard, which describes the ETFs as mutual funds inside the qxf file downloads. Yet, the CUSIP numbers are the same and MSMoney uses the CUSIP to keep track of the investment. At present, it looks like I need to remove the CUSIP from the older investment transactions to make the downloads from Vanguard seamless. But, my problem is worse in that I have the same investment at a commercial quality trader, Interactive Brokers, which treats and describes ETF's as stocks (not MF's) in their qxf files. For now, I just want to properly rename the older transactions, which requires a change of the CUSIP. Keeping the transactions around is necessary for basis and gain calculations for income taxes.
 

My Computer My Computer

At a glance

Windows 10Intel Core i7-1065g716 GB
OS
Windows 10
Computer type
Laptop
Manufacturer/Model
Microsoft Surface Laptop 3
CPU
Intel Core i7-1065g7
Memory
16 GB
Screen Resolution
2496 x 1664
Hard Drives
Toshiba 512G
Internet Speed
1 Gbps
Browser
Edge
Antivirus
Defender
Thanks for the link info.

BTW, I've run the app on Windows 11 as well as Windows 10 and it behaves the same way. Certain things don't work or don't work well. I have found that there are easy work arounds, but no brick walls. I really haven't had much problem with new operating systems over the years, though I don't use the full capability of MSMoney that I once did. BTW, eight years ago and with much older hardware I tested MSMoney in a VM. It worked fine. I simply didn't see the need to continue in that fashion.

My basic problem is that MSMoney permits only simple buy and sell transactions when recording a Mutual Fund event. A short sale, for example, is disallowed. Conversely, when in MSMoney I assign an ETF as a stock, then all the transaction types for stocks apply. Years ago, I bought some ETF's and described them as stocks in MSMoney. I could download transactions and quotes directly, though later when quotes were turned off did so via qxf files. Then I moved the account to Vanguard, which describes the ETFs as mutual funds inside the qxf file downloads. Yet, the CUSIP numbers are the same and MSMoney uses the CUSIP to keep track of the investment. At present, it looks like I need to remove the CUSIP from the older investment transactions to make the downloads from Vanguard seamless. But, my problem is worse in that I have the same investment at a commercial quality trader, Interactive Brokers, which treats and describes ETF's as stocks (not MF's) in their qxf files. For now, I just want to properly rename the older transactions, which requires a change of the CUSIP. Keeping the transactions around is necessary for basis and gain calculations for income taxes.
You could post that on the Google Group I mentioned to seek solutions
 

My Computer My Computer

At a glance

Windows 11 ProCore i7-13700K64 GB Kingston Fury Beast DDR5Gigabyte GeForce RTX 2060 Super Gaming OC 8G
OS
Windows 11 Pro
Computer type
PC/Desktop
Manufacturer/Model
Self build
CPU
Core i7-13700K
Motherboard
Asus TUF Gaming Plus WiFi Z790
Memory
64 GB Kingston Fury Beast DDR5
Graphics Card(s)
Gigabyte GeForce RTX 2060 Super Gaming OC 8G
Sound Card
Realtek S1200A
Monitor(s) Displays
Viewsonic VP2770 & Dell (secondary)
Screen Resolution
2560 x 1440
Hard Drives
Kingston KC3000 2TB NVME SSD & SATA HDDs & SSD
PSU
EVGA SuperNova G2 850W
Case
Nanoxia Deep Silence 1
Cooling
Noctua NH-D14
Keyboard
Microsoft Digital Media Pro
Mouse
Logitech Wireless
Internet Speed
80 Mb / s
Browser
Chrome
Antivirus
Defender, Malwarebytes Free & AdwCleaner
Back
Top Bottom