I'm trying to get data into Excel, to mimic what I used to be able to do with MS Money.
If I make an investment transaction report I get most transactions with 1 line for what I want (date, action, quantity etc) and then another line that looks to be some subset of the transaction, although I can't figure out what it really for. They don't have a date, action, security name, but appear to be resolving cash,and in any case I would like to exclude them. In some cases, the first line of the transaction just has the security info and the values are only in the second line, which means that just copying to Ecxel ends up with something that cannot be sorted or made any use of.
Am I missing something? I can't believe there is not a way to get a straighforward report, but none of the customizations or options I can find seem to do anything. Some of those extra lines go away if I exclude all transfers, but there are still a lot there. Getting rid of all the cash columns does nothing to help.
Any ideas? Is this some strange result of converting from MS Money?
Also is there any way to sort the report?
Thanks SS