Working with Excel (tools, indicators, conversion ...)

To add comments, please log in or register
DeVinci
285
DeVinci  

Hi again,

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.

_http://www.excelbusinesstools.com/regfor.htm

and the prog is attached.....( medicine OK, as usual )

Bye

DV

Sergey Golubev
Moderator
106737
Sergey Golubev  

Great! Thanks.

But, may be, it is the same problem with XLChartPro? I mean how to insert the data to those program?

DeVinci
285
DeVinci  
newdigital:
Great! Thanks.

But, may be, it is the same problem with XLChartPro? I mean how to insert the data to those program?

Hi Man

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 ...

Sorry again

Good luck

DV

Sergey Golubev
Moderator
106737
Sergey Golubev  

It is ok.

I do not need it personally.

I think people who will use it will be able to find the way.

Sergey Golubev
Moderator
106737
Sergey Golubev  

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.

Sergey Golubev
Moderator
106737
Sergey Golubev  

... and predicting the future.

Part 2 of 2.

forexgom
9
forexgom  

very interesting... but i dont speak russian ...

newdigital, do you know how to install the package and how to use it ?

Regards

Sergey Golubev
Moderator
106737
Sergey Golubev  

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 ...

whatchee4
11
whatchee4  
newdigital:
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

fxid10t
146
fxid10t  

if all else fails use

http://babelfish.altavista.com/

to help translate,

хорошее везение

Sergey Golubev
Moderator
106737
Sergey Golubev  

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

Files:
ta-lib.zip 177 kb