天相                                                                                                                                                                                       金融数据提供商

14.15.       stockUNSTAtDate(股票类型,统计日期)

说明:获取在某“统计日期”“所有上市”“非ST 的股票样本

参数:

n  股票类型:

'A.SH'-上海A;

'B.SH'-上海B;

'A.SZ'-深圳A;

'B.SZ'-深圳B;

'SH'-上海A+B;

'SZ'-深圳A+B

'A'-A;

'B'-B;

'A+B'-AB

'AB'-A+B;

n  统计日期:

用例:

     统计2010-12-31日所有上市的A股非ST股票:

  select * from dbo.stockUNSTAtDate('A',20101231);

   查询截止到20101231所有上市的深圳A股非ST股票:

select * from dbo.stockUNSTAtDate('A.SZ',20101231);

                                                                                                                                                                                                            页数