//Main code for creating chart.
//Note: the argument img is unused because this demo only has 1 chart.
public void createChart(WinChartViewer WebChartViewer1, string img, int stockId, int timeFrameId, DateTime fromDt, DateTime toDt, int ballSize, int chartWidth, int chartHeighth, int priceType)
{
var stock = (from s in dataContext.stocks
where s.id == stockId
select s).FirstOrDefault();
if (stock == null)
{
errMsg(WebChartViewer1, "Инструмент не найден");
return;
}
var quotes = (from q in dataContext.volquotes
where q.stock == stockId &&
q.timeframe == timeFrameId &&
q.datetime >= fromDt &&
q.datetime <= toDt.AddDays(1)
orderby q.datetime ascending
select q);
VolQuotesLst = quotes.ToList();
if (quotes == null || quotes.Count() == 0)
{
errMsg(WebChartViewer1, "Данные отсутствуют");
return;
}
var timeFrame = (from t in dataContext.timeframes
where t.id == timeFrameId
select t).FirstOrDefault();
if (timeFrame == null)
{
errMsg(WebChartViewer1, "Тайм фрейм отсутствуют");
return;
}
string tickerKey = stock.ticker.Trim();
// The data series we want to get.
if (!getData(fromDt, toDt))
{
errMsg(WebChartViewer1, "Инструмент не найден");
return;
}
//-------------
// Create the chart object using the selected size
FinanceChart m = new FinanceChart(chartWidth);
string[] monthNames = { "Янв", "Фев", "Мар", "Апр", "Май", "Июн", "Июл", "Авг", "Сен", "Окт", "Ноя", "Дек" };
m.setMonthNames(monthNames);
m.setDateLabelFormat("{value|yyyy}",
"<*font=bold*>{value|mmm yy}",
"{value|mm/yy}",
"<*font=bold*>{value|d mmm}",
"{value|d}",
"<*font=bold*>{value|d mmm<*br*>h:nna}",
"{value|h:nna}");
// Set the data into the chart object
m.setData(timeStamps, highData, lowData, openData, closeData, VolumeData,
0);
//
// We configure the title of the chart. In this demo chart design, we put the
// company name as the top line of the title with left alignment.
//
m.addPlotAreaTitle(Chart.TopLeft, tickerKey);
m.addPlotAreaTitle(Chart.BottomLeft, "<*font=Arial,size=8*>" + m.formatValue(
fromDt, "dd MMM, yyyy") + " - " + m.formatValue(
toDt, "dd MMM, yyyy"));
// A copyright message at the bottom left corner the title area
m.addPlotAreaTitle(Chart.BottomRight,
" ");
//--
int mainHeight = 350;
int indicatorHeight = 110;
//
// Add the main chart
//
XYChart MainChart = m.addMainChart(mainHeight);
//---------------------
m.addCandleStick(0x33ff33, 0xff3333);
m.addVolBars(indicatorHeight, 0x99ff99, 0xff9999, 0xc0c0c0);
// Output the chart
WebChartViewer1.Image = m.makeImage();
}
/// <summary>
/// Draw the chart according to user selection and display it in the WPFChartViewer.
/// </summary>
/// <param name="viewer">The WPFChartViewer object to display the chart.</param>
private void drawChart(WPFChartViewer viewer)
{
// Use InvariantCulture to draw the chart. This ensures the chart will look the
// same on any computer.
System.Threading.Thread.CurrentThread.CurrentCulture =
System.Globalization.CultureInfo.InvariantCulture;
// In this demo, we just assume we plot up to the latest time. So endDate is now.
DateTime endDate = DateTime.Now;
// If the trading day has not yet started (before 9:30am), or if the end date is
// on on Sat or Sun, we set the end date to 4:00pm of the last trading day
while ((endDate.TimeOfDay.CompareTo(new TimeSpan(9, 30, 0)) < 0) || (
endDate.DayOfWeek == DayOfWeek.Sunday) || (endDate.DayOfWeek ==
DayOfWeek.Saturday))
{
endDate = endDate.Date.AddDays(-1).Add(new TimeSpan(16, 0, 0));
}
// The duration selected by the user
int durationInDays = int.Parse(((ListItem)timeRange.SelectedItem).Key);
// Compute the start date by subtracting the duration from the end date.
DateTime startDate;
if (durationInDays >= 30)
{
// More or equal to 30 days - so we use months as the unit
startDate = new DateTime(endDate.Year, endDate.Month, 1).AddMonths(
-durationInDays / 30);
}
else
{
// Less than 30 days - use day as the unit. Note that we use trading days
// below. For less than 30 days, the starting point of the axis is always at
// the start of the day.
startDate = endDate.Date;
for (int i = 1; i < durationInDays; ++i)
{
startDate = startDate.AddDays(
(startDate.DayOfWeek == DayOfWeek.Monday) ? -3 : -1);
}
}
// The first moving average period selected by the user.
int avgPeriod1;
try { avgPeriod1 = int.Parse(movAvg1.Text); }
catch { avgPeriod1 = 0; }
avgPeriod1 = Math.Max(0, Math.Min(300, avgPeriod1));
// The second moving average period selected by the user.
int avgPeriod2;
try { avgPeriod2 = int.Parse(movAvg2.Text); }
catch { avgPeriod2 = 0; }
avgPeriod2 = Math.Max(0, Math.Min(300, avgPeriod2));
// We need extra leading data points in order to compute moving averages.
int extraPoints = Math.Max(20, Math.Max(avgPeriod1, avgPeriod2));
// Get the data series to compare with, if any.
compareKey = compareWith.Text.Trim();
compareData = null;
if (getData(compareKey, startDate, endDate, durationInDays, extraPoints))
{
compareData = closeData;
}
// The data series we want to get.
tickerKey = tickerSymbol.Text.Trim();
if (!getData(tickerKey, startDate, endDate, durationInDays, extraPoints))
{
errMsg(viewer, "Please enter a valid ticker symbol");
return;
}
// We now confirm the actual number of extra points (data points that are before
// the start date) as inferred using actual data from the database.
extraPoints = timeStamps.Length;
for (int i = 0; i < timeStamps.Length; ++i)
{
if (timeStamps[i] >= startDate)
{
extraPoints = i;
break;
}
}
// Check if there is any valid data
if (extraPoints >= timeStamps.Length)
{
// No data - just display the no data message.
errMsg(viewer, "No data available for the specified time period");
return;
}
// In some finance chart presentation style, even if the data for the latest day
// is not fully available, the axis for the entire day will still be drawn, where
// no data will appear near the end of the axis.
if (resolution < 86400)
{
// Add extra points to the axis until it reaches the end of the day. The end
// of day is assumed to be 4:00pm (it depends on the stock exchange).
DateTime lastTime = timeStamps[timeStamps.Length - 1];
int extraTrailingPoints = (int)(new TimeSpan(16, 0, 0).Subtract(
lastTime.TimeOfDay).TotalSeconds / resolution);
if (extraTrailingPoints > 0)
{
DateTime[] extendedTimeStamps = new DateTime[timeStamps.Length +
extraTrailingPoints];
Array.Copy(timeStamps, 0, extendedTimeStamps, 0, timeStamps.Length);
for (int i = 0; i < extraTrailingPoints; ++i)
{
extendedTimeStamps[i + timeStamps.Length] = lastTime.AddSeconds(
resolution * i);
}
timeStamps = extendedTimeStamps;
}
}
//
// At this stage, all data is available. We can draw the chart as according to
// user input.
//
//
// Determine the chart size. In this demo, user can select 4 different chart
// sizes. Default is the large chart size.
//
int width = 780;
int mainHeight = 255;
int indicatorHeight = 80;
string selectedSize = ((ListItem)chartSize.SelectedItem).Key;
if (selectedSize == "S")
{
// Small chart size
width = 450;
mainHeight = 160;
indicatorHeight = 60;
}
else if (selectedSize == "M")
{
// Medium chart size
width = 620;
mainHeight = 215;
indicatorHeight = 70;
}
else if (selectedSize == "H")
{
// Huge chart size
width = 1000;
mainHeight = 320;
indicatorHeight = 90;
}
// Create the chart object using the selected size
FinanceChart m = new FinanceChart(width);
// Set the data into the chart object
m.setData(timeStamps, highData, lowData, openData, closeData, volData, extraPoints);
//
// We configure the title of the chart. In this demo chart design, we put the
// company name as the top line of the title with left alignment.
//
m.addPlotAreaTitle(Chart.TopLeft, tickerKey);
// We displays the current date as well as the data resolution on the next line.
string resolutionText = "";
if (resolution == 30 * 86400)
{
resolutionText = "Monthly";
}
else if (resolution == 7 * 86400)
{
resolutionText = "Weekly";
}
else if (resolution == 86400)
{
resolutionText = "Daily";
}
else if (resolution == 900)
{
resolutionText = "15-min";
}
m.addPlotAreaTitle(Chart.BottomLeft, "<*font=Arial,size=8*>" + m.formatValue(
DateTime.Now, "mmm dd, yyyy") + " - " + resolutionText + " chart");
// A copyright message at the bottom left corner the title area
m.addPlotAreaTitle(Chart.BottomRight,
"<*font=arial.ttf,size=8*>(c) Advanced Software Engineering");
//
// Add the first techical indicator according. In this demo, we draw the first
// indicator on top of the main chart.
//
addIndicator(m, ((ListItem)indicator1.SelectedItem).Key, indicatorHeight);
//
// Add the main chart
//
m.addMainChart(mainHeight);
//
// Set log or linear scale according to user preference
//
m.setLogScale(logScale.IsChecked.GetValueOrDefault());
//
// Set axis labels to show data values or percentage change to user preference
//
if (percentageScale.IsChecked.GetValueOrDefault())
{
m.setPercentageAxis();
}
//
// Draw any price line the user has selected
//
string mainType = ((ListItem)chartType.SelectedItem).Key;
if (mainType == "Close")
{
m.addCloseLine(0x000040);
}
else if (mainType == "TP")
{
m.addTypicalPrice(0x000040);
}
else if (mainType == "WC")
{
m.addWeightedClose(0x000040);
}
else if (mainType == "Median")
{
m.addMedianPrice(0x000040);
}
//
// Add comparison line if there is data for comparison
//
if ((compareData != null) && (compareData.Length > extraPoints))
{
m.addComparison(compareData, 0x0000ff, compareKey);
}
//
// Add moving average lines.
//
addMovingAvg(m, ((ListItem)avgType1.SelectedItem).Key, avgPeriod1, 0x663300);
addMovingAvg(m, ((ListItem)avgType2.SelectedItem).Key, avgPeriod2, 0x9900ff);
//
// Draw candlesticks or OHLC symbols if the user has selected them.
//
if (mainType == "CandleStick")
{
m.addCandleStick(0x33ff33, 0xff3333);
}
else if (mainType == "OHLC")
{
m.addHLOC(0x008800, 0xcc0000);
}
//
// Add parabolic SAR if necessary
//
if (parabolicSAR.IsChecked.GetValueOrDefault())
{
m.addParabolicSAR(0.02, 0.02, 0.2, Chart.DiamondShape, 5, 0x008800, 0x000000);
}
//
// Add price band/channel/envelop to the chart according to user selection
//
string selectedBand = ((ListItem)priceBand.SelectedItem).Key;
if (selectedBand == "BB")
{
m.addBollingerBand(20, 2, 0x9999ff, unchecked ((int)(0xc06666ff)));
}
else if (selectedBand == "DC")
{
m.addDonchianChannel(20, 0x9999ff, unchecked ((int)(0xc06666ff)));
}
else if (selectedBand == "Envelop")
{
m.addEnvelop(20, 0.1, 0x9999ff, unchecked ((int)(0xc06666ff)));
}
//
// Add volume bars to the main chart if necessary
//
if (volumeBars.IsChecked.GetValueOrDefault())
{
m.addVolBars(indicatorHeight, 0x99ff99, 0xff9999, 0xc0c0c0);
}
//
// Add additional indicators as according to user selection.
//
addIndicator(m, ((ListItem)indicator2.SelectedItem).Key, indicatorHeight);
addIndicator(m, ((ListItem)indicator3.SelectedItem).Key, indicatorHeight);
addIndicator(m, ((ListItem)indicator4.SelectedItem).Key, indicatorHeight);
//
// output the chart
//
viewer.Chart = m;
//
// tooltips for the chart
//
viewer.ImageMap = m.getHTMLImageMap("", "", "title='" + m.getToolTipDateFormat()
+ " {value|P}'");
}
/// <summary>
/// Create a financial chart according to user selections. The user selections are
/// encoded in the query parameters.
/// </summary>
public BaseChart drawChart()
{
// In this demo, we just assume we plot up to the latest time. So end date is now.
DateTime endDate = DateTime.Now;
// If the trading day has not yet started (before 9:30am), or if the end date is on on Sat or
// Sun, we set the end date to 4:00pm of the last trading day
while ((endDate.TimeOfDay.CompareTo(new TimeSpan(9, 30, 0)) < 0) || (endDate.DayOfWeek ==
DayOfWeek.Sunday) || (endDate.DayOfWeek == DayOfWeek.Saturday))
{
endDate = endDate.Date.AddDays(-1).Add(new TimeSpan(16, 0, 0));
}
// The duration selected by the user
int durationInDays = int.Parse(Request["TimeRange"]);
// Compute the start date by subtracting the duration from the end date.
DateTime startDate = endDate;
if (durationInDays >= 30)
{
// More or equal to 30 days - so we use months as the unit
startDate = new DateTime(endDate.Year, endDate.Month, 1).AddMonths(-durationInDays / 30);
}
else
{
// Less than 30 days - use day as the unit. The starting point of the axis is always at
// the start of the day (9:30am). Note that we use trading days, so we skip Sat and Sun
// in counting the days.
startDate = endDate.Date;
for (int i = 1; i < durationInDays; ++i)
{
if (startDate.DayOfWeek == DayOfWeek.Monday)
{
startDate = startDate.AddDays(-3);
}
else
{
startDate = startDate.AddDays(-1);
}
}
}
// The moving average periods selected by the user.
int avgPeriod1 = 0;
try { avgPeriod1 = int.Parse(Request["movAvg1"]);; }
catch { avgPeriod1 = 0;; }
int avgPeriod2 = 0;
try { avgPeriod2 = int.Parse(Request["movAvg2"]);; }
catch { avgPeriod2 = 0;; }
if (avgPeriod1 < 0)
{
avgPeriod1 = 0;
}
else if (avgPeriod1 > 300)
{
avgPeriod1 = 300;
}
if (avgPeriod2 < 0)
{
avgPeriod2 = 0;
}
else if (avgPeriod2 > 300)
{
avgPeriod2 = 300;
}
// We need extra leading data points in order to compute moving averages.
int extraPoints = 20;
if (avgPeriod1 > extraPoints)
{
extraPoints = avgPeriod1;
}
if (avgPeriod2 > extraPoints)
{
extraPoints = avgPeriod2;
}
// Get the data series to compare with, if any.
string compareKey = Request["CompareWith"].Trim();
compareData = null;
if (getData(compareKey, startDate, endDate, durationInDays, extraPoints))
{
compareData = closeData;
}
// The data series we want to get.
string tickerKey = Request["TickerSymbol"].Trim();
if (!getData(tickerKey, startDate, endDate, durationInDays, extraPoints))
{
return(errMsg("Please enter a valid ticker symbol"));
}
// We now confirm the actual number of extra points (data points that are before the start
// date) as inferred using actual data from the database.
extraPoints = timeStamps.Length;
for (int i = 0; i < timeStamps.Length; ++i)
{
if (timeStamps[i] >= startDate)
{
extraPoints = i;
break;
}
}
// Check if there is any valid data
if (extraPoints >= timeStamps.Length)
{
// No data - just display the no data message.
return(errMsg("No data available for the specified time period"));
}
// In some finance chart presentation style, even if the data for the latest day is not fully
// available, the axis for the entire day will still be drawn, where no data will appear near
// the end of the axis.
if (resolution < 86400)
{
// Add extra points to the axis until it reaches the end of the day. The end of day is
// assumed to be 16:00 (it depends on the stock exchange).
DateTime lastTime = timeStamps[timeStamps.Length - 1];
int extraTrailingPoints = (int)(new TimeSpan(16, 0, 0).Subtract(lastTime.TimeOfDay
).TotalSeconds / resolution);
if (extraTrailingPoints > 0)
{
DateTime[] extendedTimeStamps = new DateTime[timeStamps.Length + extraTrailingPoints
];
Array.Copy(timeStamps, 0, extendedTimeStamps, 0, timeStamps.Length);
for (int i = 0; i < extraTrailingPoints; ++i)
{
extendedTimeStamps[i + timeStamps.Length] = lastTime.AddSeconds(resolution * (i +
1));
}
timeStamps = extendedTimeStamps;
}
}
//
// At this stage, all data are available. We can draw the chart as according to user input.
//
//
// Determine the chart size. In this demo, user can select 4 different chart sizes. Default
// is the large chart size.
//
int width = 780;
int mainHeight = 255;
int indicatorHeight = 80;
string size = Request["ChartSize"];
if (size == "S")
{
// Small chart size
width = 450;
mainHeight = 160;
indicatorHeight = 60;
}
else if (size == "M")
{
// Medium chart size
width = 620;
mainHeight = 215;
indicatorHeight = 70;
}
else if (size == "H")
{
// Huge chart size
width = 1000;
mainHeight = 320;
indicatorHeight = 90;
}
// Create the chart object using the selected size
FinanceChart m = new FinanceChart(width);
// Set the data into the chart object
m.setData(timeStamps, highData, lowData, openData, closeData, volData, extraPoints);
//
// We configure the title of the chart. In this demo chart design, we put the company name as
// the top line of the title with left alignment.
//
m.addPlotAreaTitle(Chart.TopLeft, tickerKey);
// We displays the current date as well as the data resolution on the next line.
string resolutionText = "";
if (resolution == 30 * 86400)
{
resolutionText = "Monthly";
}
else if (resolution == 7 * 86400)
{
resolutionText = "Weekly";
}
else if (resolution == 86400)
{
resolutionText = "Daily";
}
else if (resolution == 900)
{
resolutionText = "15-min";
}
m.addPlotAreaTitle(Chart.BottomLeft, "<*font=Arial,size=8*>" + m.formatValue(DateTime.Now,
"mmm dd, yyyy") + " - " + resolutionText + " chart");
// A copyright message at the bottom left corner the title area
m.addPlotAreaTitle(Chart.BottomRight,
"<*font=Arial,size=8*>(c) Advanced Software Engineering");
//
// Add the first techical indicator according. In this demo, we draw the first indicator on
// top of the main chart.
//
addIndicator(m, Request["Indicator1"], indicatorHeight);
//
// Add the main chart
//
m.addMainChart(mainHeight);
//
// Set log or linear scale according to user preference
//
if (Request["LogScale"] == "1")
{
m.setLogScale(true);
}
//
// Set axis labels to show data values or percentage change to user preference
//
if (Request["PercentageScale"] == "1")
{
m.setPercentageAxis();
}
//
// Draw any price line the user has selected
//
string mainType = Request["ChartType"];
if (mainType == "Close")
{
m.addCloseLine(0x000040);
}
else if (mainType == "TP")
{
m.addTypicalPrice(0x000040);
}
else if (mainType == "WC")
{
m.addWeightedClose(0x000040);
}
else if (mainType == "Median")
{
m.addMedianPrice(0x000040);
}
//
// Add comparison line if there is data for comparison
//
if (compareData != null)
{
if (compareData.Length > extraPoints)
{
m.addComparison(compareData, 0x0000ff, compareKey);
}
}
//
// Add moving average lines.
//
addMovingAvg(m, Request["avgType1"], avgPeriod1, 0x663300);
addMovingAvg(m, Request["avgType2"], avgPeriod2, 0x9900ff);
//
// Draw candlesticks or OHLC symbols if the user has selected them.
//
if (mainType == "CandleStick")
{
m.addCandleStick(0x33ff33, 0xff3333);
}
else if (mainType == "OHLC")
{
m.addHLOC(0x008800, 0xcc0000);
}
//
// Add parabolic SAR if necessary
//
if (Request["ParabolicSAR"] == "1")
{
m.addParabolicSAR(0.02, 0.02, 0.2, Chart.DiamondShape, 5, 0x008800, 0x000000);
}
//
// Add price band/channel/envelop to the chart according to user selection
//
string bandType = Request["Band"];
if (bandType == "BB")
{
m.addBollingerBand(20, 2, 0x9999ff, unchecked ((int)0xc06666ff));
}
else if (bandType == "DC")
{
m.addDonchianChannel(20, 0x9999ff, unchecked ((int)0xc06666ff));
}
else if (bandType == "Envelop")
{
m.addEnvelop(20, 0.1, 0x9999ff, unchecked ((int)0xc06666ff));
}
//
// Add volume bars to the main chart if necessary
//
if (Request["Volume"] == "1")
{
m.addVolBars(indicatorHeight, 0x99ff99, 0xff9999, 0xc0c0c0);
}
//
// Add additional indicators as according to user selection.
//
addIndicator(m, Request["Indicator2"], indicatorHeight);
addIndicator(m, Request["Indicator3"], indicatorHeight);
addIndicator(m, Request["Indicator4"], indicatorHeight);
return(m);
}