public object[,] FundamentalBalanceSheetRange(string securityID, DateUtilities.CALDate startDate, DateUtilities.CALDate endDate, string fieldsStr, string reportType) { Dictionary <string, string> tmp = server_config[server]; string requestString = tmp["host"]; requestString = (tmp["port"] != "" ? requestString + ":" + tmp["port"] : requestString); requestString = requestString + api_config["FundamentalBalanceSheetRange"][server]; requestString = requestString + "stockID=" + securityID; requestString = requestString + "&startDate=" + startDate.plainRepr(); requestString = requestString + "&endDate=" + endDate.plainRepr(); requestString = requestString + "&reportType=" + reportType; requestString = requestString + "&field="; string[] fields = fieldsStr.Split(','); if (fields.Length != 0) { foreach (object field in fields) { string tmpStr = field.ToString(); requestString = requestString + tmpStr + ","; } requestString = requestString.Remove(requestString.Length - 1); } WebRequest wReq = System.Net.WebRequest.Create(requestString); WebResponse wResp = wReq.GetResponse(); Stream respStream = wResp.GetResponseStream(); //return requestString; return(CSVHelper.parseCSVString(respStream)); }
public static object CALIsBizDay(string calName, int serialNumber) { try { DateUtilities.CALCalendar cal = new DateUtilities.CALCalendar(calName); DateUtilities.CALDate calDate = new DateUtilities.CALDate(serialNumber); return(cal.IsBizDay(calDate)); } catch (Exception e) { return(Utilities.ExcelRangeErrorString(e)); } }
public static object CALDateAdvance(string calName, int serialNumber, string periodrepr, object covrepr, object endOfMonth) { try { //if (ExcelDnaUtil.IsInFunctionWizard()) // return "!!! In FunctionWizard"; DateUtilities.CALCalendar cal = new DateUtilities.CALCalendar(calName); DateUtilities.CALDate calDate = new DateUtilities.CALDate(serialNumber); string cStr = Utilities.Check(covrepr, "Following"); bool eom = Utilities.Check(endOfMonth, false); return(cal.DateAdvance(calDate, periodrepr, cStr, eom).SerialNumber()); } catch (Exception e) { return(Utilities.ExcelRangeErrorString(e)); } }
public static object CALSecurityCategory(string standard, int level, string fieldsStr, int date) { try { if (ExcelDnaUtil.IsInFunctionWizard()) { return("!!! In FunctionWizard"); } DataAPI tmp = new DataAPI(); DateUtilities.CALDate snapDate = new DateUtilities.CALDate(date); return(Utilities.ArrayResizer.Resize(tmp.SecurityCategory(standard, level, fieldsStr, snapDate))); } catch (Exception e) { return(Utilities.ExcelRangeErrorString(e)); } }
public static object CALMarketDataGetHistDailyQuotes(string securityID, string fieldsStr, int start, int end) { try { if (ExcelDnaUtil.IsInFunctionWizard()) { return("!!! In FunctionWizard"); } DataAPI tmp = new DataAPI(); DateUtilities.CALDate startDate = new DateUtilities.CALDate(start); DateUtilities.CALDate endDate = new DateUtilities.CALDate(end); return(Utilities.ArrayResizer.Resize(tmp.MarketDataGetHistDailyQuotes(securityID, fieldsStr, startDate, endDate))); } catch (Exception e) { return(Utilities.ExcelRangeErrorString(e)); } }
public static object CALFundamentalBalanceSheetRange(string securityID, int start, int end, string fieldsStr, string reportType) { try { if (ExcelDnaUtil.IsInFunctionWizard()) { return("!!! In FunctionWizard"); } DataAPI tmp = new DataAPI(); DateUtilities.CALDate startDate = new DateUtilities.CALDate(start); DateUtilities.CALDate endDate = new DateUtilities.CALDate(end); //return tmp.FundamentalBalanceSheetRange(securityID, startDate, endDate, fieldsStr, reportType); return(Utilities.ArrayResizer.Resize(tmp.FundamentalBalanceSheetRange(securityID, startDate, endDate, fieldsStr, reportType))); } catch (Exception e) { return(Utilities.ExcelRangeErrorString(e)); } }
public static object CALBizDatesList(string calName, int start, int end) { try { //if (ExcelDnaUtil.IsInFunctionWizard()) // return "!!! In FunctionWizard"; DateUtilities.CALCalendar cal = new DateUtilities.CALCalendar(calName); DateUtilities.CALDate beginDate = new DateUtilities.CALDate(start); DateUtilities.CALDate endDate = new DateUtilities.CALDate(end); DateUtilities.CALDate[] dateList = cal.BizDatesList(beginDate, endDate); double[,] ret = new double[dateList.Length, 1]; for (int i = 0; i < dateList.Length; ++i) { ret[i, 0] = (double)dateList[i].SerialNumber(); } return(Utilities.ArrayResizer.ResizeDoubles(ret)); } catch (Exception e) { return(Utilities.ExcelRangeErrorString(e)); } }
public object[,] SecurityCategory(string standard, int level, string fieldsStr, DateUtilities.CALDate date) { Dictionary <string, string> tmp = server_config[server]; string requestString = tmp["host"]; requestString = (tmp["port"] != "" ? requestString + ":" + tmp["port"] : requestString); requestString = requestString + api_config["SecurityCategory"][server]; requestString = requestString + "standard=" + standard + level; requestString = requestString + "&date=" + date.plainRepr(); requestString = requestString + "&field="; string[] fields = fieldsStr.Split(','); if (fields.Length != 0) { foreach (object field in fields) { string tmpStr = field.ToString(); requestString = requestString + tmpStr + ","; } requestString = requestString.Remove(requestString.Length - 1); } WebRequest wReq = System.Net.WebRequest.Create(requestString); WebResponse wResp = wReq.GetResponse(); Stream respStream = wResp.GetResponseStream(); return(CSVHelper.parseCSVString(respStream)); }
public object[,] MarketDataGetHistDailyQuotes(string securityID, string fieldsStr, DateUtilities.CALDate startDate, DateUtilities.CALDate endDate) { Dictionary <string, string> tmp = server_config[server]; string requestString = tmp["host"]; requestString = (tmp["port"] != "" ? requestString + ":" + tmp["port"] : requestString); requestString = requestString + api_config["MarketDataGetHistDailyQuotes"][server]; requestString = requestString + "securityID=" + securityID; requestString = requestString + "&field="; string[] fields = fieldsStr.Split(','); if (fields.Length != 0) { foreach (object field in fields) { string tmpStr = field.ToString(); requestString = requestString + tmpStr + ","; } requestString = requestString.Remove(requestString.Length - 1); } requestString = requestString + "&startDate=" + startDate.plainRepr(); requestString = requestString + "&endDate=" + endDate.plainRepr(); WebRequest wReq = System.Net.WebRequest.Create(requestString); WebResponse wResp = wReq.GetResponse(); Stream respStream = wResp.GetResponseStream(); return(CSVHelper.parseCSVString(respStream)); }