💾 Archived View for gemini.circumlunar.space › users › laur%C3%AB › finance › annual_portfolio_balan… captured on 2023-03-20 at 19:19:04.

View Raw

More Information

⬅️ Previous capture (2021-12-03)

🚧 View Differences

-=-=-=-=-=-=-

# This data file was generated by the Spreadsheet Calculator.
# You almost certainly shouldn't edit it.

format A 18 2 0
format Z 14 2 0
label A0 = "Year 2021"
leftstring A2 = "Investments"
label B2 = "January"
label C2 = "%"
label D2 = "February"
fmt D2 "February"
label E2 = "%"
label F2 = "March"
label G2 = "%"
label H2 = "April"
label I2 = "%"
label J2 = "May"
label K2 = "%"
label L2 = "June"
label M2 = "%"
label N2 = "July"
label O2 = "%"
label P2 = "August"
label Q2 = "%"
label R2 = "September"
label S2 = "%"
label T2 = "October"
label U2 = "%"
label V2 = "November"
label W2 = "%"
label X2 = "December"
label Y2 = "%"
leftstring Z2 = "Final Balance"
leftstring A3 = "Fixed Income"
let B3 = 200
let C3 = B3/B11*100
let D3 = 220
let E3 = D3/D11*100
let F3 = 215
let G3 = F3/F11*100
let I3 = H3/H11*100
let K3 = J3/J11*100
let M3 = L3/L11*100
let O3 = N3/N11*100
let Q3 = P3/P11*100
let S3 = R3/R11*100
let U3 = T3/T11*100
let W3 = V3/V11*100
let Y3 = X3/X11*100
leftstring A4 = "Stocks"
let B4 = 2000
let C4 = B4/B11*100
let D4 = 1990
let E4 = D4/D11*100
let F4 = 2150
let G4 = F4/F11*100
let I4 = H4/H11*100
let K4 = J4/J11*100
let M4 = L4/L11*100
let O4 = N4/N11*100
let Q4 = P4/P11*100
let S4 = R4/R11*100
let U4 = T4/T11*100
let W4 = V4/V11*100
let Y4 = X4/X11*100
leftstring A5 = "Real State"
let B5 = 400
let C5 = B5/B11*100
let D5 = 400
let E5 = D5/D11*100
let F5 = 450
let G5 = F5/F11*100
let I5 = H5/H11*100
let K5 = J5/J11*100
let M5 = L5/L11*100
let O5 = N5/N11*100
let Q5 = P5/P11*100
let S5 = R5/R11*100
let U5 = T5/T11*100
let W5 = V5/V11*100
let Y5 = X5/X11*100
leftstring A6 = "Crypto*"
let B6 = 800
let C6 = B6/B11*100
let D6 = 1000
let E6 = D6/D11*100
let F6 = 900
let G6 = F6/F11*100
let I6 = H6/H11*100
let K6 = J6/J11*100
let M6 = L6/L11*100
let O6 = N6/N11*100
let Q6 = P6/P11*100
let S6 = R6/R11*100
let U6 = T6/T11*100
let W6 = V6/V11*100
let Y6 = X6/X11*100
leftstring A7 = "Insurance fund"
let B7 = 100
let C7 = B7/B11*100
let D7 = 100
let E7 = D7/D11*100
let F7 = 110
let G7 = F7/F11*100
let I7 = H7/H11*100
let K7 = J7/J11*100
let M7 = L7/L11*100
let O7 = N7/N11*100
let Q7 = P7/P11*100
let S7 = R7/R11*100
let U7 = T7/T11*100
let W7 = V7/V11*100
let Y7 = X7/X11*100
leftstring A8 = "Emergency fund"
let B8 = 5000
let C8 = B8/B11*100
let D8 = 5000
let E8 = D8/D11*100
let F8 = 5500
let G8 = F8/F11*100
let I8 = H8/H11*100
let K8 = J8/J11*100
let M8 = L8/L11*100
let O8 = N8/N11*100
let Q8 = P8/P11*100
let S8 = R8/R11*100
let U8 = T8/T11*100
let W8 = V8/V11*100
let Y8 = X8/X11*100
label Z8 = "Year Goal:"
leftstring A9 = "Broker (chequing)"
let B9 = 100
let C9 = B9/B11*100
let D9 = 100
let E9 = D9/D11*100
let F9 = 50
let G9 = F9/F11*100
let I9 = H9/H11*100
let K9 = J9/J11*100
let M9 = L9/L11*100
let O9 = N9/N11*100
let Q9 = P9/P11*100
let S9 = R9/R11*100
let U9 = T9/T11*100
let W9 = V9/V11*100
let Y9 = X9/X11*100
label Z9 = "insert goal"
leftstring A10 = "Bank (chequing)"
let B10 = 5000
let C10 = B10/B11*100
let D10 = 4500
let E10 = D10/D11*100
let F10 = 5000
let G10 = F10/F11*100
let I10 = H10/H11*100
let K10 = J10/J11*100
let M10 = L10/L11*100
let O10 = N10/N11*100
let Q10 = P10/P11*100
let S10 = R10/R11*100
let U10 = T10/T11*100
let W10 = V10/V11*100
let Y10 = X10/X11*100
label Z10 = "Results"
leftstring A11 = "Total"
let B11 = @sum(B3:B10)
label C11 = "---"
let D11 = @sum(D3:D10)
let E11 = (D11/B11-1)*100
let F11 = @sum(F3:F10)
let G11 = (F11/D11-1)*100
let I11 = (H11/F11-1)*100
let K11 = (J11/H11-1)*100
let M11 = (L11/J11-1)*100
let O11 = (N11/L11-1)*100
let Q11 = (P11/N11-1)*100
let S11 = (R11/P11-1)*100
let U11 = (T11/R11-1)*100
let W11 = (V11/T11-1)*100
let Y11 = (X11/V11-1)*100
let Z11 = X11
leftstring A13 = "References"
leftstring A14 = "Dolar"
label C14 = "-"
label E14 = "-"
label G14 = "-"
label I14 = "-"
label K14 = "-"
label M14 = "-"
label O14 = "-"
label Q14 = "-"
label S14 = "-"
label U14 = "-"
label W14 = "-"
label Y14 = "-"
leftstring A15 = "Euro*"
label C15 = "-"
label E15 = "-"
label G15 = "-"
label I15 = "-"
label K15 = "-"
label M15 = "-"
label O15 = "-"
label Q15 = "-"
label S15 = "-"
label U15 = "-"
label W15 = "-"
label Y15 = "-"
leftstring A16 = "Bitcoin*"
label C16 = "-"
label E16 = "-"
label G16 = "-"
label I16 = "-"
label K16 = "-"
label M16 = "-"
label O16 = "-"
label Q16 = "-"
label S16 = "-"
label U16 = "-"
label W16 = "-"
label Y16 = "-"
leftstring A17 = "Gold**"
label C17 = "-"
label E17 = "-"
label G17 = "-"
label I17 = "-"
label K17 = "-"
label M17 = "-"
label O17 = "-"
label Q17 = "-"
label S17 = "-"
label U17 = "-"
label W17 = "-"
label Y17 = "-"
leftstring A18 = "Date of month"
label C18 = "-"
label E18 = "-"
label G18 = "-"
label I18 = "-"
label K18 = "-"
label M18 = "-"
label O18 = "-"
label Q18 = "-"
label S18 = "-"
label U18 = "-"
label W18 = "-"
label Y18 = "-"
leftstring A20 = "*converted in dolar"
leftstring A21 = "** showed in dolar/ounce"
goto A0 A0