Report Writer

dainiusforex's Avatar

dainiusforex

30 Jan, 2023 08:40 AM

Great extension. What I'm missing when extracting accounts including securities data is "Face value" and "Maturity date" of bonds. These two are important when building investment reports. Or I cannot find setting to get these two?

  1. 1 Posted by Stuart Beesley ... on 30 Jan, 2023 08:45 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    does extract_data extension: option extract investment transactions help at all..?

  2. 2 Posted by dainiusforex on 30 Jan, 2023 08:52 AM

    dainiusforex's Avatar

    Thank you. Checked already. This does not include APR which is quite nice to have. Nor has security type. So its pretty useless

  3. 3 Posted by Stuart Beesley ... on 30 Jan, 2023 09:19 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Let me know any other points and I’ll add them.

  4. 4 Posted by Stuart Beesley ... on 30 Jan, 2023 09:19 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    … and are these better as different extract or in the same transaction extract?

  5. 5 Posted by dainiusforex on 30 Jan, 2023 09:24 AM

    dainiusforex's Avatar

    Well. Its better to have everything in one file so you can operate data more easily. About what I need more so cannot mention right now. Questions will rise during usage. For now these 2 are missing :) Thank you.

  6. 6 Posted by dainiusforex on 30 Jan, 2023 01:05 PM

    dainiusforex's Avatar

    BTW, Report Writer has very useful setting https://www.screencast.com/t/HmpQhPRUiDmH , so when file is created you can chose if you want to keep same name or create unique or with datestamp

  7. 7 Posted by Stuart Beesley ... on 30 Jan, 2023 09:32 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    OK - build 1028 PREVIEW of extract data extension now available at:
    https://yogi1967.github.io/MoneydancePythonScripts/

    There is a new option (optional) to extract the security account info you are after..

    Let me know how it goes?

    Thanks

  8. 8 Posted by dainiusforex on 31 Jan, 2023 08:22 AM

    dainiusforex's Avatar

    Hi. Took brief look and seems OK. Will try to build decent report with this data and let you know in few days. Thank you

  9. 9 Posted by Stuart Beesley ... on 31 Jan, 2023 08:40 AM

    Stuart Beesley (Mr Toolbox)'s Avatar


    Regards Stuart

    On 31 Jan 2023, at 08:22, dainiusforex <[email blocked]> wrote:

     pre { width: 92%; margin: 10px 2%; padding: 5px 2%; background-color: rgb(239, 239, 239); border: 1px solid rgb(214, 214, 214); } blockquote { margin-left: 0px; padding-left: 1em; border-left-width: 5px; border-left-style: solid; border-left-color: rgb(204, 204, 204); }

    // Please reply above this line
    ==================================================

    From: dainiusforex

    Hi. Took brief look and seems OK. Will try to build decent report with this data and let you know in few days. Thank you

    On Mon, Jan 30 at 01:32 PM PST, Stuart Beesley (Mr Toolbox) wrote:

    OK - build 1028 PREVIEW of extract data extension now available at:
    https://yogi1967.github.io/MoneydancePythonScripts/

    There is a new option (optional) to extract the security account info you are after..

    Let me know how it goes?

    Thanks

    Having trouble reading this? View this discussion online: Report Writer.

    To unsubscribe and stop receiving emails from https://infinitekind.tenderapp.com, visit this page

  10. 10 Posted by dainiusforex on 31 Jan, 2023 05:10 PM

    dainiusforex's Avatar

    Hi Stuart. Tried to use extract investment transactions for report building. So. While all fields are available and usable I found that your StockGlance2020 extraction would be better suited for my needs but if this csv has columns: security type , APR and maturity date of bonds (other securities). Investment transactions csv would be nice to have improved also. I'm not scripter so only hope that these improvements are possible and wouldn't be too much trouble for you.

  11. 11 Posted by Stuart Beesley ... on 31 Jan, 2023 05:33 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Sorry if I am not understanding properly. What exactly are you requesting..?

    Do you mean, add all the same fields I just added to extract_investment_transactions to the stockglance2020 extract as well..?

    Thanks

  12. 12 Posted by dainiusforex on 31 Jan, 2023 05:34 PM

    dainiusforex's Avatar

    Yes, that's correct. If it's possible

  13. 13 Posted by Stuart Beesley ... on 31 Jan, 2023 08:56 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I’m not sure your idea will work… it consolidates securities across all accounts. Thus if security a is a BOND in one account and CD in another (for example) and there is one consolidated csv row, then how do I output the extra security info for both?

  14. 14 Posted by dainiusforex on 01 Feb, 2023 07:45 AM

    dainiusforex's Avatar

    Excuse my ignorance in scripting, but as I can see we have all accounts in transactions extraction. I'm not English speaking but try to explain. I'm aware that stocks, mutuals doesn't have maturity date while bonds do. So maybe in csv is we can have bonds maturity displayed and stocks would have null in that cell. You see my idea is to predict moneys available in certain months or weeks for investing after some investments will mature and while I do not see all maturity dates in one report and cannot group or filter or sum them I'm partially blind. It's strange that MD does not have such analytic instrument. Balance predictor could be used for this purpose but for this we need to create reminders while it's doble job because maturity date could be entered when security is added. I hope you understood my English and whole idea.

  15. 15 Posted by Stuart Beesley ... on 01 Feb, 2023 08:35 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Ok. It might be easier if you posted a sample excel file of the format you are after.

    Forget existing extensions and reports, can you create a small excel and show the columns you are after. Create 2-3 dummy rows of data and any dummy totals.

    Upload that and let me take a look

    Make sense?

  16. 16 Posted by dainiusforex on 01 Feb, 2023 08:36 AM

    dainiusforex's Avatar

    Maybe you have personal/work email?

  17. 17 Posted by Stuart Beesley ... on 01 Feb, 2023 09:48 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    ...

  18. 18 Posted by dainiusforex on 01 Feb, 2023 09:51 AM

    dainiusforex's Avatar

    OK. I'll send you excel sample

  19. 19 Posted by Stuart Beesley ... on 03 Feb, 2023 07:26 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    NEW PREVIEW of extract_data extension with a new option to extract Security Balances now available for testing:

    https://yogi1967.github.io/MoneydancePythonScripts/

  20. 20 Posted by dainiusforex on 06 Feb, 2023 04:46 PM

    dainiusforex's Avatar

    Loaded. Starting to use. Will inform you as it went

    ------ Original Message ------

  21. System closed this discussion on 08 May, 2023 04:50 PM.

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

Recent Discussions

23 Apr, 2024 06:08 PM
23 Apr, 2024 06:03 PM
23 Apr, 2024 06:00 PM
23 Apr, 2024 04:50 PM
23 Apr, 2024 04:36 PM