Portfolio Tracker

System Jobs

Refresh Live Prices

Fetches the latest current_price from Yahoo Finance for all active securities.

Update Rolling P&L (Incremental)

Calculates historical P&L for dates missing in the database.

Update Rolling P&L (Full)

Wipes and recalculates the entire historical P&L timeline. Use if data looks corrupt.

Load Historical Prices

Runs the load_historical_prices command to backfill price history.

Execution History

Job Name	Status	Started	Duration	Output
Refresh Live Prices	Success	Jan 19, 11:01:32	0 minutes	Refresh Live Prices - Output Starting price refresh for 5 securities... Updated: AAPL -> 255.517 Updated: MSFT -> 459.86 Updated: VOO -> 636.09 Updated: SHEL.L -> 2730.617 Updated: SIE.DE -> 253.6 Updated: 5 Errors: []
Load Historical Prices	Success	Jan 19, 10:59:42	0 minutes	Load Historical Prices - Output [AAPL] Fetching from 2026-01-04 to 2026-01-19... Created: AAPL on 2026-01-05 - 267.260009765625 Created: AAPL on 2026-01-06 - 262.3599853515625 Created: AAPL on 2026-01-07 - 260.3299865722656 Created: AAPL on 2026-01-08 - 259.0400085449219 Created: AAPL on 2026-01-09 - 259.3699951171875 Created: AAPL on 2026-01-12 - 260.25 Created: AAPL on 2026-01-13 - 261.04998779296875 Created: AAPL on 2026-01-14 - 259.9599914550781 Created: AAPL on 2026-01-15 - 258.2099914550781 Created: AAPL on 2026-01-16 - 255.52999877929688 [MSFT] Fetching from 2026-01-04 to 2026-01-19... Created: MSFT on 2026-01-05 - 472.8500061035156 Created: MSFT on 2026-01-06 - 478.510009765625 Created: MSFT on 2026-01-07 - 483.4700012207031 Created: MSFT on 2026-01-08 - 478.1099853515625 Created: MSFT on 2026-01-09 - 479.2799987792969 Created: MSFT on 2026-01-12 - 477.17999267578125 Created: MSFT on 2026-01-13 - 470.6700134277344 Created: MSFT on 2026-01-14 - 459.3800048828125 Created: MSFT on 2026-01-15 - 456.6600036621094 Created: MSFT on 2026-01-16 - 459.8599853515625 [VOO] Fetching from 2026-01-04 to 2026-01-19... Created: VOO on 2026-01-05 - 632.4600219726562 Created: VOO on 2026-01-06 - 636.2100219726562 Created: VOO on 2026-01-07 - 634.1699829101562 Created: VOO on 2026-01-08 - 634.0599975585938 Created: VOO on 2026-01-09 - 638.3099975585938 Created: VOO on 2026-01-12 - 639.3400268554688 Created: VOO on 2026-01-13 - 638.030029296875 Created: VOO on 2026-01-14 - 634.9400024414062 Created: VOO on 2026-01-15 - 636.6199951171875 Created: VOO on 2026-01-16 - 636.0900268554688 [SHEL.L] Fetching from 2026-01-04 to 2026-01-19... Created: SHEL.L on 2026-01-05 - 2738.0 Created: SHEL.L on 2026-01-06 - 2747.0 Created: SHEL.L on 2026-01-07 - 2655.5 Created: SHEL.L on 2026-01-08 - 2562.0 Created: SHEL.L on 2026-01-09 - 2640.0 Created: SHEL.L on 2026-01-12 - 2661.5 Created: SHEL.L on 2026-01-13 - 2722.0 Created: SHEL.L on 2026-01-14 - 2739.0 Created: SHEL.L on 2026-01-15 - 2746.5 Created: SHEL.L on 2026-01-16 - 2752.5 [SIE.DE] Fetching from 2026-01-04 to 2026-01-19... Created: SIE.DE on 2026-01-05 - 244.60000610351562 Created: SIE.DE on 2026-01-06 - 247.5500030517578 Created: SIE.DE on 2026-01-07 - 256.25 Created: SIE.DE on 2026-01-08 - 251.8000030517578 Created: SIE.DE on 2026-01-09 - 254.1999969482422 Created: SIE.DE on 2026-01-12 - 258.3500061035156 Created: SIE.DE on 2026-01-13 - 261.75 Created: SIE.DE on 2026-01-14 - 259.04998779296875 Created: SIE.DE on 2026-01-15 - 260.8500061035156 Created: SIE.DE on 2026-01-16 - 260.25 Finished fetching all historical prices.
Update Rolling P&L (Full)	Success	Jan 19, 10:59:33	0 minutes	Update Rolling P&L (Full) - Output Full recalculation requested. This may take a while... Updated rolling P&L for 2023-01-19: -1995.898000000000000000000000 Updated rolling P&L for 2023-02-18: -2504.405000000000000000000000 Updated rolling P&L for 2023-03-20: -2508.387000000000000000000000 Updated rolling P&L for 2023-04-19: -2565.497000000000000000000000 Updated rolling P&L for 2023-05-19: -2754.492500000000000000000000 Updated rolling P&L for 2023-06-18: -2862.830500000000000000000000 Updated rolling P&L for 2023-07-18: -3012.169000000000000000000000 Updated rolling P&L for 2023-08-17: -2800.784000000000000000000000 Updated rolling P&L for 2023-09-16: -2674.741000000000000000000000 Updated rolling P&L for 2023-10-16: -2495.275500000000000000000000 Updated rolling P&L for 2023-11-15: -2450.406000000000000000000000 Updated rolling P&L for 2023-12-15: -2180.258000000000000000000000 Updated rolling P&L for 2024-01-14: -2376.257200000000000000000000 Updated rolling P&L for 2024-02-13: -2422.242300000000000000000000 Updated rolling P&L for 2024-03-14: -2144.626800000000000000000000 Updated rolling P&L for 2024-04-13: -2420.354000000000000000000000 Updated rolling P&L for 2024-05-13: -2488.859400000000000000000000 Updated rolling P&L for 2024-06-12: -2269.461100000000000000000000 Updated rolling P&L for 2024-07-12: -2006.612400000000000000000000 Updated rolling P&L for 2024-08-11: -2247.956600000000000000000000 Updated rolling P&L for 2024-09-10: -2140.219900000000000000000000 Updated rolling P&L for 2024-10-10: -2191.429300000000000000000000 Updated rolling P&L for 2024-11-09: -2341.898300000000000000000000 Updated rolling P&L for 2024-12-09: -2282.935300000000000000000000 Updated rolling P&L for 2025-01-08: -2182.528400000000000000000000 Updated rolling P&L for 2025-02-07: -2055.901000000000000000000000 Updated rolling P&L for 2025-03-09: -2222.493700000000000000000000 Updated rolling P&L for 2025-04-08: -2321.210600000000000000000000 Updated rolling P&L for 2025-05-08: -2303.926300000000000000000000 Updated rolling P&L for 2025-06-07: -2215.719900000000000000000000 Updated rolling P&L for 2025-07-07: -2127.998800000000000000000000 Updated rolling P&L for 2025-08-06: -2278.212900000000000000000000 Updated rolling P&L for 2025-09-05: -1993.129300000000000000000000 Updated rolling P&L for 2025-10-05: -1673.114900000000000000000000 Updated rolling P&L for 2025-11-04: -1831.639200000000000000000000 Updated rolling P&L for 2025-12-04: -1900.805100000000000000000000 Updated rolling P&L for 2026-01-03: 4601.162500000000000000000000 Portfolio rolling P&L update complete.
Update Rolling P&L	Success	Jan 19, 10:59:12	0 minutes	Update Rolling P&L - Output Found 37 missing dates to process. Created rolling P&L for 2023-01-19: -1995.898000000000000000000000 Created rolling P&L for 2023-02-18: -2504.405000000000000000000000 Created rolling P&L for 2023-03-20: -2508.387000000000000000000000 Created rolling P&L for 2023-04-19: -2565.497000000000000000000000 Created rolling P&L for 2023-05-19: -2754.492500000000000000000000 Created rolling P&L for 2023-06-18: -2862.830500000000000000000000 Created rolling P&L for 2023-07-18: -3012.169000000000000000000000 Created rolling P&L for 2023-08-17: -2800.784000000000000000000000 Created rolling P&L for 2023-09-16: -2674.741000000000000000000000 Created rolling P&L for 2023-10-16: -2495.275500000000000000000000 Created rolling P&L for 2023-11-15: -2450.406000000000000000000000 Created rolling P&L for 2023-12-15: -2180.258000000000000000000000 Created rolling P&L for 2024-01-14: -2376.257200000000000000000000 Created rolling P&L for 2024-02-13: -2422.242300000000000000000000 Created rolling P&L for 2024-03-14: -2144.626800000000000000000000 Created rolling P&L for 2024-04-13: -2420.354000000000000000000000 Created rolling P&L for 2024-05-13: -2488.859400000000000000000000 Created rolling P&L for 2024-06-12: -2269.461100000000000000000000 Created rolling P&L for 2024-07-12: -2006.612400000000000000000000 Created rolling P&L for 2024-08-11: -2247.956600000000000000000000 Created rolling P&L for 2024-09-10: -2140.219900000000000000000000 Created rolling P&L for 2024-10-10: -2191.429300000000000000000000 Created rolling P&L for 2024-11-09: -2341.898300000000000000000000 Created rolling P&L for 2024-12-09: -2282.935300000000000000000000 Created rolling P&L for 2025-01-08: -2182.528400000000000000000000 Created rolling P&L for 2025-02-07: -2055.901000000000000000000000 Created rolling P&L for 2025-03-09: -2222.493700000000000000000000 Created rolling P&L for 2025-04-08: -2321.210600000000000000000000 Created rolling P&L for 2025-05-08: -2303.926300000000000000000000 Created rolling P&L for 2025-06-07: -2215.719900000000000000000000 Created rolling P&L for 2025-07-07: -2127.998800000000000000000000 Created rolling P&L for 2025-08-06: -2278.212900000000000000000000 Created rolling P&L for 2025-09-05: -1993.129300000000000000000000 Created rolling P&L for 2025-10-05: -1673.114900000000000000000000 Created rolling P&L for 2025-11-04: -1831.639200000000000000000000 Created rolling P&L for 2025-12-04: -1900.805100000000000000000000 Created rolling P&L for 2026-01-03: 4601.162500000000000000000000 Portfolio rolling P&L update complete.
Refresh Live Prices	Success	Jan 19, 10:57:58	0 minutes	Refresh Live Prices - Output Starting price refresh for 5 securities... Updated: AAPL -> 255.517 Updated: MSFT -> 459.86 Updated: VOO -> 636.09 Updated: SHEL.L -> 2733.5 Updated: SIE.DE -> 254.25 Updated: 5 Errors: []