Real-Time Gold Investment Tracking System

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.

---

Project Overview

• Client Type: Individual Investor
• Location: Egyptian investor based in Saudi Arabia
• Scope: Custom Real-Time Gold Portfolio Dashboard
• Tools Used: Notion · Gold Price API · Google Apps Script
• Date: 1FEB 2026

---

The Challenge: Manual Gold Tracking & Repetitive Calculations

The client invests in physical gold and needed to track:

• Live gold price per gram
• Value of owned weights (5g, 10g, etc.)
• Purchase price vs. current value
• Profit or loss
• ROI percentage
• Multi-currency pricing (USD, SAR, EGP)

Before the system:

• He checked gold prices online daily
• Calculated portfolio value manually
• Computed profit and percentage returns by hand
• Repeated the process every time the price changed

This method was time-consuming and error-prone.

He needed a real-time gold investment tracker inside Notion.

---

The Solution: Notion + Gold Price API Integration

To eliminate manual calculations, we built a custom Notion investment tracking system powered by automation.

Live Gold Price in Notion

We connected Notion to a Gold Price API using:

• Custom Notion Integration
• Google Apps Script (middleware automation)
• Scheduled update logic

The system automatically updates:

• Live price per gram
• Live price per ounce
• USD, SAR, and EGP conversions

This allows global market monitoring directly inside Notion.

---

Gold Portfolio Tracking Database

We created a second database to manage:

• Weight owned (grams / ounce)
• Buy date
• Buy price per gram
• Total purchase value

This database is dynamically linked to the live price database to automatically calculate:

• Current value
• Total portfolio value
• Net profit or loss
• ROI percentage

All calculations update instantly when gold prices change.

---

Smart Purchase Logging System

To simplify daily usage, we implemented one-click action buttons.

With a single click, the system:

• Captures the live gold price
• Multiplies by selected weight
• Logs purchase details
• Records transaction date
• Adds entry to the portfolio database

No manual price copying.

No spreadsheet formulas.

No recalculations.

---

System Features

Real-Time Gold Price Tracking in Notion

Live API-powered price updates.

Automated Gold Profit Calculator

Dynamic calculation of gains, losses, and ROI.

Multi-Currency Investment Monitoring

Track performance in USD, SAR, and EGP.

Structured Investment Dashboard

Clear portfolio overview in one centralized system.