public bool downloadVWAP(string folderPath, string scriptName, bool bIsTestOn, bool bSaveData) { string interval = ddlVWAP_Interval.SelectedValue; if (StockApi.getVWAP(folderPath, scriptName, day_interval: interval, bIsTestModeOn: bIsTestOn, bSaveData: bSaveData, apiKey: Session["ApiKey"].ToString()) == null) { Response.Write("<script language=javascript>alert('VWAP data not available for selected script.')</script>"); return(false); } return(true); }
public void ShowGraph(string scriptName) { string folderPath = Server.MapPath("~/scriptdata/"); bool bIsTestOn = true; DataTable scriptData = null; DataTable tempData = null; string expression = ""; string interval = ""; string fromDate = "", toDate = ""; DataRow[] filteredRows = null; if (ViewState["FetchedData"] == null) { if (Session["IsTestOn"] != null) { bIsTestOn = System.Convert.ToBoolean(Session["IsTestOn"]); } if (Session["TestDataFolder"] != null) { folderPath = Session["TestDataFolder"].ToString(); } if (Request.QueryString["interval"] != null) { interval = Request.QueryString["interval"]; scriptData = StockApi.getVWAP(folderPath, scriptName, day_interval: interval, bIsTestModeOn: bIsTestOn, bSaveData: false); } ViewState["FetchedData"] = scriptData; } else { if (ViewState["FromDate"] != null) { fromDate = ViewState["FromDate"].ToString(); } if (ViewState["ToDate"] != null) { toDate = ViewState["ToDate"].ToString(); } if ((fromDate.Length > 0) && (toDate.Length > 0)) { tempData = (DataTable)ViewState["FetchedData"]; expression = "Date >= '" + fromDate + "' and Date <= '" + toDate + "'"; filteredRows = tempData.Select(expression); if ((filteredRows != null) && (filteredRows.Length > 0)) { scriptData = filteredRows.CopyToDataTable(); } } else { scriptData = (DataTable)ViewState["FetchedData"]; } } if (scriptData != null) { ////time,Real Lower Band,Real Middle Band,Real Upper Band /// (chartVWAP.Series["seriesVWAP"]).XValueMember = "Date"; (chartVWAP.Series["seriesVWAP"]).XValueType = ChartValueType.Date; (chartVWAP.Series["seriesVWAP"]).YValueMembers = "VWAP"; //(chartVWAP.Series["seriesVWAP"]).ToolTip = "VWAP: Date:#VALX; Value:#VALY"; chartVWAP.ChartAreas["chartareaVWAP"].AxisX.Title = "Date"; chartVWAP.ChartAreas["chartareaVWAP"].AxisX.TitleAlignment = System.Drawing.StringAlignment.Center; chartVWAP.ChartAreas["chartareaVWAP"].AxisY.Title = "Value"; chartVWAP.ChartAreas["chartareaVWAP"].AxisY.TitleAlignment = System.Drawing.StringAlignment.Center; chartVWAP.ChartAreas["chartareaVWAP"].AxisX.LabelStyle.Format = "g"; //chartVWAP.Titles["titleVWAP"].Text = $"{"Volume Weighted Average Price - "}{scriptName}"; if (chartVWAP.Annotations.Count > 0) { chartVWAP.Annotations.Clear(); } chartVWAP.DataSource = scriptData; chartVWAP.DataBind(); } }
public void ShowGraph(string scriptName) { string folderPath = Server.MapPath("~/scriptdata/"); bool bIsTestOn = true; DataTable intraData = null; DataTable vwapData = null; DataTable tempData = null; string expression = ""; string outputSize = ""; string interval_intra = ""; string interval_vwap = ""; string fromDate = "", toDate = ""; DataRow[] filteredRows = null; if ((ViewState["FetchedDataIntra"] == null) || (ViewState["FetchedDataVWAP"] == null)) { if (Session["IsTestOn"] != null) { bIsTestOn = System.Convert.ToBoolean(Session["IsTestOn"]); } if (Session["TestDataFolder"] != null) { folderPath = Session["TestDataFolder"].ToString(); } if ((Request.QueryString["size"] != null) && (Request.QueryString["interval_intra"] != null)) { outputSize = Request.QueryString["size"].ToString(); interval_intra = Request.QueryString["interval_intra"]; intraData = StockApi.getIntraday(folderPath, scriptName, time_interval: interval_intra, outputsize: outputSize, bIsTestModeOn: bIsTestOn, bSaveData: false); ViewState["FetchedDataIntra"] = intraData; } else { ViewState["FetchedDataIntra"] = null; intraData = null; } if (Request.QueryString["interval_vwap"] != null) { interval_vwap = Request.QueryString["interval_vwap"]; vwapData = StockApi.getVWAP(folderPath, scriptName, day_interval: interval_vwap, bIsTestModeOn: bIsTestOn, bSaveData: false); ViewState["FetchedDataVWAP"] = vwapData; } else { ViewState["FetchedDataVWAP"] = null; vwapData = null; } } else { if (ViewState["FromDate"] != null) { fromDate = ViewState["FromDate"].ToString(); } if (ViewState["ToDate"] != null) { toDate = ViewState["ToDate"].ToString(); } if ((fromDate.Length > 0) && (toDate.Length > 0)) { tempData = (DataTable)ViewState["FetchedDataIntra"]; expression = "Date >= '" + fromDate + "' and Date <= '" + toDate + "'"; filteredRows = tempData.Select(expression); if ((filteredRows != null) && (filteredRows.Length > 0)) { intraData = filteredRows.CopyToDataTable(); } tempData.Clear(); tempData = null; tempData = (DataTable)ViewState["FetchedDataVWAP"]; expression = "Date >= '" + fromDate + "' and Date <= '" + toDate + "'"; filteredRows = tempData.Select(expression); if ((filteredRows != null) && (filteredRows.Length > 0)) { vwapData = filteredRows.CopyToDataTable(); } } else { intraData = (DataTable)ViewState["FetchedDataIntra"]; vwapData = (DataTable)ViewState["FetchedDataVWAP"]; } } if ((intraData != null) && (vwapData != null)) { showCandleStickGraph(intraData); showVWAP(vwapData); } }