Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

save portfolio as csv

Questions on using, creating, or understanding data in Fund Manager reports.

Postby alpappy » Fri May 03, 2024 2:26 pm

HI Mark
Is it posible to save my portfolio as csv to import into a spreadsheet How can I do that
thanks
alan
alpappy
 
Posts: 366
Joined: Sat Aug 17, 2013 3:59 am

Postby alpappy » Fri May 03, 2024 2:30 pm

when I try export it says format illegal? Alan
alpappy
 
Posts: 366
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Fri May 03, 2024 2:57 pm

Hi alpappy,

What about your portfolio exactly are you trying to export? All the transactions? The current holdings? Any report can be saved to a CSV file using "File / Export to CSV..." from within that report window. If you want all the transactions exported to a CSV file you can either export an Investment Transactions report, or customize it more with "File / Export / Transactions / Generic..." and where it asks for an "Export Format" use something like this:

SYMB,MM/DD/YY,TRAN,ANUM,BNUM,CNUM

Press "Help" in that dialog for more detailed instructions, but it might be simpler to just export a report if that meets your needs.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11598
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Fri May 03, 2024 3:05 pm

HI My accountant wants spread sheet format of the transaction for financial year buy sell dividends tax paid and buy commisions Will that format do all of that thanks alan
alpappy
 
Posts: 366
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Fri May 03, 2024 3:09 pm

Yes, you can create an Investment Transaction report for the year, and export it to CSV with "File / Export to CSV...".
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11598
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Fri May 03, 2024 8:29 pm

Thanks Mark using the transaction report worked perfectly Tax done in no time
Kind regards
alan
alpappy
 
Posts: 366
Joined: Sat Aug 17, 2013 3:59 am


Return to Reports

Who is online

Users browsing this forum: No registered users and 7 guests

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