劉任昌EXCEL股票圖SPY平均線 

日期	成交量	開	高	低	收
2023/1/3	74,850,700 	384.369995	386.429993	377.829987	380.820007
2023/1/4	85,934,100 	383.179993	385.880005	380	383.76001
2023/1/5	76,970,500 	381.720001	381.839996	378.76001	379.380005
2023/1/6	104,189,600 	382.609985	389.25	379.410004	388.079987
2023/1/9	73,978,100 	390.369995	393.700012	387.670013	387.859985
2023/1/10	65,358,100 	387.25	390.649994	386.269989	390.579987
2023/1/11	68,881,100 	392.230011	395.600006	391.380005	395.519989
2023/1/12	90,157,700 	396.670013	398.48999	392.420013	396.959991
2023/1/13	63,903,900 	393.619995	399.100006	393.339996	398.5
2023/1/17	62,677,300 	398.480011	400.230011	397.059998	397.769989
2023/1/18	99,632,300 	399.01001	400.119995	391.279999	391.48999
2023/1/19	86,958,900 	389.359985	391.079987	387.26001	388.640015
2023/1/20	91,806,400 	390.100006	396.040009	388.380005	395.880005
2023/1/23	84,178,800 	396.720001	402.649994	395.720001	400.630005
2023/1/24	59,524,900 	398.880005	401.149994	397.640015	400.200012
2023/1/25	84,800,300 	395.950012	400.700012	393.559998	400.350006
2023/1/26	72,287,400 	403.130005	404.920013	400.029999	404.75
2023/1/27	68,346,200 	403.660004	408.160004	403.440002	405.679993
2023/1/30	74,202,000 	402.799988	405.130005	400.279999	400.589996
2023/1/31	86,811,800 	401.130005	406.529999	400.769989	406.480011
2023/2/1	101,459,200 	405.209991	413.670013	402.350006	410.799988
2023/2/2	101,654,500 	414.859985	418.309998	412.880005	416.779999
2023/2/3	94,736,800 	411.589996	416.970001	411.089996	412.350006
2023/2/6	60,295,300 	409.790009	411.290009	408.100006	409.829987
2023/2/7	90,990,700 	408.869995	416.48999	407.570007	415.190002
2023/2/8	76,227,500 	413.130005	414.529999	409.929993	410.649994
2023/2/9	78,694,900 	414.410004	414.570007	405.809998	407.089996
2023/2/10	70,769,700 	405.859985	408.440002	405.01001	408.040009
2023/2/13	64,913,500 	408.720001	412.970001	408.23999	412.829987
2023/2/14	88,389,300 	411.23999	415.049988	408.51001	412.640015
2023/2/15	61,555,700 	410.350006	414.059998	409.470001	413.980011
2023/2/16	76,431,500 	408.790009	412.910004	408.140015	408.279999
2023/2/17	89,257,800 	406.059998	407.51001	404.049988	407.26001
2023/2/21	82,655,900 	403.059998	404.160004	398.820007	399.089996
2023/2/22	83,742,300 	399.519989	401.130005	397.019989	398.540009
2023/2/23	96,242,400 	401.559998	402.200012	396.25	400.660004
2023/2/24	108,194,400 	395.420013	397.25	393.640015	396.380005
2023/2/27	80,444,700 	399.869995	401.290009	396.75	397.730011
2023/2/28	96,438,600 	397.230011	399.279999	396.149994	396.26001
2023/3/1	99,706,800 	395.410004	396.690002	393.380005	394.73999
2023/3/2	85,127,800 	392.679993	398.690002	392.329987	397.809998
2023/3/3	90,120,000 	399.709991	404.450012	399.029999	404.190002
2023/3/6	72,795,900 	405.049988	407.450012	404.01001	404.470001
2023/3/7	108,310,600 	404.420013	404.670013	397.630005	398.269989
2023/3/8	74,746,600 	398.390015	399.709991	396.589996	398.920013
2023/3/9	111,945,300 	399.73999	401.480011	390.529999	391.559998
2023/3/10	189,253,000 	390.98999	393.160004	384.320007	385.910004
2023/3/13	157,790,000 	381.809998	390.390015	380.649994	385.359985
2023/3/14	149,752,400 	390.5	393.450012	387.049988	391.730011
2023/3/15	172,996,900 	385.890015	389.48999	383.709991	389.279999
2023/3/16	143,254,200 	386.820007	396.470001	386.290009	396.109985
2023/3/17	140,553,400 	393.220001	394.399994	388.549988	389.98999
2023/3/20	93,055,800 	390.799988	394.170013	390.070007	393.73999
2023/3/21	91,524,200 	397.23999	399.410004	395.579987	398.910004
2023/3/22	111,746,600 	398.730011	402.48999	392.070007	392.109985
2023/3/23	119,351,300 	395.089996	399.290009	390.350006	393.170013
2023/3/24	107,682,400 	391.839996	395.839996	389.399994	395.75
2023/3/27	74,010,400 	398.119995	398.920013	395.559998	396.48999
2023/3/28	62,871,700 	395.769989	396.48999	393.690002	395.600006
2023/3/29	77,497,900 	399.929993	401.600006	398.679993	401.350006
2023/3/30	69,840,000 	404.089996	404.350006	401.76001	403.700012
2023/3/31	112,062,600 	404.660004	409.700012	404.549988	409.390015
2023/4/3	67,391,100 	408.850006	411.369995	408.440002	410.950012
2023/4/4	66,601,500 	411.619995	411.920013	407.23999	408.670013
2023/4/5	65,200,200 	407.910004	408.700012	405.880005	407.600006
2023/4/6	63,743,300 	406.769989	409.480011	405.679993	409.190002
2023/4/10	63,681,000 	406.609985	409.690002	405.970001	409.609985
2023/4/11	59,297,900 	410.26001	411.179993	408.920013	409.720001
2023/4/12	86,420,400 	411.869995	412.170013	407.440002	408.049988
2023/4/13	85,814,800 	409.179993	413.839996	407.98999	413.470001
2023/4/14	78,161,500 	412.809998	415.089996	410.059998	412.459991
2023/4/17	66,436,400 	412.369995	413.959991	411.089996	413.940002
2023/4/18	63,560,000 	415.579987	415.720001	412.779999	414.209991
2023/4/19	55,227,300 	412.220001	415.079987	412.160004	414.140015
2023/4/20	75,840,400 	411.209991	413.700012	410.269989	411.880005
2023/4/21	73,457,400 	412.190002	412.679993	410.170013	412.200012
2023/4/24	64,332,100 	411.98999	413.070007	410.600006	412.630005
2023/4/25	97,766,700 	410.579987	411.160004	406.019989	406.079987
2023/4/26	80,447,000 	406.720001	407.839996	403.779999	404.359985
2023/4/27	92,968,400 	407	412.690002	406.73999	412.410004
2023/4/28	89,335,600 	411.48999	415.940002	411.429993	415.929993
2023/5/1	62,122,300 	415.470001	417.619995	415.269989	415.51001
2023/5/2	103,998,500 	414.769989	414.820007	407.820007	410.839996
2023/5/3	91,531,800 	411.359985	413.869995	407.769989	408.019989
2023/5/4	94,901,900 	406.929993	407.269989	403.73999	405.130005
2023/5/5	87,844,000 	408.910004	413.720001	408.640015	412.630005
2023/5/8	50,046,800 	412.970001	413.23999	411.279999	412.73999
2023/5/9	49,220,100 	411.130005	412.089996	410.690002	410.929993
2023/5/10	96,142,900 	413.880005	414.540009	408.869995	412.850006
2023/5/11	70,157,100 	411.950012	412.429993	409.970001	412.130005
2023/5/12	70,439,400 	413.420013	413.640015	409.070007	411.589996
2023/5/15	54,289,400 	412.220001	413.429993	410.230011	413.01001
2023/5/16	57,705,500 	411.859985	412.820007	410.23999	410.25
2023/5/17	87,287,000 	412.350006	415.859985	410.640015	415.230011
2023/5/18	97,177,200 	414.899994	419.670013	414.670013	419.230011
2023/5/19	103,679,700 	420.170013	420.720001	417.350006	418.619995
2023/5/22	60,745,400 	418.640015	420.390015	417.350006	418.790009
2023/5/23	86,383,500 	417.079987	418.720001	413.679993	414.089996
2023/5/24	89,213,700 	412.420013	412.820007	409.880005	411.089996
2023/5/25	90,961,600 	414.73999	416.160004	412.410004	414.649994
2023/5/26	93,830,000 	415.329987	420.769989	415.25	420.019989
2023/5/30	72,216,000 	422.029999	422.579987	418.73999	420.179993
2023/5/31	110,811,800 	418.279999	419.220001	416.220001	417.850006
2023/6/1	88,865,000 	418.089996	422.920013	416.790009	421.820007
2023/6/2	91,366,700 	424.5	428.73999	423.950012	427.920013
2023/6/5	65,460,200 	428.279999	429.619995	426.369995	427.100006
2023/6/6	64,022,200 	426.670013	428.579987	425.98999	428.029999
2023/6/7	85,373,300 	428.440002	429.619995	426.109985	426.549988
2023/6/8	61,952,800 	426.619995	429.600006	425.820007	429.130005
2023/6/9	85,742,800 	429.959991	431.98999	428.869995	429.899994
2023/6/12	76,104,300 	430.920013	433.880005	430.170013	433.799988
2023/6/13	95,899,700 	435.320007	437.329987	434.630005	436.660004
2023/6/14	100,612,100 	437.01001	439.059998	433.589996	437.179993
2023/6/15	110,303,100 	436.329987	443.899994	436.230011	442.600006
2023/6/16	114,121,300 	443.019989	443.609985	438.970001	439.459991
2023/6/20	76,160,400 	437.450012	438.369995	435.029999	437.179993
2023/6/21	76,982,300 	436.160004	436.98999	434.329987	434.940002
2023/6/22	70,637,200 	433.950012	436.619995	433.600006	436.51001
2023/6/23	92,074,500 	432.929993	435.059998	432.470001	433.209991
2023/6/26	72,823,600 	432.619995	434.609985	431.190002	431.440002
2023/6/27	72,813,700 	432.350006	436.809998	431.880005	436.170013
2023/6/28	75,636,000 	435.049988	437.440002	434.410004	436.390015
2023/6/29	67,882,300 	435.959991	438.279999	435.540009	438.109985
2023/6/30	104,921,500 	441.440002	444.299988	441.109985	443.279999
2023/7/3	32,793,400 	442.920013	444.079987	442.630005	443.790009
2023/7/5	58,418,400 	441.910004	443.890015	441.899994	443.130005
2023/7/6	80,658,300 	439.420013	440.100006	437.059998	439.660004
2023/7/7	86,076,100 	438.630005	442.640015	438.299988	438.549988
2023/7/10	62,443,500 	438.179993	439.839996	437.589996	439.660004
2023/7/11	64,463,800 	440.450012	442.970001	439.440002	442.459991
2023/7/12	91,924,500 	446.390015	447.480011	444.910004	446.019989
2023/7/13	72,425,200 	447.899994	450.380005	447.450012	449.559998
2023/7/14	69,761,800 	450.480011	451.359985	448.48999	449.279999
2023/7/17	52,680,200 	449.130005	451.929993	449.079987	450.839996
2023/7/18	80,744,400 	450.5	454.859985	450.049988	454.190002
2023/7/19	65,891,700 	455.01001	456.429993	454.109985	455.200012
2023/7/20	70,591,600 	454.170013	455.100006	451.440002	452.179993
2023/7/21	71,245,400 	453.959991	454.170013	452.170013	452.179993
2023/7/24	54,023,400 	453.369995	455.040009	452.299988	454.200012
2023/7/25	55,191,200 	453.920013	456.73999	453.869995	455.440002
2023/7/26	71,052,900 	454.470001	456.98999	453.380005	455.51001
2023/7/27	92,194,400 	459.019989	459.440002	451.549988	452.48999
2023/7/28	80,011,800 	455.880005	457.779999	452.48999	456.920013
2023/7/31	62,040,400 	457.410004	458.160004	456.049988	457.790009
2023/8/1	55,291,500 	456.269989	457.25	455.48999	456.480011
2023/8/2	93,933,400 	453.25	453.519989	449.350006	450.130005
2023/8/3	64,276,100 	448.040009	450.790009	447.369995	448.839996
2023/8/4	100,052,300 	450.720001	452.899994	446.269989	446.809998
2023/8/7	58,357,500 	448.709991	450.869995	447.98999	450.709991
2023/8/8	71,361,300 	448.079987	450.700012	445.269989	448.75
2023/8/9	78,789,600 	449.029999	449.200012	444.959991	445.75
2023/8/10	93,005,500 	448.190002	451.700012	444.700012	445.910004
2023/8/11	68,664,600 	443.970001	446.700012	443.350006	445.649994
2023/8/14	47,867,400 	444.700012	448.109985	444.380005	448.109985
2023/8/15	75,707,500 	446.269989	446.640015	442.299988	442.890015
2023/8/16	80,107,200 	442.459991	444.179993	439.529999	439.640015
2023/8/17	95,711,300 	441.160004	441.429993	435.75	436.290009
2023/8/18	98,758,400 	433.369995	437.570007	433.01001	436.5
2023/8/21	68,719,000 	437.549988	440.109985	435.320007	439.339996
2023/8/22	65,062,900 	441.179993	441.179993	437.570007	438.149994
2023/8/23	68,441,000 	439.25	443.670013	439.100006	443.029999
2023/8/24	88,517,300 	444.690002	445.220001	436.859985	436.890015
2023/8/25	102,325,100 	438.679993	441.299988	435	439.970001
2023/8/28	61,595,400 	442.23999	443.399994	439.970001	442.76001
2023/8/29	83,081,900 	442.649994	449.450012	442.459991	449.160004
2023/8/30	69,053,900 	449.51001	451.670013	448.779999	451.01001
2023/8/31	66,084,600 	451.649994	452.829987	450.160004	450.350006
2023/9/1	58,875,700 	453.170013	453.670013	449.679993	451.190002
2023/9/5	55,166,200 	450.730011	451.059998	449.170013	449.23999
2023/9/6	70,758,500 	448.399994	448.51001	443.809998	446.220001
2023/9/7	70,355,400 	443.109985	445.549988	442.75	444.850006
2023/9/8	61,659,700 	444.899994	447.109985	444.529999	445.519989
2023/9/11	60,180,100 	448.23999	448.769989	446.470001	448.450012
2023/9/12	67,565,400 	446.950012	448.529999	445.390015	445.98999
2023/9/13	60,199,300 	446.220001	447.709991	445.079987	446.51001
2023/9/14	83,430,800 	449.070007	451.079987	447.720001	450.359985
2023/9/15	111,761,400 	447.140015	447.480011	442.920013	443.369995
2023/9/18	55,752,200 	443.049988	444.970001	442.559998	443.630005
2023/9/19	66,514,600 	442.679993	443.290009	439.940002	442.709991
2023/9/20	82,562,600 	444.01001	444.440002	438.429993	438.640015
2023/9/21	103,976,100 	435.700012	435.970001	431.230011	431.390015
2023/9/22	100,829,700 	432.450012	434.100006	429.98999	430.420013
2023/9/25	70,874,500 	429.170013	432.269989	428.720001	432.230011
2023/9/26	96,168,400 	429.089996	429.820007	425.019989	425.880005
2023/9/27	104,705,800 	427.089996	427.670013	422.290009	426.049988
2023/9/28	92,258,300 	425.480011	430.25	424.869995	428.519989
2023/9/29	115,078,500 	431.670013	431.850006	425.910004	427.480011
2023/10/2	83,798,600 	426.619995	428.600006	424.459991	427.309998
2023/10/3	103,760,600 	425.059998	427.369995	420.179993	421.589996
2023/10/4	87,453,000 	422.070007	425.429993	420.559998	424.660004
2023/10/5	70,142,700 	424.359985	425.369995	421.170013	424.5
2023/10/6	113,202,700 	421.970001	431.130005	420.600006	429.540009
2023/10/9	80,374,400 	427.579987	432.880005	427.01001	432.290009
2023/10/10	78,607,300 	432.940002	437.220001	432.529999	434.540009
2023/10/11	62,451,700 	435.640015	436.579987	433.179993	436.320007
2023/10/12	81,154,200 	436.950012	437.339996	431.230011	433.660004
2023/10/13	95,143,100 	435.209991	436.450012	429.880005	431.5
2023/10/16	75,433,200 	433.820007	437.140015	433.570007	436.040009
2023/10/17	75,324,700 	432.809998	438.140015	432.450012	436.019989
2023/10/18	93,559,800 	434.190002	435.179993	429.089996	430.209991
2023/10/19	121,323,000 	430.950012	432.820007	425.730011	426.429993
2023/10/20	123,845,800 	425.980011	426.540009	421.079987	421.190002
2023/10/23	92,035,100 	419.609985	424.450012	417.799988	420.459991
2023/10/24	78,564,200 	422.649994	424.820007	420.73999	423.630005
2023/10/25	94,223,200 	421.890015	421.920013	417.019989	417.549988
2023/10/26	115,156,800 	416.450012	417.329987	411.600006	412.549988
2023/10/27	107,367,700 	414.190002	414.600006	409.209991	410.679993
2023/10/30	86,562,700 	413.559998	416.679993	412.220001	415.589996
2023/10/31	79,665,200 	416.179993	418.529999	414.209991	418.200012
2023/11/1	98,068,100 	419.200012	423.5	418.649994	422.660004
2023/11/2	94,938,900 	426.579987	430.920013	426.559998	430.76001
2023/11/3	100,110,800 	433.140015	436.290009	433.01001	434.690002
2023/11/6	67,831,700 	435.470001	436.149994	433.679993	435.690002
2023/11/7	64,256,100 	435.690002	437.589996	434.51001	436.929993
2023/11/8	61,746,000 	437.549988	438.089996	434.869995	437.25
2023/11/9	83,174,400 	438.429993	438.470001	433.399994	433.839996
2023/11/10	89,462,200 	435.980011	440.929993	433.829987	440.609985
2023/11/13	52,236,100 	439.230011	441.329987	438.420013	440.190002
2023/11/14	97,176,900 	446.320007	450.059998	446.089996	448.730011
2023/11/15	77,327,600 	450.109985	451.380005	448.799988	449.679993
2023/11/16	66,665,800 	449.220001	450.559998	448.119995	450.230011
2023/11/17	83,133,200 	450.23999	451.420013	449.290009	450.790009
2023/11/20	69,936,200 	450.529999	455.130005	450.519989	454.26001
2023/11/21	49,244,600 	453.179993	454.130005	451.959991	453.269989
2023/11/22	59,394,900 	454.980011	456.380005	453.890015	455.019989
2023/11/24	29,737,400 	455.070007	455.5	454.730011	455.299988
2023/11/27	50,506,000 	454.649994	455.48999	454.079987	454.480011
2023/11/28	62,115,000 	454.079987	456.269989	453.5	454.929993
2023/11/29	63,146,000 	457.149994	458.320007	454.200012	454.609985
2023/11/30	79,752,700 	455.480011	456.76001	453.339996	456.399994
2023/12/1	89,097,900 	455.769989	459.649994	455.160004	459.100006
2023/12/4	72,430,900 	455.600006	459.119995	454.339996	456.690002
2023/12/5	69,793,500 	455.26001	457.589996	454.869995	456.600006
2023/12/6	69,124,700 	458.809998	458.839996	454.309998	454.76001
2023/12/7	66,995,400 	456.910004	458.899994	456.290009	458.230011
2023/12/8	83,080,900 	457.459991	460.75	457.209991	460.200012
2023/12/11	65,002,200 	459.690002	462.170013	459.470001	461.98999
2023/12/12	68,327,600 	461.630005	464.200012	460.600006	464.100006
2023/12/13	93,278,000 	464.48999	470.76001	464.119995	470.5
2023/12/14	119,026,000 	472.5	473.730011	469.25	472.01001
2023/12/15	141,319,300 	469.48999	470.700012	467.429993	469.329987
2023/12/18	70,375,300 	470.980011	472.980011	469.890015	471.970001
2023/12/19	55,761,800 	472.529999	474.920013	472.450012	474.839996
2023/12/20	102,921,000 	473.959991	475.899994	467.820007	468.26001
2023/12/21	86,667,500 	471.329987	472.980011	468.839996	472.700012
2023/12/22	67,126,600 	473.859985	475.380005	471.700012	473.649994
2023/12/26	55,387,000 	474.070007	476.579987	473.98999	475.649994
2023/12/27	68,000,300 	475.440002	476.660004	474.890015	476.51001
2023/12/28	77,158,100 	476.880005	477.549988	476.26001	476.690002
2023/12/29	122,234,100 	476.48999	477.029999	473.299988	475.309998
2024/1/2	123,623,700 	472.160004	473.670013	470.48999	472.649994
2024/1/3	103,585,900 	470.429993	471.190002	468.170013	468.790009
2024/1/4	84,232,200 	468.299988	470.959991	467.049988	467.279999
2024/1/5	86,060,800 	467.48999	470.440002	466.429993	467.920013
2024/1/8	74,879,100 	468.429993	474.75	468.299988	474.600006
2024/1/9	65,931,400 	471.869995	474.929993	471.350006	473.880005
2024/1/10	67,310,600 	474.160004	477.450012	473.869995	476.559998
2024/1/11	77,940,700 	477.589996	478.119995	472.26001	476.350006
2024/1/12	57,944,000 	477.839996	478.600006	475.230011	476.679993
2024/1/16	85,014,900 	475.26001	476.609985	473.059998	474.929993
2024/1/17	68,843,900 	471.820007	472.790009	469.869995	472.290009
2024/1/18	91,856,200 	474.01001	477.059998	472.420013	476.48999
2024/1/19	110,733,300 	477.649994	482.720001	476.540009	482.429993
2024/1/22	75,844,900 	484.01001	485.220001	482.779999	483.450012
2024/1/23	49,945,300 	484.01001	485.109985	482.890015	484.859985
2024/1/24	81,765,000 	487.809998	488.769989	484.880005	485.390015
2024/1/25	72,525,000 	487.579987	488.309998	485.390015	488.029999
2024/1/26	76,641,600 	487.589996	489.119995	486.540009	487.410004
2024/1/29	61,322,800 	487.730011	491.420013	487.170013	491.269989
2024/1/30	58,618,400 	490.559998	491.619995	490.109985	490.890015
2024/1/31	126,011,100 	488.619995	489.079987	482.859985	482.880005
2024/2/1	91,891,600 	484.630005	489.230011	483.799988	489.200012
2024/2/2	99,147,700 	489.649994	496.049988	489.299988	494.350006
2024/2/5	75,757,100 	493.700012	494.380005	490.230011	492.549988
2024/2/6	55,918,600 	493.519989	494.320007	492.049988	493.980011
2024/2/7	70,556,500 	496.290009	498.529999	495.359985	498.100006
2024/2/8	52,343,600 	498.100006	498.709991	497.26001	498.320007
2024/2/9	63,979,400 	498.839996	501.649994	498.48999	501.200012
2024/2/12	56,502,300 	501.170013	503.5	500.23999	500.980011
2024/2/13	113,099,200 	494.529999	497.089996	490.720001	494.079987
2024/2/14	68,387,800 	496.790009	499.070007	494.399994	498.570007
2024/2/15	61,683,000 	499.290009	502.200012	498.799988	502.01001
2024/2/16	75,461,200 	501.700012	502.869995	498.75	499.51001
2024/2/20	71,736,700 	497.720001	498.410004	494.450012	496.76001
2024/2/21	59,603,800 	495.420013	497.369995	493.559998	497.209991
2024/2/22	76,402,500 	504.01001	508.48999	503.019989	507.5
2024/2/23	61,321,800 	509.269989	510.130005	507.100006	507.850006
2024/2/26	50,386,700 	508.299988	508.75	505.859985	505.98999
2024/2/27	48,854,500 	506.700012	507.160004	504.75	506.929993
2024/2/28	56,506,600 	505.329987	506.859985	504.959991	506.26001
2024/2/29	83,924,800 	508.070007	509.73999	505.350006	508.079987
2024/3/1	76,805,900 	508.980011	513.289978	508.559998	512.849976
2024/3/4	49,799,300 	512.030029	514.200012	512	512.299988
2024/3/5	72,855,600 	510.23999	510.700012	504.910004	507.179993
2024/3/6	68,382,400 	510.549988	512.070007	508.420013	509.75
2024/3/7	58,652,100 	513.140015	515.890015	509.809998	514.809998
2024/3/8	86,425,500 	515.460022	518.219971	511.130005	511.720001

