teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

1

code

2020/07/14 03:07

投稿

pon244
pon244

スコア59

title CHANGED
File without changes
body CHANGED
@@ -42,4 +42,27 @@
42
42
  |company|2020-07-11|2020-07-13|
43
43
  |:--|:--:|--:|
44
44
  TXG|xx|xx||
45
- YI|xx|xx||
45
+ YI|xx|xx||
46
+
47
+ ```ここに言語を入力
48
+ start1 = '2020-07-11'
49
+ end2= '2020-07-13'
50
+
51
+
52
+ def get_val(data, company, date):
53
+ try:
54
+ return data.DataReader(company, 'yahoo', date,date).Close.sum()
55
+ except KeyError:
56
+ pass
57
+ return 0
58
+
59
+
60
+ for i in companies_TEST:
61
+
62
+ print(i + " done!")
63
+ df_NYSE.at[str(i),"2020-07-10"] =get_val(str(i), 'yahoo', start1,start1).Close.sum()
64
+ df_NYSE.at[str(i),"2020-07-13"] =get_val(str(i), 'yahoo', end2,end2).Close.sum()
65
+
66
+
67
+ print("ALL done!")
68
+ ```