Correlation Table - Importing OHLC Data for all pairs into a spreadsheet.

I'm trying to build and maintain a spreadsheet that lists the M15 OHLC data for all (or most) currency pairs. Since I'd like to update it daily, I don't want to have to manual import data for each pair individually. I'd like to somehow update all pairs at once.

Is there a way to do it?

It's use will be for a correlation table. I'd prefer not to have to make my own, but I want to be able to work with the data, and the correlation tables that I've found on the internet:
A) are presented in image format, so I'm unable to transfer the data to the spreadsheet.
B) don't include all of the pairs I want.
C) both of the above.

Thanks in advance.

You can either write or order or maybe find a script that exports the data in CSV format that is eatable by msexcel and other spreadsheet programs.

I appreciate the help.

Hi Bababot,

I've got some indicators for this ....

Multi-time frame table


Oscillator


Would be great if you could give them a whirl. There are some issues for Linux users running MT4 under WINE but otherwise it should work.
The DLL and MQL files are all open source that is of interest to you as well the links are in the a thread.

Which you can find here (http://www.forexfactory.com/showthread.php?t=453930).

Hope you find it helpful.

Regards,

Michael