Daily statement, ps ledger and invoice

hihi @Charles (Unlicensed) please help to write any related logic or guides here, i will copy and paste into the user guides, thank you so much!

Daily Statement

https://mafint.atlassian.net/browse/MAF-3641

https://mafint.atlassian.net/browse/MAF-3714

The current version of the Daily Statement feature has basically become stable. Overall, this new table can be seen as a combination of GROUP P/L and POSITION MATRIX: it can not only view the total profit and loss and daily/weekly changes based on different groups, but also capture the positions under each product code.

The interface of the "setting" is the same as that of GROUP P/L. Users need to select portfolios, dates, and how to group (GROUP).

Users can freely drag any column in the table to set row groups (which is consistent with the previous feature). In this new table, we have added two new columns, DOD and WOW, and here is the detailed logic:

WoW (week-over-week) 周环比 comparison means taking the profit and loss of the current day and subtracting it from that of the same day of the previous week. For example, if today is Wednesday, we subtract the profit and loss of this Wednesday from that of the previous Wednesday. If today is Thursday, we subtract the profit and loss of this Thursday from that of the previous Thursday.

DoD (day-over-day)日环比 comparison means taking the profit and loss of the current day and subtracting it from that of the previous day, without the need for a percentage change.

If there are holidays, and the holidays fall on Thursday to Sunday, then Monday to Wednesday of the new week will be compared normally, and Thursday and Friday will be compared with Wednesday. If the holiday is from last Saturday to this Wednesday, then Monday to Wednesday of the following week will be compared with Friday of the previous week.

The data for TOTAL P/L, DOD, and WOW are all obtained from HISTORICAL GROUP P/L, and users need to store the daily profit and loss data in advance. Specifically, for example, if we store the P/L of trading portfolio 5003 on April 20th in GROUP P/L, then this data will be in DOD in DAILY STATEMENT. To obtain WOW, we only need to store the profit and loss data of the same day in the previous week.

PS Ledger

Invoice

Issue Invoice

Receive Invoice