xlsgen > overview > Bollinger bands

Chart Bollinger bands is a unique chart in xlsgen for visualizing and predicting changes in data. It is a case of financial chart.

Bollinger bands include the following :

• moving average (in the example above, it is the dotted line)
• upper band defined by twice the moving standard deviation over the same period than the moving average (in the example above, the purple band above the signal)
• lower band defined by twice the moving standard deviation over the same period than the moving average (in the example above, the purple band below the signal)

Bollinger bands were designed for making decisions according to the signal crossing the bands. Statistically, it is agreed that :

• a buy/sell signal whenever the signal crosses a band
• the signal crosses one band then it will cross the other one

Note that it is also known that bollinger bands being independent of the actual volume (another measure), it may yield inaccurate decision making.

xlsgen::IXlsChartPtr chart = worksheet->NewChart(xlsgen::charttype_bollingerbands, 4, 3, 18, 8);
xlsgen::IXlsChartDynamicDataSourceSeriesPtr serie001 = chart->DynamicDataSource->AddSerie();
serie001->SeriesValuesFormula = L"Sheet1!$C$3:$C$99";