TseDataReader.py

#!/usr/local/bin python
# -*- coding: UTF-8 -*-
from pandas_datareader.base import _DailyBaseReader
import pandas as pd


class TseDataReader(_DailyBaseReader):
    @property
    def url(self):
        return 'http://www.jpx.co.jp/listing/others/margin/tvdivq0000000od2-att/list.xls'

    def read(self):
        """ read data """
        return pd.read_excel(self.url, skiprows=1, sheetname='一覧')