updating prices

New comment
 

Dear all

I am using mt4excel.dll and shoblon script to transfer the prices from mt4 to excel. its working fine just the 4 hours prices its not updating every 4 hours alone.

I have to close MS Excel and reboot shoblon script to open a new sheet with the updated prices.

any help for updating without closing and opening again?

i am using this command for the 4 hours high: ExcelSetValueCell(9,4,iHigh("EURUSD",PERIOD_H4,0));

Thanks in advanced

 
adaheem:

Dear all

I am using mt4excel.dll and shoblon script to transfer the prices from mt4 to excel. its working fine just the 4 hours prices its not updating every 4 hours alone.

I have to close MS Excel and reboot shoblon script to open a new sheet with the updated prices.

any help for updating without closing and opening again?

i am using this command for the 4 hours high: ExcelSetValueCell(9,4,iHigh("EURUSD",PERIOD_H4,0));

Thanks in advanced

 ExcelSetValueCell(9,4,iHigh("EURUSD",PERIOD_H4,0));
Bar zero is not ended As long it is not ended the high can change
 
deVries:
Bar zero is not ended As long it is not ended the high can change

what must the zero be to change?
 
adaheem:

what must the zero be to change?
https://www.mql5.com/en/forum/141013 see post geektrader page2 maybe it helps
 
deVries:
https://www.mql5.com/en/forum/141013 see post geektrader page2 maybe it helps


I did not get any help.

will you please correct my command?

 
adaheem:


I did not get any help.

will you please correct my command?

This command 

ExcelSetValueCell(9,4,iHigh("EURUSD",PERIOD_H4,0));

you try to place the high of bar 0 that is the last running candle

the moment the candle close and becomes one you know what the high is

I don't use excel but if i search here for excelsetvaluecell i find two other topics maybe that helps you

New comment
Reason: