Need some help. I am new very new to SQL and was wondering if anyone could provide me with the correct script/Query to reproduce the Home Page Summary (Left Hand Side only) - showing Net worth summary (i.e. not the graphs or info on the RHS of the Home Page).
Thank you in advance.
E.
Script for MM Ex Home Page Summary
Moderator: Renato
-
- New User
- Posts: 2
- Joined: Mon Apr 08, 2019 1:26 am
- Are you a spam bot?: No
Re: Script for MM Ex Home Page Summary
The SQL to provide that info is likely not possible as accounts and share values are stored in difference places.
The reports Account Summary and Credit report provide something similar for Accounts (not shares).
Attached their GRM files.
There is one for share values somewhere, I'll see if I can dig it out.
The reports Account Summary and Credit report provide something similar for Accounts (not shares).
Attached their GRM files.
There is one for share values somewhere, I'll see if I can dig it out.
- Attachments
-
- CreditReport.grm
- (2.42 KiB) Downloaded 808 times
-
- CreditReport.grm
- (2.42 KiB) Downloaded 770 times
-
- AccountSummary.grm
- (2.62 KiB) Downloaded 750 times
-
- New User
- Posts: 2
- Joined: Mon Apr 08, 2019 1:26 am
- Are you a spam bot?: No
Re: Script for MM Ex Home Page Summary
Thank you! I will give these a try to see if I can adapt and create a customized Net worth report format
siowena wrote:The SQL to provide that info is likely not possible as accounts and share values are stored in difference places.
The reports Account Summary and Credit report provide something similar for Accounts (not shares).
Attached their GRM files.
There is one for share values somewhere, I'll see if I can dig it out.
Re: Script for MM Ex Home Page Summary
[quote="euroglider"]Thank you! I will give these a try to see if I can adapt and create a customized Net worth report format
Ok, I was bored at work
Try this one.
(note the two files are the same, for some reason the board adds the file twice).
Ok, I was bored at work
Try this one.
(note the two files are the same, for some reason the board adds the file twice).
- Attachments
-
- HomePageNetWorth.grm
- (4.07 KiB) Downloaded 819 times
-
- HomePageNetWorth.grm
- (4.07 KiB) Downloaded 722 times