Gold Portfolio — Market & Gain Graphs V3.2.2

Accumulated current sale value

—

Waiting for live price…

Total market gain

—

Investment gold

—

PNJ + SJC only

Cost basis

—

Original purchase costs

Physical count

—

13 bullion + jewellery

Live Price Basis

Live sale-price basis and market reference values.

USD / oz

—

Spot / Chỉ

—

International spot conversion

PNJ sale / Chỉ

—

SJC sale / Chỉ

—

Accumulated Value by Group

Current value split across PNJ, SJC and jewellery. Figures remain shown above; this graph is an additional visual summary.

Cost Basis vs Current Value

Side-by-side comparison showing where value stands now against original cost.

Clear Position Summary

Accumulated value by asset group. This is the main table to read first.

API / Storage status

Not checked

Run Check storage after deployment.

Documents uploaded

From D1 metadata table

Items with evidence

Items with at least one document

Upload Evidence

Attach one file to one gold item. Accepted: photo, scan, PDF, invoice, receipt or supporting evidence.

Gold item

Document type

File

Notes

Evidence Position

Shows whether each piece has attached evidence.

Document Register

Documents are served through the app API; the R2 bucket remains private.

No documents loaded yet.

Market Gain Analysis

Shows actual/estimated sale value per Chỉ and the gain against original cost.

Calculation Formula

Corrected from Tael to Chỉ.

Waiting for price…

Key correction: the previous app treated each 1 Chỉ item as 1 Tael, multiplying value by 10. This version values each bullion piece as 1 Chỉ unless edited otherwise.

Market Gain by Item

Visual comparison of gain by bullion piece. The detailed table remains above.

Price Snapshot Trend

Live gold price history from your saved refresh snapshots.

Price Snapshot History

Logged when live price is refreshed.

Settings

Use actual sale price per Chỉ when you have a shop quote. If blank, the app estimates from the Worker gold price.

Gold Price Worker URL

USD / VND

PNJ premium / discount %

SJC local premium %

Actual PNJ sale price / Chỉ VND

Actual SJC sale price / Chỉ VND

Jewellery sale / liquidation value VND

Manual gold price USD / oz

Data action

Storage key

Import JSON

About this corrected version

Build: market and gain graph enhanced dashboard · Worker-first price fetch · Cloudflare Pages ready.

Application version	V3.2.2
Build timestamp	2026-05-05T18:25:00+07:00
Deployment marker	JCDVN-GOLD-D1-R2-V3-2-2-20260505
GitHub / Cloudflare check	If this version and timestamp are not visible after deployment, Cloudflare Pages is still serving an older index.html.
Position basis	All bullion holdings are stored as individual pieces and valued using the sale price per Chỉ. 10 Chỉ = 1 Tael for conversion only.
Investment bullion default	13 pieces, each 1 Chỉ: 11 PNJ + 2 SJC = 13 Chỉ = 1.300 Taels.
Jewellery default	Charm item is separated and valued using a fixed sale/liquidation value.
Worker endpoint	https://jcdvn-gold-price-worker.john-f04.workers.dev/api/gold-price
D1 database	jcdvn-gold-portfolio · binding DB
R2 bucket	jcdvn-gold-documents · binding GOLD_DOCS
Evidence API	/api/health · /api/items · /api/documents/upload · /api/documents/list · /api/documents/view · /api/documents/delete
Calculation	USD/oz × 0.12055 oz per Chỉ × USD/VND = international spot value per Chỉ.
Actual sale price	Settings can override calculated PNJ/SJC values with real shop quote prices per Chỉ.