Fund Manager 2016 and 0 Balance Shares

[dbender54]

In my Fund Manager reports (in the program), it is set not to show closed (zero share lot) values. In my Fund Manager reports, no closed shares positions are shown (which is as I want, but forgot where this is done?), but when I upload my (master) Portfolio (after setting up the User Name and Password), it is showing share transactions I've closed (sold), which obviously clutters up viewing my current positions.
I assume I can change this in the mobile app, but have not found where. In the Options-->Mobile/Web Access Preferences, Show Hidden Items is not checked. The issue (displaying positions which have long ago been closed) is the same in the web client.

[Mark]

Hi dbender54,

You'll want to "hide" your investments that have been sold. We have a tutorial on doing this here:

https://youtu.be/2bb7hSew_8g

Or, if you want the short version, use "File / File Operations / Hide Sold Investments..." and turn off "View / Hidden Investments/Portfolios". I'd suggest watching the tutorial, it covers all aspects of this, including the report option you're using now.

Once you hide your investments, and re-upload your mobile/web data they will be removed from those displays as well.

[dbender54]

Thanks and I'll review the video, but the sold investments do not appear in any of my reports. Why would they display in the upload?

[Mark]

Hi dbender54,

Because they aren't hidden. There is a report only option that prevents displaying investments with zero shares, but this is just for reports. If you mark the investments with the hidden attribute, then they will be hidden everywhere (graphs, portfolio editor, reports, mobile/web interfaces, etc).

[dbender54]

It's been so long since I made that choice, I'd forgotten that it was for the reports only, since that's all I really look at on a day to day basis.

Thank you.

[dbender54]

The default period under File-->File Operations-->Hide Sold Investments is today. If I leave it as that, the upload does correctly hide any sold investments, but is this a 'sticky' setting such that I don't need to change it when performing an upload, unless I want to change the date range or one of the checkbox options?

Screenshot: https://dl.dropboxusercontent.com/u/402 ... 7%20AM.png

I find this improvement of Fund Manager to be very valuable (once I understand how I need to adjust the settings) as I was filtering an Excel spreadsheet and uploading to Google Docs or other web services, which obviously wasn't a very elegant (and definitely a much more manual one) solution. So even not having explored the other improvements, very nice!

When I initially went thru this tonight, it ended up showing a number of very small mutual fund imbalances (funds I no longer owned) that didn't appear to have been in the prior reports, but once I "hid sold investments", they reappeared. They had share imbalances of ten thousandths of shares, so no monetary impact, but definitely not what I wanted (as they would have been in the upload report with zero value). It was easy to find and zero them out, but then performing a price retrieval generated retrieval (quote server) errors when I had not been receiving them before. In the past, I've found these to be caused when I had an option that expired. I haven't bought/sold any recently, but in the past, I simply disabled price retrieval for them once they expired to prevent the retrieval error. I began to experience price retrieval errors (obviously if expired, the options quote server won't have a price for them any longer) in this process and I had to go thru each sub-portfolio looking for options and disabling the price retrieval. This eliminated the price retrieval errors that had reappeared.

Thanks for the explanation and the video tutorial!

[Mark]

Hi dbender54,

When you use that "Hide Sold Investments" it turns on the hidden attribute for each "sold" investment. This stays on, unless you change it. That "Hide Sold Investments" dialog can also turn on/off the price retrieve option. Notice the 2 options for turning it off for sold and on for non-sold investments. This is probably how your price retrieve got turned back on for investments that owned a small fractional share, and were considered non-sold. To be considered sold, you have to own 0.000000 shares (out to 6 decimals) for the entire date range you specify in that dialog. If you have some investments that got their price retrieve turned on because of this, you can fix their share balance, and re-run that "Hide Sold Investments" dialog to turn the price retrieve back off.

[dbender54]

Thank you, this makes sense in the context of what I saw take place.

If I set the upload feature to upload on a schedule, will it do so if the computer is asleep (which will happen if I'm not at the computer for a while)?

[Mark]

Hi dbender54,

No, the computer has to be running. It isn't capable of bringing your computer out of sleep mode...

[dbender54]

Thought as much, though this means the auto upload feature will be of limited value since (like most computers), after a period of inactivity, it automatically goes into sleep (not hibernation) mode. It's a MacBook Pro running Fundmanager under a virtual machine (Parallels), so it's not feasible to never let it sleep.

Thanks again and nice upgrade!