市場環境監控_美股.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	Date	Vol	80% Vol	Price	200 MA	Mom	75-25	75-25 80%	波動度高於歷史水平80分位	分位差高於歷史水平80分位	股價低於200均線
2	1994-01-27 0:00:00	2.05E-05	4.41E-05	47.75	45.77016	0.086771	0.409911	0.460301	FALSE	FALSE	FALSE
3	1994-01-28 0:00:00	1.77E-05	4.41E-05	47.875	45.78484	0.081921	0.396161	0.460293	FALSE	FALSE	FALSE
4	1994-01-31 0:00:00	1.62E-05	4.41E-05	48.21875	45.80219	0.087385	0.401199	0.460286	FALSE	FALSE	FALSE
5	1994-02-01 0:00:00	1.65E-05	4.41E-05	47.96875	45.81938	0.070432	0.417116	0.460278	FALSE	FALSE	FALSE
6	1994-02-02 0:00:00	1.71E-05	4.41E-05	48.28125	45.83828	0.072917	0.396059	0.460243	FALSE	FALSE	FALSE
7	1994-02-03 0:00:00	1.75E-05	4.41E-05	48.0625	45.85891	0.068798	0.40229	0.460209	FALSE	FALSE	FALSE
8	1994-02-04 0:00:00	2.58E-05	4.41E-05	46.96875	45.875	0.044475	0.393739	0.460174	FALSE	FALSE	FALSE
9	1994-02-07 0:00:00	2.60E-05	4.40E-05	47.1875	45.89391	0.056683	0.391373	0.460137	FALSE	FALSE	FALSE
10	1994-02-08 0:00:00	2.57E-05	4.40E-05	47.21875	45.91063	0.055905	0.393621	0.460098	FALSE	FALSE	FALSE
11	1994-02-09 0:00:00	2.59E-05	4.40E-05	47.40625	45.92875	0.054937	0.396668	0.460058	FALSE	FALSE	FALSE
12	1994-02-10 0:00:00	2.68E-05	4.40E-05	47	45.94391	0.053959	0.398092	0.460025	FALSE	FALSE	FALSE
13	1994-02-11 0:00:00	2.65E-05	4.40E-05	47.15625	45.95953	0.084831	0.396731	0.460002	FALSE	FALSE	FALSE
14	1994-02-14 0:00:00	2.64E-05	4.40E-05	47.21875	45.97406	0.08705	0.409166	0.45998	FALSE	FALSE	FALSE
15	1994-02-15 0:00:00	2.67E-05	4.40E-05	47.46875	45.98906	0.093593	0.419562	0.459957	FALSE	FALSE	FALSE
16	1994-02-16 0:00:00	2.60E-05	4.40E-05	47.4375	46.00328	0.088953	0.414058	0.459945	FALSE	FALSE	FALSE
17	1994-02-17 0:00:00	2.62E-05	4.40E-05	47.15625	46.01688	0.078628	0.412386	0.459932	FALSE	FALSE	FALSE
18	1994-02-18 0:00:00	2.66E-05	4.40E-05	46.875	46.02953	0.072961	0.409684	0.45992	FALSE	FALSE	FALSE
19	1994-02-22 0:00:00	2.83E-05	4.40E-05	47.34375	46.04406	0.069915	0.40728	0.459885	FALSE	FALSE	FALSE
20	1994-02-23 0:00:00	2.81E-05	4.40E-05	47.21875	46.05703	0.064834	0.408009	0.45984	FALSE	FALSE	FALSE
21	1994-02-24 0:00:00	3.11E-05	4.40E-05	46.59375	46.06719	0.049261	0.394279	0.459795	FALSE	FALSE	FALSE
22	1994-02-25 0:00:00	3.15E-05	4.40E-05	46.8125	46.08109	0.057163	0.397069	0.459764	FALSE	FALSE	FALSE
23	1994-02-28 0:00:00	3.14E-05	4.40E-05	46.8125	46.09516	0.041725	0.405188	0.459764	FALSE	FALSE	FALSE
24	1994-03-01 0:00:00	3.14E-05	4.40E-05	46.625	46.1075	0.033241	0.382914	0.459764	FALSE	FALSE	FALSE
25	1994-03-02 0:00:00	3.12E-05	4.40E-05	46.6875	46.12031	0.04039	0.380875	0.459763	FALSE	FALSE	FALSE
26	1994-03-03 0:00:00	3.13E-05	4.39E-05	46.5625	46.12797	0.040503	0.373883	0.459745	FALSE	FALSE	FALSE
27	1994-03-04 0:00:00	3.14E-05	4.39E-05	46.6875	46.13563	0.020492	0.384886	0.459727	FALSE	FALSE	FALSE
28	1994-03-07 0:00:00	3.17E-05	4.39E-05	46.9375	46.14656	0.029472	0.377197	0.459708	FALSE	FALSE	FALSE
29	1994-03-08 0:00:00	3.19E-05	4.38E-05	46.75	46.15563	0.023256	0.389164	0.459699	FALSE	FALSE	FALSE
30	1994-03-09 0:00:00	3.17E-05	4.38E-05	46.96875	46.16531	0.030864	0.37742	0.459694	FALSE	FALSE	FALSE
31	1994-03-10 0:00:00	3.19E-05	4.38E-05	46.59375	46.17031	0.033264	0.384375	0.45969	FALSE	FALSE	FALSE
32	1994-03-11 0:00:00	3.23E-05	4.37E-05	46.84375	46.17734	0.033793	0.384896	0.459682	FALSE	FALSE	FALSE
33	1994-03-14 0:00:00	3.22E-05	4.37E-05	46.90625	46.18578	0.035172	0.39567	0.459666	FALSE	FALSE	FALSE
34	1994-03-15 0:00:00	3.21E-05	4.36E-05	46.875	46.19188	0.040944	0.397024	0.45965	FALSE	FALSE	FALSE
35	1994-03-16 0:00:00	3.31E-05	4.36E-05	47.25	46.20016	0.042759	0.402623	0.459635	FALSE	FALSE	FALSE
36	1994-03-17 0:00:00	3.29E-05	4.36E-05	47.25	46.20922	0.049271	0.387381	0.459604	FALSE	FALSE	FALSE
37	1994-03-18 0:00:00	3.28E-05	4.36E-05	46.96875	46.21766	0.048849	0.398605	0.459573	FALSE	FALSE	FALSE
38	1994-03-21 0:00:00	3.30E-05	4.36E-05	46.84375	46.22625	0.043872	0.39755	0.459542	FALSE	FALSE	FALSE
39	1994-03-22 0:00:00	3.26E-05	4.36E-05	46.96875	46.2375	0.046657	0.401522	0.459528	FALSE	FALSE	FALSE
40	1994-03-23 0:00:00	3.25E-05	4.36E-05	46.9375	46.24781	0.039446	0.405074	0.459522	FALSE	FALSE	FALSE
41	1994-03-24 0:00:00	3.49E-05	4.36E-05	46.375	46.25516	0.032707	0.387385	0.459517	FALSE	FALSE	FALSE
42	1994-03-25 0:00:00	3.61E-05	4.35E-05	45.9375	46.25938	0.018711	0.388617	0.459487	FALSE	FALSE	TRUE
43	1994-03-28 0:00:00	3.57E-05	4.35E-05	46	46.26422	0.017277	0.379974	0.459409	FALSE	FALSE	TRUE
44	1994-03-29 0:00:00	4.19E-05	4.35E-05	45.09375	46.265	-0.00207	0.357699	0.459331	FALSE	FALSE	TRUE
45	1994-03-30 0:00:00	4.45E-05	4.36E-05	44.46875	46.26219	-0.01249	0.346235	0.459253	TRUE	FALSE	TRUE
46	1994-03-31 0:00:00	4.46E-05	4.36E-05	44.59375	46.25922	0.011339	0.347083	0.459238	TRUE	FALSE	TRUE
47	1994-04-04 0:00:00	4.82E-05	4.37E-05	43.90625	46.25625	-0.00917	0.345178	0.459224	TRUE	FALSE	TRUE
48	1994-04-05 0:00:00	5.52E-05	4.39E-05	44.8125	46.25734	0.014144	0.364251	0.459209	TRUE	FALSE	TRUE
49	1994-04-06 0:00:00	5.25E-05	4.40E-05	44.8125	46.25828	0.010571	0.359344	0.45917	TRUE	FALSE	TRUE
50	1994-04-07 0:00:00	5.30E-05	4.40E-05	45.03125	46.26234	0.016937	0.36642	0.459118	TRUE	FALSE	TRUE
51	1994-04-08 0:00:00	5.37E-05	4.40E-05	44.6875	46.26172	-0.00487	0.353668	0.459066	TRUE	FALSE	TRUE
52	1994-04-11 0:00:00	5.41E-05	4.40E-05	44.875	46.26219	-0.00278	0.359314	0.459028	TRUE	FALSE	TRUE
53	1994-04-12 0:00:00	5.37E-05	4.41E-05	44.8125	46.25984	-0.00278	0.368517	0.459015	TRUE	FALSE	TRUE
54	1994-04-13 0:00:00	5.40E-05	4.41E-05	44.57813	46.25742	-0.008	0.362018	0.459002	TRUE	FALSE	TRUE
55	1994-04-14 0:00:00	5.39E-05	4.41E-05	44.59375	46.25508	-0.00765	0.354676	0.458989	TRUE	FALSE	TRUE
56	1994-04-15 0:00:00	5.39E-05	4.41E-05	44.59375	46.25336	-0.00349	0.357561	0.458977	TRUE	FALSE	TRUE
57	1994-04-18 0:00:00	5.42E-05	4.41E-05	44.29688	46.25141	-0.00526	0.343479	0.458965	TRUE	FALSE	TRUE
58	1994-04-19 0:00:00	5.43E-05	4.42E-05	44.35938	46.25211	-0.00316	0.333702	0.458953	TRUE	FALSE	TRUE
59	1994-04-20 0:00:00	5.41E-05	4.42E-05	44.3125	46.25195	0.008535	0.323952	0.458942	TRUE	FALSE	TRUE
60	1994-04-21 0:00:00	5.76E-05	4.42E-05	44.90625	46.25227	0.026429	0.333774	0.458931	TRUE	FALSE	TRUE
61	1994-04-22 0:00:00	5.74E-05	4.42E-05	44.85938	46.25172	0.033477	0.339778	0.45892	TRUE	FALSE	TRUE
62	1994-04-25 0:00:00	5.78E-05	4.42E-05	45.32813	46.25367	0.03312	0.345716	0.458907	TRUE	FALSE	TRUE
63	1994-04-26 0:00:00	5.76E-05	4.44E-05	45.28125	46.25555	0.034261	0.34784	0.458893	TRUE	FALSE	TRUE
64	1994-04-28 0:00:00	5.71E-05	4.45E-05	44.95313	46.255	0.022388	0.34739	0.458878	TRUE	FALSE	TRUE
65	1994-04-29 0:00:00	5.71E-05	4.46E-05	45.09375	46.25609	0.024131	0.349644	0.458863	TRUE	FALSE	TRUE
66	1994-05-02 0:00:00	5.71E-05	4.46E-05	45.375	46.25922	0.023977	0.343213	0.458856	TRUE	FALSE	TRUE
67	1994-05-03 0:00:00	5.69E-05	4.49E-05	45.32813	46.26227	0.019325	0.337753	0.45885	TRUE	FALSE	TRUE
68	1994-05-04 0:00:00	4.87E-05	4.51E-05	45.25	46.2643	0.014716	0.329104	0.458843	TRUE	FALSE	TRUE
69	1994-05-05 0:00:00	4.82E-05	4.53E-05	45.1875	46.26617	0.016878	0.33506	0.458834	TRUE	FALSE	TRUE
70	1994-05-06 0:00:00	4.95E-05	4.56E-05	44.75	46.26742	0.009161	0.336304	0.458825	TRUE	FALSE	TRUE
71	1994-05-09 0:00:00	5.01E-05	4.56E-05	44.35938	46.26563	-0.00176	0.330618	0.458815	TRUE	FALSE	TRUE
72	1994-05-10 0:00:00	5.04E-05	4.60E-05	44.70313	46.2643	0.001751	0.334174	0.458807	TRUE	FALSE	TRUE
73	1994-05-11 0:00:00	5.13E-05	4.64E-05	44.29688	46.26109	-0.00596	0.336899	0.458803	TRUE	FALSE	TRUE
74	1994-05-12 0:00:00	5.18E-05	4.65E-05	44.51563	46.25945	0.011001	0.324855	0.458799	TRUE	FALSE	TRUE
75	1994-05-13 0:00:00	5.11E-05	4.65E-05	44.51563	46.25656	0.011719	0.329832	0.458795	TRUE	FALSE	TRUE
76	1994-05-16 0:00:00	5.11E-05	4.65E-05	44.53125	46.255	0.008493	0.33091	0.458789	TRUE	FALSE	TRUE
77	1994-05-17 0:00:00	5.48E-05	4.75E-05	45.1875	46.25609	0.024079	0.324448	0.458783	TRUE	FALSE	TRUE
78	1994-05-18 0:00:00	5.54E-05	4.82E-05	45.51563	46.25867	0.010756	0.322668	0.458777	TRUE	FALSE	TRUE
79	1994-05-19 0:00:00	5.40E-05	4.83E-05	45.73438	46.26234	0.012803	0.316306	0.45875	TRUE	FALSE	TRUE
80	1994-05-20 0:00:00	5.41E-05	4.86E-05	45.5625	46.26563	0.018156	0.324733	0.458713	TRUE	FALSE	TRUE
81	1994-05-23 0:00:00	5.13E-05	4.86E-05	45.48438	46.2682	0.01217	0.321719	0.458675	TRUE	FALSE	TRUE
82	1994-05-24 0:00:00	5.12E-05	4.86E-05	45.67188	46.27047	0.014226	0.309812	0.458645	TRUE	FALSE	TRUE
83	1994-05-25 0:00:00	5.14E-05	4.90E-05	45.79688	46.27352	0.004455	0.310541	0.45863	TRUE	FALSE	TRUE
84	1994-05-26 0:00:00	5.12E-05	4.96E-05	45.82813	46.27672	0.008597	0.308735	0.458615	TRUE	FALSE	TRUE
85	1994-05-27 0:00:00	5.12E-05	5.01E-05	45.875	46.28078	0.014513	0.304027	0.4586	TRUE	FALSE	TRUE
86	1994-05-31 0:00:00	5.11E-05	5.04E-05	45.8125	46.28422	0.003422	0.308502	0.458576	TRUE	FALSE	TRUE
87	1994-06-01 0:00:00	5.13E-05	5.05E-05	46.01563	46.28742	0.009253	0.314467	0.458552	TRUE	FALSE	TRUE
88	1994-06-02 0:00:00	5.08E-05	5.06E-05	45.96875	46.28961	0.011692	0.318144	0.458528	TRUE	FALSE	TRUE
89	1994-06-03 0:00:00	5.12E-05	5.07E-05	46.23438	46.29188	0.021049	0.314919	0.458509	TRUE	FALSE	TRUE
90	1994-06-06 0:00:00	5.08E-05	5.08E-05	46.21875	46.29406	0.024238	0.319474	0.458492	FALSE	FALSE	TRUE
91	1994-06-07 0:00:00	4.98E-05	5.07E-05	46.15625	46.29578	0.032145	0.326877	0.458475	FALSE	FALSE	TRUE
92	1994-06-08 0:00:00	5.03E-05	5.07E-05	45.78125	46.29609	0.020195	0.333642	0.458455	FALSE	FALSE	TRUE
93	1994-06-09 0:00:00	5.08E-05	5.08E-05	46.03125	46.29516	0.025052	0.323976	0.458427	TRUE	FALSE	TRUE
94	1994-06-10 0:00:00	5.09E-05	5.08E-05	46.10938	46.29445	0.022523	0.313837	0.458399	TRUE	FALSE	TRUE
95	1994-06-13 0:00:00	4.97E-05	5.08E-05	46.17188	46.29391	0.02533	0.316405	0.458371	FALSE	FALSE	TRUE
96	1994-06-14 0:00:00	5.08E-05	5.08E-05	46.53125	46.29531	0.035466	0.312141	0.458355	TRUE	FALSE	FALSE
97	1994-06-15 0:00:00	5.05E-05	5.08E-05	46.34375	46.29484	0.029146	0.321071	0.458339	FALSE	FALSE	FALSE
98	1994-06-16 0:00:00	5.05E-05	5.08E-05	46.4375	46.29422	0.027663	0.312587	0.458323	FALSE	FALSE	FALSE
99	1994-06-17 0:00:00	5.28E-05	5.08E-05	45.875	46.29109	0.030899	0.32282	0.458289	TRUE	FALSE	TRUE
100	1994-06-20 0:00:00	5.39E-05	5.08E-05	45.48438	46.2868	0.019972	0.312323	0.458246	TRUE	FALSE	TRUE