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

paco99 · #**121** (**permalink**) 06-09-2008, 01:47 AM

Is it possible for an event in Excel to trigger a buy or sell using MetaTrader?

I have Excel performing my calculations, and I want a buy to take place if the value of one particular cell is greater than 10. Is this possible to do with MetaTrader?

Thanks,

Paco

jfx88 · #**122** (**permalink**) 06-09-2008, 03:27 AM

I don't know how to do it, but yes it's possible.
I've seen many other software that can do this.
for example, the news trader software that can automatically place your buy/sell order to MT4 platform.
Hope anyone have any idea?

thanks,
jfx88

Foreverold · #**123** (**permalink**) 06-15-2008, 04:11 AM

convert metatrader data to prn source

earlier in the thread I believe ND said his traderxl did not work, mine does,
if I am allowed to post it I will the serial number is included

f4mnect · #**124** (**permalink**) 06-25-2008, 10:16 AM

theres 3 pages to this, 1st page currency info, nothing to new here but a different visual and take on things, been done before, 2nd page i'm excited about...risk calc, I think me and my partner did a hell of a job on this, lol. 3rd page something I saw before and liked, Please look it over and give me your thoughts. Sorry only 6 currencys but those are the 6 I trade

lordgbengs · #**125** (**permalink**) 06-26-2008, 03:12 PM

pls does anybody knows how to convert OHLC(open,low,high and close) from excel spreadsheet to draw candlesticks on metatrader4 ,tnx

f4mnect · #**126** (**permalink**) 06-30-2008, 09:00 AM

Could anybody help me, I want to be able to import the daily open into excel and not have to do it manualy everyday

f4mnect · #**127** (**permalink**) 06-30-2008, 09:10 AM

I tried =MT4|OPEN!EURUSD but with no luck, is that right or how might i be able to import the daily open

kenleyl · #**128** (**permalink**) 07-01-2008, 05:20 PM

I am plotting objects at various times on a chart and would like to know how to get various indicator values for the points in time where the objects are plotted. Similar to the data window feature in MT4.

Example - if I create an arrow object on a chart as follows:

ObjectCreate("buy_arrow", OBJ_ARROW, 0, D'2008.06.30 3:30', 1.5785)

How can I get rsi value for the exact point where that object lives on the chart?

Thanks,
Ken

fairwind · #**129** (**permalink**) 07-09-2008, 09:31 AM

Hello folks,

I have been struggling with a formulation which searchs the time value, I can't find the correct way ( if there is one ?). The attached zip file shows two days of data from the currency pair GBP/USD on an hourly basis, which has Time, Open, High, Low, Close along with my poor attempt to formulate time in column G.

What I want to do is ....

"only calculate the difference between Close and High in the hour of 22:00"

I have an average understanding of programming XLS and can handle the "difference" part but not the "search Time" part. ( The formula I have in Col. G is incorrect in that it calls for the Time again, instead of Open in Col. C, all of which gives me error messages ).

Can anyone offer me some guidance in this problem?

Thanks for all assistance offered ...

forexsvoboda · #**130** (**permalink**) 07-22-2008, 06:19 PM

Hello.

I have one question. How to get data from indicator iEXposure to excel....How can it I transfer direct to the excel tabele...

I now to used the current data in excel (like: =MT4|BID!EURUSDm....)

I need, that i can transfer data from deals, buy, sell and so one....

Please, could me someone help by this problem?

Thanks