Script for MM Ex Home Page Summary

Build and share your cool customized reports built w/ one sql, Chart.js and Lua

Moderator: Renato

Post Reply
euroglider
New MMEX User
Posts: 2
Joined: Mon Apr 08, 2019 1:26 am
Are you a spam bot?: No

Script for MM Ex Home Page Summary

Post by euroglider »

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.
siowena
Super MMEX User
Posts: 109
Joined: Tue Jul 17, 2018 8:04 am
Are you a spam bot?: No

Re: Script for MM Ex Home Page Summary

Post by siowena »

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 798 times
CreditReport.grm
(2.42 KiB) Downloaded 755 times
AccountSummary.grm
(2.62 KiB) Downloaded 739 times
euroglider
New MMEX 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

Post by euroglider »

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.
siowena
Super MMEX User
Posts: 109
Joined: Tue Jul 17, 2018 8:04 am
Are you a spam bot?: No

Re: Script for MM Ex Home Page Summary

Post by siowena »

[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 805 times
HomePageNetWorth.grm
(4.07 KiB) Downloaded 712 times
Post Reply