Data Table for Forcasting We only extract one row for example purpose.
| Date |
Open |
Close |
High |
Low |
DayHLRange |
5DAvgRange |
10DAvgRange |
| 2017-09-01 | $171.99 | 171.04 | $172.39 | $170.65 | 1.74 | 3.36 | 3.55 |
Calculation Formula: [ClosePrice] +/- [AverageRange] * [ratio] = [ForecastValue]
| 171.04 | + ( | 3.36 |
*
2 | / |
3 | ) = | 173 |
5DayHigh |
171.04 | - ( | 3.36 |
*
1 | / |
3 | ) = | 170 |
5DayLow |
Uptrend |
| 171.04 | + ( | 3.36 |
*
2 | / | 3
| ) = | 172 |
5DayHigh |
171.04 | - ( | 3.36 |
*
1 | / | 3 | ) = | 169 |
5DayLow |
Downtrend |
| Maximum {ForecastValues} = | 173 |
MixHigh |
Minimum {ForecastValues} = | 169 |
MixLow | |
| 171.04 | + ( | 3.55 |
*
2 | / | 3
| ) = | 173 |
10DayHigh |
171.04 | - ( | 3.55 |
*
1 | / | 3
| ) = | 170 |
10DayLow | Uptrend |
| 171.04 | + ( | 3.55 |
* 2 | / | 3
| ) = | 172 |
10DayHigh |
171.04 | - ( | 3.55 |
*
1 | / | 3 | ) = |
169 |
10DayLow | Downtrend |
Apply Formula Result Table: If you change the numerator and denominator this table will recalculate. We only show 10 rows here.
| Date |
5DHi |
5DLo |
IO |
5DHi |
5DLo |
IO |
MixHi |
MixLo |
IO |
10DHi |
10DLo |
IO |
10DHi |
10DLo |
IO |
| 2017-09-05 | $173 | $170 | | $172 | $169 | | $173 | $169 | | $173 | $170 | | $172 | $169 | |
| 2017-09-01 | $174 | $170 | I | $173 | $169 | I | $174 | $169 | I | $174 | $170 | I | $173 | $169 | I |
| 2017-08-31 | $174 | $170 | I | $173 | $169 | I | $174 | $169 | I | $174 | $170 | I | $173 | $169 | I |
| 2017-08-30 | $170 | $166 | O | $169 | $165 | O | $170 | $165 | O | $170 | $166 | O | $169 | $165 | O |
| 2017-08-29 | $171 | $167 | O | $170 | $166 | O | $171 | $166 | O | $171 | $167 | O | $170 | $166 | O |
| 2017-08-28 | $174 | $170 | O | $173 | $169 | O | $174 | $169 | O | $174 | $171 | O | $173 | $169 | O |
| 2017-08-25 | $178 | $174 | O | $176 | $172 | O | $178 | $172 | O | $178 | $174 | O | $176 | $172 | O |
| 2017-08-24 | $179 | $174 | I | $177 | $173 | I | $179 | $173 | I | $179 | $174 | I | $177 | $173 | I |
| 2017-08-23 | $177 | $173 | O | $176 | $172 | O | $177 | $172 | I | $177 | $173 | O | $176 | $172 | O |
| 2017-08-22 | $172 | $168 | O | $171 | $167 | O | $172 | $167 | O | $172 | $168 | O | $170 | $167 | O |
Statistic Distribution Table
Data Start Date: 2016-01-15 Data End Date: 2017-08-31 Total Date Count: 306
| Indicator |
U5DCount |
D5DCount |
MixCount |
U10DCount |
D10DCount |
| I | 129 | 108 | 251 | 122 | 113 |
| O | 493 | 514 | 371 | 500 | 509 |
Please Note: Data on this page is temporary, and will not save to actual table. Our forecast table still use 3,2,1 default parameters.