• Home
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • User/Email: Password:
  • 9:15pm
Menu
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • 9:15pm
Sister Sites
  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Print Thread

Similar Threads

Trading correlation pairs by using the other pairs 738 replies

MT4 MTF Correlation table and Correlation oscillator indicators 155 replies

How do I stream MT4 tick data into a spreadsheet using .CSV (no DDE)? 6 replies

Need help with importing prices from MT4 into Excel spreadsheet 1 reply

Correlation spreadsheet anyone? 6 replies

  • Platform Tech
  • /
  • Reply to Thread
  • Subscribe
  • 2
Attachments: Correlation Table - Importing OHLC Data for all pairs into a spreadsheet.
Exit Attachments
Tags: Correlation Table - Importing OHLC Data for all pairs into a spreadsheet.
Cancel

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

  • Post #1
  • Quote
  • First Post: Apr 16, 2009 8:53pm Apr 16, 2009 8:53pm
  •  babatot
  • | Joined Apr 2009 | Status: Member | 28 Posts
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.
  • Post #2
  • Quote
  • Apr 17, 2009 1:43am Apr 17, 2009 1:43am
  •  Irtron
  • | Joined Jul 2008 | Status: MQL Expert | 73 Posts
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.
 
 
  • Post #3
  • Quote
  • Apr 17, 2009 8:31pm Apr 17, 2009 8:31pm
  •  babatot
  • | Joined Apr 2009 | Status: Member | 28 Posts
I appreciate the help.
 
 
  • Post #4
  • Quote
  • Last Post: Feb 3, 2014 4:40pm Feb 3, 2014 4:40pm
  •  9047
  • Joined Jun 2011 | Status: Nominal | 304 Posts
Hi Bababot,

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

Multi-time frame table
Attached Image (click to enlarge)
Click to Enlarge

Name: eurusd_corr_table_demo.gif
Size: 25 KB


Oscillator
Attached Image (click to enlarge)
Click to Enlarge

Name: euraud_corr_oscillator_demo.gif
Size: 27 KB


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
 
 
  • Platform Tech
  • /
  • Correlation Table - Importing OHLC Data for all pairs into a spreadsheet.
  • Reply to Thread
0 traders viewing now
Top of Page
  • Facebook
  • Twitter
About FF
  • Mission
  • Products
  • User Guide
  • Media Kit
  • Blog
  • Contact
FF Products
  • Forums
  • Trades
  • Calendar
  • News
  • Market
  • Brokers
  • Trade Explorer
FF Website
  • Homepage
  • Search
  • Members
  • Report a Bug
Follow FF
  • Facebook
  • Twitter

FF Sister Sites:

  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Forex Factory® is a brand of Fair Economy, Inc.

Terms of Service / ©2023