Working with Excel (tools, indicators, conversion ...) - page 15
You are missing trading opportunities:
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
Registration
Log in
You agree to website policy and terms of use
If you do not have an account, please register
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 AverageNewdigital,
Thanks to you and the forum I have started learning and using computers efficiently for forex trading.
I want to use this programme. Kindly give me instructions on how to use it in Openoffice Calc programme including instructions how to get MT4 data in Openoffice Calc programme usind DDE links. I am attaching the link to openoffice calc tutorial on external links [Tutorial] External Links In Calc (View topic) • OpenOffice.org Community Forum
Thank you again.
I do not know sorry (it is necessary for me to read and so on).
Anyway, thanks for the link.
Newdigital,
Thanks to you and the forum I have started learning and using computers efficiently for forex trading.
I want to use this programme. Kindly give me instructions on how to use it in Openoffice Calc programme including instructions how to get MT4 data in Openoffice Calc programme usind DDE links. I am attaching the link to openoffice calc tutorial on external links [Tutorial] External Links In Calc (View topic) • OpenOffice.org Community Forum
Thank you again.You could use the excel file provided with the MT4 installation as example. DDE is just a protocol. See from the link you provided 4. Cell Function DDE.
See this example, is StarCalc the brother of OOCalc but it's the same thing.
Excel and correlation
Has anyone looked at or have a excel sheet that shows correlation
between gold, oil, bond , dow and currency
or any work sheet that has correlation on it to get me started
I am not that good with excel but will try
convert qqe.mq4 to excel
Please someone help me to convert qqe.mq4 to excel, i very very need it.
or you can make simple equation like this (example, laquerre):
Inputs: Price((H+L)/2),
gamma(.8);
Vars: L0(0),
L1(0),
L2(0),
L3(0),
Filt(0)
FIR(0);
L0 = (1 - gamma)*Price + gamma*L0[1];
L1 = -gamma*L0 + L0[1] + gamma*L1[1];
L2 = -gamma*L1 + L1[1] + gamma*L2[1];
L3 = -gamma*L2 + L2[1] + gamma*L3[1];
Filt = (L0 + 2*L1 + 2*L2 + L3) / 6;
FIR = (Price + 2*Price[1] + 2*Price[2] + Price[3]) / 6;
Plot1(Filt, "Filt");
Plot2(FIR, "FIR");
i can make it for my self.
thank you in advance
Howto on volume ='MT4'|VOL!EURUSD
I am not getting volume to work, the mt4 sample does not have volume
I have tried these but not getting volume to work i have bid,ask,hi,low working but not volume
='MT4'|VOL!EURUSD
='MT4'|VOLUME!EURUSD
=MT4|VOL!EURUSD
=MT4|VOLUME!EURUSD
I am not getting these to work
This works?
='MT4'|HIGH!EURUSD
='MT4'|ASK!EURUSD
='MT4'|BID!EURUSD
='MT4'|LOW!EURUSDI am not getting volume to work, the mt4 sample does not have volume
I have tried these but not getting volume to work i have bid,ask,hi,low working but not volume
='MT4'|VOL!EURUSD
='MT4'|VOLUME!EURUSD
=MT4|VOL!EURUSD
=MT4|VOLUME!EURUSD
I am not getting these to workThere is no explanation about Volume on the help files and I can't find any information about.Sorry
Thank you for looking
Thank you, no problem i will keep looking,
I do find it strange i have read many times that you can do it.
but i have not seen it done yet with volume.
There is no explanation about Volume on the help files and I can't find any information about.Sorry
Metatrader excel link
Hi,
Can anyone give me some idea of how i can connect excel and metatrader. I have managed to get the bid/ask in excel via DDE but am looking to get the order ticket into excel.
Any help would be appreciated.
Thanks