033

留言

  1. Ryu20222024年3月10日 晚上8:58

    https://ryu2022.blogspot.com/2024/03/d11050131excelspy.html

    回覆刪除
  2. 佘芷涵2024年3月10日 晚上9:02

    https://zxcv0218.blogspot.com/2024/03/excelspy.html

    回覆刪除
    回覆
    1. George2024年3月11日 凌晨2:28

      持續累積、學習、壯大自己的生命力。

      刪除
  3. RayWu2024年3月10日 晚上9:05

    https://draft.blogger.com/blog/post/edit/preview/6174802439427569065/1931493513952161014

    回覆刪除
    回覆
    1. George2024年3月11日 凌晨2:47

      耐心做，就會進步，就會有收穫。

      刪除
  4. 曹理淵 程式設計2024年3月10日 晚上9:06

    作者已經移除這則留言。

    回覆刪除
  5. 曹理淵 程式設計2024年3月10日 晚上9:08

    https://liyuantsao.blogspot.com/2024/03/202313-74850700-384_10.html

    回覆刪除
  6. 黃書涵2024年3月10日 晚上9:09

    https://leilaaa26777.blogspot.com/2024/03/excelspy.html

    回覆刪除
  7. D11017136徐偉宬2024年3月10日 晚上9:10

    https://algorithmic-trading-17136.blogspot.com/2024/03/spy.html

    回覆刪除
  8. 2021/9/62024年3月10日 晚上9:12

    作者已經移除這則留言。

    回覆刪除
  9. 金一乙42李岳勳2024年3月10日 晚上9:12

    https://d11017242takming.blogspot.com/2024/03/excelspy.html

    回覆刪除
  10. D110172432024年3月10日 晚上9:15

    https://yan911222.blogspot.com/2024/03/blog-post.html

    回覆刪除
  11. 江舜廷2024年3月10日 晚上9:15

    https://ting1008finan.blogspot.com/2024/03/excelspy.html

    回覆刪除
  12. d110361242024年3月10日 晚上9:17

    https://11036124.blogspot.com/2024/03/20240311.html

    回覆刪除
    回覆
    1. George2024年3月11日 凌晨2:25

      https://www.facebook.com/photo?fbid=7688180447859783

      刪除
    2. George2024年3月11日 凌晨2:26

      https://www.facebook.com/photo?fbid=7688180204526474

      刪除
  13. 李嘉芊2024年3月17日 晚上9:06

    https://jia-0909.blogspot.com/2024/03/excel-spy.html

    回覆刪除

