
Let's stay connected! Follow me on social media to get exclusive content, helpful tips, and the latest updates on everything I create and share.
© 2025 Mostafa Yasser. All rights reserved.
Developed by Hazem Yasser
Automated Notion dashboard with live gold price API integration and automated profit & ROI calculation.
If you're manually tracking gold investments and calculating profits by hand, this case study shows how a fully automated Gold Investment Tracking System in Notion can bring real-time clarity to your portfolio.
The client invests in physical gold and needed to track:
Before the system:
This method was time-consuming and error-prone.
He needed a real-time gold investment tracker inside Notion.
To eliminate manual calculations, we built a custom Notion investment tracking system powered by automation.
We connected Notion to a Gold Price API using:
The system automatically updates:
This allows global market monitoring directly inside Notion.
We created a second database to manage:
This database is dynamically linked to the live price database to automatically calculate:
All calculations update instantly when gold prices change.
To simplify daily usage, we implemented one-click action buttons.
With a single click, the system:
No manual price copying.
No spreadsheet formulas.
No recalculations.
Live API-powered price updates.
Dynamic calculation of gains, losses, and ROI.
Track performance in USD, SAR, and EGP.
Clear portfolio overview in one centralized system.