Extract Data Extension - Request

rayplayer's Avatar


07 May, 2022 03:26 PM

Just been looking over the portfolio report in MD and find that the Cost Basis column doesn't change regardless of when the report is dated, that is before or after stock purchases. The correct information resides within MD (See Cost Basis Report) but it’s not used?

Whilst looking through the forum I came across the Extract Data extension and gave it a try - the StockGlance 2020 looks idea for my purposes, but it is no more useful that the Portfolio Report as (unless I’m mistaken) the Cost Basis column uses the same incorrect data as the Portfolio Report.

Checking this forum I note that the problem with the Cost Basis column in the Portfolio Report has been flagged on numerous occasions over the years, yet it has not been corrected. IK obviously do not see reporting as a priority - can the Extract Data extension be modified instead?

  1. 1 Posted by Stuart Beesley ... on 07 May, 2022 04:12 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I’m the developer of the extension. Yes it (of course) uses MD data/APIs. I can consider changes, but I need to understand the problem more. At the moment, I don’t understand your issue. I’ll need to be able to reproduce it.

    Question. Do you have stock splits? Is it only wrong on these? Are you using avg cost basis or lot controlled?

  2. 2 Posted by Stuart Beesley ... on 07 May, 2022 04:16 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    The ideal would be a (test) dataset with the issue that I can look at and fix the issue?

  3. 3 Posted by Stuart Beesley ... on 07 May, 2022 04:28 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Ah also I know that one of the CB reports was fixed for cost basis and the other was not. (It got put on the shelf halfway through fixing 😢). I can’t remember which tho’

  4. 4 Posted by rayplayer on 09 May, 2022 09:13 AM

    rayplayer's Avatar

    Hi Stuart, the Investment Performance Report 'Buys' column does seem to be correct - unlike the Portfolio Report 'Cost Basis' column. As far as I can tell, the StockGlance 2020 appears to be using the same Cost Basis data as the Portfolio Report.

    I have no stock splits and am using a mix of average cost and lot matching.

    Can you elaborate on what you require regarding a data set and I'll see what I can muster.

  5. 5 Posted by Stuart Beesley ... on 09 May, 2022 09:34 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Do MD/File/New and create a new dummy dataset. Create a security and investment account (with dummy data). Add some buy / sells etc until you can reproduce the issue. Then file/export backup and send me the xxx.moneydancearchive file to look at. You can email me:

    Then just file/open your original.

  6. 6 Posted by Stuart Beesley ... on 11 May, 2022 11:20 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    FYI - my research indicates that the cost basis report is the one that is actually wrong, and the other ones are correct.....

  7. 7 Posted by rayplayer on 29 May, 2022 12:22 PM

    rayplayer's Avatar

    Hi Stuart, apologies for taking so long but I have done as you suggested and was unable to replicate the problem. In my dummy dataset the Cost Basis in the Cost Basis Report is correct, and aligns with the Investment Performance Report and the Portfolio Report for any given date.

    Based on what I have done it looks like the issue is in my main data file and the portfolio report is corrupted somehow. The Cost Basis Report and the Investment Performance Report align for any given date, but the Portfolio Report uses the same 'incorrect' Cost Basis regardless of date. Not sure how to fix that, but many thanks for your help and apologies for wasting your time.

    I also notice a similar report from old at https://infinitekind.tenderapp.com/discussions/problems/28009-cost-in-portfolio-report

  8. 8 Posted by Stuart Beesley ... on 29 May, 2022 01:19 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Do you have any sell/buy/MiscXxx for zero share amounts?
    Have you at any time sold all before buying more?

  9. 9 Posted by rayplayer on 30 May, 2022 10:45 AM

    rayplayer's Avatar

    Hi Stuart, I have tracked it down to the way I recorded a Capital Consolidation.

    The Cost Basis is now reporting correctly after I followed some of the advice in a discussion at https://infinitekind.tenderapp.com/discussions/investments/3966-capital-consolidation#comment_46597526 Essentially I was using a sell to change the share number when I should have been using the stock split function.

    Many Thanks


  10. 10 Posted by Stuart Beesley ... on 30 May, 2022 10:57 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Cool! Great to know.. So there is NO issue now?

  11. 11 Posted by rayplayer on 30 May, 2022 03:56 PM

    rayplayer's Avatar

    Fingers crossed

  12. rayplayer closed this discussion on 30 May, 2022 03:56 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? 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

Recent Discussions

15 Apr, 2024 01:38 AM
14 Apr, 2024 10:53 PM
14 Apr, 2024 09:35 PM
14 Apr, 2024 07:25 PM
14 Apr, 2024 04:28 PM