EFI EKSuper (With Prompts)(Purch Sold)(With Averages)(MAR-APR25)

6 May

Written By Nomad FI

Notes:

AI is able to integrate pictures of snapshots (JPG, PDF) of multiple file uploads as well as copied over data from Excel (XLS)
For this to work, would need to manually upload one file (snapshot) at a time
During file upload, have AI create a structured table of the results and then create a name for the table (this will be the identifier)
We would then need to do Data Validation to confirm its completeness
AI has issues syncing and consolidating all of the Funds when uploading files if the Funds are different in both tables
AI doesn’t know the difference between Averages and Totals. AI calculates the average of the average column for the total instead of summing up the total directly, and yet, it still says it’s validated (hallucination), so we would need to distinguish that its the weighted average and not the average of averages when calculating the total.
AI has issues calculating totals accurately in the summary reports even if the totals for all Funds add up correctly. To fix this, can prompt AI to override manually, or to copy over the pivot table results from Excel for override. AI treats totals as s static number, and not a formula even if we told AI that its a formula. For example, if AI removes a row from the table, the total amount remains the same and doesn’t automatically recalculate.
Certain terminology that confuses AI are Grand Total, Total, Averages and risks hallucinations during calculations
AI does well doing admin tasks in structured tables

Additional Notes:

We can now compare AvgPur, AvgPP and AvgSold, AvgSP for EFI and EKSuper, so these tables results makes it much easier for assessment

// Phase III //

Create % metrics for the EFI and EKSuper for all funds and totals
Create Target Allocation for all funds for EFI and EKSuper vs Actual Allocation Amounts
Integrate CP (Current Prices) for all funds
Create a FY (Full Year) report for JUL24-JUN25 of all our trades
Create next year’s target allocations for EFI and EKSuper

EK Cash Flow (MAY25)