Skip to content

Instantly share code, notes, and snippets.

@gary136
Created March 24, 2020 15:07
Show Gist options
  • Save gary136/f31fccf27942eceeb919239dd9b197af to your computer and use it in GitHub Desktop.
Save gary136/f31fccf27942eceeb919239dd9b197af to your computer and use it in GitHub Desktop.
price_variation.ipynb
Display the source blob
Display the rendered blob
Raw
{
"cells": [
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"from twstock import *"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"pd.set_option('display.max_rows', 5000)\n",
"pd.set_option('display.max_columns', 500)\n",
"pd.set_option('display.width', 1000)\n",
"plt.rcParams['font.sans-serif'] = ['Microsoft JhengHei'] \n",
"plt.rcParams['axes.unicode_minus'] = False"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [],
"source": [
"p0 = TwPrice('20200102', '上市')[['股價日期', '證券代號', '證券名稱', '收盤價']]"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>股價日期</th>\n",
" <th>證券代號</th>\n",
" <th>證券名稱</th>\n",
" <th>收盤價</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2020-01-02</td>\n",
" <td>0050</td>\n",
" <td>元大台灣50</td>\n",
" <td>97.65</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2020-01-02</td>\n",
" <td>0051</td>\n",
" <td>元大中型100</td>\n",
" <td>35.45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2020-01-02</td>\n",
" <td>0052</td>\n",
" <td>富邦科技</td>\n",
" <td>73.30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>2020-01-02</td>\n",
" <td>0053</td>\n",
" <td>元大電子</td>\n",
" <td>42.70</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>2020-01-02</td>\n",
" <td>0054</td>\n",
" <td>元大台商50</td>\n",
" <td>24.75</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 股價日期 證券代號 證券名稱 收盤價\n",
"0 2020-01-02 0050 元大台灣50 97.65\n",
"1 2020-01-02 0051 元大中型100 35.45\n",
"2 2020-01-02 0052 富邦科技 73.30\n",
"3 2020-01-02 0053 元大電子 42.70\n",
"4 2020-01-02 0054 元大台商50 24.75"
]
},
"execution_count": 20,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"p0.head()"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [],
"source": [
"p1 = TwPrice('20200324', '上市')[['股價日期', '證券代號', '證券名稱', '收盤價']]"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>股價日期</th>\n",
" <th>證券代號</th>\n",
" <th>證券名稱</th>\n",
" <th>收盤價</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2020-03-24</td>\n",
" <td>0050</td>\n",
" <td>元大台灣50</td>\n",
" <td>74.25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2020-03-24</td>\n",
" <td>0051</td>\n",
" <td>元大中型100</td>\n",
" <td>26.62</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2020-03-24</td>\n",
" <td>0052</td>\n",
" <td>富邦科技</td>\n",
" <td>57.40</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>2020-03-24</td>\n",
" <td>0053</td>\n",
" <td>元大電子</td>\n",
" <td>33.30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>2020-03-24</td>\n",
" <td>0054</td>\n",
" <td>元大台商50</td>\n",
" <td>18.88</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 股價日期 證券代號 證券名稱 收盤價\n",
"0 2020-03-24 0050 元大台灣50 74.25\n",
"1 2020-03-24 0051 元大中型100 26.62\n",
"2 2020-03-24 0052 富邦科技 57.40\n",
"3 2020-03-24 0053 元大電子 33.30\n",
"4 2020-03-24 0054 元大台商50 18.88"
]
},
"execution_count": 21,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"p1.head()"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {},
"outputs": [],
"source": [
"px = pd.merge(p0,p1,on=['證券代號', '證券名稱'],how='left')\n",
"px = px[['證券代號', '證券名稱', '股價日期_x', '收盤價_x', '股價日期_y', '收盤價_y']]\n",
"px['差價'] = px['收盤價_y'] - px['收盤價_x']\n",
"px['價格波動(%)'] = round(100 * px['差價'] / px['收盤價_x'], 2)"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>證券代號</th>\n",
" <th>證券名稱</th>\n",
" <th>股價日期_x</th>\n",
" <th>收盤價_x</th>\n",
" <th>股價日期_y</th>\n",
" <th>收盤價_y</th>\n",
" <th>差價</th>\n",
" <th>價格波動(%)</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0050</td>\n",
" <td>元大台灣50</td>\n",
" <td>2020-01-02</td>\n",
" <td>97.65</td>\n",
" <td>2020-03-24</td>\n",
" <td>74.25</td>\n",
" <td>-23.40</td>\n",
" <td>-23.96</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>0051</td>\n",
" <td>元大中型100</td>\n",
" <td>2020-01-02</td>\n",
" <td>35.45</td>\n",
" <td>2020-03-24</td>\n",
" <td>26.62</td>\n",
" <td>-8.83</td>\n",
" <td>-24.91</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>0052</td>\n",
" <td>富邦科技</td>\n",
" <td>2020-01-02</td>\n",
" <td>73.30</td>\n",
" <td>2020-03-24</td>\n",
" <td>57.40</td>\n",
" <td>-15.90</td>\n",
" <td>-21.69</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>0053</td>\n",
" <td>元大電子</td>\n",
" <td>2020-01-02</td>\n",
" <td>42.70</td>\n",
" <td>2020-03-24</td>\n",
" <td>33.30</td>\n",
" <td>-9.40</td>\n",
" <td>-22.01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>0054</td>\n",
" <td>元大台商50</td>\n",
" <td>2020-01-02</td>\n",
" <td>24.75</td>\n",
" <td>2020-03-24</td>\n",
" <td>18.88</td>\n",
" <td>-5.87</td>\n",
" <td>-23.72</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 證券代號 證券名稱 股價日期_x 收盤價_x 股價日期_y 收盤價_y 差價 價格波動(%)\n",
"0 0050 元大台灣50 2020-01-02 97.65 2020-03-24 74.25 -23.40 -23.96\n",
"1 0051 元大中型100 2020-01-02 35.45 2020-03-24 26.62 -8.83 -24.91\n",
"2 0052 富邦科技 2020-01-02 73.30 2020-03-24 57.40 -15.90 -21.69\n",
"3 0053 元大電子 2020-01-02 42.70 2020-03-24 33.30 -9.40 -22.01\n",
"4 0054 元大台商50 2020-01-02 24.75 2020-03-24 18.88 -5.87 -23.72"
]
},
"execution_count": 31,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"px.head()"
]
},
{
"cell_type": "code",
"execution_count": 34,
"metadata": {
"scrolled": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>證券代號</th>\n",
" <th>證券名稱</th>\n",
" <th>股價日期_x</th>\n",
" <th>收盤價_x</th>\n",
" <th>股價日期_y</th>\n",
" <th>收盤價_y</th>\n",
" <th>差價</th>\n",
" <th>價格波動(%)</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>58</th>\n",
" <td>00672L</td>\n",
" <td>元大S&amp;P原油正2</td>\n",
" <td>2020-01-02</td>\n",
" <td>17.09</td>\n",
" <td>2020-03-24</td>\n",
" <td>2.89</td>\n",
" <td>-14.20</td>\n",
" <td>-83.09</td>\n",
" </tr>\n",
" <tr>\n",
" <th>219</th>\n",
" <td>03050X</td>\n",
" <td>元展47</td>\n",
" <td>2020-01-02</td>\n",
" <td>2.12</td>\n",
" <td>2020-03-24</td>\n",
" <td>0.46</td>\n",
" <td>-1.66</td>\n",
" <td>-78.30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15790</th>\n",
" <td>1472</td>\n",
" <td>三洋紡</td>\n",
" <td>2020-01-02</td>\n",
" <td>27.30</td>\n",
" <td>2020-03-24</td>\n",
" <td>9.32</td>\n",
" <td>-17.98</td>\n",
" <td>-65.86</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16284</th>\n",
" <td>3321</td>\n",
" <td>同泰</td>\n",
" <td>2020-01-02</td>\n",
" <td>15.75</td>\n",
" <td>2020-03-24</td>\n",
" <td>5.64</td>\n",
" <td>-10.11</td>\n",
" <td>-64.19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15947</th>\n",
" <td>2231</td>\n",
" <td>為升</td>\n",
" <td>2020-01-02</td>\n",
" <td>249.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>90.00</td>\n",
" <td>-159.50</td>\n",
" <td>-63.93</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16662</th>\n",
" <td>9946</td>\n",
" <td>三發地產</td>\n",
" <td>2020-01-02</td>\n",
" <td>27.30</td>\n",
" <td>2020-03-24</td>\n",
" <td>10.05</td>\n",
" <td>-17.25</td>\n",
" <td>-63.19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16536</th>\n",
" <td>6558</td>\n",
" <td>興能高</td>\n",
" <td>2020-01-02</td>\n",
" <td>73.20</td>\n",
" <td>2020-03-24</td>\n",
" <td>27.40</td>\n",
" <td>-45.80</td>\n",
" <td>-62.57</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16420</th>\n",
" <td>5225</td>\n",
" <td>東科-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>55.80</td>\n",
" <td>2020-03-24</td>\n",
" <td>21.10</td>\n",
" <td>-34.70</td>\n",
" <td>-62.19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16252</th>\n",
" <td>3046</td>\n",
" <td>建碁</td>\n",
" <td>2020-01-02</td>\n",
" <td>16.55</td>\n",
" <td>2020-03-24</td>\n",
" <td>6.50</td>\n",
" <td>-10.05</td>\n",
" <td>-60.73</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16509</th>\n",
" <td>6283</td>\n",
" <td>淳安</td>\n",
" <td>2020-01-02</td>\n",
" <td>31.20</td>\n",
" <td>2020-03-24</td>\n",
" <td>12.40</td>\n",
" <td>-18.80</td>\n",
" <td>-60.26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15822</th>\n",
" <td>1538</td>\n",
" <td>正峰新</td>\n",
" <td>2020-01-02</td>\n",
" <td>4.94</td>\n",
" <td>2020-03-24</td>\n",
" <td>1.99</td>\n",
" <td>-2.95</td>\n",
" <td>-59.72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>00653L</td>\n",
" <td>富邦印度正2</td>\n",
" <td>2020-01-02</td>\n",
" <td>30.38</td>\n",
" <td>2020-03-24</td>\n",
" <td>12.24</td>\n",
" <td>-18.14</td>\n",
" <td>-59.71</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15884</th>\n",
" <td>1795</td>\n",
" <td>美時</td>\n",
" <td>2020-01-02</td>\n",
" <td>117.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>48.10</td>\n",
" <td>-69.40</td>\n",
" <td>-59.06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>123</th>\n",
" <td>00852L</td>\n",
" <td>國泰美國道瓊正2</td>\n",
" <td>2020-01-02</td>\n",
" <td>17.56</td>\n",
" <td>2020-03-24</td>\n",
" <td>7.30</td>\n",
" <td>-10.26</td>\n",
" <td>-58.43</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16554</th>\n",
" <td>6698</td>\n",
" <td>旭暉應材</td>\n",
" <td>2020-01-02</td>\n",
" <td>91.90</td>\n",
" <td>2020-03-24</td>\n",
" <td>39.40</td>\n",
" <td>-52.50</td>\n",
" <td>-57.13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16385</th>\n",
" <td>4739</td>\n",
" <td>康普</td>\n",
" <td>2020-01-02</td>\n",
" <td>77.10</td>\n",
" <td>2020-03-24</td>\n",
" <td>33.25</td>\n",
" <td>-43.85</td>\n",
" <td>-56.87</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16143</th>\n",
" <td>2702</td>\n",
" <td>華園</td>\n",
" <td>2020-01-02</td>\n",
" <td>23.10</td>\n",
" <td>2020-03-24</td>\n",
" <td>10.30</td>\n",
" <td>-12.80</td>\n",
" <td>-55.41</td>\n",
" </tr>\n",
" <tr>\n",
" <th>88</th>\n",
" <td>00712</td>\n",
" <td>FH富時不動產</td>\n",
" <td>2020-01-02</td>\n",
" <td>18.17</td>\n",
" <td>2020-03-24</td>\n",
" <td>8.15</td>\n",
" <td>-10.02</td>\n",
" <td>-55.15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16651</th>\n",
" <td>9935</td>\n",
" <td>慶豐富</td>\n",
" <td>2020-01-02</td>\n",
" <td>41.45</td>\n",
" <td>2020-03-24</td>\n",
" <td>18.60</td>\n",
" <td>-22.85</td>\n",
" <td>-55.13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16303</th>\n",
" <td>3504</td>\n",
" <td>揚明光</td>\n",
" <td>2020-01-02</td>\n",
" <td>83.80</td>\n",
" <td>2020-03-24</td>\n",
" <td>38.95</td>\n",
" <td>-44.85</td>\n",
" <td>-53.52</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16523</th>\n",
" <td>6451</td>\n",
" <td>訊芯-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>162.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>76.70</td>\n",
" <td>-85.80</td>\n",
" <td>-52.80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16415</th>\n",
" <td>4994</td>\n",
" <td>傳奇</td>\n",
" <td>2020-01-02</td>\n",
" <td>87.20</td>\n",
" <td>2020-03-24</td>\n",
" <td>41.65</td>\n",
" <td>-45.55</td>\n",
" <td>-52.24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16460</th>\n",
" <td>6120</td>\n",
" <td>達運</td>\n",
" <td>2020-01-02</td>\n",
" <td>16.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>7.96</td>\n",
" <td>-8.54</td>\n",
" <td>-51.76</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16305</th>\n",
" <td>3518</td>\n",
" <td>柏騰</td>\n",
" <td>2020-01-02</td>\n",
" <td>39.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>18.85</td>\n",
" <td>-20.15</td>\n",
" <td>-51.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16286</th>\n",
" <td>3346</td>\n",
" <td>麗清</td>\n",
" <td>2020-01-02</td>\n",
" <td>30.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>14.80</td>\n",
" <td>-15.70</td>\n",
" <td>-51.48</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>00647L</td>\n",
" <td>元大S&amp;P500正2</td>\n",
" <td>2020-01-02</td>\n",
" <td>42.39</td>\n",
" <td>2020-03-24</td>\n",
" <td>20.58</td>\n",
" <td>-21.81</td>\n",
" <td>-51.45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16370</th>\n",
" <td>4551</td>\n",
" <td>智伸科</td>\n",
" <td>2020-01-02</td>\n",
" <td>174.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>85.10</td>\n",
" <td>-88.90</td>\n",
" <td>-51.09</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16404</th>\n",
" <td>4943</td>\n",
" <td>康控-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>174.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>85.40</td>\n",
" <td>-89.10</td>\n",
" <td>-51.06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16009</th>\n",
" <td>2388</td>\n",
" <td>威盛</td>\n",
" <td>2020-01-02</td>\n",
" <td>36.35</td>\n",
" <td>2020-03-24</td>\n",
" <td>17.85</td>\n",
" <td>-18.50</td>\n",
" <td>-50.89</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16569</th>\n",
" <td>8104</td>\n",
" <td>錸寶</td>\n",
" <td>2020-01-02</td>\n",
" <td>57.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>28.00</td>\n",
" <td>-29.00</td>\n",
" <td>-50.88</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16528</th>\n",
" <td>6491</td>\n",
" <td>晶碩</td>\n",
" <td>2020-01-02</td>\n",
" <td>180.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>89.10</td>\n",
" <td>-91.40</td>\n",
" <td>-50.64</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16346</th>\n",
" <td>3712</td>\n",
" <td>永崴投控</td>\n",
" <td>2020-01-02</td>\n",
" <td>20.85</td>\n",
" <td>2020-03-24</td>\n",
" <td>10.30</td>\n",
" <td>-10.55</td>\n",
" <td>-50.60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16262</th>\n",
" <td>3057</td>\n",
" <td>喬鼎</td>\n",
" <td>2020-01-02</td>\n",
" <td>7.62</td>\n",
" <td>2020-03-24</td>\n",
" <td>3.78</td>\n",
" <td>-3.84</td>\n",
" <td>-50.39</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16541</th>\n",
" <td>6591</td>\n",
" <td>動力-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>62.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>30.85</td>\n",
" <td>-31.15</td>\n",
" <td>-50.24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16548</th>\n",
" <td>6668</td>\n",
" <td>中揚光</td>\n",
" <td>2020-01-02</td>\n",
" <td>93.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>46.30</td>\n",
" <td>-46.70</td>\n",
" <td>-50.22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16412</th>\n",
" <td>4976</td>\n",
" <td>佳凌</td>\n",
" <td>2020-01-02</td>\n",
" <td>28.90</td>\n",
" <td>2020-03-24</td>\n",
" <td>14.40</td>\n",
" <td>-14.50</td>\n",
" <td>-50.17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15950</th>\n",
" <td>2239</td>\n",
" <td>英利-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>95.20</td>\n",
" <td>2020-03-24</td>\n",
" <td>47.45</td>\n",
" <td>-47.75</td>\n",
" <td>-50.16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16555</th>\n",
" <td>6706</td>\n",
" <td>惠特</td>\n",
" <td>2020-01-02</td>\n",
" <td>129.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>64.60</td>\n",
" <td>-64.90</td>\n",
" <td>-50.12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16323</th>\n",
" <td>3607</td>\n",
" <td>谷崧</td>\n",
" <td>2020-01-02</td>\n",
" <td>16.95</td>\n",
" <td>2020-03-24</td>\n",
" <td>8.48</td>\n",
" <td>-8.47</td>\n",
" <td>-49.97</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15745</th>\n",
" <td>1340</td>\n",
" <td>勝悅-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>16.30</td>\n",
" <td>2020-03-24</td>\n",
" <td>8.19</td>\n",
" <td>-8.11</td>\n",
" <td>-49.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16310</th>\n",
" <td>3535</td>\n",
" <td>晶彩科</td>\n",
" <td>2020-01-02</td>\n",
" <td>22.75</td>\n",
" <td>2020-03-24</td>\n",
" <td>11.45</td>\n",
" <td>-11.30</td>\n",
" <td>-49.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16428</th>\n",
" <td>5285</td>\n",
" <td>界霖</td>\n",
" <td>2020-01-02</td>\n",
" <td>71.30</td>\n",
" <td>2020-03-24</td>\n",
" <td>36.25</td>\n",
" <td>-35.05</td>\n",
" <td>-49.16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15778</th>\n",
" <td>1456</td>\n",
" <td>怡華</td>\n",
" <td>2020-01-02</td>\n",
" <td>12.20</td>\n",
" <td>2020-03-24</td>\n",
" <td>6.21</td>\n",
" <td>-5.99</td>\n",
" <td>-49.10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16516</th>\n",
" <td>6414</td>\n",
" <td>樺漢</td>\n",
" <td>2020-01-02</td>\n",
" <td>257.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>131.00</td>\n",
" <td>-126.00</td>\n",
" <td>-49.03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15875</th>\n",
" <td>1736</td>\n",
" <td>喬山</td>\n",
" <td>2020-01-02</td>\n",
" <td>85.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>43.35</td>\n",
" <td>-41.65</td>\n",
" <td>-49.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16570</th>\n",
" <td>8105</td>\n",
" <td>凌巨</td>\n",
" <td>2020-01-02</td>\n",
" <td>14.35</td>\n",
" <td>2020-03-24</td>\n",
" <td>7.36</td>\n",
" <td>-6.99</td>\n",
" <td>-48.71</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16500</th>\n",
" <td>6243</td>\n",
" <td>迅杰</td>\n",
" <td>2020-01-02</td>\n",
" <td>11.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>5.65</td>\n",
" <td>-5.35</td>\n",
" <td>-48.64</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16326</th>\n",
" <td>3645</td>\n",
" <td>達邁</td>\n",
" <td>2020-01-02</td>\n",
" <td>52.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>27.00</td>\n",
" <td>-25.50</td>\n",
" <td>-48.57</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16592</th>\n",
" <td>8429</td>\n",
" <td>金麗-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>11.90</td>\n",
" <td>2020-03-24</td>\n",
" <td>6.12</td>\n",
" <td>-5.78</td>\n",
" <td>-48.57</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15980</th>\n",
" <td>2351</td>\n",
" <td>順德</td>\n",
" <td>2020-01-02</td>\n",
" <td>68.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>35.00</td>\n",
" <td>-33.00</td>\n",
" <td>-48.53</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15743</th>\n",
" <td>1338</td>\n",
" <td>廣華-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>67.90</td>\n",
" <td>2020-03-24</td>\n",
" <td>35.00</td>\n",
" <td>-32.90</td>\n",
" <td>-48.45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16359</th>\n",
" <td>4190</td>\n",
" <td>佐登-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>127.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>65.80</td>\n",
" <td>-61.70</td>\n",
" <td>-48.39</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16362</th>\n",
" <td>4426</td>\n",
" <td>利勤</td>\n",
" <td>2020-01-02</td>\n",
" <td>47.95</td>\n",
" <td>2020-03-24</td>\n",
" <td>24.75</td>\n",
" <td>-23.20</td>\n",
" <td>-48.38</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15994</th>\n",
" <td>2367</td>\n",
" <td>燿華</td>\n",
" <td>2020-01-02</td>\n",
" <td>34.15</td>\n",
" <td>2020-03-24</td>\n",
" <td>17.70</td>\n",
" <td>-16.45</td>\n",
" <td>-48.17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16653</th>\n",
" <td>9938</td>\n",
" <td>百和</td>\n",
" <td>2020-01-02</td>\n",
" <td>84.60</td>\n",
" <td>2020-03-24</td>\n",
" <td>43.90</td>\n",
" <td>-40.70</td>\n",
" <td>-48.11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16537</th>\n",
" <td>6573</td>\n",
" <td>虹揚-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>25.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>13.25</td>\n",
" <td>-12.25</td>\n",
" <td>-48.04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16489</th>\n",
" <td>6209</td>\n",
" <td>今國光</td>\n",
" <td>2020-01-02</td>\n",
" <td>31.65</td>\n",
" <td>2020-03-24</td>\n",
" <td>16.45</td>\n",
" <td>-15.20</td>\n",
" <td>-48.03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16294</th>\n",
" <td>3419</td>\n",
" <td>譁裕</td>\n",
" <td>2020-01-02</td>\n",
" <td>18.20</td>\n",
" <td>2020-03-24</td>\n",
" <td>9.46</td>\n",
" <td>-8.74</td>\n",
" <td>-48.02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16024</th>\n",
" <td>2413</td>\n",
" <td>環科</td>\n",
" <td>2020-01-02</td>\n",
" <td>17.20</td>\n",
" <td>2020-03-24</td>\n",
" <td>8.95</td>\n",
" <td>-8.25</td>\n",
" <td>-47.97</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16535</th>\n",
" <td>6552</td>\n",
" <td>易華電</td>\n",
" <td>2020-01-02</td>\n",
" <td>81.90</td>\n",
" <td>2020-03-24</td>\n",
" <td>42.70</td>\n",
" <td>-39.20</td>\n",
" <td>-47.86</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16636</th>\n",
" <td>9914</td>\n",
" <td>美利達</td>\n",
" <td>2020-01-02</td>\n",
" <td>174.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>90.80</td>\n",
" <td>-83.20</td>\n",
" <td>-47.82</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16215</th>\n",
" <td>3004</td>\n",
" <td>豐達科</td>\n",
" <td>2020-01-02</td>\n",
" <td>89.30</td>\n",
" <td>2020-03-24</td>\n",
" <td>46.75</td>\n",
" <td>-42.55</td>\n",
" <td>-47.65</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16136</th>\n",
" <td>2630</td>\n",
" <td>亞航</td>\n",
" <td>2020-01-02</td>\n",
" <td>19.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>9.96</td>\n",
" <td>-9.04</td>\n",
" <td>-47.58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15955</th>\n",
" <td>2305</td>\n",
" <td>全友</td>\n",
" <td>2020-01-02</td>\n",
" <td>6.96</td>\n",
" <td>2020-03-24</td>\n",
" <td>3.65</td>\n",
" <td>-3.31</td>\n",
" <td>-47.56</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16058</th>\n",
" <td>2457</td>\n",
" <td>飛宏</td>\n",
" <td>2020-01-02</td>\n",
" <td>10.25</td>\n",
" <td>2020-03-24</td>\n",
" <td>5.42</td>\n",
" <td>-4.83</td>\n",
" <td>-47.12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15881</th>\n",
" <td>1783</td>\n",
" <td>和康生</td>\n",
" <td>2020-01-02</td>\n",
" <td>25.40</td>\n",
" <td>2020-03-24</td>\n",
" <td>13.45</td>\n",
" <td>-11.95</td>\n",
" <td>-47.05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16270</th>\n",
" <td>3149</td>\n",
" <td>正達</td>\n",
" <td>2020-01-02</td>\n",
" <td>9.33</td>\n",
" <td>2020-03-24</td>\n",
" <td>4.95</td>\n",
" <td>-4.38</td>\n",
" <td>-46.95</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16414</th>\n",
" <td>4989</td>\n",
" <td>榮科</td>\n",
" <td>2020-01-02</td>\n",
" <td>24.40</td>\n",
" <td>2020-03-24</td>\n",
" <td>12.95</td>\n",
" <td>-11.45</td>\n",
" <td>-46.93</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16511</th>\n",
" <td>6288</td>\n",
" <td>聯嘉</td>\n",
" <td>2020-01-02</td>\n",
" <td>26.35</td>\n",
" <td>2020-03-24</td>\n",
" <td>14.05</td>\n",
" <td>-12.30</td>\n",
" <td>-46.68</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16065</th>\n",
" <td>2465</td>\n",
" <td>麗臺</td>\n",
" <td>2020-01-02</td>\n",
" <td>11.15</td>\n",
" <td>2020-03-24</td>\n",
" <td>5.95</td>\n",
" <td>-5.20</td>\n",
" <td>-46.64</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16356</th>\n",
" <td>4148</td>\n",
" <td>全宇生技-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>41.60</td>\n",
" <td>2020-03-24</td>\n",
" <td>22.25</td>\n",
" <td>-19.35</td>\n",
" <td>-46.51</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16498</th>\n",
" <td>6235</td>\n",
" <td>華孚</td>\n",
" <td>2020-01-02</td>\n",
" <td>13.45</td>\n",
" <td>2020-03-24</td>\n",
" <td>7.20</td>\n",
" <td>-6.25</td>\n",
" <td>-46.47</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16446</th>\n",
" <td>5608</td>\n",
" <td>四維航</td>\n",
" <td>2020-01-02</td>\n",
" <td>8.14</td>\n",
" <td>2020-03-24</td>\n",
" <td>4.36</td>\n",
" <td>-3.78</td>\n",
" <td>-46.44</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16506</th>\n",
" <td>6278</td>\n",
" <td>台表科</td>\n",
" <td>2020-01-02</td>\n",
" <td>118.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>63.20</td>\n",
" <td>-54.80</td>\n",
" <td>-46.44</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15975</th>\n",
" <td>2344</td>\n",
" <td>華邦電</td>\n",
" <td>2020-01-02</td>\n",
" <td>19.65</td>\n",
" <td>2020-03-24</td>\n",
" <td>10.60</td>\n",
" <td>-9.05</td>\n",
" <td>-46.06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16287</th>\n",
" <td>3356</td>\n",
" <td>奇偶</td>\n",
" <td>2020-01-02</td>\n",
" <td>29.90</td>\n",
" <td>2020-03-24</td>\n",
" <td>16.15</td>\n",
" <td>-13.75</td>\n",
" <td>-45.99</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16588</th>\n",
" <td>8404</td>\n",
" <td>百和興業-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>44.70</td>\n",
" <td>2020-03-24</td>\n",
" <td>24.15</td>\n",
" <td>-20.55</td>\n",
" <td>-45.97</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16047</th>\n",
" <td>2442</td>\n",
" <td>新美齊</td>\n",
" <td>2020-01-02</td>\n",
" <td>11.15</td>\n",
" <td>2020-03-24</td>\n",
" <td>6.03</td>\n",
" <td>-5.12</td>\n",
" <td>-45.92</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16227</th>\n",
" <td>3019</td>\n",
" <td>亞光</td>\n",
" <td>2020-01-02</td>\n",
" <td>108.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>58.90</td>\n",
" <td>-49.60</td>\n",
" <td>-45.71</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15803</th>\n",
" <td>1515</td>\n",
" <td>力山</td>\n",
" <td>2020-01-02</td>\n",
" <td>72.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>39.15</td>\n",
" <td>-32.85</td>\n",
" <td>-45.62</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16379</th>\n",
" <td>4572</td>\n",
" <td>駐龍</td>\n",
" <td>2020-01-02</td>\n",
" <td>128.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>70.10</td>\n",
" <td>-58.40</td>\n",
" <td>-45.45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16522</th>\n",
" <td>6449</td>\n",
" <td>鈺邦</td>\n",
" <td>2020-01-02</td>\n",
" <td>39.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>21.55</td>\n",
" <td>-17.95</td>\n",
" <td>-45.44</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16408</th>\n",
" <td>4960</td>\n",
" <td>誠美材</td>\n",
" <td>2020-01-02</td>\n",
" <td>7.31</td>\n",
" <td>2020-03-24</td>\n",
" <td>3.99</td>\n",
" <td>-3.32</td>\n",
" <td>-45.42</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16583</th>\n",
" <td>8261</td>\n",
" <td>富鼎</td>\n",
" <td>2020-01-02</td>\n",
" <td>30.10</td>\n",
" <td>2020-03-24</td>\n",
" <td>16.45</td>\n",
" <td>-13.65</td>\n",
" <td>-45.35</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16148</th>\n",
" <td>2712</td>\n",
" <td>遠雄來</td>\n",
" <td>2020-01-02</td>\n",
" <td>54.30</td>\n",
" <td>2020-03-24</td>\n",
" <td>29.70</td>\n",
" <td>-24.60</td>\n",
" <td>-45.30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15794</th>\n",
" <td>1476</td>\n",
" <td>儒鴻</td>\n",
" <td>2020-01-02</td>\n",
" <td>403.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>221.00</td>\n",
" <td>-182.50</td>\n",
" <td>-45.23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16423</th>\n",
" <td>5258</td>\n",
" <td>虹堡</td>\n",
" <td>2020-01-02</td>\n",
" <td>29.95</td>\n",
" <td>2020-03-24</td>\n",
" <td>16.45</td>\n",
" <td>-13.50</td>\n",
" <td>-45.08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16019</th>\n",
" <td>2405</td>\n",
" <td>浩鑫</td>\n",
" <td>2020-01-02</td>\n",
" <td>12.30</td>\n",
" <td>2020-03-24</td>\n",
" <td>6.80</td>\n",
" <td>-5.50</td>\n",
" <td>-44.72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16292</th>\n",
" <td>3413</td>\n",
" <td>京鼎</td>\n",
" <td>2020-01-02</td>\n",
" <td>184.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>102.00</td>\n",
" <td>-82.50</td>\n",
" <td>-44.72</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16406</th>\n",
" <td>4956</td>\n",
" <td>光鋐</td>\n",
" <td>2020-01-02</td>\n",
" <td>14.35</td>\n",
" <td>2020-03-24</td>\n",
" <td>7.94</td>\n",
" <td>-6.41</td>\n",
" <td>-44.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16407</th>\n",
" <td>4958</td>\n",
" <td>臻鼎-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>146.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>81.10</td>\n",
" <td>-65.40</td>\n",
" <td>-44.64</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15735</th>\n",
" <td>1316</td>\n",
" <td>上曜</td>\n",
" <td>2020-01-02</td>\n",
" <td>14.30</td>\n",
" <td>2020-03-24</td>\n",
" <td>7.94</td>\n",
" <td>-6.36</td>\n",
" <td>-44.48</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16626</th>\n",
" <td>9802</td>\n",
" <td>鈺齊-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>131.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>73.10</td>\n",
" <td>-58.40</td>\n",
" <td>-44.41</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16547</th>\n",
" <td>6666</td>\n",
" <td>羅麗芬-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>178.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>99.00</td>\n",
" <td>-79.00</td>\n",
" <td>-44.38</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16317</th>\n",
" <td>3583</td>\n",
" <td>辛耘</td>\n",
" <td>2020-01-02</td>\n",
" <td>66.30</td>\n",
" <td>2020-03-24</td>\n",
" <td>36.90</td>\n",
" <td>-29.40</td>\n",
" <td>-44.34</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15813</th>\n",
" <td>1528</td>\n",
" <td>恩德</td>\n",
" <td>2020-01-02</td>\n",
" <td>9.30</td>\n",
" <td>2020-03-24</td>\n",
" <td>5.20</td>\n",
" <td>-4.10</td>\n",
" <td>-44.09</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16015</th>\n",
" <td>2399</td>\n",
" <td>映泰</td>\n",
" <td>2020-01-02</td>\n",
" <td>12.50</td>\n",
" <td>2020-03-24</td>\n",
" <td>6.99</td>\n",
" <td>-5.51</td>\n",
" <td>-44.08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16383</th>\n",
" <td>4725</td>\n",
" <td>信昌化</td>\n",
" <td>2020-01-02</td>\n",
" <td>12.35</td>\n",
" <td>2020-03-24</td>\n",
" <td>6.91</td>\n",
" <td>-5.44</td>\n",
" <td>-44.05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15828</th>\n",
" <td>1568</td>\n",
" <td>倉佑</td>\n",
" <td>2020-01-02</td>\n",
" <td>19.55</td>\n",
" <td>2020-03-24</td>\n",
" <td>10.95</td>\n",
" <td>-8.60</td>\n",
" <td>-43.99</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16364</th>\n",
" <td>4439</td>\n",
" <td>冠星-KY</td>\n",
" <td>2020-01-02</td>\n",
" <td>183.00</td>\n",
" <td>2020-03-24</td>\n",
" <td>102.50</td>\n",
" <td>-80.50</td>\n",
" <td>-43.99</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 證券代號 證券名稱 股價日期_x 收盤價_x 股價日期_y 收盤價_y 差價 價格波動(%)\n",
"58 00672L 元大S&P原油正2 2020-01-02 17.09 2020-03-24 2.89 -14.20 -83.09\n",
"219 03050X 元展47 2020-01-02 2.12 2020-03-24 0.46 -1.66 -78.30\n",
"15790 1472 三洋紡 2020-01-02 27.30 2020-03-24 9.32 -17.98 -65.86\n",
"16284 3321 同泰 2020-01-02 15.75 2020-03-24 5.64 -10.11 -64.19\n",
"15947 2231 為升 2020-01-02 249.50 2020-03-24 90.00 -159.50 -63.93\n",
"16662 9946 三發地產 2020-01-02 27.30 2020-03-24 10.05 -17.25 -63.19\n",
"16536 6558 興能高 2020-01-02 73.20 2020-03-24 27.40 -45.80 -62.57\n",
"16420 5225 東科-KY 2020-01-02 55.80 2020-03-24 21.10 -34.70 -62.19\n",
"16252 3046 建碁 2020-01-02 16.55 2020-03-24 6.50 -10.05 -60.73\n",
"16509 6283 淳安 2020-01-02 31.20 2020-03-24 12.40 -18.80 -60.26\n",
"15822 1538 正峰新 2020-01-02 4.94 2020-03-24 1.99 -2.95 -59.72\n",
"38 00653L 富邦印度正2 2020-01-02 30.38 2020-03-24 12.24 -18.14 -59.71\n",
"15884 1795 美時 2020-01-02 117.50 2020-03-24 48.10 -69.40 -59.06\n",
"123 00852L 國泰美國道瓊正2 2020-01-02 17.56 2020-03-24 7.30 -10.26 -58.43\n",
"16554 6698 旭暉應材 2020-01-02 91.90 2020-03-24 39.40 -52.50 -57.13\n",
"16385 4739 康普 2020-01-02 77.10 2020-03-24 33.25 -43.85 -56.87\n",
"16143 2702 華園 2020-01-02 23.10 2020-03-24 10.30 -12.80 -55.41\n",
"88 00712 FH富時不動產 2020-01-02 18.17 2020-03-24 8.15 -10.02 -55.15\n",
"16651 9935 慶豐富 2020-01-02 41.45 2020-03-24 18.60 -22.85 -55.13\n",
"16303 3504 揚明光 2020-01-02 83.80 2020-03-24 38.95 -44.85 -53.52\n",
"16523 6451 訊芯-KY 2020-01-02 162.50 2020-03-24 76.70 -85.80 -52.80\n",
"16415 4994 傳奇 2020-01-02 87.20 2020-03-24 41.65 -45.55 -52.24\n",
"16460 6120 達運 2020-01-02 16.50 2020-03-24 7.96 -8.54 -51.76\n",
"16305 3518 柏騰 2020-01-02 39.00 2020-03-24 18.85 -20.15 -51.67\n",
"16286 3346 麗清 2020-01-02 30.50 2020-03-24 14.80 -15.70 -51.48\n",
"33 00647L 元大S&P500正2 2020-01-02 42.39 2020-03-24 20.58 -21.81 -51.45\n",
"16370 4551 智伸科 2020-01-02 174.00 2020-03-24 85.10 -88.90 -51.09\n",
"16404 4943 康控-KY 2020-01-02 174.50 2020-03-24 85.40 -89.10 -51.06\n",
"16009 2388 威盛 2020-01-02 36.35 2020-03-24 17.85 -18.50 -50.89\n",
"16569 8104 錸寶 2020-01-02 57.00 2020-03-24 28.00 -29.00 -50.88\n",
"16528 6491 晶碩 2020-01-02 180.50 2020-03-24 89.10 -91.40 -50.64\n",
"16346 3712 永崴投控 2020-01-02 20.85 2020-03-24 10.30 -10.55 -50.60\n",
"16262 3057 喬鼎 2020-01-02 7.62 2020-03-24 3.78 -3.84 -50.39\n",
"16541 6591 動力-KY 2020-01-02 62.00 2020-03-24 30.85 -31.15 -50.24\n",
"16548 6668 中揚光 2020-01-02 93.00 2020-03-24 46.30 -46.70 -50.22\n",
"16412 4976 佳凌 2020-01-02 28.90 2020-03-24 14.40 -14.50 -50.17\n",
"15950 2239 英利-KY 2020-01-02 95.20 2020-03-24 47.45 -47.75 -50.16\n",
"16555 6706 惠特 2020-01-02 129.50 2020-03-24 64.60 -64.90 -50.12\n",
"16323 3607 谷崧 2020-01-02 16.95 2020-03-24 8.48 -8.47 -49.97\n",
"15745 1340 勝悅-KY 2020-01-02 16.30 2020-03-24 8.19 -8.11 -49.75\n",
"16310 3535 晶彩科 2020-01-02 22.75 2020-03-24 11.45 -11.30 -49.67\n",
"16428 5285 界霖 2020-01-02 71.30 2020-03-24 36.25 -35.05 -49.16\n",
"15778 1456 怡華 2020-01-02 12.20 2020-03-24 6.21 -5.99 -49.10\n",
"16516 6414 樺漢 2020-01-02 257.00 2020-03-24 131.00 -126.00 -49.03\n",
"15875 1736 喬山 2020-01-02 85.00 2020-03-24 43.35 -41.65 -49.00\n",
"16570 8105 凌巨 2020-01-02 14.35 2020-03-24 7.36 -6.99 -48.71\n",
"16500 6243 迅杰 2020-01-02 11.00 2020-03-24 5.65 -5.35 -48.64\n",
"16326 3645 達邁 2020-01-02 52.50 2020-03-24 27.00 -25.50 -48.57\n",
"16592 8429 金麗-KY 2020-01-02 11.90 2020-03-24 6.12 -5.78 -48.57\n",
"15980 2351 順德 2020-01-02 68.00 2020-03-24 35.00 -33.00 -48.53\n",
"15743 1338 廣華-KY 2020-01-02 67.90 2020-03-24 35.00 -32.90 -48.45\n",
"16359 4190 佐登-KY 2020-01-02 127.50 2020-03-24 65.80 -61.70 -48.39\n",
"16362 4426 利勤 2020-01-02 47.95 2020-03-24 24.75 -23.20 -48.38\n",
"15994 2367 燿華 2020-01-02 34.15 2020-03-24 17.70 -16.45 -48.17\n",
"16653 9938 百和 2020-01-02 84.60 2020-03-24 43.90 -40.70 -48.11\n",
"16537 6573 虹揚-KY 2020-01-02 25.50 2020-03-24 13.25 -12.25 -48.04\n",
"16489 6209 今國光 2020-01-02 31.65 2020-03-24 16.45 -15.20 -48.03\n",
"16294 3419 譁裕 2020-01-02 18.20 2020-03-24 9.46 -8.74 -48.02\n",
"16024 2413 環科 2020-01-02 17.20 2020-03-24 8.95 -8.25 -47.97\n",
"16535 6552 易華電 2020-01-02 81.90 2020-03-24 42.70 -39.20 -47.86\n",
"16636 9914 美利達 2020-01-02 174.00 2020-03-24 90.80 -83.20 -47.82\n",
"16215 3004 豐達科 2020-01-02 89.30 2020-03-24 46.75 -42.55 -47.65\n",
"16136 2630 亞航 2020-01-02 19.00 2020-03-24 9.96 -9.04 -47.58\n",
"15955 2305 全友 2020-01-02 6.96 2020-03-24 3.65 -3.31 -47.56\n",
"16058 2457 飛宏 2020-01-02 10.25 2020-03-24 5.42 -4.83 -47.12\n",
"15881 1783 和康生 2020-01-02 25.40 2020-03-24 13.45 -11.95 -47.05\n",
"16270 3149 正達 2020-01-02 9.33 2020-03-24 4.95 -4.38 -46.95\n",
"16414 4989 榮科 2020-01-02 24.40 2020-03-24 12.95 -11.45 -46.93\n",
"16511 6288 聯嘉 2020-01-02 26.35 2020-03-24 14.05 -12.30 -46.68\n",
"16065 2465 麗臺 2020-01-02 11.15 2020-03-24 5.95 -5.20 -46.64\n",
"16356 4148 全宇生技-KY 2020-01-02 41.60 2020-03-24 22.25 -19.35 -46.51\n",
"16498 6235 華孚 2020-01-02 13.45 2020-03-24 7.20 -6.25 -46.47\n",
"16446 5608 四維航 2020-01-02 8.14 2020-03-24 4.36 -3.78 -46.44\n",
"16506 6278 台表科 2020-01-02 118.00 2020-03-24 63.20 -54.80 -46.44\n",
"15975 2344 華邦電 2020-01-02 19.65 2020-03-24 10.60 -9.05 -46.06\n",
"16287 3356 奇偶 2020-01-02 29.90 2020-03-24 16.15 -13.75 -45.99\n",
"16588 8404 百和興業-KY 2020-01-02 44.70 2020-03-24 24.15 -20.55 -45.97\n",
"16047 2442 新美齊 2020-01-02 11.15 2020-03-24 6.03 -5.12 -45.92\n",
"16227 3019 亞光 2020-01-02 108.50 2020-03-24 58.90 -49.60 -45.71\n",
"15803 1515 力山 2020-01-02 72.00 2020-03-24 39.15 -32.85 -45.62\n",
"16379 4572 駐龍 2020-01-02 128.50 2020-03-24 70.10 -58.40 -45.45\n",
"16522 6449 鈺邦 2020-01-02 39.50 2020-03-24 21.55 -17.95 -45.44\n",
"16408 4960 誠美材 2020-01-02 7.31 2020-03-24 3.99 -3.32 -45.42\n",
"16583 8261 富鼎 2020-01-02 30.10 2020-03-24 16.45 -13.65 -45.35\n",
"16148 2712 遠雄來 2020-01-02 54.30 2020-03-24 29.70 -24.60 -45.30\n",
"15794 1476 儒鴻 2020-01-02 403.50 2020-03-24 221.00 -182.50 -45.23\n",
"16423 5258 虹堡 2020-01-02 29.95 2020-03-24 16.45 -13.50 -45.08\n",
"16019 2405 浩鑫 2020-01-02 12.30 2020-03-24 6.80 -5.50 -44.72\n",
"16292 3413 京鼎 2020-01-02 184.50 2020-03-24 102.00 -82.50 -44.72\n",
"16406 4956 光鋐 2020-01-02 14.35 2020-03-24 7.94 -6.41 -44.67\n",
"16407 4958 臻鼎-KY 2020-01-02 146.50 2020-03-24 81.10 -65.40 -44.64\n",
"15735 1316 上曜 2020-01-02 14.30 2020-03-24 7.94 -6.36 -44.48\n",
"16626 9802 鈺齊-KY 2020-01-02 131.50 2020-03-24 73.10 -58.40 -44.41\n",
"16547 6666 羅麗芬-KY 2020-01-02 178.00 2020-03-24 99.00 -79.00 -44.38\n",
"16317 3583 辛耘 2020-01-02 66.30 2020-03-24 36.90 -29.40 -44.34\n",
"15813 1528 恩德 2020-01-02 9.30 2020-03-24 5.20 -4.10 -44.09\n",
"16015 2399 映泰 2020-01-02 12.50 2020-03-24 6.99 -5.51 -44.08\n",
"16383 4725 信昌化 2020-01-02 12.35 2020-03-24 6.91 -5.44 -44.05\n",
"15828 1568 倉佑 2020-01-02 19.55 2020-03-24 10.95 -8.60 -43.99\n",
"16364 4439 冠星-KY 2020-01-02 183.00 2020-03-24 102.50 -80.50 -43.99"
]
},
"execution_count": 34,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"px[~px['證券名稱'].str.contains('|'.join(('購','售')))].sort_values(by='價格波動(%)').head(100)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.4"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment