Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Importing Historical Vanguard data

Questions about updating prices or transactions in Fund Manager

Postby Briarned » Thu May 23, 2019 9:52 am

I am trying to import some CSV formatted data from Vanguard that goes farther back than 18 month that Vanguard allows for OFX pull. I converted most of the transaction types to the proper TRAN key values, but not sure how to proceed with some transfer (cash deposit/withdrwal) type transactions. Based on the help file, it seems TXOUT/TXIN are the most appropriate keys, yet they expect a value for number of shares. How should I handle such transactions?
Attachments
2019-05-23 09_49_30-Window.png
2019-05-23 09_49_30-Window.png (21.55 KiB) Viewed 1532 times
Briarned
 
Posts: 2
Joined: Wed May 22, 2019 1:20 pm

Postby Mark » Thu May 23, 2019 10:16 am

Hi Briarned,

If you are withdrawing or adding cash, this can be just a SELL or BUY of cash. Cash is just like any other investment, but you keep the price fixed at 1. So, if you withdraw $1,000, record a SELL of 1,000 shares at a price of $1/share.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby aviator » Thu May 23, 2019 10:18 am

I think it depends on the origin or destination of your cash. If the accounts are within Fund Manager, the transfer in/out would be used. In my case, retail bank accounts are where transactions like these begin or end. Since FM doesn't support retail banking (hint, hint, Mark), I just delete those transactions. However, if the cash originates in or is destined to another FM account, I use transfers instead.
aviator
 
Posts: 419
Joined: Thu Jul 09, 2009 4:47 am

Postby Briarned » Thu May 23, 2019 11:01 am

Thank you, I'll give it a try.
Briarned
 
Posts: 2
Joined: Wed May 22, 2019 1:20 pm


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 15 guests

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