Working with Excel (tools, indicators, conversion ...) - page 15

PJ Lal
109
PJ Lal  
newdigital:
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

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.

Sergey Golubev
Moderator
107288
Sergey Golubev  

I do not know sorry (it is necessary for me to read and so on).

Anyway, thanks for the link.

Linuxser
5921
Linuxser  
pj9100:
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.

toddanderson
495
toddanderson  

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

kikiq
11
kikiq  

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

Files:
qqe.mq4 4 kb
toddanderson
495
toddanderson  

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

Linuxser:
This works?

='MT4'|HIGH!EURUSD

='MT4'|ASK!EURUSD

='MT4'|BID!EURUSD

='MT4'|LOW!EURUSD
Linuxser
5921
Linuxser  
toddanderson:
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

There is no explanation about Volume on the help files and I can't find any information about.Sorry

toddanderson
495
toddanderson  

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.

Linuxser:
There is no explanation about Volume on the help files and I can't find any information about.Sorry
Latino
10
Latino  

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

toddanderson
495
toddanderson