Report Writer
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?
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 Stuart Beesley ... on 30 Jan, 2023 08:45 AM
does extract_data extension: option extract investment transactions help at all..?
2 Posted by dainiusforex on 30 Jan, 2023 08:52 AM
Thank you. Checked already. This does not include APR which is quite nice to have. Nor has security type. So its pretty useless
3 Posted by Stuart Beesley ... on 30 Jan, 2023 09:19 AM
Let me know any other points and I’ll add them.
4 Posted by Stuart Beesley ... on 30 Jan, 2023 09:19 AM
… and are these better as different extract or in the same transaction extract?
5 Posted by dainiusforex on 30 Jan, 2023 09:24 AM
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 Posted by dainiusforex on 30 Jan, 2023 01:05 PM
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 Posted by Stuart Beesley ... on 30 Jan, 2023 09:32 PM
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 Posted by dainiusforex on 31 Jan, 2023 08:22 AM
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 Posted by Stuart Beesley ... on 31 Jan, 2023 08:40 AM
On 31 Jan 2023, at 08:22, dainiusforex <[email blocked]> wrote:
// 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:
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 Posted by dainiusforex on 31 Jan, 2023 05:10 PM
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 Posted by Stuart Beesley ... on 31 Jan, 2023 05:33 PM
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 Posted by dainiusforex on 31 Jan, 2023 05:34 PM
Yes, that's correct. If it's possible
13 Posted by Stuart Beesley ... on 31 Jan, 2023 08:56 PM
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 Posted by dainiusforex on 01 Feb, 2023 07:45 AM
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 Posted by Stuart Beesley ... on 01 Feb, 2023 08:35 AM
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 Posted by dainiusforex on 01 Feb, 2023 08:36 AM
Maybe you have personal/work email?
17 Posted by Stuart Beesley ... on 01 Feb, 2023 09:48 AM
...
18 Posted by dainiusforex on 01 Feb, 2023 09:51 AM
OK. I'll send you excel sample
19 Posted by Stuart Beesley ... on 03 Feb, 2023 07:26 PM
NEW PREVIEW of extract_data extension with a new option to extract Security Balances now available for testing:
https://yogi1967.github.io/MoneydancePythonScripts/
20 Posted by dainiusforex on 06 Feb, 2023 04:46 PM
Loaded. Starting to use. Will inform you as it went
------ Original Message ------
System closed this discussion on 08 May, 2023 04:50 PM.