EK Super (AI)(Prelim Format)
Notes:
Transactions / Holdings
Based on Transactions, keep the same Qty for Buy and Sells
Open item Buys remain separate
Holdings report shows CP, APP, LPP, TPP, TG%
Test Notes:
Test is for one fund, so no assigned Super
LPP picks up from Transactions
APP and TPP is calculated
Brainstorming:
If we make initial purchases within our super, will create Buy transactions showing accurate amounts
For maintenance, reconciliation may arise when we DCA our Sells to calculate our CG and our remaining Qty in the Holdings
If we upload our transactions, how would this work overtime on our accumulation?
AI may increase their risk on hallucinations when uploading and verifying data based on previous reports
We need to identify a way to minimize the hallucinations, so minimize the uploads
Uploads can be summary reports, and AI can do calculations and merges
Calculations for LPP, APP, and TPP should remain in Excel as we have conditional formatting
Our current EKSuper report includes Rem$, DCA$, 52WH, 52WL for TAPP
Metrics include A$, Tar$, A%, T%, Tar%, CP, Qty, APP, TAPP, TPP, TG%, VAPP%
Summary:
Our Excel report is more efficient. We can utilize AI, but not for consolidation purposes due to risk of hallucinations during verification. AI works best when calculating based in existing data, and forecasting using measurable metrics.
Updated:
Updated Type REITs-to-Income
Renamed Cash+Cash ETF with Cash
Updated Tar$ nominal from 360K-to-400K
Set Tar$ = Tar$ nominal x Tar%
Updated from DCA/3 with DCA/4
Updated TPP with no LPP, then TAPP
Updated TPP with LPP x 96.25%
Sell at TG% at +7.5%
