Gold prices on investing.com are CFD prices which are from a provider (i don't know who) which in turn should mirror CME prices but there may be some discrepancies (as you've found out).
The settlement price of gold on CME is not the same as the last traded price on CME in the day. You'll have...