Presenting MT4 data in MS Excel in multiple Time-frames?

 

Hi

I need help on how to write MT 4 formula for MS Excel worksheet in multiple time-frames to be able to see what a currency pair has done in the last 12 hours, 24 hours, past week till now and past month till now, in a form of heat-map represented visually just like it is presented on these websites http://www.actionforex.com/markets/data/currency-heat-map-2009031181561 or http://finviz.com/forex_performance.ashx so that you know the strength and weakness of different pairs over a period of time, be able to know which one is trending, consolidating, stalling and which one is just ready to move.

Thanks.

 
Ah. So after Spamming the living daylight out of us, you finally decided to create your own post? Sigh.
Reason: