Working with Excel (tools, indicators, conversion ...) - Page 14

peterdias77 · 07-22-2008, 06:42 PM

Can some one give me code to read CSV file row by row and extract value of each cell ?

Format of excel, please see pic:

Thanks in Advance

newmont · 07-26-2008, 02:02 AM

Here is a simple program that i found over in forex factory that transfers the 1 hour and daily data into a the files folder in your brokers file folder in program files. Install it as an expert and its should send the csv file to the folder which you can use in excel.

basza · 08-02-2008, 02:36 AM

Hi

Could someone please post a formula for working out the pip value of the pairs.

Thanks in advance

Linuxser · 08-02-2008, 03:16 AM

Quote:

Originally Posted by basza

Hi

Could someone please post a formula for working out the pip value of the pairs.

Thanks in advance

That depends on pair, account type, broker and include leverage is best.

A EURUSD standard account should be $10/lot. With a mini $1/lot.

But for CHF currently is $0.95

It's different for every pair and sometimes different for brokers. Best is to look at your broker values, specially for synthetic crosses.

Some help

Currency Converter for 164 Currencies

basza · 08-02-2008, 03:26 AM

Quote:

Originally Posted by Linuxser

That depends on pair, account type, broker and include leverage is best.

A EURUSD standard account should be $10/lot. With a mini $1/lot.

But for CHF currently is $0.95

It's different for every pair and sometimes different for brokers. Best is to look at your broker values, specially for synthetic crosses.

Some help

Currency Converter for 164 Currencies

Thanks Linuxser for that link.

I'm trying to get pip values onto the dde spreadsheet that came with mt4, so have to try and find what gets / and * by what.

basza · 08-02-2008, 04:16 AM

Quote:

Originally Posted by Linuxser

That depends on pair, account type, broker and include leverage is best.

A EURUSD standard account should be $10/lot. With a mini $1/lot.

But for CHF currently is $0.95

It's different for every pair and sometimes different for brokers. Best is to look at your broker values, specially for synthetic crosses.

Some help

Currency Converter for 164 Currencies

Hi Linuxser

Do this values look right. I won't be able to test them till the market opens again as the are linked to the dde feed.

Linuxser · 08-02-2008, 02:17 PM

Quote:

Originally Posted by basza

Hi Linuxser

Do this values look right. I won't be able to test them till the market opens again as the are linked to the dde feed.

Seems it's ok.

Just make the calculation...

USD/CAD it's 1/1.0274 = 0.9733

0.9733 X 1 standard lots = 9.7333 pip/lot

Latino · 08-12-2008, 02:48 PM

Hi,

Somehow i got moved to a fibo thread last time so am attempting to post again. My query has nothing to do with fibo, more of a programming issue.

I am attempting to develop a link between excel and metatrader, using either the DDE or APi. I would like to be able to send orders from excel to metatrader . Also account details and order sizing so i can set my own MM criteria from excel.

What is the simplest way to do this and where can i find the applets or whatever that is required to achieve this?

I have the API code but m not sure how to use it. I had an earlier version that used DDE but canot fid the code for it.

Any help would be apprciated.

Regards

Latino

pj9100 · 08-18-2008, 11:53 AM

Quote:

Originally Posted by 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.

newdigital · 08-18-2008, 12:20 PM

I do not know sorry (it is necessary for me to read and so on).
Anyway, thanks for the link.

LinkBacks (?) LinkBack to this Thread: http://www.forex-tsd.com/tools-utilities/4457-working-excel-tools-indicators-conversion.html
Posted By	For	Type	Date
hilbert transform trend line	This thread	Refback	01-31-2008 10:08 PM
Ôèíàíñîâàÿ êîìïàíèÿ UMIS: Ôîðåêñ (Forex), îáó÷åíèå Ôîðåêñ (FOREX) òðåéäåðîâ, èíòåðíåò-òðåéäèíã, áèðæåâàÿ èãðà íà ðûíêå Forex, èãðà íà áèðæå. Ôîíäîâûé ðûíîê, ôüþ÷åðñû	This thread	Refback	01-30-2008 08:54 AM
hilbert transform trend line	This thread	Refback	01-25-2008 10:06 AM
Biznes i handel » Forex - systemy i strategie :: RE: hilbert transform trend line	This thread	Pingback	01-25-2008 09:23 AM
Firma - Twoja firma » Blog Archive » Forex - systemy i strategie :: RE: hilbert transform trend line	This thread	Pingback	01-25-2008 08:51 AM
Working with Excel (tools, indicators, conversion ...) - Forex Trading	This thread	Refback	12-28-2007 04:09 AM

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mql2Mq4 Conversion Tool Beta V0.2	yousky	Tools and utilities	33	10-20-2006 09:59 AM
4 Hr Expert very profitable needs conversion	saslam	Expert Advisors - Metatrader 4	8	09-24-2006 12:57 PM
Some useful tools ( portable version, so, working WITHOUT installation )	De Vinci	Tools and utilities	1	08-18-2006 04:16 PM
Thread subscription tools not working	cardio	General Discussion	1	02-21-2006 08:13 PM

Register in Forex TSD!
Trading Systems Leaders in this forum (automated trading systems) are winning more than 3000 pips in a month (30000$ investing one lot every time). Click here to register and get more information