SQL=SELECT
startValue.fidCurDate AS startDate,
startValue.fidTot AS startValue,
TotalMax.fidCurDate AS maxDate,
TotalMax.maxTot AS TotalMax,
TotalMin.fidCurDate AS minDate,
TotalMin.minTot AS TotalMin,
MostRecent.fidCurDate AS mostRecentDate,
MostRecent.fidTot AS mostRecentValue
FROM
(SELECT fidCurDate, fidTot FROM fidelity WHERE fidId = '286') AS startValue,
(SELECT fidCurDate, MAX(fidTot) AS maxTot FROM fidelity WHERE fidCurDate BETWEEN '2022-01-01' AND CONCAT(YEAR(CURDATE()), '-12-31')) AS TotalMax,
(SELECT fidCurDate, MIN(fidTot) AS minTot FROM fidelity WHERE fidCurDate BETWEEN '2022-01-01' AND CONCAT(YEAR(CURDATE()), '-12-31')) AS TotalMin,
(SELECT fidCurDate, fidTot FROM fidelity ORDER BY fidCurDate DESC LIMIT 1) AS MostRecent
Column Names
Array
(
[0] => startDate
[1] => startValue
[2] => maxDate
[3] => TotalMax
[4] => minDate
[5] => TotalMin
[6] => mostRecentDate
[7] => mostRecentValue
)
|
2022 Statistics - Min - Max - Losses
2022 Withdrawals: House: - Monthly $2,000/mo - Fees: - Deposits:
| Start Value | Min | Max | Last Bal | Max-Loss | Real Gain/Loss |
| $ 1,946,000 | $ 2,066,769 | $ 3,580,567 | $ 0 | $ -3,580,567 | $ -1,946,000 |
|
NEW TTITLE Results
| startDate | startValue | maxDate | TotalMax | minDate | TotalMin | mostRecentDate | mostRecentValue |
|---|
|