Tutorial Membuat Buku Investasi Saham Sederhana Menggunakan Excel
Untuk mempermudah pemahaman terhadap penjelasan di video, salin (copy) dan tempel (paste) rumus excel (function & formula) berikut pada sel yang sesuai.
Sheet "Investasi", Baris 3 dan 5
- Cell (J3) =SUM(E5:E1048576)
- Cell (K3) =SUM(F5:F1048576)
- Cell (L3) =E3-F3
- (A5) =N(A4)+1
- (C5) =IF(E5="","",IF(E5="M",B5,IF(E5="BH",B5,IF(E5="D",B5,IF(E5="W",B5,IF(NETWORKDAYS(B5,B5+2)=3,B5+2,IF(NETWORKDAYS(B5,B5+2)=2,B5+4,B5+4)))))))
- (E5) =IF(G5="","",IF(LEFT(G5,5)="Modal","M",IF(G5="Bagi Hasil","BH",IF(LEFT(G5,3)="Div","D",IF(LEFT(G5,3)="Wit","W",IF(LEFT(G5,4)="Beli","B",IF(LEFT(G5,4)="Jual","S")))))))
- (F5) =IFERROR(IFS(LEFT(G5,4)="Beli",RIGHT(G5,4),LEFT(G5,4)="Jual",RIGHT(G5,4),LEFT(G5,3)="Div",RIGHT(G5,4)),"")
- (J5) =IF(E5="M",H5,IF(E5="BH",H5,IF(E5="D",H5*I5*100,IF(E5="S",H5*I5*100*XLOOKUP(D5,Fee!$A:$A,Fee!$C:$C),""))))
- (K5) =IF(E5="W",H5,IF(E5="B",H5*I5*100*XLOOKUP(D5,Fee!$A:$A,Fee!$B:$B),""))
- (L5) =IF(E5="","",N(L4)+NUMBERVALUE(J5)-NUMBERVALUE(K5))
Tutorial Membuat Buku Investasi Saham Sederhana Menggunakan Excel
No comments
Post a Comment