Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Exporting Transactions

Questions about updating prices or transactions in Fund Manager

Postby Bsrr » Fri Dec 08, 2023 12:09 pm

I am suing the following format to export transactions from FM to Generic CSV.

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

Some of the values in FM are "negative" values and show up in red in FM with a minus sign in front of the Total Value column (for example a money fund redemption from my money market account) but when exported to CSV they don't show up as "negative" in my spreadsheet. See attached 2 screen shots - one screenshot with how the transaction looks in FM and one screenshot with the result in my spreadsheet (see the values 18.42 and 27.58 in the attached screenshots).

I can't find anything in the Format info online on the FM website that would allow me to have the "negative" values show up in my exported CSV value as negatives. Is this possible? Thanks.
Attachments
Trans in FM.png
This is how the transactions look in FM
Trans in FM.png (13.94 KiB) Viewed 1116 times
Trans Export from FM.png
This is how the transactions look in the exported CSV file
Trans Export from FM.png (65.04 KiB) Viewed 1116 times
Bsrr
 
Posts: 7
Joined: Wed Oct 04, 2023 7:06 pm

Postby Mark » Fri Dec 08, 2023 3:00 pm

Hi Bsrr,

The information about them being negative is stored in the transaction code of SELL. Since it is a sell, they show up as negative in FM, but the generic format has all positive values, plus the SELL transaction code. If you needed negative numbers for some other reason, you could write an equation that looks for SELL as a transaction code, and then manipulate your other numbers.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11297
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Bsrr » Sat Dec 09, 2023 3:25 pm

Thank you.
Bsrr
 
Posts: 7
Joined: Wed Oct 04, 2023 7:06 pm


Return to Prices and Transactions

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.