張貼留言

這個網誌中的熱門文章

2025年3月7日福斯汽車與遊戲驛站軋工事件

圖片
嵌入embed網頁src=source來源 維基百科福斯汽車Volkswagan軋空事件 維基百科福斯遊戲驛站GameStop事件 維基百科 遊戲驛站軋空事件（或稱遊戲驛站空頭擠壓事件，又簡稱GME事件，部分中文媒體又以「史詩級軋空」稱之）是指在2021年1月，美國電子產品銷售商遊戲驛站（GameStop）股票發生持續軋空的現象，導致對部分對沖基金造成重大財務影響。一些對沖基金賣空遊戲驛站，押注股價將繼續下跌，相當於遊戲驛站總股本140%的股份被做空。然而因遊戲驛站股價高漲且持有者惜售，空方無法獲得足夠股份履行期權合約，不得不急於彌補倉位，反而推動股價繼續上漲，產生軋空現象；或因無法履行期權合約而被強行平倉，產生巨額損失[2]。遊戲驛站股價因軋空使得其最高點價位比歷史低點飆升近190倍（截止1月28日），在2021年1月28日每股股價最高達483美元，對空頭造成了巨大損失。這次軋空事件主要是由Reddit社群網站上的r/wallstreetbets討論板和其他線上交易論壇的使用者透過羅賓漢等免費交易app觸發。 1月28日，多個證券經紀公司，包括羅賓漢暫停使用者購入遊戲驛站及其他一些關聯股票，後來援引稱他們無法在清算公司張貼足夠的擔保物權來執行客戶的訂單。這一決定引發了來自跨黨派的政治家和商人的批評，指責這一行為操縱市場[3][4]。有投資者在美國紐約南區聯邦地區法院和美國伊利諾伊北區聯邦地區法院對羅賓漢發動集體訴訟[5]。 除了遊戲驛站之外，多個被嚴重做空的股票，以及和這些股票代碼近似的股票亦出現股價暴漲。此外在券商限制購入這些股票後，加密貨幣及一些金屬期貨的總市值也大幅上揚。 以上嵌入網頁的程式碼 <STYLE>H1{PADDING:5PX;TEXT-ALIGN:CENTER;BACKGROUND-COLOR:PURPLE;COLOR:WHITE;}</STYLE> <H1>嵌入embed網頁src=source來源</H1> <iframe src="https://www.youtube.com/embed/EPyVZuJWbRQ?si=L-KvgNKWWwyXsszG"></iframe> <H1>維基百科福斯汽車Volkswaga...
閱讀完整內容

