MMEX Desktop v1.3.4.beta.2 is ready https://sourceforge.net/projects/moneym ... .4-bata.2/

Script for MM Ex Home Page Summary

Build and share your cool customized reports built w/ one sql, Chart.js and Lua (https://github.com/moneymanagerex/general-reports)
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: 70
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 410 times
CreditReport.grm
(2.42 KiB) Downloaded 403 times
AccountSummary.grm
(2.62 KiB) Downloaded 383 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: 70
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 404 times
HomePageNetWorth.grm
(4.07 KiB) Downloaded 369 times

Post Reply