NAV records Saved records refresh automatically. Input SUB-RED.xlsx Date BOC A1 MOP NAV BOC A2 HKD NAV Action Loading NAV records…