【トラリピ】リピート系総合【ループイフダン】18

459 ：名無しさん＠お金いっぱい。：2018/09/29(土) 10:45:35.84 ID:gxMVHmxZ0.net

>>452
> 「日ごとの値」が欲しいんですよね。
「4時間足で計算してもいい」と書いたやん。

ほい、マネパのデータで4時間足を使った 「日ごとのボラ」
csv形式で貼るから、エクセルに取り込んで見てくれ。
一番最後の行は数式

日付,終値(買い),4H変化率,1日換算ボラ
2018/9/21 2:00,82.029,,
2018/9/21 6:00,82.064,0.000427,
2018/9/21 10:00,82.190,0.001534,
2018/9/21 14:00,82.220,0.000365,
2018/9/21 18:00,82.008,-0.002582,
2018/9/21 22:00,81.990,-0.000220,
2018/9/22 2:00,82.014,0.000293,0.337%
2018/9/24 6:00,81.954,-0.000732,
2018/9/24 10:00,81.815,-0.001698,
2018/9/24 14:00,81.945,0.001588,
2018/9/24 18:00,81.792,-0.001869,
2018/9/24 22:00,81.774,-0.000220,
2018/9/25 2:00,81.837,0.000770,0.334%
2018/9/25 6:00,81.937,0.001221,
2018/9/25 10:00,81.705,-0.002835,
2018/9/25 14:00,81.752,0.000575,
2018/9/25 18:00,81.872,0.001467,
2018/9/25 22:00,81.870,-0.000024,
2018/9/26 2:00,81.889,0.000232,0.379%
2018/9/26 6:00,81.911,0.000269,
2018/9/26 10:00,82.076,0.002012,
2018/9/26 14:00,81.940,-0.001658,
2018/9/26 18:00,81.869,-0.000867,
2018/9/26 22:00,81.972,0.001257,
2018/9/27 2:00,81.858,-0.001392,0.365%
2018/9/27 6:00,81.905,0.000574,
2018/9/27 10:00,81.832,-0.000892,
2018/9/27 14:00,81.531,-0.003685,
2018/9/27 18:00,81.551,0.000245,
2018/9/27 22:00,81.919,0.004502,
2018/9/28 2:00,81.712,-0.002530,0.701%
2018/9/28 6:00,81.787,0.000917,
2018/9/28 10:00,81.868,0.000990,
2018/9/28 14:00,81.940,0.000879,
2018/9/28 18:00,81.863,-0.000940,
2018/9/28 22:00,82.114,0.003061,
2018/9/29 2:00,82.085,-0.000353,0.338%
,,↑=LN(B38/B37),↑=STDEV.S(C33:C38)*SQRT(6)