Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

generic price import

Questions about updating prices or transactions in Fund Manager

Postby flight » Sat Jan 07, 2017 7:24 am

Mark,

Is this format string acceptable for importing generic (.txt file) prices?

09/22/09 3.50
09/23/09 3.25
09/24/09 3.55
09/25/09 3.05
09/28/09 4.25
09/29/09 4.25
09/30/09 4.70
10/01/09 4.36
10/02/09 4.14
10/05/09 4.09
10/06/09 3.56
10/07/09 3.42
10/08/09 3.50
10/09/09 3.10
10/12/09 3.25
10/13/09 3.20
10/14/09 3.16
10/15/09 3.00
10/16/09 2.88
10/19/09 2.99
10/20/09 3.30
10/21/09 3.27
10/22/09 3.96
10/23/09 3.80
10/26/09 3.84
10/27/09 4.03
10/28/09 3.84
10/29/09 3.40
10/30/09 3.29
11/02/09 3.27
11/03/09 3.50
11/04/09 3.44
11/05/09 3.16
11/06/09 3.56
11/09/09 3.40
11/10/09 3.85
11/11/09 3.84
11/12/09 3.95
11/13/09 3.38
11/16/09 3.37
11/17/09 3.27
11/18/09 3.44
11/19/09 3.39
11/20/09 3.14
11/23/09 3.20
11/24/09 3.25
11/25/09 3.48
11/27/09 3.10
11/30/09 3.13
12/01/09 3.16
12/02/09 3.17
12/03/09 3.06
12/04/09 3.10
12/07/09 3.00
12/08/09 3.05
12/09/09 3.15
12/10/09 2.88
12/11/09 2.93
12/14/09 3.15
12/15/09 3.14
12/16/09 3.10
12/17/09 2.79
12/18/09 2.99
12/21/09 2.78
12/22/09 2.74
12/23/09 2.59
12/24/09 2.70
12/28/09 2.84
12/29/09 2.93
12/30/09 2.92
12/31/09 2.80
flight
 
Posts: 151
Joined: Sun Jul 27, 2014 11:03 am

Postby Mark » Sat Jan 07, 2017 8:02 am

Hi flight,

Yes. You would use the format string:

MM/DD/YY NAV

and "Specify" the symbol.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby flight » Sat Jan 07, 2017 10:35 am

I thought so, but got the message "the specified input format did not match any lines in the imported file".

I used the one ending in PRN format
flight
 
Posts: 151
Joined: Sun Jul 27, 2014 11:03 am

Postby Mark » Sat Jan 07, 2017 3:09 pm

Hi flight,

I just test imported it using these settings, and it worked correctly. Did you look at your price file with a text editor? If you're viewing it in Excel there may be other formatting characters you're not seeing. I've attached the file I imported so you can try it too. The format string is:

MM/DD/YY NAV

and you must "Specify" the symbol, but not the date.
Attachments
prices.txt
price file
(1.04 KiB) Downloaded 230 times
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby flight » Sun Jan 08, 2017 6:54 am

that txt file didn't work either. i attached a screen shot.
Attachments
Capture.JPG
Capture.JPG (33.3 KiB) Viewed 2578 times
flight
 
Posts: 151
Joined: Sun Jul 27, 2014 11:03 am

Postby Mark » Sun Jan 08, 2017 11:54 am

Hi flight,

You aren't entering the format string. In the edit box that says "Input Format", you can type directly in there. You don't have to just press the down arrow and choose one of the recent ones. Type directly in that box, and enter:

MM/DD/YY NAV

which is the format of your data and that file.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby flight » Sun Jan 08, 2017 12:09 pm

That worked. Thanks Mark!
flight
 
Posts: 151
Joined: Sun Jul 27, 2014 11:03 am

Postby flight » Fri Feb 03, 2017 6:44 pm

Mark,

Is this a valid import for transactions:

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

GSIP BUY 07/30/12 15.95 62.6959 0
VSIP BUY 07/30/12 15.40 64.9351 0
GSIP BUY 09/27/12 16.81 34.652 0
VSIP BUY 09/27/12 16.10 36.1801 0
GSIP BUY 10/11/12 16.53 30.248 0
VSIP BUY 10/11/12 16.09 31.0752 0
GSIP BUY 10/12/12 16.53 30.248 0
VSIP BUY 10/12/12 15.99 31.2695 0
VSIP BUY 10/24/12 15.90 31.4465 0
GSIP BUY 10/24/12 16.19 30.8833 0
GSIP BUY 10/24/12 16.19 13.8975 0
VSIP BUY 10/24/12 15.90 14.1509 0
GSIP BUY 12/11/12 16.56 60.3865 0
VSIP BUY 12/11/12 16.14 61.9579 0
flight
 
Posts: 151
Joined: Sun Jul 27, 2014 11:03 am

Postby Mark » Fri Feb 03, 2017 8:10 pm

Hi flight,

Yes, but you need to enter the format string that matches the format of your data. Since your data is space delimited, use a space in your format string, instead of a comma. It would be:

SYMB TRAN MM/DD/YY ANUM BNUM CNUM
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 10 guests

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