Share totals with each transaction
One feature that I haven't seen on any program except Quicken (I use a Mac) is the column for total shares owned. In Moneydance I have no idea if I entries are correct without manually adding the total number of shared owned on a given date. This is something for computers, not people.
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by Ben Spencer on 23 Aug, 2009 04:59 PM
Hi Steve
In the portfolio view Moneydance lists each of the securities owned and the total number of each security owned. If you look at the attached screen shot you can see that a total of 10 shares in google are owned in this account.
Perhaps I am misunderstand your question.
Sincerely
Ben Spencer
2 Posted by steve and maggi... on 23 Aug, 2009 09:59 PM
Ben,
I would like to see the total number of shares owned at the time each
transaction is made. I believe this is the only way I can easily
verify that transactions have been recorded correctly. Quicken is the
only program I have found that provides this information.
thanks,
Steve
3 Posted by Ben Spencer on 24 Aug, 2009 05:12 PM
Hi Steve
I'd be happy to enter this into our issue tracking system as a suggested new feature and I need a little more information to ensure that I capture the suggestion correctly. Does this exist in a particular report that quicken generates? If so which report? Could you provide a screenshot of this feature in quicken such that I can unambiguously understand exactly what you are refering to.
Many thanks,
Ben Spencer
4 Posted by Steve on 24 Aug, 2009 10:59 PM
Ben,
Here is a screen shot from Quicken. It is not a report; just the regular register view for an investment account. The field I would like to see added to the register view for securities is Share Balance.
thanks,
Steve
5 Posted by Ben Spencer on 29 Aug, 2009 07:46 PM
Hi Steve
What version of Quicken are you using? I was paying around with Quicken 2009 Deluxe and the interface for entering a buy transaction for a security is quite different that the one you attached. I think there is a significant difference in the way quicken handles securities when compared to moneydance. From your screenshot you sent It seems like quicken has a transaction register for each security. (please correct me if I am wrong)Where as moneydance there is one account/register per investment account. In this register you can buy and sell multiple types of securities So a running total of the share balance would not make sense in this context and would require a significant change to the underlying data structure and the way Moneydance functions.
Sincerely
Ben Spencer
6 Posted by Steve on 30 Aug, 2009 03:11 AM
Ben,
The screenshot is from Quicken 2007 for Mac. I don't know anything about 2009. When I started using Quicken for Mac (Quicken 98, Maybe), everything was called an account. I'm actually getting confused with the terms. Even if I have four separate mutual funds with one company but they show up completely independent in Quicken.
You're telling me if I have several (what is the right term?) securities with one company that I have no way to separate out the statements. When I get paper statements from these companies they will show me a summary page with the total dollars at the statement date. But on separate sheets they will show me, for each security (or mutual fund), the activity for that statement period. On those sheets, most, but not all, companies will show a share balance for each line of the statement, which I find very useful.
Couldn't you add this column on your "Securities Detail" tab? Wouldn't a share total be easy to implement there -- just a sum of all the shares to that point.
I'm troubled by the notion of lumping all securities at one company together. Say I have five mutual funds at one company, how can I keep track of and verify the transactions?
When I get my monthly statement from my credit union, the checking account transactions are listed separately from the savings account transactions. I can't imagine the difficulty if they were combined and sorted by date. Why treat mutual funds differently?
Maybe because of the way I set things up in Quicken many years ago, every Security was listed as a separate account when I first imported to moneydance; I only have one security per account.
There is so much to like about Moneydance but this feature is very important to me. I may have to go back to Quicken. Time to mull that one over.
7 Posted by Ben Spencer on 31 Aug, 2009 05:23 PM
Hi Steve
I am not saying that there is no way to separate out the various securities for an investment account. That is a relatively simple task and you can already see that we do exactly that in the cost basis report. I believe you were asking to have a running total of shares owned in the transaction register. And I believe that doesn't make sense in a register that can handle multiple securities. It would be quite possible to add such a column to the table in the securities detail view as you suggest. In fact there is already a suggestion ticket for such a feature in our issue tracking system. Here is the link to the ticket:
http://moneydance.com/trac/ticket/1235
If you register and log into trac you can vote on tickets. (click the up arrow next to the vote count) We use the number of votes tickets get to help us determine what to implement next.
I am sorry for my confusion in this matter.
Sincerely
Ben Spencer
8 Posted by avp2 on 04 Sep, 2009 03:11 AM
I have Quicken 2006 for Mac and only ever remembered seeing a "cash balance" column where Steve's jpg showed share balance. You can see share balances in the "portfolio" of course. I had to look around, but found the register Steve's talking about as the "single mutual fund" type.
I started using Quicken when it first came out and never used, or missed, the single fund type account. I always just opened the portfolio in a separate window and watched the totals update as I entered transactions in the register. I can see though where it would be nice to be able to do something similar in MD; perhaps by having a share balance column in the stock listing of the home page (along with columns for running average, high and low price since first purchase).
9 Posted by Ed on 14 Feb, 2010 09:19 PM
Quicken has long supported a feature for Standard Brokerage accounts called "single mutal fund". It available in Quicken Premier 2009, and has been part of Quicken for a long time (I've been using it since it was a DOS product) Single Mutal Fund is not a well supported feature for other investment account types).
In Quicken, when Single Mutual Fund is true, the account will have no cash balance, may only contain one security, and instead of a Cash Bal column in the transaction register, you get a Share Bal. This is invaluable for reconciling Mutual Fund statements where the number of shares is more important then the price per share.
I am a registered user of Moneydance, but this is the one missing feature that prevents me from finally dropping Quicken and actually migrating to Moneydance.
10 Posted by Jon Hoover on 15 Feb, 2010 06:25 PM
Ed,
Thanks for the suggestion. I've added it to our feature and bug tracking site. You can vote for the ticket and we'll use it to determine how to prioritize new enhancements.
http://www.moneydance.com/trac/ticket/2630
Jon Hoover, Moneydance Support
11 Posted by Ed Belisle on 26 Feb, 2010 06:36 AM
This ticket (2630) is similar to ticket #1235.
2630 requests a running share total in the transaction view (plus
several account restrictions)
1235 requests a running share total in the Securities detail.
Also, I apologize for being a backseat architect, but could a Single
Mutual Fund account type be implemented by treating a stock as a
currency?
12 Posted by Angie Rauscher on 09 Mar, 2010 07:20 PM
Ed,
It could be, but frankly it would be a bit weird. It is a work-around for those who want this feature now.
Thanks all for your input on potential improvements to Moneydance,
Angie Rauscher
Moneydance Support
Angie Rauscher closed this discussion on 09 Mar, 2010 07:20 PM.
Steve re-opened this discussion on 17 Dec, 2011 08:04 PM
13 Posted by Steve on 17 Dec, 2011 08:04 PM
Again disappointed that this wasn't addressed with the latest Moneydance release (2011 r2). It has been two years. Is there any hope of this feature ever being added?
In the securities detail window you list the number of shares for each transaction. What is the big deal about summing those up for each line above and including that row and displaying it?
14 Posted by Ben Spencer on 17 Dec, 2011 08:18 PM
The trouble with displaying the running shares balance in the transaction register is that it would not be clear which security the running balance referred to as the investment register can and does refer to all the securities associated with the account.
Ben Spencer
Moneydance Support
15 Posted by Steve on 17 Dec, 2011 10:52 PM
Ben,
I thought this had been discussed previously. I only have one security per account but came to understand how you allow multiple securities per account.
So the Register view wouldn't work. But why not add the running share total to the Security Detail window?
16 Posted by Ben Spencer on 18 Dec, 2011 04:54 PM
I am sorry I misunderstood you. Yes this has been discussed previously. I have attached the relevant suggestion ticket to this discussion.
It would not be a problem to add this field to the security detail view. It is just a question of prioritising which feature we implement.
Ben Spencer
Moneydance Support
System closed this discussion on 31 Mar, 2015 03:30 PM.