Exemplo n.º 1
0
        /**
           * 获取股票分时数据
           * 
           * http://market.finance.sina.com.cn/downxls.php?date=2011-07-08&symbol=sh600900
                获取代码为sh600900,在2011-07-08的成交明细,数据为xls格式。
                http://vip.stock.finance.sina.com.cn/quotes_service/view/cn_price.php?symbol=sh600900
                获得sh600900当日的分价表
                http://market.finance.sina.com.cn/pricehis.php?symbol=sh600900&startdate=2011-08-17&enddate=2011-08-19
                获得sh600900从2011-08-17到2011-08-19的分价表。
         * */
        public static DataTable getGuoPiaoTimeHisFromSina(string code,DateTime date)
        {

            if (String.IsNullOrEmpty(code))
            {
                return null;
            }

            //雅虎历史数据
            string url = "http://market.finance.sina.com.cn/downxls.php?date=" + date.Date.ToShortDateString() + "&symbol="+code;
            Console.WriteLine(url);
            HttpClient client = null;
            DataTable datatable = null;
            client = new HttpClient(url);
            Stream stream = null;
            try
            {
                stream = client.GetStream();
                datatable = CSVFileHelper.OpenCSVFromSteam(code, stream);
            }
            catch (Exception e)
            {
                client.Reset();
                Console.WriteLine("no data to get today");
            }

            return datatable;
        }
Exemplo n.º 2
0
        /**
         * 获取股票,大盘历史数据
         * 
         * 直接在浏览器地址中数据网址即可
            http://table.finance.yahoo.com/table.csv?s=股票代码
            上证股票是股票代码后面加上.ss,深证股票是股票代码后面加上.sz
            深市数据链接:http://table.finance.yahoo.com/table.csv?s=000001.sz
            上市数据链接:http://table.finance.yahoo.com/table.csv?s=600000.ss
            另外,上证综指代码:000001.ss,深证成指代码:399001.SZ,沪深300代码:000300.ss
            例如查询中国石油的历史数据,直接在浏览器中输入:http://table.finance.yahoo.com/table.csv?s=601857.ss
         * */
        public static DataTable getGuoPiaoHisDataFromYaoh(DateTime bdate, DateTime edate, string code)
        {

            if (String.IsNullOrEmpty(code))
            {
                return null;
            }
            else
            {
                code = getYaohUrlCode(code);
            }

            //雅虎历史数据
            string url = "http://table.finance.yahoo.com/table.csv?" + "a=" + (bdate.Month - 1).ToString()
                + "&b=" + bdate.Day.ToString() + "&c=" + bdate.Year.ToString()
                + "&d=" + (edate.Month - 1).ToString() + "&e=" + edate.Day.ToString()
                + "&f=" + edate.Year.ToString() + "&s=" + code;
            Console.WriteLine(url);
            HttpClient client = null;
            DataTable datatable = null;
                   
            try
            {
                client = new HttpClient(url);
                datatable = CSVFileHelper.OpenCSVFromSteam(code, client.GetStream());
            }
            catch (Exception e)
            {
                client.Reset();
                throw e;
            }
            
            return datatable;
        }