[Investment tech hack] 運用管理表(記事用)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1
【補足事項】
このスプレッドシートはサンプルとして、作者の2015年の実際のデータを入力してあります。
当時は記録していなかった項目も含まれることから正常に表示されない箇所がいくつかあります。
予めご了承ください。
2
※白背景の箇所を手入力していく
前日
3
2015純資産残高追加資金資金削減運用資金
増減メモ
1Nの価値N合計N実質前日比年の推移四半期の推移月ごとの推移備考
4
日付口座1口座2口座3口座4銀行合計230,551668,348N比累計損益最大残高DDDD %DD 日数1st累計損益最大残高DDDD %DD 日数1st累計損益最大残高DDDD %DD 日数
5
14/12/31 水154,434641,640000796,074796,074
6
15/1/1 木154,434641,640000796,07400.00%0.00%0796,07400.00%010796,07400.00%010796,07400.00%0
7
15/1/2 金154,434660,770000815,20419,1302.40%0.00%19,130815,20400.00%019,130815,20400.00%019,130815,20400.00%0
8
15/1/5 月140,086691,103000831,189*15,9851.96%0.00%35,115831,18900.00%035,115831,18900.00%035,115831,18900.00%0
9
15/1/6 火0000832,130832,130*9410.11%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
10
15/1/7 水0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
11
15/1/8 木0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
12
15/1/9 金0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
13
15/1/12 月0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
14
15/1/13 火0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
15
15/1/14 水0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
16
15/1/15 木0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
17
15/1/16 金0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
18
15/1/19 月0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
19
15/1/20 火0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
20
15/1/21 水0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
21
15/1/22 木0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
22
15/1/23 金0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
23
15/1/26 月0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
24
15/1/27 火0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
25
15/1/28 水0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
26
15/1/29 木0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
27
15/1/30 金0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%036,056832,13000.00%0
28
15/2/2 月0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%010832,13000.00%0
29
15/2/3 火0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%00832,13000.00%0
30
15/2/4 水0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%00832,13000.00%0
31
15/2/5 木0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%00832,13000.00%0
32
15/2/6 金0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%00832,13000.00%0
33
15/2/9 月0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%00832,13000.00%0
34
15/2/10 火0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%00832,13000.00%0
35
15/2/12 木0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%00832,13000.00%0
36
15/2/13 金0000832,130832,130*00.00%0.00%36,056832,13000.00%036,056832,13000.00%00832,13000.00%0
37
15/2/16 月0000500,000500,000*-332,130-39.91%0.00%-296,074832,130-332,130-39.91%1-296,074832,130-332,130-39.91%1-332,130832,130-332,130-39.91%1
38
15/2/17 火0000500,000500,0004119*1.00%*0%*00.00%0.00%-296,074832,130-332,130-39.91%2-296,074832,130-332,130-39.91%2-332,130832,130-332,130-39.91%2
39
15/2/18 水0300,00000200,000500,0004119*1.00%*0%*00.00%0.00%-296,074832,130-332,130-39.91%3-296,074832,130-332,130-39.91%3-332,130832,130-332,130-39.91%3
40
15/2/19 木0300,00000200,000500,000332,1304119*1.00%*0%*332,13039.91%0.00%36,056500,00000.00%036,056500,00000.00%00500,00000.00%0
41
15/2/20 金0300,00000200,000500,000*00.00%0.00%36,056500,00000.00%036,056500,00000.00%00500,00000.00%0
42
15/2/23 月0300,00000200,000500,000*00.00%0.00%36,056500,00000.00%036,056500,00000.00%00500,00000.00%0
43
15/2/24 火0300,00000200,000500,000*00.00%0.00%36,056500,00000.00%036,056500,00000.00%00500,00000.00%0
44
15/2/25 水0300,00000200,000500,000*00.00%0.00%36,056500,00000.00%036,056500,00000.00%00500,00000.00%0
45
15/2/26 木0300,00000200,000500,000*00.00%0.00%36,056500,00000.00%036,056500,00000.00%00500,00000.00%0
46
15/2/27 金0301,45500200,000501,455*1,4550.29%0.00%37,511501,45500.00%037,511501,45500.00%01,455501,45500.00%0
47
15/3/2 月0307,00000200,000507,000*5,5451.11%0.00%43,056507,00000.00%043,056507,00000.00%015,545501,45500.00%0
48
15/3/3 火0302,00000200,000502,000*-5,000-0.99%0.00%38,056507,000-5,000-0.99%138,056507,000-5,000-0.99%1545502,00000.00%0
49
15/3/4 水0311,00800200,000511,008*9,0081.79%0.00%47,064511,00800.00%047,064511,00800.00%09,553511,00800.00%0
50
15/3/5 木0345,66600200,000545,666*34,6586.78%0.00%81,722545,66600.00%081,722545,66600.00%044,211545,66600.00%0
51
15/3/6 金0370,00000200,000570,000*24,3344.46%0.00%106,056570,00000.00%0106,056570,00000.00%068,545570,00000.00%0
52
15/3/9 月0519,52900100,000619,529*49,5298.69%0.00%155,585619,52900.00%0155,585619,52900.00%0118,074619,52900.00%0
53
15/3/10 火0534,30400100,000634,304*14,7752.38%0.00%170,360634,30400.00%0170,360634,30400.00%0132,849634,30400.00%0
54
15/3/11 水0563,92500100,000663,925*29,6214.67%0.00%199,981663,92500.00%0199,981663,92500.00%0162,470663,92500.00%0
55
15/3/12 木0630,46000100,000730,460*66,53510.02%0.00%266,516730,46000.00%0266,516730,46000.00%0229,005730,46000.00%0
56
15/3/13 金0616,75700100,000716,757*-13,703-1.88%0.00%252,813730,460-13,703-1.88%1252,813730,460-13,703-1.88%1215,302730,460-13,703-1.88%1
57
15/3/16 月0648,50400100,000748,504*31,7474.43%0.00%284,560748,50400.00%0284,560748,50400.00%0247,049748,50400.00%0
58
15/3/17 火0640,30100100,000740,301*-8,203-1.10%0.00%276,357748,504-8,203-1.10%1276,357748,504-8,203-1.10%1238,846748,504-8,203-1.10%1
59
15/3/18 水0648,35100100,000748,351*8,0501.09%0.00%284,407748,504-153-0.02%2284,407748,504-153-0.02%2246,896748,504-153-0.02%2
60
15/3/19 木0531,82500100,000631,825*-116,526-15.57%0.00%167,881748,504-116,679-15.59%3167,881748,504-116,679-15.59%3130,370748,504-116,679-15.59%3
61
15/3/20 金0562,26200100,000662,262*30,4374.82%0.00%198,318748,504-86,242-11.52%4198,318748,504-86,242-11.52%4160,807748,504-86,242-11.52%4
62
15/3/23 月0374,01500250,000624,015*-38,247-5.78%0.00%160,071748,504-124,489-16.63%5160,071748,504-124,489-16.63%5122,560748,504-124,489-16.63%5
63
15/3/24 火0362,22600250,000612,226*-11,789-1.89%0.00%148,282748,504-136,278-18.21%6148,282748,504-136,278-18.21%6110,771748,504-136,278-18.21%6
64
15/3/25 水149,600368,987000518,587*-93,639-15.29%0.00%54,643748,504-229,917-30.72%754,643748,504-229,917-30.72%717,132748,504-229,917-30.72%7
65
15/3/26 木154,900354,453000509,353*-9,234-1.78%0.00%45,409748,504-239,151-31.95%845,409748,504-239,151-31.95%87,898748,504-239,151-31.95%8
66
15/3/27 金151,000363,364000514,364*5,0110.98%0.00%50,420748,504-234,140-31.28%950,420748,504-234,140-31.28%912,909748,504-234,140-31.28%9
67
15/3/30 月137,200363,879000501,079100,000*86,71514.11%0.00%137,135648,504-147,425-22.73%10137,135648,504-147,425-22.73%1099,624648,504-147,425-22.73%10
68
15/3/31 火138,400371,207000509,607*8,5281.70%0.00%145,663648,504-138,897-21.42%11145,663648,504-138,897-21.42%11108,152648,504-138,897-21.42%11
69
15/4/1 水135,000368,770000503,770*-5,837-1.15%0.00%139,826648,504-144,734-22.32%121-5,837509,607-5,837-1.15%11-5,837509,607-5,837-1.15%1
70
15/4/2 木154,900378,715000533,615*29,8455.92%0.00%169,671648,504-114,889-17.72%1324,008533,61500.00%024,008533,61500.00%0
71
15/4/3 金155,700373,426000529,126*-4,489-0.84%0.00%165,182648,504-119,378-18.41%1419,519533,615-4,489-0.84%119,519533,615-4,489-0.84%1
72
15/4/6 月191,900362,906000554,806*25,6804.85%0.00%190,862648,504-93,698-14.45%1545,199554,80600.00%045,199554,80600.00%0
73
15/4/7 火187,200360,810000548,010*-6,796-1.22%0.00%184,066648,504-100,494-15.50%1638,403554,806-6,796-1.22%138,403554,806-6,796-1.22%1
74
15/4/8 水207,600342,784000550,384*2,3740.43%0.00%186,440648,504-98,120-15.13%1740,777554,806-4,422-0.80%240,777554,806-4,422-0.80%2
75
15/4/9 木221,600329,804000551,404*1,0200.19%0.00%187,460648,504-97,100-14.97%1841,797554,806-3,402-0.61%341,797554,806-3,402-0.61%3
76
15/4/10 金180,420342,032000522,452*-28,952-5.25%0.00%158,508648,504-126,052-19.44%1912,845554,806-32,354-5.83%412,845554,806-32,354-5.83%4
77
15/4/13 月167,620348,138000515,758*-6,694-1.28%0.00%151,814648,504-132,746-20.47%206,151554,806-39,048-7.04%56,151554,806-39,048-7.04%5
78
15/4/14 火167,320341,985000509,305*-6,453-1.25%0.00%145,361648,504-139,199-21.46%21-302554,806-45,501-8.20%6-302554,806-45,501-8.20%6
79
15/4/15 水134,220333,446000467,666*-41,639-8.18%0.00%103,722648,504-180,838-27.89%22-41,941554,806-87,140-15.71%7-41,941554,806-87,140-15.71%7
80
15/4/16 木126,020337,032000463,052*-4,614-0.99%0.00%99,108648,504-185,452-28.60%23-46,555554,806-91,754-16.54%8-46,555554,806-91,754-16.54%8
81
15/4/17 金132,220334,917000467,137*4,0850.88%0.00%103,193648,504-181,367-27.97%24-42,470554,806-87,669-15.80%9-42,470554,806-87,669-15.80%9
82
15/4/20 月140,000333,496000473,496*6,3591.36%0.00%109,552648,504-175,008-26.99%25-36,111554,806-81,310-14.66%10-36,111554,806-81,310-14.66%10
83
15/4/21 火108,020333,848000441,868*-31,628-6.68%0.00%77,924648,504-206,636-31.86%26-67,739554,806-112,938-20.36%11-67,739554,806-112,938-20.36%11
84
15/4/22 水71,440334,321000405,761*-36,107-8.17%0.00%41,817648,504-242,743-37.43%27-103,846554,806-149,045-26.86%12-103,846554,806-149,045-26.86%12
85
15/4/23 木79,840320,922000400,762*-4,999-1.23%0.00%36,818648,504-247,742-38.20%28-108,845554,806-154,044-27.77%13-108,845554,806-154,044-27.77%13
86
15/4/24 金72,540330,172000402,712*1,9500.49%0.00%38,768648,504-245,792-37.90%29-106,895554,806-152,094-27.41%14-106,895554,806-152,094-27.41%14
87
15/4/27 月86,040261,704000347,744*-54,968-13.65%0.00%-16,200648,504-300,760-46.38%30-161,863554,806-207,062-37.32%15-161,863554,806-207,062-37.32%15
88
15/4/28 火69,740259,677000329,4174119*1.00%*0%*-18,327-5.27%0.00%-34,527648,504-319,087-49.20%31-180,190554,806-225,389-40.62%16-180,190554,806-225,389-40.62%16
89
15/4/29 水58,940268,000000326,9404119*1.00%*0%*-2,477-0.75%0.00%-37,004648,504-321,564-49.59%32-182,667554,806-227,866-41.07%17-182,667554,806-227,866-41.07%17
90
15/4/30 木106,040235,529000341,56960,0004119*1.00%*0%*74,62919.29%0.00%37,625588,504-246,935-41.96%33-108,038494,806-153,237-30.97%18-108,038494,806-153,237-30.97%18
91
15/5/1 金107,540258,347000365,887*24,3187.12%0.00%61,943588,504-222,617-37.83%34-83,720494,806-128,919-26.05%19124,318341,56900.00%0
92
15/5/4 月112,040263,591000375,631*9,7442.66%0.00%71,687588,504-212,873-36.17%35-73,976494,806-119,175-24.09%2034,062375,63100.00%0
93
15/5/5 火112,040275,001000387,041*11,4103.04%0.00%83,097588,504-201,463-34.23%36-62,566494,806-107,765-21.78%2145,472387,04100.00%0
94
15/5/6 水112,040271,637000383,677*-3,364-0.87%0.00%79,733588,504-204,827-34.80%37-65,930494,806-111,129-22.46%2242,108387,041-3,364-0.87%1
95
15/5/7 木111,440282,921000394,361*10,6842.78%0.00%90,417588,504-194,143-32.99%38-55,246494,806-100,445-20.30%2352,792394,36100.00%0
96
15/5/8 金105,740277,128000382,868*-11,493-2.91%0.00%78,924588,504-205,636-34.94%39-66,739494,806-111,938-22.62%2441,299394,361-11,493-2.91%1
97
15/5/11 月112,940260,948000373,888*-8,980-2.35%0.00%69,944588,504-214,616-36.47%40-75,719494,806-120,918-24.44%2532,319394,361-20,473-5.19%2
98
15/5/12 火110,040281,202000391,242*17,3544.64%0.00%87,298588,504-197,262-33.52%41-58,365494,806-103,564-20.93%2649,673394,361-3,119-0.79%3
99
15/5/13 水108,140268,271000376,411*-14,831-3.79%0.00%72,467588,504-212,093-36.04%42-73,196494,806-118,395-23.93%2734,842394,361-17,950-4.55%4
100
15/5/14 木107,240269,037000376,277*-134-0.04%0.00%72,333588,504-212,227-36.06%43-73,330494,806-118,529-23.95%2834,708394,361-18,084-4.59%5
Loading...
 
 
 
資金の推移
銘柄とリスクの管理
トレード記録
資金の管理と分析
グラフ
設定
Holidays
DB
 
 
Main menu