To calculate your average account balance, first create a custom flex query to obtain the average balance of the account over a specific period of time:
- Login to Client Portal
- Click Performance & Reports followed by Flex Queries
- Click on Create ("+") icon to next to Activity Flex Query
- Assign a Query Name
- Under Sections select Net Asset Value (NAV) in Base, and then check the fields: Report Date, Cash, Total and click Save
- Under Delivery Configuration select Format "Text" and the desired time period
- Under General Configuration, select Text Separator "Comma"
- Click on Continue, review your activity flex query and click Create at the bottom of page and Ok.
You can run the custom flex query by clicking on the Run (arrow) icon next to the name of the query in the Custom Flex Queries section from the Performance & Reports menu followed by Flex Queries.
- You can open the document with a spreadsheet software and use the "Average" function on the "Cash" column to calculate the average cash balance of the account over the period.
- You can open the document with a spreadsheet software and use the "Average" function on the "Total" column to calculate the average Net Asset Value of the account over the period.
Additional Information