Spdex 0.0.3
download lottery data
License: BSD
Keywords: spdex


Spdex
===============

* You will never make
* Money beyond your cognition
* Unless you rely on luck
* But the money made by luck
* In the end, they often lose by strength
* This is a necessity
* 
* Every penny you make
* Is the realization of your perception of the world
* Every penny you lose
* Because of a flawed perception of the world
* 
* The biggest fairness in this world is: when a person's wealth is greater than what they know, there are 100 ways in this society to harvest you
* 
* Until your cognition and wealth match

Target Users
--------------

* anyone

Installation
--------------

    pip install spdex
    
Upgrade
---------------

    pip install spdex --upgrade
    
Quick Start
--------------

::

    from spdex import SpdexIOS

    spi=SpdexIOS()
    
    #在线更新数据库
    spi.update()                

	#显示联赛列表
    df =spi.leagues()           
    print(df)
    
    # 查询联赛信息
    df=spi.events('英冠')         # 或df=spi.events(485)
    print(df)

	#查询赛事详情（信息提示）
    df=spi.markets(29704943, 'csData')  
    df=df.sort_values(by='RefreshTime', kind='quicksort', axis=0).reset_index(drop=True)
    print(df)
    
    #导出联赛数据
    df=spi.export()                 
    print(df)
    spi.pb2csv(df,'test.csv')

