[investment tech hack] CSVを自動取得(関数を使用)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKL
1
2
記事へ戻る
3
2018/11/21 =today()
4
2018-11
=if(month(A1)<10,year(A1)&"-0"&MONTH(A1),year(A1)&"-"&MONTH(A1))
5
日付カテゴリー銘柄コード限月ストライクプライス始値高値安値終値精算値出来高取組高
6
以下は次の関数で取得 =IMPORTDATA("http://www.tocom.or.jp/data/yakujou/"&A4&".csv")
※ エディタを開けない場合は「ファイル ▷ コピーを作成」で作成したものでお試しください。
※ この関数ではうまく取得できないタイミングがあります(月が変わってすぐのタイミング等)
7
2018110111112018120442744304409442044209210708
8
201811011111201902044264426440944204420634868
9
20181101111120190404421442744044416441616120886
10
20181101111120190604417442043994411441179316331
11
201811011111201908044154417439344064406568834056
12
2018110111112019100441144154391440344032502411126
13
201811011112201812051.851.851.851.851.81167
14
201811011112201902052276
15
201811011112201904052.2186
16
20181101111220190605252.151.751.851.818472
17
201811011112201908052.152.151.751.851.816365
18
201811011112201910052.152.751.751.751.73463
19
2018110111132018120303230633029306030603124257
20
201811011113201902030363066302830663066729127
21
2018110111132019040303330653033306030602019678
22
2018110111132019060302230573015305030506965704
23
201811011113201908030143046300730433043384013497
24
20181101111320191003013304430033042304274935011
25
2018110111142018120391039103910391039101163
26
2018110111142019020382838283820382038202216
27
2018110111142019040375864
28
2018110111142019060363536653629366536655235
29
20181101111420190803636368136023653365344557
30
20181101111420191003621368035753637363710258
31
20181101112012019010242902454024290245302453011315
32
2018110111201201903024500245902450024580245808478
33
20181101112012019050244102445024400244502445012915
34
2018110111201201907024110241102404024040240406501
35
201811011120120190902431024310241902420024200961157
36
2018110111201201911024880248902479024800248001931380
37
201811011120220181204650055
38
201811011120220190204500031
39
201811011120220190404460051
40
201811011120220190604650046500465004650046500154
41
2018110111202201908044070440704407044070440701449
42
201811011120220191004460044600446004460044600133
43
2018110111204201811014700192
44
2018110111204201812014660202
45
201811011120420190101470025
46
2018110111204201902014490145001449014500145002234
47
201811011120420190301438014380143801438014380158
48
20181101112042019040143801438014380143801438017
49
2018110111312018120650406505063660636606366027503
50
2018110111312019010644506446063210633606336067778
51
201811011131201902063810638906249062660626601161192
52
201811011131201903063950641306253062680626803091367
53
2018110111312019040643906451062860630506305010842438
54
2018110111312019050644606477063010631606316028621390
55
2018110111322018120700007000068960689906899044869
56
2018110111322019010701907050068990690706907084859
57
20181101113220190206900069060688006898068980146897
58
2018110111322019030692706927067760680306803093613
59
20181101113220190406836068390668906706067060352975
60
20181101113220190506787068070665806662066620324732
61
2018110111342018120722000
62
2018110111342019010719000
63
2018110111342019020716000
64
2018110111342019030713000
65
2018110111342019040710000
66
2018110111342019050707000
67
201811011137201812065500250
68
201811011137201901064800197
69
201811011137201902064500645006450064500645001185
70
201811011137201903064000174
71
201811011137201904064000180
72
2018110111372019050671000
73
201811011138201812071000710007050070500705007327
74
2018110111382019010710007100070500705007050011272
75
201811011138201902071000710007050070500705009193
76
2018110111382019030700009
77
2018110111382019040720001
78
2018110111382019050720000
79
2018110111812018110144.7145.1144144.3144.333823
80
2018110111812018120150.1150.2148.2148.2148.2461760
81
2018110111812019010156.8157.5155.6155.6155.61172697
82
2018110111812019020159.1159.8157.5157.5157.52543922
83
2018110111812019030161.3162159.716016029798753
84
2018110111812019040162.2163.4161.1161.3161.333406586
85
2018110111822018120141141141141141164
86
2018110111822019010141.8141.8141.8141.8141.8360
87
201811011182201902014414414414414410621
88
2018110111822019030143.8143.8143.8143.8143.82564
89
2018110111822019040146146.6144.314514510301890
90
2018110111822019050147147.6145.5145.9145.966563
91
201811011216201812044244433440644124420361786
92
201811011216201902044194419440744074420151936
93
20181101121620190404416441644064406441652286
94
201811011216201906044194423439944114411772888
95
2018110112162019080441244174393440644068214949
96
20181101121620191004410441643914404440316571735
97
20181101121720181203040306030403060306015545
98
2018110112172019020303830563038305630668528
99
2018110112172019040304530613045306130609834
100
20181101121720190603030305330273044305040862
Loading...
Main menu