I need code to populate excell with up to 3000 last bars of historical data from Metatrader4 and keep columns updated automatically in real time at bar close with an options to delay update by x-number of seconds to prevent excel from calculation overload.
I want to build an excel page with data columns for EUR/USD, EUR/JPY, USD/JPY, GBP/USD, GBP/JPY, USD/CHF for M1,M5,M15,H1,H4,D1 timeframes. You don’t have to build the entire datasheet, but rather provide a sample - DATE,TIME,OPEN,HIGH,LOW,CLOSE,VOLUME for one currency pair EUR/USD, and PROVIDE NECESSARY code and documentation on how to proceed with the rest in a sufficient format so I can do the rest .
Excel code should retain last data even during MT4 shutdowns or disconnects
Additional Project Description:
03/28/2013 at 7:48 YEKT
Sample Excel datasheet is a delivery product. Sample Excel datasheet has to to be fully functional with following features: connecting to MT4 on the spreadsheet opening,
populating up to 3000 last historical records for specified currency pair of DATE,TIME,OPEN,HIGH,LOW,CLOSE,VOLUME,
and updating in real time on bar close with an option to delay updates by x-number of seconds.
Sample Excel datasheet has to retain last data even in case of disconnect from MT4. Both MT4 and Excel code has do be provided as complete, fully disclosed, meaning:
contain description of what each piece of code does, include installation instruction and how it can be applied to various currency pairs and time frames to collect MT4 real time updated historical data automatically into a spreadsheet.