return::

    ->
    100%|██████████| 27/27 [00:05<00:00,  4.92it/s]

      SortName   Id  Classification  SportTypeId   FullName                                   Eng                 Chs
    0       美冠   77               0            1     美国冠军联赛     \Soccer\CONCACAF Champions League          \足球\美国冠军联赛
    1      冠军杯   80               1            1  UEFA欧洲冠军杯         \Soccer/UEFA Champions League  \足球\欧洲赛事/UEFA欧洲冠军杯
    2      欧霸杯  145               1            1  欧洲联赛(欧霸杯)            \Soccer/UEFA Europa League       \足球\欧洲联赛(欧霸杯)
    3       英冠  485               1            1         英冠           \足球\GB\English Championship           \足球\GB\英冠
    4     解放者杯  791               1            1     南美解放者杯  \足球\Other\CONMEBOL Copa Libertadores    \足球\Other\南美解放者杯
    5      南俱杯  817               1            1     南美俱乐部杯  \足球\Other\CONMEBOL Copa Sudamericana       \足球\Other\南俱杯

       KellyDraw  BfPayoutHome  AwayTeamId            MatchTime  EventTypeId  UnusualHot   EventId AsianAvrLet HomeTeam  Classifnication  BfOddsHome      0    10.4200      -27.0323       48317  2020-02-27T03:45:00            1           0  29704956          +1    米德尔斯堡                1        6.20   
    1     4.4030      -28.8848       48349  2020-02-27T03:45:00            1           1  29704953       -0.75  谢菲尔德星期三                1        1.82   
    2     5.2404       32.3128       62683  2020-02-27T03:45:00            1           0  29704960        -0.5      富勒姆                1        1.94   
    3     3.1854      -25.3662       48759  2020-02-27T03:45:00            1           1  29704940       -0.25     米尔沃尔                1        2.40   
    4     4.8931       48.8506       69720  2020-02-27T03:45:00            1           0  29704943       -0.25     布莱克本                1        2.50   
    
       IsTutorial  BfOddsDraw  BfAmountAway  MediaIndexHome  MaxLastOdds  MaxTeamId  MediaIndexAway  UnusualIndex  HomeTeamId  BfPayoutAway      0       False        4.30     525927.52             0.0         1.66      48317             0.0             0       74303       12.0341   
    1       False        3.70      33310.23             0.0         3.70      58805             0.0             0       47992       -7.2253   
    2       False        3.90      27558.63             0.0         1.92      56764             0.0             0       56764      -31.9583   
    3       False        3.20      21975.64             0.0         3.15      58805             0.0             0       56036      -45.4908   
    4       False        3.25      18676.32             0.0         2.46      48350             0.0             0       48350      -48.2014   
    
       BfIndexDraw SortName  BfIndexAway  KellyHome  IsStopUpdate  MediaIndexDraw  UnusualPayout  BfOddsAway  BfPayoutDraw  MaxTradedChange      0      32.3894       英冠      40.9439    18.6986         False             0.0              0        1.66      -11.3733         95634.18   
    1      50.3352       英冠      28.1142     3.3642         False             0.0              1        5.60       66.1023         17182.12   
    2      23.7891       英冠      25.8817     2.5340         False             0.0              0        4.50      -37.4596         12551.16   
    3      57.1350       英冠      18.0926     3.4189         False             0.0              1        3.70       72.1353         20357.73   
    4      28.6854       英冠      18.4102     5.9881         False             0.0              0        3.50      -19.2915          3953.07   
    
       BfAmountHome  IsUpgraded AwayTeam  KellyAway  LeagueId  BfIndexHome  BfAmountDraw        MaxUpdateTime  
    0      90599.50       False      利兹联     1.8715       485      26.6667     160276.44  2020-02-26T20:37:41  
    1      83623.27       False      查尔顿    21.0095       485      21.5506      92900.58  2020-02-26T18:17:35  
    2     128044.37       False      斯旺西    12.2998       485      50.3292      29768.99  2020-02-26T13:32:09  
    3      48308.07       False      伯明翰    11.4365       485      24.7724      81996.09  2020-02-26T18:17:41  
    4      74731.34       False     斯托克城    12.9505       485      52.9044      30419.25  2020-02-26T15:30:26  

        Kelly  HotTrend          RefreshTime      Payout  LayOdds3   EventId   MarketId  LayTraded2  TradedChange  Handicap  LayTraded1  BackOdds2      0     0.0       0.0  2020-02-26T20:36:12  170.388375       0.0  29704943  168899119        0.00          0.00       0.0        0.00      950.0   
    1     0.0       0.0  2020-02-26T20:36:12  -48.001593      80.0  29704943  168899119      346.59          0.00       0.0      195.03       60.0   
    2     0.0       0.0  2020-02-26T20:36:12  -21.392661       8.4  29704943  168899119      792.28          0.00       0.0     2023.84        7.6   
    3     0.0       0.0  2020-02-26T20:36:12  -86.620064      38.0  29704943  168899119      746.64          0.00       0.0      320.14       30.0   
    4     0.0       0.0  2020-02-26T20:36:12   67.798829      40.0  29704943  168899119      370.83          0.00       0.0      745.96       28.0   
    5     0.0       0.0  2020-02-26T20:36:12  -53.774936       7.6  29704943  168899119     1913.47          0.00       0.0     2019.38        6.6   
    6     0.0       0.0  2020-02-26T20:36:12  -58.675164      23.0  29704943  168899119      310.83          0.00       0.0     1302.81       19.0   
    7     0.0       0.0  2020-02-26T20:36:12  -43.161761      55.0  29704943  168899119       70.32          0.00       0.0      278.90       42.0   
    8     0.0       0.0  2020-02-26T20:36:12  -83.649010      65.0  29704943  168899119      247.54          0.00       0.0      556.85       48.0   
    9     0.0       0.0  2020-02-26T20:36:12  210.840417      90.0  29704943  168899119      165.18          0.00       0.0     1427.82       55.0   
    10    0.0       0.0  2020-02-26T20:36:12  -25.829037      16.0  29704943  168899119      990.66          0.00       0.0      348.31       14.0   
    11    0.0       0.0  2020-02-26T20:36:12  -19.141986      23.0  29704943  168899119      172.74          0.00       0.0      158.95       19.5   
    12    0.0       0.0  2020-02-26T20:36:12  -56.742141      34.0  29704943  168899119      940.39          0.00       0.0      100.79       28.0   
    13    0.0       0.0  2020-02-26T20:36:12  -57.555922      14.5  29704943  168899119      507.44          0.00       0.0      950.22       12.5   
    14    0.0       0.0  2020-02-26T20:36:12   23.064630      13.0  29704943  168899119     1029.31          0.00       0.0     1369.44       11.0   
    15    0.0       0.0  2020-02-26T20:36:12   85.935536       9.8  29704943  168899119     2952.64          0.00       0.0     4317.08        8.8   
    16    0.0       0.0  2020-02-26T20:36:12  127.296773      11.5  29704943  168899119     1228.86          0.00       0.0     5252.81        9.6   
    17    0.0       0.0  2020-02-26T20:36:12  182.437225     170.0  29704943  168899119      234.04         53.43       0.0       71.42      120.0   
    
        OrderIndex  SuperWeight  LastOdds  LayTraded3  Europe ExchangeAttr  ExchangeTrade   Amount  BackTraded1        Per  LayOdds1     Weight      0           19          0.0    1000.0        0.00     0.0         None       0.000000    40.31         2.02   0.270321       0.0  12.795103   
    1           12          0.0      60.0       90.94     0.0         None       0.515043   123.95       236.96   0.831216      70.0   2.460630   
    2            5          0.0       7.8     1855.76     0.0         None       1.080932  1469.23       209.05   9.852748       8.0   3.719796   
    3           13          0.0      32.0      102.91     0.0         None       0.479589    61.04       212.20   0.409338      34.0   0.633155   
    4           14          0.0      29.0       36.39     0.0         None      -0.121244   832.03       728.84   5.579645      32.0   7.940444   
    5            6          0.0       6.8     1047.97     0.0         None       0.181466   976.31      2207.64   6.547196       7.2   2.187425   
    6            3          0.0      21.0      278.89     0.0         None       0.128830   309.63       512.11   2.076398      21.0   1.955544   
    7            8          0.0      42.0      342.73     0.0         None       0.241210   197.20       487.44   1.322436      48.0   2.689656   
    8           15          0.0      50.0       73.83     0.0         None       0.353053    47.99       231.37   0.321824      55.0   0.773751   
    9            4          0.0      60.0       20.16     0.0         None       2.568363   731.63       159.12   4.906357      70.0  14.709339   
    10           7          0.0      14.5     1006.93     0.0         None       0.464461   763.91      1311.58   5.122828      15.0   3.509861   
    11          11          0.0      22.0      909.28     0.0         None       0.591294   597.45       967.53   4.006537      21.0   3.826301   
    12          17          0.0      32.0      378.26     0.0         None       4.949350   201.58       237.10   1.351808      30.0   2.047013   
    13           9          0.0      13.0     2215.94     0.0         None       0.038973   474.76       534.00   3.183770      13.5   2.008507   
    14          10          0.0      11.5      887.94     0.0         None       0.089495  1547.75      1826.39  10.379308      12.0   5.823565   
    15           1          0.0       9.4      448.63     0.0         None       1.083534  2950.80       795.37  19.788249       9.4   8.798691   
    16           2          0.0      10.5      379.06     0.0         None       1.439388  3271.49       666.76  21.938817      10.5  10.755954   
    17          16          0.0     140.0       93.53     0.0         None       1.511249   314.82        33.86   2.111203     140.0  13.365266   
    
        LayOdds2 TradedAttr  BackTraded3  BackOdds3  SelectionId  BackTraded2       PcId  ZuCaiWeight  BackOdds1  
    0        0.0       None        46.16      900.0      9063256         0.26  891962554          0.0     1000.0  
    1       75.0       None       114.01       55.0           14       255.39  891962548          0.0       65.0  
    2        8.2       None      1967.53        7.4            2       847.18  891962541          0.0        7.8  
    3       36.0       None       214.04       29.0           10       375.99  891962549          0.0       32.0  
    4       34.0       None       271.68       27.0           11       197.76  891962550          0.0       29.0  
    5        7.4       None       371.02        6.4            3      1269.32  891962542          0.0        6.8  
    6       22.0       None       854.47       18.5            9       396.03  891962539          0.0       19.5  
    7       50.0       None        57.85       40.0           15        25.20  891962544          0.0       44.0  
    8       60.0       None       320.79       46.0           12       131.85  891962551          0.0       50.0  
    9       75.0       None       189.85       50.0           16        83.18  891962540          0.0       60.0  
    10      15.5       None       637.33       13.5            8       448.53  891962543          0.0       14.5  
    11      22.0       None       233.26       19.0            7       341.23  891962547          0.0       20.0  
    12      32.0       None        32.46       27.0      9063254        82.62  891962553          0.0       29.0  
    13      14.0       None       549.32       12.0            5      1811.09  891962545          0.0       13.0  
    14      12.5       None       335.55       10.5            6       748.50  891962546          0.0       11.5  
    15       9.6       None      1041.28        8.6            1      1950.78  891962537          0.0        9.0  
    16      11.0       None       546.01        9.4            4       747.79  891962538          0.0        9.8  
    17     150.0         买+       186.50      110.0           13        56.17  891962552          0.0      130.0  

                       更新时间  胜_价位     平_价位      负_价位              2.5小_价位              2.5大_价位        胜_成交量        平_成交量        负_成交量 2.5小_成交量      0              29721044    美冠      纽约城      珊卡洛斯  2020-02-27T07:00:00  2020-02-26T15:30:31                                                   
    1   2020-02-27 00:22:00  1.41      5.5       7.6                 1.52                    0      1805.64        33.27       128.88  1820.02   
    2   2020-02-26 23:36:58  1.43      5.2       7.6                 1.56                    0      1785.39          3.8       128.88  1804.71   
    3   2020-02-26 20:40:29  1.47      5.2       7.6                 1.64                    0      1706.15         3.81       129.08  1608.64   
    4              29720101    美冠    墨西哥美洲        通讯  2020-02-27T11:00:00  2020-02-26T16:54:27                                                   
    5   2020-02-26 23:36:58  1.21        0        19                    0                    0      1263.66            0        40.28        0   
    6   2020-02-26 20:40:30  1.21        0        19                    0                    0       1264.1            0        40.31        0   
    7              29720056    美冠   蒙特利尔冲击      萨普里萨  2020-02-27T09:00:00  2020-02-26T15:36:34                                                   
    8   2020-02-26 23:36:58  2.16        0         0                 1.78                    0       466.84            0            0    923.1   
    9   2020-02-26 20:40:30  2.02        0         0                    0                    0       326.88            0            0        0   
    10             29625143   冠军杯    皇家马德里     曼彻斯特城  2020-02-27T04:00:00  2020-02-26T19:35:08                                                   
    11  2020-02-27 00:33:43  3.25     3.65      2.42                 1.87                 2.14  3.70189e+06  2.54511e+06  6.57394e+06   309716   
    12  2020-02-27 00:31:37  3.25     3.65      2.42                 1.87                 2.14  3.69979e+06  2.54381e+06  6.55673e+06   309716   
    13  2020-02-27 00:22:01   3.2     3.65      2.42                 1.88                 2.12  3.69353e+06  2.53348e+06  6.38773e+06   295899   
    14  2020-02-26 23:36:58   3.2     3.65      2.46                 1.88                 2.14  3.38486e+06  2.50841e+06   5.8234e+06   263764   
    15  2020-02-26 20:59:45  3.15      3.6      2.48                  1.9                  2.1  2.94972e+06  1.94683e+06  4.88537e+06   138511   
    16  2020-02-26 20:53:38   3.1     3.55      2.52                 1.89                 2.12  2.77225e+06  1.76157e+06  4.75572e+06   137679   
    17  2020-02-26 20:40:30  3.15      3.6       2.5                 1.89                 2.12  2.76052e+06    1.399e+06  4.69747e+06   108098   
    18             29625147   冠军杯       里昂      尤文图斯  2020-02-27T04:00:00  2020-02-26T19:48:53                                                   
    19  2020-02-27 00:31:37   4.3      3.4      2.14                 2.58                 1.63  1.15904e+06  1.54773e+06  6.45884e+06  93793.3   
    20  2020-02-27 00:22:01   4.2      3.4      2.12                 2.58                 1.63   1.1507e+06  1.54709e+06  6.33296e+06    93534   
    21  2020-02-26 23:36:59   4.3     3.35      2.14                  2.6                 1.64   1.0741e+06  1.48101e+06  5.94428e+06  86618.9   
    22  2020-02-26 20:59:46   4.3     3.25      2.18                  2.6                 1.62       851049  1.16354e+06  4.88791e+06  45753.9   
    23  2020-02-26 20:53:39   4.3      3.3      2.16                  2.6                 1.62       845464   1.1635e+06  4.88593e+06  33663.4   
    24  2020-02-26 20:40:30   4.3      3.3      2.16                  2.6                 1.63       839084  1.12424e+06  4.83352e+06  33428.2   
    25             29713520   欧霸杯      布拉加   格拉斯哥流浪者  2020-02-27T01:00:00  2020-02-26T23:53:53                                                   
    26  2020-02-27 00:33:44     2      3.9       4.1                 1.79                 2.28  2.80711e+06       383972       530851   404054   
    27  2020-02-27 00:32:20     2      3.9       4.1                 1.78                 2.28   2.8006e+06       383530       530814   402976   
    28  2020-02-27 00:31:38     2      3.9       4.1                 1.78                 2.28  2.79935e+06       383530       525173   402976   
    29  2020-02-27 00:22:01     2      3.8       4.2                  1.8                 2.24  2.53881e+06       338104       429421   376810   
    ..                  ...   ...      ...       ...                  ...                  ...          ...          ...          ...      ...   
    64  2020-02-26 20:40:32   2.4      3.2       3.7                 2.48                 1.65      48308.1      81996.1      21975.6  5508.69   
    65             29704943    英冠     布莱克本      斯托克城  2020-02-27T03:45:00  2020-02-26T15:30:26                                                   
    66  2020-02-26 20:59:49  2.48     3.25      3.45                 2.52                 1.65      82635.1      30721.6      18898.1  5244.13   
    67  2020-02-26 20:53:41   2.5     3.25      3.45                 2.56                 1.65        82183      30721.6      18898.1  3750.03   
    68  2020-02-26 20:40:33   2.5     3.25       3.5                  2.5                 1.65      74731.3      30419.2      18676.3  3138.44   
    69             29719980  解放者杯     巴西国际     托利马体育  2020-02-27T08:30:00  2020-02-26T21:19:09                                                   
    70  2020-02-27 00:33:47   1.5      4.4       9.8                 2.56                 1.54      42150.5      4336.63         8353   161.68   
    71  2020-02-27 00:31:41   1.5      4.4       9.8                 2.56                 1.54      32879.5      4336.63         8353   161.68   
    72  2020-02-27 00:22:07  1.47      4.4        11                 2.56                 1.55      29921.7      4336.63      7366.91   161.68   
    73  2020-02-26 23:37:05  1.49      4.3       9.6                 2.56                 1.55      25735.4      3919.73      5504.89   161.68   
    74  2020-02-26 20:53:42  1.47      4.4       9.6                 2.56                 1.64      8974.59      3255.54      1755.28   161.33   
    75  2020-02-26 20:40:33  1.49      4.4       9.6                 2.56                 1.64      8072.61      3255.54      1755.28   161.33   
    76             29719977  解放者杯    波特诺山丘  瓜亚基尔巴塞罗那  2020-02-27T06:15:00  2020-02-26T08:40:44                                                   
    77  2020-02-27 00:31:41  1.99      3.4       5.3                  3.3                 1.51      1609.51       596.55       698.22    149.5   
    78  2020-02-27 00:22:08  2.04      3.4       4.6                  3.3                 1.51      1574.73       596.55       689.66    149.5   
    79  2020-02-26 23:37:06  2.08     3.05       4.6                  3.3                 1.51      1415.79        549.8       689.66    149.5   
    80  2020-02-26 20:40:34  2.04      3.1       4.6                 2.88                    0       1068.3       529.24       582.59   148.45   
    81             29721509   南俱杯  蒙得维的亚国民       巴伊亚  2020-02-27T06:15:00  2020-02-26T19:03:32                                                   
    82  2020-02-27 00:22:08  2.72     3.35         3                 2.34                 1.71       965.15      1816.49       272.19   111.25   
    83  2020-02-26 23:37:06  2.72      3.2         3                 2.34                 1.71       931.31      1584.19       272.19   111.25   
    84  2020-02-26 20:40:34  2.72      3.3       3.1                 2.34                    0       741.85      1522.98       254.26   111.13   
    85             29721516   南俱杯    蒙得维的亚      拉尼罗斯  2020-02-27T06:15:00  2020-02-26T21:40:33                                                   
    86  2020-02-27 00:22:08  1.18       15        36                 1.49                  2.6      1113.18       158.66       344.97   822.02   
    87  2020-02-26 23:37:06  1.18       15        36                 1.51                  2.6      1113.18       158.66       344.97   794.32   
    88  2020-02-26 20:40:34  1.12     11.5        34                 1.51                  2.6          681         2.01        297.5   794.61   
    89             29704961    英冠       雷丁      维冈竞技  2020-02-27T04:00:00  2020-02-26T23:57:23                                                   
    90  2020-02-27 00:33:46  2.34     3.45      3.55                 2.16                 1.86       159825      42722.5      72712.4  10789.7   
    91  2020-02-27 00:31:40  2.34     3.45      3.55                 2.16                 1.86       156653      42722.5      72712.4  10789.7   
    92  2020-02-27 00:22:07  2.34      3.4       3.6                 2.16                 1.86       140574      41865.2      68829.3  10789.7   
    93  2020-02-26 23:37:05  2.34      3.4       3.6                 2.14                 1.86      96936.1      34243.8      62994.7  10466.4