```python # 生成一个list，list中为上证指数成分股中流通市值最大的5个股票的股票代码。 # 获取 上证指数成分股的股票代码 stocks = get_index_stocks('000001.XSHG') q = query( # 获取 市值表.股票代码，市值表.流通市值 valuation.code, valuation.circulating_market_cap ).filter( # 筛选 上证指数成分股 valuation.code.in_(stocks) ).order_by( # 排序 按市值从大到小排 valuation.circulating_market_cap.desc() # 数量 上限5条数据 ).limit(5) w = get_fundamentals(q) print(w) # code circulating_market_cap #0 601398.XSHG 15367.8965 #1 601857.XSHG 11593.6211 #2 600519.XSHG 11035.6973 #3 601288.XSHG 10850.6406 #4 601318.XSHG 8286.9883 list(w['code']) #['601398.XSHG', '601857.XSHG', '600519.XSHG', '601288.XSHG', '601318.XSHG'] ```

``` # 获取任一股票最近5个交易日最高价的平均价 # 方法1 h = history(count=5, security_list=['000001.XSHE'], field='high') print(mean(h.values)) # 方法2 w = attribute_history(security='000001.XSHE', count=5, fields=['high']) print(mean(w.values)) # 生成list，存储上证指数成分股中流通市值最大的5个股票的股票代码 stocks = get_index_stocks('000001.XSHG') #print(stocks) q = query(valuation.code ).filter(valuation.code.in_(stocks) ).order_by(valuation.circulating_market_cap.desc() ).limit(5) qw = get_fundamentals(q) #print(qw.loc[:, ['code']].values) print(list(qw['code'])) ```

@godxu2333 可以的，参考：https://www.joinquant.com/view/community/detail/b048a3e848d190ad810c3930fb07a4dc

@SunnyWind filter里面用来筛选上证成分股的in，我按照这种方法一直报错，需要把in变成in_才可以，请问您知道为什么吗？

@dmmzzy API就是in_,但是我代码也是in_,但不知道上面为什么显示的是in

@joyjo1735 请问你的代码是怎么粘的，怎么样代码才会是有格式的

@joyjo1735 赞

获取前一天的最低价，最高价等等怎么写，获取每周的MACD怎么写，就是这些数据加上时间条件限制应该怎么表述

看看

w=attribute_history(security='600373.XSHG',count=5, fields=['money','high']) a=(w.iloc[:,1].values) print(sum(a)/5)

q=query(valuation.code,valuation.circulating_market_cap ).filter(valuation.code.in_(get_index_stocks('000001.XSHG')) ).order_by(valuation.circulating_market_cap.desc() ).limit(5) w=get_fundamentals(q) print(list(w.iloc[:,0]))

def initialize(context): w=history(count=5, field='high', security_list=['000001.XSHE']) print(w) a = w.iloc[:].values.sum() print(a/5)

g.security=('000001.XSHE') w=attribute_history(g.security,count=5,\ fields=['high','low']) print(max(w.loc[:,('high')].values.T))

作业4 ``` t=attribute_history(security='000001.XSHE',count=5, fields=['high']) print(t) print(mean(t.values)) ```

ok

def stk_5day_havg(stk): stk_high=[] w=attribute_history(security=stk,count=5,fields=['high']) stk_high = w.values print (stk_high.mean(axis=0))

def top5_mkt_cpt_stk(): q=query(valuation.code).order_by(valuation.circulating_market_cap.desc()).limit(5) w=get_fundamentals(q).values print(w)

为啥啥也看不到

@PayZhang 清理一下浏览器缓存 ,或者换个浏览器试试