[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/05/25 =today()
4
2018-05
=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
201805011111201806046274640461446154615844591
8
201805011111201808046254641461246144614509620
9
201805011111201810046304637460846174617834641
10
20180501111120181204623463846084613461354431956
11
201805011111201902046174632460246064606426430553
12
201805011111201904046164632460046054605157507844
13
20180501111220180605859
14
201805011112201808058.1246
15
201805011112201810058.3173
16
201805011112201812057.157.157.157.157.18570
17
201805011112201902057.657.657.257.257.221659
18
2018050111122019040585857.157.157.16996
19
201805011113201806032003207318631863186241145
20
20180501111320180803202322031903190319082089
21
201805011113201810032103223318131813181374407
22
20180501111320181203212323331913191319133214343
23
201805011113201902031993229318531853185499430568
24
20180501111320190403197322731813182318288369525
25
201805011114201806034213421342134213421180
26
2018050111142018080339033903333333333336227
27
2018050111142018100331833203318332033204121
28
2018050111142018120335833583309331033105292
29
20180501111420190203326332932693269326943478
30
2018050111142019040331833203256325832585499
31
201805011120120180702549025680254102550025500510595
32
20180501112012018090269202719026700267002670017753
33
20180501112012018110271202725026830268302683032618
34
20180501112012019010250902544025090252902529086577
35
2018050111201201903025300255902526025460254601781817
36
2018050111201201905025330255902514025450254506341921
37
201805011120220180604828090
38
20180501112022018080483301056
39
2018050111202201810049500495004950049500495001109
40
201805011120220181204950049940495004991049910366
41
201805011120220190204990050990499005099050990727
42
20180501112022019040499005000049900500005000022
43
2018050111204201805012900262110
44
2018050111204201806012810246
45
2018050111204201807013340133401334013340133401101
46
20180501112042018080130901313013010130101301014348
47
20180501112042018090132301324013100131601316011274
48
201805011120420181001320013200130501305013050712
49
2018050111312018060633106370063310636406364082811
50
2018050111312018070626506308062570630406304047850
51
201805011131201808061700626106156062600626001031333
52
201805011131201809061280621006107062100621001561054
53
201805011131201810060570615506042061530615309342760
54
2018050111312018110602606129060130611906119015931056
55
2018050111322018060635006444063500644406444018914
56
2018050111322018070632506408063250640606406021577
57
2018050111322018080630006388063000638706387040906
58
2018050111322018090630506411062940640706407042810
59
201805011132201810063110642306311064200642001421002
60
20180501113220181106352064530634006448064480264285
61
2018050111342018060643000
62
2018050111342018070640000
63
2018050111342018080637000
64
2018050111342018090634000
65
2018050111342018100631000
66
2018050111342018110629000
67
2018050111372018060630006300063000630006300010167
68
201805011137201807062600626006260062600626005106
69
20180501113720180806050080
70
2018050111372018090595005
71
2018050111372018100620002
72
2018050111372018110620001
73
20180501113820180606050017
74
20180501113820180706100017
75
20180501113820180806050017
76
2018050111382018090600004
77
2018050111382018100600005
78
2018050111382018110600000
79
2018050111812018050178.6184178.6182.4182.454730
80
2018050111812018060182.9188.4182.9186.9186.94492960
81
2018050111812018070185.4191.5185.3189.5189.56853786
82
2018050111812018080186193185.9191.5191.514216345
83
2018050111812018090186.2193.9186.2192.7192.755508187
84
2018050111812018100186.3193.2185.7192.9192.966537347
85
20180501121620180604633463346304630461541006
86
2018050112162018080461146124611461246142652
87
20180501121620181004635463546154615461731661
88
201805011216201812046254636460546064613302869
89
20180501121620190204620463346014605460610305043
90
20180501121620190404612463446004604460520231156
91
201805011217201806031903190319031903186150
92
2018050112172018080321932193218321831902337
93
2018050112172018100319031903190319031812266
94
201805011217201812032223226319631963191141069
95
2018050112172019020320432263187318731851351800
96
201805011217201904032133222318231823182267490
97
2018050112180462946444614461946175627117925
98
201805011219032403267322532263187410051894
99
20180501123320180504839049360483604928049280623694
100
2018050112332018060478404883047800487404874015612633
Loading...
 
 
 
シート1
 
 
Main menu