Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Exporting Portfolio value into Fasttrack FNU format

Comments, critical feedback, praise, or suggestions for new features.

Postby abfs » Mon Jan 17, 2011 12:23 pm

Hi new to the fund Manager:

Can you add Fasttrack FNUformat to your export?
Link to the format:

http://www.fasttrack.net/newhelp/fundnodb.asp

File Format:

The file must be in ASCII text format, i.e.,variable length lines of text with carriage returns at the end of each line.

Line 1 should be the ticker symbol (usually the file name without extension). Five characters maximum.
Line 2 should be the name of the mutual fund, stock, etc. Forty characters maximum.
Lines 3 through the end of the file must have the date, price and distribution, if any, on that date. For example, if on Mar 4, 1991 the price was 35 5/8 and the equity went x-dividend with a dividend of $0.30. The corresponding line in the ASCII file would be:

03/04/91, 35.625,0.3

The date may or may not be surrounded by quotes. Both ways work.

Miscellaneous Requirements

Spaces are insignificant.
Commas are required.
Decimal points are required.
If you have no distribution data, insert 0 for the distribution on each line.
FastTrack will give line number error messages when invalid formats are encountered. These messages usually are not fatal.
FastTrack resynchronizes itself to the next valid line of data when a format problem has been detected. This means that your chart may appear to be perfect except that data discarded due to format problems will appear as a short (perhaps undetectable) horizontal line on the chart.
abfs
 
Posts: 1
Joined: Mon Jan 17, 2011 12:02 pm

Postby Mark » Mon Jan 17, 2011 5:10 pm

Hi abfs,

Thanks for the suggestion. We can consider this for a future update.

You can currently export portfolio value to an ASCII file using "File / Export / Other / Portfolio Value". It isn't in the exact format described below, but could probably be edited into that format using Excel or some other such tool.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11712
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Feedback

Who is online

Users browsing this forum: No registered users and 16 guests

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