Beispiel #1
0
 /// <summary>
 /// 从数据库中读取期权信息,并判断是否完整。
 /// </summary>
 /// <param name="startDate">开始时间</param>
 /// <param name="endDate">结束时间</param>
 /// <returns>是否完整</returns>
 private bool GetOptionListFromTable(int startDate, int endDate)
 {
     using (SqlConnection conn = new SqlConnection(connectString))
     {
         conn.Open();//打开数据库
         SqlCommand cmd = conn.CreateCommand();
         cmd.CommandText = "select * from [" + dataBaseName + "].[dbo].[" + optionCodeTableName + "]";
         int theLastCode      = 0;
         int theLastStartDate = 0;
         try
         {
             //从数据库中读取数据流存入reader中
             SqlDataReader reader = cmd.ExecuteReader();
             //从reader中读取下一行数据,如果没有数据,reader.Read()返回flase
             while (reader.Read())
             {
                 optionFormat newOption  = new optionFormat();
                 int          optionCode = reader.GetInt32(reader.GetOrdinal("OptionCode"));
                 theLastCode           = (optionCode > theLastCode) ? optionCode : theLastCode;
                 newOption.optionCode  = optionCode;
                 newOption.optionName  = reader.GetString(reader.GetOrdinal("OptionName")).Trim();
                 newOption.executeType = reader.GetString(reader.GetOrdinal("ExecuteType")).Trim();
                 newOption.strike      = reader.GetDouble(reader.GetOrdinal("Strike"));
                 newOption.optionType  = reader.GetString(reader.GetOrdinal("OptionType")).Trim();
                 newOption.startDate   = reader.GetInt32(reader.GetOrdinal("StartDate"));
                 newOption.endDate     = reader.GetInt32(reader.GetOrdinal("EndDate"));
                 newOption.market      = reader.GetString(reader.GetOrdinal("Market")).Trim();
                 theLastStartDate      = (theLastStartDate > newOption.startDate) ? theLastStartDate : newOption.startDate;
                 if (myOptionList.ContainsKey(optionCode) == false)
                 {
                     myOptionList.Add(optionCode, newOption);
                 }
             }
         }
         catch (Exception myerror)
         {
             System.Console.WriteLine(myerror.Message);
         }
         if (theLastStartDate >= endDate && theLastCode % 10000 == myOptionList.Count)
         {
             return(true);
         }
     }
     return(false);
 }
Beispiel #2
0
        /// <summary>
        /// 按日期遍历,添加期权信息。写入静态哈希表myOptionList。
        /// </summary>
        /// <param name="startDate">开始日期</param>
        /// <param name="endDate">结束日期</param>
        private void GetOptionInformationList(int startDate, int endDate)
        {
            //定义交易日期的类。
            TradeDays myTradeDays = new TradeDays(startDate, endDate);

            //从数据库表中获取信息,如果已经是完整信息就不需要连接万德数据库。
            if (GetOptionListFromTable(startDate, endDate) == true)
            {
                return;
            }
            //按日期遍历,添加期权信息。
            WindAPI w = new WindAPI();

            w.start();
            foreach (int today in myTradeDays.myTradeDays)
            {
                if (TradeDays.IsOptionExerciseDate(today) || today == myTradeDays.myTradeDays[myTradeDays.myTradeDays.Count - 1])
                {
                    WindData optionToday = w.wset("OptionChain", "date=" + today.ToString() + ";us_code=" + Configuration.underlyingAsset + ";option_var=;month=全部;call_put=全部");
                    object[] optionList  = optionToday.data as object[];
                    int      num         = optionList.Length / 13;
                    for (int i = 0; i < num; i++)
                    {
                        optionFormat option     = new optionFormat();
                        string       codeString = (string)optionList[i * 13 + 4 - 1];
                        option.optionCode  = Convert.ToInt32(codeString.Substring(0, 8));
                        option.market      = codeString.Substring(9, 2);
                        option.optionName  = (string)optionList[i * 13 + 5 - 1];
                        option.executeType = (string)optionList[i * 13 + 6 - 1];
                        option.strike      = (double)optionList[i * 13 + 7 - 1];
                        option.optionType  = (string)optionList[i * 13 + 9 - 1];
                        option.startDate   = TradeDays.DateTimeToInt((DateTime)optionList[i * 13 + 10 - 1]);
                        option.endDate     = TradeDays.DateTimeToInt((DateTime)optionList[i * 13 + 11 - 1]);
                        if (myOptionList.ContainsKey(option.optionCode) == false)
                        {
                            myOptionList.Add(option.optionCode, option);
                        }
                    }
                }
            }
            w.stop();
        }