ความคิดเห็นที่ 28
ผมใช้ MS Access ในการคำนวณ และผมได้ลอง export ข้อมูลการซื้อขายออกมาในรูป text file ไม่รู้จะใช้ได้หรือเปล่าลองเอา text file นี้ไปเปิดใน Excel ดู โดยใช้ Comma ในการแยกข้อมูลแล้วกันนะครับ
2001/1/5 00:00:00,"99SET",278.74,3500.00,977782.1,2001/2/7 00:00:00,323.21,1.128693e+06,150910.9,15.43,1.150911e+06,"SOLD", 2001/2/26 00:00:00,"99SET",328.73,3400.00,1.120193e+06,2001/3/2 00:00:00,316.21,1.072698e+06,-47495.00,-4.23,1.103416e+06,"SOLD", 2001/4/17 00:00:00,"99SET",291.67,3700.00,1.081604e+06,2001/5/17 00:00:00,300.49,1.109315e+06,27711.00,2.56,1.131127e+06,"SOLD", 2001/5/24 00:00:00,"99SET",311.56,3600.00,1.124136e+06,2001/7/12 00:00:00,314.07,1.128111e+06,3975.00,0.35,1.135102e+06,"SOLD", 2001/8/6 00:00:00,"99SET",323.00,3500.00,1.13304e+06,2001/9/11 00:00:00,332.65,1.161659e+06,28619.00,2.52,1.163721e+06,"SOLD", 2001/10/5 00:00:00,"99SET",282.83,4100.00,1.162209e+06,2001/10/31 00:00:00,273.88,1.120385e+06,-41824.00,-3.59,1.121897e+06,"SOLD", 2001/11/19 00:00:00,"99SET",276.10,4000.00,1.106882e+06,2001/12/12 00:00:00,295.71,1.180182e+06,73300.00,6.62,1.195198e+06,"SOLD", 2001/12/25 00:00:00,"99SET",303.12,3900.00,1.184824e+06,2002/2/22 00:00:00,361.46,1.406526e+06,221702.0,18.71,1.4169e+06,"SOLD", 2002/2/28 00:00:00,"99SET",375.58,3700.00,1.392769e+06,2002/3/14 00:00:00,378.19,1.396159e+06,3391.00,0.24,1.42029e+06,"SOLD", 2002/3/22 00:00:00,"99SET",387.93,3600.00,1.399686e+06,2002/3/28 00:00:00,377.52,1.356018e+06,-43668.00,-3.11,1.376622e+06,"SOLD", 2002/4/12 00:00:00,"99SET",377.50,3600.00,1.362054e+06,2002/4/26 00:00:00,374.10,1.343734e+06,-18320.00,-1.34,1.358302e+06,"SOLD", 2002/5/9 00:00:00,"99SET",387.07,3500.00,1.357789e+06,2002/6/20 00:00:00,405.61,1.416445e+06,58656.00,4.31,1.416958e+06,"SOLD", 2002/7/8 00:00:00,"99SET",404.05,3400.00,1.376857e+06,2002/7/17 00:00:00,392.71,1.332214e+06,-44643.00,-3.24,1.372315e+06,"SOLD", 2002/9/11 00:00:00,"99SET",360.92,3700.00,1.338405e+06,2002/9/17 00:00:00,356.83,1.317304e+06,-21101.00,-1.57,1.351215e+06,"SOLD", 2002/10/21 00:00:00,"99SET",342.72,3900.00,1.339611e+06,2002/11/13 00:00:00,345.63,1.344928e+06,5317.00,0.39,1.356532e+06,"SOLD", 2002/11/18 00:00:00,"99SET",357.58,3700.00,1.326019e+06,2002/12/16 00:00:00,355.61,1.312801e+06,-13219.00,-0.99,1.343314e+06,"SOLD", 2003/1/7 00:00:00,"99SET",366.50,3600.00,1.322365e+06,2003/2/14 00:00:00,370.34,1.330228e+06,7863.00,0.59,1.351178e+06,"SOLD", 2003/3/4 00:00:00,"99SET",366.99,3600.00,1.324133e+06,2003/3/11 00:00:00,351.65,1.263095e+06,-61038.00,-4.60,1.290141e+06,"SOLD", 2003/3/19 00:00:00,"99SET",362.03,3500.00,1.269952e+06,2003/4/24 00:00:00,375.86,1.312554e+06,42602.00,3.35,1.332743e+06,"SOLD", 2003/5/12 00:00:00,"99SET",385.36,3400.00,1.313168e+06,2003/7/11 00:00:00,468.59,1.589626e+06,276458.0,21.05,1.609201e+06,"SOLD", 2003/7/16 00:00:00,"99SET",498.83,3200.00,1.599843e+06,2003/7/24 00:00:00,480.75,1.534943e+06,-64900.00,-4.05,1.544301e+06,"SOLD", 2003/8/4 00:00:00,"99SET",492.45,3100.00,1.530025e+06,2003/9/19 00:00:00,561.18,1.735749e+06,205724.0,13.44,1.750025e+06,"SOLD", 2003/9/25 00:00:00,"99SET",574.41,3000.00,1.727102e+06,2003/10/6 00:00:00,559.53,1.674818e+06,-52284.00,-3.02,1.697741e+06,"SOLD", 2003/10/10 00:00:00,"99SET",578.77,2900.00,1.682205e+06,2003/11/12 00:00:00,648.64,1.876829e+06,194625.0,11.56,1.892366e+06,"SOLD", 2003/11/27 00:00:00,"99SET",632.83,2900.00,1.839331e+06,2004/1/8 00:00:00,757.80,2.192682e+06,353351.0,19.21,2.245717e+06,"SOLD", 2004/1/12 00:00:00,"99SET",792.60,2800.00,2.224267e+06,2004/1/16 00:00:00,767.39,2.143864e+06,-80403.00,-3.61,2.165314e+06,"SOLD", 2004/2/5 00:00:00,"99SET",720.36,2900.00,2.093738e+06,2004/2/25 00:00:00,719.65,2.082296e+06,-11442.00,-0.54,2.153872e+06,"SOLD", 2004/4/2 00:00:00,"99SET",679.29,3100.00,2.110531e+06,2004/4/23 00:00:00,691.82,2.139823e+06,29292.00,1.38,2.183164e+06,"SOLD", 2004/5/20 00:00:00,"99SET",614.87,3500.00,2.156881e+06,2004/6/9 00:00:00,607.38,2.121053e+06,-35828.00,-1.66,2.147337e+06,"SOLD", 2004/6/25 00:00:00,"99SET",641.55,3300.00,2.121872e+06,2004/7/16 00:00:00,646.77,2.129545e+06,7673.00,0.36,2.155009e+06,"SOLD",
จากคุณ :
siamstocks
- [
6 มี.ค. 48 10:32:52
A:202.57.140.156 X: TicketID:090428
]
|
|
|