天相                                                                                                                                                                                       金融数据提供商

14.14.       stockAtDate(股票类型,统计日期)

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

参数:

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  统计日期:

相关表:T_STOCK   股票基本信息表

用例:

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

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

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

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

                                                                                                                                                                                                            页数