💾 Archived View for gemini.circumlunar.space › users › laur%C3%AB › finance › portfolio.sc captured on 2023-09-08 at 16:35:41.

View Raw

More Information

⬅️ Previous capture (2023-03-20)

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

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

format A 15 2 0
format B 13 6 0
format C 13 2 0
format D 14 0 0
format E 10 0 0
format F 15 2 0
format G 14 2 0
format I 17 2 0
format J 19 2 0
format N 20 2 0
leftstring A0 = "Portfolio"
leftstring C0 = "last updated"
let D0 = @dts(2021,8,30)
leftstring N1 = "General Overview"
leftstring A2 = "Emergency fund"
rightstring O2 = "Percentage"
rightstring P2 = "Amount"
leftstring N3 = "Chequing account"
let O3 = P3/P18*100
let P3 = 5000
leftstring A4 = "Account"
leftstring B4 = "Sector"
leftstring C4 = "Ticker"
leftstring D4 = "Date of entry"
rightstring E4 = "Quantity"
rightstring F4 = "Price of entry"
rightstring G4 = "Today's price"
rightstring H4 = "Variation"
rightstring I4 = "% Weight in book"
rightstring J4 = "In portfolio today"
rightstring K4 = "Category"
rightstring L4 = "Results"
leftstring N4 = "Emergency fund"
let O4 = P4/P18*100
let P4 = @sum(J5:J7)
leftstring A5 = "Bank 1"
leftstring B5 = "Savings"
leftstring D5 = "Aug 30,21"
let E5 = 1
let F5 = 1500
let G5 = 1505.1
let H5 = (G5/F5-1)*100
let I5 = J5/P4*100
let J5 = G5
rightstring K5 = "AP"
let L5 = (J5*H5+J6*H6+J7*H7)/P4
leftstring A6 = "Bank 2"
leftstring B6 = "Savings"
leftstring D6 = "Aug 30,21"
let E6 = 1
let F6 = 2550
let G6 = 2555.1
let H6 = (G6/F6-1)*100
let I6 = J6/P4*100
let J6 = G6
rightstring K6 = "AP"
leftstring N6 = "Amount invested"
let P6 = @sum(P10:P14)
leftstring A7 = "Bank 2"
leftstring B7 = "Chequing"
leftstring D7 = "Aug 30,21"
let E7 = 1
let F7 = 600
let G7 = 601.1
let H7 = (G7/F7-1)*100
let I7 = J7/P4*100
let J7 = G7
leftstring N7 = "Cash in Broker"
let P7 = 100
leftstring N8 = "Total invested"
let O8 = P8/P18*100
let P8 = @sum(P6:P7)
leftstring N9 = "________________________________________"
leftstring A10 = "Fixed Income"
leftstring N10 = "Fixed income"
let O10 = P10/P8*100
let P10 = @sum(J13:J14)
leftstring N11 = "Equities"
let O11 = P11/P8*100
let P11 = @sum(J20:J22)
rightstring Q11 = "*doesn't include dividends"
leftstring A12 = "Account"
leftstring B12 = "Sector"
leftstring C12 = "Ticker"
leftstring D12 = "Date of entry"
rightstring E12 = "Quantity"
rightstring F12 = "Price of entry"
rightstring G12 = "Today's price"
rightstring H12 = "Variation"
rightstring I12 = "% Weight in book"
rightstring J12 = "In portfolio today"
rightstring K12 = "Category"
rightstring L12 = "Results"
leftstring N12 = "REITs"
let O12 = P12/P8*100
let P12 = @sum(J30:J31)
rightstring Q12 = "*doesn't include rent"
leftstring A13 = "Exchange 1"
leftstring B13 = "Bonds"
leftstring C13 = "BOND.1"
leftstring D13 = "Aug 30,21"
let E13 = 1
let F13 = 100
let G13 = 120
let H13 = (G13/F13-1)*100
let I13 = J13/P10*100
let J13 = E13*G13
rightstring K13 = "AP"
let L13 = (J13*H13+J14*H14)/P10
leftstring N13 = "Cryptos"
let O13 = P13/P8*100
let P13 = @sum(J40:J44)
leftstring C14 = "BOND.2"
leftstring D14 = "Aug 30,21"
let E14 = 1
let F14 = 50
let G14 = 48
let H14 = (G14/F14-1)*100
let I14 = J14/P10*100
let J14 = E14*G14
rightstring K14 = "AP"
leftstring N14 = "Insurance"
let O14 = P14/P8*100
let P14 = @sum(J49:J50)
leftstring N15 = "Consolidated results"
let O15 = (O10*L13+O13*L40+O14*L49)/100
leftstring A17 = "Equities"
leftstring N17 = "________________________________________"
leftstring N18 = "Networth"
let P18 = P3+P4+P8
leftstring A19 = "Account"
leftstring B19 = "Sector"
leftstring C19 = "Ticker"
leftstring D19 = "Date of entry"
rightstring E19 = "Quantity"
rightstring F19 = "Price of entry"
rightstring G19 = "Today's price"
rightstring H19 = "Variation"
rightstring I19 = "% Weight in book"
rightstring J19 = "In portfolio today"
rightstring K19 = "Category"
rightstring L19 = "Results"
leftstring A20 = "Exchange 1"
leftstring B20 = "S&P 500"
leftstring C20 = "S&P"
leftstring D20 = "Aug 30,21"
let E20 = 15
let F20 = 50
let G20 = 60
let H20 = (G20/F20-1)*100
let I20 = J20/P11*100
let J20 = E20*G20
rightstring K20 = "AC"
let L20 = (J20*H20+J21*H21+J22*H22)/P11
leftstring A21 = "Exchange 1"
leftstring C21 = "stock.2"
leftstring D21 = "Aug 30,21"
let E21 = 10
let F21 = 25
let G21 = 26
let H21 = (G21/F21-1)*100
let I21 = J21/P11*100
let J21 = E21*G21
rightstring K21 = "AC"
leftstring A22 = "Exchange 1"
leftstring C22 = "stock.3"
leftstring D22 = "Aug 30,21"
let E22 = 5
let F22 = 12.5
let G22 = 16
let H22 = (G22/F22-1)*100
let I22 = J22/P11*100
let J22 = E22*G22
rightstring K22 = "AC"
leftstring A27 = "REIT"
leftstring A29 = "Account"
leftstring B29 = "Sector"
leftstring C29 = "Ticker"
leftstring D29 = "Date of entry"
rightstring E29 = "Quantity"
rightstring F29 = "Price of entry"
rightstring G29 = "Today's price"
rightstring H29 = "Variation"
rightstring I29 = "% Weight in book"
rightstring J29 = "In portfolio today"
rightstring K29 = "Category"
rightstring L29 = "Results"
leftstring A30 = "Exchange 1"
leftstring B30 = "appartments"
leftstring C30 = "reit.1"
leftstring D30 = "Aug 30,21"
let E30 = 5
let F30 = 50
let G30 = 80
let H30 = (G30/F30-1)*100
let I30 = J30/P12*100
let J30 = E30*G30
rightstring K30 = "IG"
let L30 = (J30*H30+J31*H31)/P12
leftstring A31 = "Exchange 1"
leftstring B31 = "entertainment"
leftstring C31 = "reit.2"
let E31 = 5
let F31 = 50
let G31 = 55
let H31 = (G31/F31-1)*100
let I31 = J31/P12*100
let J31 = E31*G31
rightstring K31 = "IG"
leftstring A37 = "Crypto"
leftstring A39 = "Account"
leftstring B39 = "Sector"
leftstring C39 = "Ticker"
leftstring D39 = "Date of entry"
rightstring E39 = "Quantity"
rightstring F39 = "Price of entry"
rightstring G39 = "Today's price"
rightstring H39 = "Variation"
rightstring I39 = "% Weight in book"
rightstring J39 = "In portfolio today"
rightstring K39 = "Category"
rightstring L39 = "Results"
leftstring A40 = "Exchange 2 "
leftstring C40 = "BTC"
leftstring D40 = "Aug 30,21"
let E40 = 0.02
let F40 = 450
let G40 = 45000
let H40 = (J40/F40-1)*100
let I40 = J40/P13*100
let J40 = E40*G40
rightstring K40 = "AC"
let L40 = (J40*H40+J41*H41+J42*H42+J43*H43+J44*H44)/P13
leftstring A41 = "wallet"
leftstring C41 = "crypto"
leftstring D41 = "Aug 30,21"
let E41 = 0.05
let F41 = 50
let G41 = 1050
let H41 = (J41/F41-1)*100
let I41 = J41/P13*100
let J41 = E41*G41
rightstring K41 = "AC"
leftstring A42 = "wallet"
leftstring C42 = "crypto"
leftstring D42 = "Aug 30,21"
let E42 = 10
let F42 = 10
let G42 = 1
let H42 = (J42/F42-1)*100
let I42 = J42/P13*100
let J42 = E42*G42
rightstring K42 = "AC"
leftstring A43 = "wallet"
leftstring C43 = "crypto"
leftstring D43 = "Aug 30,21"
let E43 = 0.5
let F43 = 500
let G43 = 2000
let H43 = (J43/F43-1)*100
let I43 = J43/P13*100
let J43 = E43*G43
rightstring K43 = "AC"
leftstring A44 = "wallet"
leftstring C44 = "crypto"
leftstring D44 = "Aug 30,21"
let E44 = 50
let F44 = 10
let G44 = 0.5
let H44 = (J44/F44-1)*100
let I44 = J44/P13*100
let J44 = E44*G44
rightstring K44 = "AC"
leftstring A46 = "Insurance"
leftstring A48 = "Account"
leftstring B48 = "Sector"
leftstring C48 = "Ticker"
leftstring D48 = "Date of entry"
rightstring E48 = "Quantity"
rightstring F48 = "Price of entry"
rightstring G48 = "Today's price"
rightstring H48 = "Variation"
rightstring I48 = "% Weight in book"
rightstring J48 = "In portfolio today"
rightstring K48 = "Category"
rightstring L48 = "Results"
leftstring A49 = "Bank 3"
leftstring B49 = "gold/ounce"
leftstring D49 = "Aug 30,21"
let E49 = 1
let F49 = 1820
let G49 = 1826
let H49 = (G49/F49-1)*100
let I49 = J49/P14*100
let J49 = E49*G49
rightstring K49 = "AP"
let L49 = (J49*H49+J50*H50)/P14
leftstring A50 = "Bank 3"
leftstring B50 = "silver/ounce"
leftstring D50 = "Aug 30,21"
let E50 = 1
let F50 = 24
let G50 = 24.24
let H50 = (G50/F50-1)*100
let I50 = J50/P14*100
let J50 = E50*G50
rightstring K50 = "AP"
goto N17 K0