大台-每日高點跟低點出現的時間統計
統計時間：2001/1/2~2011/8/15，總共2631個交易日為什麼選用這段時間...因為我手邊剛好有這段時間的資料
高點時間：
845 ~ 85553520.33%
855 ~ 9052077.87%
905 ~ 9151325.02%
915 ~ 9251345.09%
925 ~ 935893.38%
935 ~ 945652.47%
945 ~ 955662.51%
955 ~ 1005572.17%
1005 ~ 1015471.79%
1015 ~ 1025572.17%
1025 ~ 1035311.18%
1035 ~ 1045351.33%
1045 ~ 1055391.48%
1055 ~ 1105331.25%
1105 ~ 1115291.10%
1115 ~ 1125361.37%
1125 ~ 1135491.86%
1135 ~ 1145421.60%
1145 ~ 1155491.86%
1155 ~ 1205511.94%
1205 ~ 1215351.33%
1215 ~ 1225321.22%
1225 ~ 1235441.67%
1235 ~ 1245501.90%
1245 ~ 1255742.81%
1255 ~ 1305652.47%
1305 ~ 1315883.34%
1315 ~ 1325913.46%
1325 ~ 13351415.36%
1335 ~ 13452288.67%
圖表：
低點時間：
845 ~ 85549918.97%
855 ~ 9051013.84%
905 ~ 9151796.80%
915 ~ 9251395.28%
925 ~ 9351053.99%
935 ~ 945953.61%
945 ~ 9551064.03%
955 ~ 1005722.74%
1005 ~ 1015612.32%
1015 ~ 1025552.09%
1025 ~ 1035461.75%
1035 ~ 1045511.94%
1045 ~ 1055672.55%
1055 ~ 1105421.60%
1105 ~ 1115331.25%
1115 ~ 1125562.13%
1125 ~ 1135381.44%
1135 ~ 1145351.33%
1145 ~ 1155421.60%
1155 ~ 1205381.44%
1205 ~ 1215281.06%
1215 ~ 1225451.71%
1225 ~ 1235662.51%
1235 ~ 1245532.01%
1245 ~ 1255752.85%
1255 ~ 1305722.74%
1305 ~ 1315742.81%
1315 ~ 13251154.37%
1325 ~ 1335883.34%
1335 ~ 13451555.89%
圖表：
交叉分析表：
計數 - Date 低點時間
高點時間8459159451015104511151145121512451315(空白)總計
84548728173765550101120198874
9155242315202718204960288
9455415491114142128170
1015511961659818123
104546156249910101
111551291423721127
11456229174311315135
12156620168637126
12451133626229133221227
1315236100502418111362460
(空白)
總計7793392391521421291081642213582631
交叉分析表(比例表示)：
計數 - Date 低點時間
高點時間8459159451015104511151145121512451315(空白)總計
8451.82%2.74%3.08%2.77%2.89%2.09%1.90%3.84%4.56%7.53%0.00%33.22%
9151.98%0.15%0.87%0.57%0.76%1.03%0.68%0.76%1.86%2.28%0.00%10.95%
9452.05%0.57%0.00%0.15%0.34%0.42%0.53%0.53%0.80%1.06%0.00%6.46%
10151.94%0.72%0.23%0.00%0.04%0.23%0.19%0.34%0.30%0.68%0.00%4.68%
10451.75%0.57%0.23%0.00%0.00%0.08%0.15%0.34%0.34%0.38%0.00%3.84%
11151.94%1.10%0.53%0.08%0.00%0.00%0.00%0.11%0.27%0.80%0.00%4.83%
11452.36%1.10%0.65%0.15%0.11%0.04%0.04%0.00%0.11%0.57%0.00%5.13%
12152.51%0.76%0.61%0.30%0.23%0.11%0.00%0.00%0.00%0.27%0.00%4.79%
12454.29%1.37%0.99%0.84%0.34%0.49%0.11%0.08%0.08%0.04%0.00%8.63%
13158.97%3.80%1.90%0.91%0.68%0.42%0.49%0.23%0.08%0.00%0.00%17.48%
(空白)0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
總計29.61%12.88%9.08%5.78%5.40%4.90%4.10%6.23%8.40%13.61%0.00%100.00%
硬拉硬拉硬拉...{:8_527:} 以前做過這統計
一個SQL指令就可以跑出來 感謝分享~{:4_87:}{:4_87:} 感謝大大分享這有用的資訊{:8_563:} 小第收ㄌ
好用ㄉ資料
{:4_90:} 感謝分享,祝操作順利 樓主真有心
謝謝分享有用的資料
感恩 看起來應該可以將時間分為三個階段
只要做前後二個階段即可
給了另一思考方向, 感謝!
謝謝版主的分享{:4_209:} 太有心了！強力推薦！
{:5_647:} 謝謝樓主分享~{:4_90:}{:4_90:}
時間高點天數比例低點天數比例高比/低比買賣點排名
845 ~ 85553520.33%49918.97%1.07
855 ~ 9052077.87%1013.84%2.05賣點1
905 ~ 9151325.02%1796.80%0.74
915 ~ 9251345.09%1395.28%0.96
925 ~ 935893.38%1053.99%0.85
935 ~ 945652.47%953.61%0.68買點6
945 ~ 955662.51%1064.03%0.62買點2
955 ~1005572.17%722.74%0.79
1005 ~1015471.79%612.32%0.77
1015 ~1025572.17%552.09%1.04
1025 ~1035311.18%461.75%0.67買點5
1035 ~1045351.33%511.94%0.69買點7
1045 ~1055391.48%672.55%0.58買點1
1055 ~1105331.25%421.60%0.78
1105 ~1115291.10%331.25%0.88
1115 ~1125361.37%562.13%0.64買點3
1125 ~1135491.86%381.44%1.29賣點5
1135 ~1145421.60%351.33%1.20賣點7
1145 ~1155491.86%421.60%1.16
1155 ~1205511.94%381.44%1.35賣點4
1205 ~1215351.33%281.06%1.25賣點6
1215 ~1225321.22%451.71%0.71買點8
1225 ~1235441.67%662.51%0.67買點4
1235 ~1245501.90%532.01%0.95
1245 ~1255742.81%752.85%0.99
1255 ~1305652.47%722.74%0.90
1305 ~1315883.34%742.81%1.19賣點8
1315 ~1325913.46%1154.37%0.79
1325 ~13351415.36%883.34%1.60賣點2
1335 ~13452288.67%1555.89%1.47賣點3
2001~20082631
2631
感謝樓主分享唷~~~
{:4_209:}
頁:
[1]