The Multiple Regression Analysis and Forecasting template provides a solid basis for identifying value drivers and forecasting time series data. While it utilises a range of commonly employed statistical measures to test the validity of the analysis, results are summarized in text for ease of use. Once relationships have been identified, forecasting can be accomplished based on a range of available methodologies. The intuitive step-by-step usage flow enables you to develop strong forecasts for your projects in a timely manner.
and the prog is attached.....( medicine OK, as usual )
But, may be, it is the same problem with XLChartPro? I mean how to insert the data to those program?
Sorry, but i have never used this prog, so, it won't be E-Z for me to help you....
But probably, if you are accustomed to Excel ( me, i am not ) , you could find your way by exploring functions ...
It is ok.
I do not need it personally.
I think people who will use it will be able to find the way.
Working with Excel (tools, indicators, conversion ...)
NeurOK Excel Neural Package - this freeware Excel add-in allows of modelling your data within Microsoft Excel:
- Excel Neural Package implements two most popular neural network architectures: multilayer perceptron and self-organized feature maps
- Excel Neural Package aims to help analysts, familiar with neural networks basics in modelling their data, examining its structure and predicting the future.
Part 1 of 2.
... and predicting the future.
Part 2 of 2.
very interesting... but i dont speak russian ...
newdigital, do you know how to install the package and how to use it ?
Go to their website http://soft.neurok.com/dm/download.shtml
It is company registered in USA originally from Russia.
I do not thing that they will use Russian language for the software products promoting/selling in USA: nobody will understand ...
its documentation is in russian, and dont know it works with excel 2000 or not, will test later
if all else fails use
to help translate,
Technical indicators for Excel
In Excel, select "Service" and then "Add-In", browse and select "ta-lib.xll".
All the TA functions will become visible in the "Function Wizard" (press Shift-F3). In the file example.xls you will see the examples of the indicators with comments.
Indicators in Excel available:
AD - Chaikin A/D Line
ADOSC - Chaikin A/D Oscillator
ADX - Average Directional Movement Index
ADXR - Average Directional Movement Index Rating
APO - Absolute Price Oscillator
AROON - Aroon
AROONOSC - Aroon Oscillator
ATR - Average True Range
AVGPRICE - Average Price
BBANDS - Bollinger Bands
CCI - Commodity Channel Index
CORREL - Pearson's Correlation Coefficient (r)
DEMA - Double Exponential Moving Average
DX - Directional Movement Index
EMA - Exponential Moving Average
HT_DCPERIOD - Hilbert Transform - Dominant Cycle Period
HT_DCPHASE - Hilbert Transform - Dominant Cycle Phase
HT_PHASOR - Hilbert Transform - Phasor Components
HT_SINE - Hilbert Transform - SineWave
HT_TRENDLINE - Hilbert Transform - Instantaneous Trendline
HT_TRENDMODE - Hilbert Transform - Trend vs Cycle Mode
KAMA - Kaufman Adaptive Moving Average
LINEARREG - Linear Regression
LINEARREG_ANGLE - Linear Regression Angle
LINEARREG_INTERCEPT - Linear Regression Intercept
LINEARREG_SLOPE - Linear Regression Slope
MA - All Moving Average
MACD - Moving Average Convergence/Divergence
MACDEXT - MACD with controllable MA type
MACDFIX - Moving Average Convergence/Divergence Fix 12/26
MAMA - MESA Adaptive Moving Average
MAX - Highest value over a specified period
MEDPRICE - Median Price
MFI - Money Flow Index
MIDPOINT - MidPoint over period
MIDPRICE - Midpoint Price over period
MIN - Lowest value over a specified period
MINUS_DI - Minus Directional Indicator
MINUS_DM - Minus Directional Movement
MOM - Momentum
OBV - On Balance Volume
PLUS_DI - Plus Directional Indicator
PLUS_DM - Plus Directional Movement
PPO - Percentage Price Oscillator
ROC - Rate of change : ((price/prevPrice)-1)*100
ROCP - Rate of change Percentage: (price-prevPrice)/prevPrice
ROCR - Rate of change ratio: (price/prevPrice)
ROCR100 - Rate of change ratio 100 scale: (price/prevPrice)*100
RSI - Relative Strength Index
SAR - Parabolic SAR
SAREXT - Parabolic SAR - Extended
SMA - Simple Moving Average
STDDEV - Standard Deviation
STOCH - Stochastic
STOCHF - Stochastic Fast
STOCHRSI - Stochastic Relative Strength Index
T3 - Triple Exponential Moving Average (T3)
TEMA - Triple Exponential Moving Average
TRANGE - True Range
TRIMA - Triangular Moving Average
TRIX - 1-day Rate-Of-Change (ROC) of a Triple Smooth EMA
TSF - Time Series Forecast
TYPPRICE - Typical Price
VAR - Variance
WCLPRICE - Weighted Close Price
WILLR - Williams' %R
WMA - Weighted Moving Average