劉任昌利用Python讀取SPY日成交資料(繳交作業情形)

圖片
傳統程式碼利用;或{}分指令或區段，刻意排版方便閱讀，PYTHON利用分行與所排當作指令 學過的電腦HTML, CSS, JAVASCRIPT, PYTHON PYTHON程式碼 #下載csv檔案下載CSV檔案 https://drive.google.com/file/d/1eB8B... #劉任昌 import csv #輸入套件csv=comma seperated value #輸入csv套件comma separated value file = open('SPY.CSV','r') #打開下載的檔案SPY.CSV,模式是r讀取, csvreader = csv.reader(file) #將檔案讀入變數csvreader header, rows = [], [] #宣告空白串列(陣列,清單) header = next(csvreader) #串列header儲存檔案第一列 for row in csvreader: #檔案接續逐列附加append於rows串列 rows.append(row) file.close() #關閉檔案 print(header) print(len(rows)) print('全球第一檔ETF交易資料') print(rows[0]) print(rows[len(rows)-1]) 執行結果 IPython 7.22.0 -- An enhanced Interactive Python. runfile('C:/Users/user/Downloads/劉任昌.py', wdir='C:/Users/user/Downloads') ['日期', '成交量', '開', '高', '低', '收', '調收'] 7833 ['1993/1/29', '1003200', '43.96875', '43.96875', '43.75...
閱讀完整內容

