I apologies ahead of time if this is already answered, do point me in the right path if that were to be the situation. I've managed to store BID and ASK prices using xlsgate. I'm having a hard time to add timestamp there's a shift in price. How would one go about coding that into mqlexcel?

I am by no means a coder, barely a scriptkiddie if you will. So I apologies beforehand if this code appears rubbish.
This is how it looks like:

Inserted Code //p ------------------------------------------------------------------ //| Test1.mq4 | //| Copyright 2015, MetaQuotes Software Corp.. | //| https://www.mql5.com | // ------------------------------------------------------------------ #property copyright Copyright 2015, MetaQuotes Software Corp. #property Hyperlink https://www.mql5.com #property version 1.00 #property stringent #include lt;xlsgate.mqhgt; extern string StartBid= C3; extern string StartAsk= D3; bool xlsgateok=false; string StrBid; string StrAsk; // ------------------------------------------------------------------ //| Expert initialization function | // ------------------------------------------------------------------ int OnInit() StrBid=StartBid; StrAsk=StartAsk; if (ExcelInit(mt4) ExcelStart()) Print(XLSgate init done); xlsgateok=true; Print(Office version = ExcelVersion()); ExcelSheetAdd(MT4); //-- return(INIT_SUCCEEDED); // ------------------------------------------------------------------ //| Expert deinitialization function | // ------------------------------------------------------------------ emptiness OnDeinit(const int reason) //-- //p ------------------------------------------------------------------ //| Expert tick function | // ------------------------------------------------------------------ double lastBid=0; double lastAsk=0; void OnTick() //-- if(xlsgateok lastBid! ) =Bid) ExcelSetValue(StrBid,Bid); lastBid=Bid; StrBid=ExcelRowAdd(StrBid,1); if(xlsgateok lastAsk! ) =Ask) ExcelSetValue(StrAsk,Ask); lastAsk=Ask; StrAsk=ExcelRowAdd(StrAsk,1); //p ------------------------------------------------------------------
Update 1: Establish a solution. Nasty coding, but it functions