Portfolio Value Report - Acquisition Date

by **rojeg** » Mon Jul 25, 2011 8:42 am

Hi

In the portfolio value report I would like to show a column with the acqusition date of each investment. How can I do this?

Thanks!

Rojeg

by **aviator** » Mon Jul 25, 2011 9:00 am

Hi Rojeg,

Mark is on vacation, so I'll take a stab at answering your question.

Have you considered creating a custom report? After creating the report, click on Custom Settings. From here you can add or remove columns based on what you need. The column you're looking for, the acquisition date of each investment, is the Investment Inception Date.

Good luck.

by **rojeg** » Mon Jul 25, 2011 11:19 am

Thanks, Aviator, many thanks.

Now I have a problem with the files I have creaated on my laptop. I have on my desktop installed the latest version (trial) but it wants me to convert the files. The conversion did not work, I can only see the portfolios in the portfolio editor but not the investments. I need help urgently.

Thanks!

Rojeg

by **aviator** » Mon Jul 25, 2011 1:01 pm

A few questions, please:

1. What version did you have on your laptop and what version on the desktop?

2. How did you do the conversion? Did you backup on the laptop and restore on the desktop? Or did you copy files or use some other method? If you haven't already tried the backup/restore method, I'd start there. (Click on File... Backup on the laptop, and then File... Restore on the desktop). Your backup on the laptop will create a .FMB file. Get that file to the desktop and try restoring it.

3. When you say the conversion "did not work", did you get error messages?

by **rojeg** » Mon Jul 25, 2011 4:12 pm

I appreciate your quick response, very useful.

I am still in the trial phase so I need to build a model portfolio fast to evaluate the program. I think I messed up when I did install the trial version on 3 PC's (Home 1 (XP), Home 2 (XP 64-bit), Laptop (XP).

I have, I think, always downloaded the latest trial version (11.2), but I do not remember exactly whether it was professional or advisor version (does it matter?). I started to build the model portfolio structure on Sat on Home 1 machine and put all files in a fundmanager archive in the cloud. I could then use these files today on my laptop using again the 11.2 version. I then installed this evening 11.2 on the Home 2 machine. The problem started when I wanted to open the portfolio file: I was asked whether I wanted to convert to the new file format in 11.2 and I pressed the yes button with error message: "investment.dat specified could not be found"...then "unable to find the investment in this location...

The program did see my portfolio file, but not the data files anymore.

I then decided to enter my (sample) investments again since I had the portfolio structure maintained. Before I had removed the (old) data files in a back-up archive. Now all this works again, but when I try to open the "old" portfolio ==> it opens but still cannot open the "old" data files!

I am curious to learn tomorrow whether the laptop machine does recognize the newly entered investment data files.

I would not be surprised if the problem was created by the 64-bit XP version on my Home 2 machine?

In any case thank you for your quick response, the program so far seems to do the trick for me especially the multi-currency functionality is very useful.

Thanks!

Rojeg

by **aviator** » Tue Jul 26, 2011 2:59 am

It sounds like you're trying to use the same data files on different machines, with the data stored in the cloud. Frankly, I'm not sure FM has that capability and, even if it does, I have no experience using that method.

Given the problems you're having with so many computers, I still think your best bet is to do a backup and restore until you've had a chance to fully evaluate the product.

Good luck.

by **rojeg** » Tue Jul 26, 2011 3:01 am

Hi Aviator

Thanks again for your help.

I could solve the problem: when I store the files in the cloud (service I use is Livedrive) the files get an ending of "investment.dat.ld" on the cloud server before they are retrieved then the first time from another client. The problem entirely is created by this "ld" file extension. In future, I will use another service (dropbox or other) to store my files in the cloud.

Another question on reports: when I do portfolio value including all sub-portfolios it always shows the grand-total of the subportfolios again at the end of the report:

investment x
investment y
Sub-total sub-portfolio A

investment x
investment y
Sub-total sub-portfolio B

sub-total sub-portfolio A
sub-total sub-portfolio B

Total Portfolio

Is there a way to avoid repeating the sub-totals of sub-portfolio at the end of the report? I am sure this is for certain people confusing (double counting)

Thanks again!

Great help!

by **aviator** » Tue Jul 26, 2011 2:02 pm

The only solution I have is to export the report to a CSV (from the report, File...Export to CSV...), open in Excel and delete the rows you don't want.

by **rojeg** » Tue Jul 26, 2011 2:17 pm

Tthat's what I thought to be the work around.

Look forward to enhanced report functionality in future upgrades!

PS: Just bought the advisor licence! I need to get my portfolio done as ap.

thank you for the help and responses.

Rojeg

Portfolio Value Report - Acquisition Date

Who is online