劉任昌python讀取CSV檔案SPDR標普500ETF在1993/1/29至2025/3/20

圖片
#白皓宇python程式碼分析spy:標準500ETF import csv #輸入套件csv=comma seperated value #輸入csv套件comma separated value file = open('SPY.CSV','r') #打開下載的檔案SPY.CSV,模式是r讀取, csvreader = csv.DictReader(file) #將檔案讀入變數csvreader for row in csvreader: #檔案接續逐列附加append於rows串列 # print(row) print(row['日']+' 當天收盤價 '+row['收']) file.close() #關閉檔案 #上一個作業讀近來放成串列list,直接讀成字典 Jupyter執行python 影片 python.org說明csv與DictReader class csv.DictReader(f, fieldnames=None, restkey=None, restval=None, dialect='excel', *args, **kwds) 建立一個物件，其運作上就像一般的讀取器，但可以將每一列資訊 map （對映） 到 dict 中，可以透過選填的參數 fieldnames 設定 key。 參數 fieldnames 是一個 sequence。如果 fieldnames 被省略了，檔案 f 中第一列的值會被當作欄位標題，且於結果中會被省略。如果 fieldname 有提供，它們就會被使用，且第一列會被包含在結果中。不管欄位標題是如何決定的，dictionary 都會保留原始的排序。 如果一列資料中的欄位比欄位標題還多，其餘的資料及以 restkey （預設為 None）特指的欄位標題會放入列表當中並儲存。如果一個非空的 (non-blank) 列中的欄位比欄位標題還少，缺少的值則會填入 restval （預設為 None）的值。 所有其他選填的引數或關鍵字引數皆會傳遞至下層的 reader 實例。 如果傳遞至 fieldnames...
閱讀完整內容