| A | B | C | D | E | G | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 日本株記入エリア | |||||||||||
2 | 証券コード | 数量 | 取得単価 | セクター | 銘柄 | 現在値 | 損益額 | 損益率 | 評価額 | 累積配当 | 総損益 | |
3 | 1545 | 180 | 8746 | 米株etf | #N/A | -¥1,574,280 | -100.00% | ¥0 | -¥1,574,280 | |||
4 | 1546 | 38 | 26930 | 米株etf | #N/A | -¥1,023,340 | -100.00% | ¥0 | -¥1,023,340 | |||
5 | 1547 | 50 | 3477 | 米株etf | #N/A | -¥173,850 | -100.00% | ¥0 | -¥173,850 | |||
6 | 1550 | 100 | 2432 | 米株etf | #N/A | -¥243,200 | -100.00% | ¥0 | -¥243,200 | |||
7 | 1345 | 100 | 2233 | 不動産 | #N/A | -¥223,300 | -100.00% | ¥0 | -¥223,300 | |||
8 | 1495 | 10 | 11820 | 不動産 | #N/A | -¥118,200 | -100.00% | ¥0 | -¥118,200 | |||
9 | 2702 | 100 | 1609 | 食品 | #N/A | -¥160,900 | -100.00% | ¥0 | -¥160,900 | |||
10 | 4917 | 200 | 1255 | 消費財 | #N/A | -¥251,000 | -100.00% | ¥0 | -¥251,000 | |||
11 | 2809 | 100 | 929 | 食品 | #N/A | -¥92,900 | -100.00% | ¥0 | -¥92,900 | |||
12 | 9861 | 100 | 2799 | 食品 | #N/A | -¥279,900 | -100.00% | ¥0 | -¥279,900 | |||
13 | 合計 | -¥4,140,870 | -100.00% | ¥0 | ¥0 | -¥4,140,870 | ||||||
14 | ||||||||||||
15 | 米国株記入エリア | USD/JPY | 143.967 | |||||||||
16 | symbol | 数量 | 取得単価 | セクター | 銘柄 | 現在値 | 損益額 | 損益率 | 評価額 | 累積配当 | 総損益 | 評価額（円） |
17 | MSFT | 30 | 161.6 | technology | Microsoft Corp | 435.28 | $8,210.40 | 169.36% | $13,058.40 | $8,210.40 | ¥1,879,979 | |
18 | GOOGL | 2 | 1356.49 | technology | Alphabet Inc Class A | 164.03 | -$2,384.92 | -87.91% | $328.06 | -$2,384.92 | ¥47,230 | |
19 | AMZN | 2 | 2075.18 | technology | Amazon.com Inc | 189.98 | -$3,770.40 | -90.85% | $379.96 | -$3,770.40 | ¥54,702 | |
20 | FISV | 3 | 122.55 | technology | Fiserv Inc | 162.34 | $119.37 | 32.47% | $487.02 | $119.37 | ¥70,115 | |
21 | TDOC | 4 | 106.62 | technology | Teladoc Health Inc | 7.06 | -$398.24 | -93.38% | $28.24 | -$398.24 | ¥4,066 | |
22 | DDOG | 10 | 48.1 | technology | Datadog Inc | 105 | $569.00 | 118.30% | $1,050.00 | $569.00 | ¥151,165 | |
23 | DOCU | 10 | 90.25 | technology | Docusign Inc | 82.13 | -$81.20 | -9.00% | $821.30 | -$81.20 | ¥118,240 | |
24 | ABBV | 5 | 94.77 | healthcare | AbbVie Inc | 198.47 | $518.50 | 109.42% | $992.35 | $518.50 | ¥142,866 | |
25 | T | 60 | 38.74 | communications | AT&T Inc | 27.61 | -$667.80 | -28.73% | $1,656.60 | -$667.80 | ¥238,496 | |
26 | VZ | 5 | 60.18 | communications | Verizon Communications Inc | 43.74 | -$82.20 | -27.32% | $218.70 | -$82.20 | ¥31,486 | |
27 | MO | 20 | 51.08 | consumerstaples | Altria Group Inc | 59.61 | $170.60 | 16.70% | $1,192.20 | $170.60 | ¥171,637 | |
28 | VYM | 22 | 94.17 | ETF/DIV | Vanguard High Dividend Yield Index Fund ETF | 125.9 | $698.06 | 33.69% | $2,769.80 | $698.06 | ¥398,760 | |
29 | VIG | 24 | 128.95 | ETF/DIV | Vanguard Dividend Appreciation Index Fund ETF | 193.02 | $1,537.68 | 49.69% | $4,632.48 | $1,537.68 | ¥666,924 | |
30 | SPYD | 90 | 39.68 | ETF/DIV | SPDR Portfolio S&P 500 High Dividend ETF | 42.42 | $246.60 | 6.91% | $3,817.80 | $246.60 | ¥549,637 | |
31 | HDV | 1 | 95.01 | ETF/DIV | iShares Core High Dividend ETF | 115.57 | $20.56 | 21.64% | $115.57 | $20.56 | ¥16,638 | |
32 | QQQ | 6 | 224.82 | technology | Invesco QQQ Trust, Series 1 | 488.83 | $1,584.06 | 117.43% | $2,932.98 | $1,584.06 | ¥422,252 | |
33 | GDX | 200 | 30.75 | ETF/DEF | VanEck Gold Miners ETF | 47.08 | $3,266.00 | 53.11% | $9,416.00 | $3,266.00 | ¥1,355,593 | |
34 | 合計 | $9,556.07 | 27.83% | $43,897.46 | 0 | $9,556.07 | ¥6,319,786 | |||||
35 | ||||||||||||
36 | sum(K3:K6) | 日米（口座別） | ||||||||||
37 | 日本 | ¥0 | ||||||||||
38 | 米国 | ¥6,319,786 | ||||||||||
39 | ||||||||||||
40 | ||||||||||||
41 | 日米（内容別） | |||||||||||
42 | 日本 | ¥0 | ||||||||||
43 | 米国 | ¥6,319,786 | ||||||||||
44 | ||||||||||||
45 | ||||||||||||
46 | ||||||||||||
47 | ||||||||||||
48 | ||||||||||||
49 | ||||||||||||
50 | ||||||||||||
51 | ||||||||||||
52 | ||||||||||||
53 | ||||||||||||
54 | ||||||||||||
55 | ||||||||||||
56 | ||||||||||||
57 | ||||||||||||
58 | ||||||||||||
59 | ||||||||||||
60 | ||||||||||||
61 | ||||||||||||
62 | ||||||||||||
63 | ||||||||||||
64 | ||||||||||||
65 | ||||||||||||
66 | ||||||||||||
67 | ||||||||||||
68 | ||||||||||||
69 | ||||||||||||
70 | Dividend50% | |||||||||||
71 | Tech25% | |||||||||||
72 | Def25% | |||||||||||
73 | ||||||||||||
74 | ||||||||||||
75 | ||||||||||||
76 | ||||||||||||
77 | ||||||||||||
78 | ||||||||||||
79 | ||||||||||||
80 | ||||||||||||
81 | ||||||||||||
82 | ||||||||||||
83 | ||||||||||||
84 |