Ultimately, the Y value (end point) will be displayed in CQG on the chart. Here is an example of applying this trend line to a daily close line chart of data (symbol: EP) in Excel. Where Excel calculates the three coefficients, x is the x-axis values and b is the y intercept. The Third Order Polynomial Trend line has this mathematical formula: In addition to the downloadable sample Excel spreadsheet, a CQG PAC is provided that uses the XLTS study to pull the results into CQG to display on a chart. This article walks you through using Microsoft® Excel’s LINEST function to determine the three coefficients and y-intercept of a 3rd order polynomial function over the past 20 bars of closing price data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |