def test_wind_wset_index_history():
sec = fdm.Wind().index_history()
time = datetime.now()
print(
sec.query('000300.SH',
startdate=datetime(2018, 1, 1),
enddate=datetime(2019, 4, 1)))
print(datetime.now() - time)
def test_wind_edb():
codes = 'M5567876'
edb = fdm.Wind().edb()
time = datetime.now()
print(
edb.query(codes,
startdate=datetime(2018, 1, 1),
enddate=datetime(2019, 4, 1)))
print(datetime.now() - time)
def test_wind_wsd():
codes = '000002.SZ,000004.SZ'.split(',')
',000005.SZ,000006.SZ,000007.SZ,000008.SZ,000009.SZ,000010.SZ,000011.SZ'
wsd = fdm.Wind().wsd()
time = datetime.now()
print(
wsd.query(
codes,
fields='acctandnotes_rcv||unit=1;rptType=1;Period=Q;Days=Alldays',
startdate=datetime(2010, 1, 1),
enddate=datetime(2019, 4, 1))) # , force_update=True
print(datetime.now() - time)
def update_all():
fdm.Wind().edb().update()
fdm.Tushare().daily_adj().update()
fdm.Tushare().daily_basic().update()
fdm.Tushare().daily_price().update()
from datetime import datetime, timedelta
import pandas as pd
from pandas import DataFrame
import fdm
wsd = fdm.Wind().wsd()
sec = fdm.Wind().sector_constituent()
date = datetime(2019, 11, 20)
# All china shares
alla = sec.query('a001010900000000', date)
delist = sec.query('a001010m00000000', date)
alla = alla.append(delist)
alla = alla.reset_index().drop(columns='index')
STARTDATE = datetime(2000, 1, 1)
ENDDATE = datetime(2019, 10, 31)
codes = list(alla['wind_code'])
starttime = datetime.now()
close = wsd.query(codes, 'close||PriceAdj=B', STARTDATE, ENDDATE)
#close = wsd.query(['000001.sz','000002.sz'],'close',STARTDATE,ENDDATE, skip_update = True)
endtime = datetime.now()
print(endtime - starttime)
print(close.shape)
def test_wind_wset_index_cons():
sec = fdm.Wind().index_constituent()
date = datetime(2005, 12, 20)
time = datetime.now()
print(sec.query('000300.SH', date))
print(datetime.now() - time)
def test_wind_wset_cons():
sec = fdm.Wind().sector_constituent()
date = datetime(2018, 11, 8)
time = datetime.now()
print(sec.query('a001010100000000', date))
print(datetime.now() - time)