Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Exporting Prices from MS Money

Questions about updating prices or transactions in Fund Manager

Postby adennis » Sat Sep 19, 2009 11:47 pm

Mark

as a seperate topic so that others who follow can search it if they too have this problem.

Though MsMoney does not have an apparant method the following works well

Reports>Investments>Price History

use Multiple Investments and Custom Dates to choose those you need

right click> export (as txt file)

copy in xl and change any formatting into required import format for FM

(nb if it is dates u get stuck on do column to txt to seperate out dd/mm/yy into constituent parts and then use =E1&"/"&F1&"/"&G1 or similar to bring them back together as mm/dd/yy)
adennis
 
Posts: 8
Joined: Mon Sep 14, 2009 9:07 am

Postby Mark » Sun Sep 20, 2009 12:58 pm

Excellent tip, thank you for sharing.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11660
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 21 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2025 Beiley Software, Inc. All rights reserved.