Investment categories
Hi I am based in the UK and currently use an old version of Quicken (2002!) on an old windows computer. But I now have a mac and want to switch to software like Moneydance, Banktivity or Personal Investing. I use it entirely for tracking investments held in different brokerage accounts (ISAs and ordinary accounts with 3 brokers for my wife and for me).
Q1: I want to be able to see my investments by category - not just stocks, bonds, etf's or unit trusts, but by sector (tech, consumer staples, retail, healthcare etc) and or by country or region (US/UK/Europe/China). Is it possible to insert categories when I enter new investments, and then show portfolio values by these customised categories? (cheeky question - If not do you know of alternative software that would do this? )
Q2: Will I be able to transfer the windows based QIF files from Quicken 2002 to a mac version of Moneydance (not totally vital, i can just start with current investments)
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 rodwhd on 19 Jul, 2017 03:35 PM
the article on Investment sub-type confirms you can create a sub-type which is great. but can you create a report which allows you to look at investments by sub-type?
2 Posted by derekkent23 on 19 Jul, 2017 04:09 PM
I am not support staff, just a user.
I think the answer to your question is yes. Look at a section of one of my Asset Allocation Reports. You can see the securities are grouped by type and subtype. Each security have a value, a percentage of “Type” and a percentage of the “Total”.
You can download the free trial version and experiment with the program. The demo version is fully functional and allows you to manually enter 100 transactions. Imported transactions are not limited, so you'll be able to fully test downloading data from your bank, and importing data from other personal finance software.
If you decide to purchase the program at a later date you can keep all your data, the license key simply unlocks the ability to manually enter more transactions. You can download the trial version of Moneydance from http://infinitekind.com/download-moneydance-personal-finance-software
You'll find the Moneydance knowledge base articles here http://help.infinitekind.com/kb which will be useful if you're using Moneydance for the first time.
Hope this helps.
3 Posted by rodwhd on 19 Jul, 2017 08:42 PM
thanks derekkent! this looks like what i am trying to achieve - presumably you specified the categories shown yourself, as sub-types, which is what i hope to do e.g. Mutual Europe ex Uk and Mutual Global Emerging Markets? Those don't appear to be standard categories shown in the manual
4 Posted by derekkent23 on 20 Jul, 2017 07:05 AM
I am not support staff, just a user.
For each security you can select a Type, Stock, Mutual, CD, Bond, Stock option, Ohers from a fixed list, see picture below. Once you have selected the type the available entries change to a list relevant to the security type you select. For each Security Type you can also add a Subtype. Importantly by clicking on Edit next to Subtype you can add any text you like adding as many Subtype as you need.
Hope this helps.
5 Posted by rodwhd on 20 Jul, 2017 08:54 AM
thanks a million - i will take the plunge - not sure if message gets
through to you be replying to this email?
*--*
6 Posted by derekkent23 on 20 Jul, 2017 09:03 AM
Hi, yes it does, also appears on the forum.
Have Fun
7 Posted by rodwhd on 25 Jul, 2017 01:50 PM
hi derkkent. quick question you may be able to help with.... I own the same
stocks across different accounts, so i often want to view and print my
investments by stock(security) rather than by investment account e.g. want
to see how many Amazon shares and the value that I own in total, not split
into separate accounts. The report Portfolio appears to give me this Edit
option, but when I select Portfolio/Edit/Show by type/All security, it
still displays and prints out the stocks separated into Investment
accounts. The Moneydance support guy has suggested I use Extensions and set
up extra Investment Reports, and design my own report there, but its very
complicated and I haven't worked it out yet. Is there a simpler way? In my
old Quicken 20002 its a core option to view a portfolio investments either
subtotalled by Account, or by security
*Yours, *
*Rod Whitehead*
*01344 842958 / **0780 330 9230*
*Skype: rodwhd*
*I am the voluntary UK Co-Ordinator for New Generation, a street kids
charity in Burundi, in East Africa. They help hundreds of street kids in
the capital, Bujumbura, and also run leadership &
entrepreneurship training and peace events for young people across Burundi.
See **http://newgenerationburundi.org* <http://newgenerationburundi.org/>
*and **New Generation Burundi*
<https://www.facebook.com/newgenerationburundi/>* in Facebook. This **3
minute film*
<http://streetaction.org/who-we-are/our-campaigns/new-generation-film/>* gives
you a good feel for the project *
*--*
8 Posted by derekkent23 on 26 Jul, 2017 07:48 AM
Sorry can help you with this one. Have never wonted to report by Security, but can see it could be useful.
Support Staff 9 Posted by Jenny on 26 Jul, 2017 11:34 AM
Hi Ron,
Using the 'Portfolio' report, you can select "Show: By Individual" on the right of the settings screen. You can then choose which securities you'd like to report on (rather than All Securities), allowing you to run a report for each specific security. However, these reports will still be subtotaled by each account.
If you're having trouble creating reports using the extension, you can create a new discussion that includes screenshots of the settings you're using. I'd be happy to provide guidance and assistance so you can generate the data you need.
Jenny
Infinite Kind Support
System closed this discussion on 25 Oct, 2017 11:40 AM.