Script for MM Ex Home Page Summary

Page 1 of 1
4 posts
Script for MM Ex Home Page Summary

euroglider
New MMEX User

Posts: 2
Joined: Sun Apr 07, 2019 7:26 pm
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.
Re: Script for MM Ex Home Page Summary

siowena
Super MMEX User

Posts: 20
Joined: Tue Jul 17, 2018 2:04 am
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.
Attachments
CreditReport.grm
(2.42 KiB) Downloaded 23 times
CreditReport.grm
(2.42 KiB) Downloaded 15 times
AccountSummary.grm
(2.62 KiB) Downloaded 29 times
Re: Script for MM Ex Home Page Summary

euroglider
New MMEX User

Posts: 2
Joined: Sun Apr 07, 2019 7:26 pm
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

siowena
Super MMEX User

Posts: 20
Joined: Tue Jul 17, 2018 2:04 am
[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).
Attachments
HomePageNetWorth.grm
(4.07 KiB) Downloaded 26 times
HomePageNetWorth.grm
(4.07 KiB) Downloaded 17 times
Page 1 of 1
Who is online

Users browsing this forum: No registered users and 2 guests