Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Import

Questions about updating prices or transactions in Fund Manager

Postby JFM » Sun Jan 26, 2020 3:09 pm

Trying to use the file/import/transaction/generic function. See attached. What am I doing wrong?
Attachments
Note to FM.xlsx
A sample of the problem
(11 KiB) Downloaded 208 times
JFM
 
Posts: 13
Joined: Thu Nov 08, 2007 5:24 pm

Postby Mark » Mon Jan 27, 2020 9:41 am

Hi JFM,

Can you attach the .CSV file you're importing, and also tell me the format string you're using?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby JFM » Mon Jan 27, 2020 10:20 am

The format string I used is

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

Attached is the .csv file.

Thanks for the help
Attachments
Test of ALGN.csv
(106 Bytes) Downloaded 219 times
JFM
 
Posts: 13
Joined: Thu Nov 08, 2007 5:24 pm

Postby JFM » Tue Jan 28, 2020 9:03 am

Found the problem - looking closely at the header string, I had a "." and not a ","! Duuuuugh! Thanks. It works fine now.
JFM
 
Posts: 13
Joined: Thu Nov 08, 2007 5:24 pm

Postby Mark » Tue Jan 28, 2020 9:23 am

Hi JFM,

Great, glad you solved it.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
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 12 guests

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