Forex
Google
New signals service!

Go Back   Forex Trading > Downloads > Tools and utilities


Register in Forex TSD!
Trading Systems Leaders in this forum (automated trading systems) are winning more than 3000 pips in a month (30000$ investing one lot every time).
Click here to register and get more information

 
 
LinkBack (6) Thread Tools
 
Old 12-16-2007, 04:26 PM
Wackena's Avatar
Senior Member
 
Join Date: May 2006
Posts: 216
Wackena is on a distinguished road
New Excel Trading Technology

SpoozTools.com soon will be offering new trading technology to individual clients. It seems to be be getting a good reception from major trading houses. IHUB discussion board is a good source of DD.

This link is for a video demo of this new trading technology.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
 
Old 12-25-2007, 11:10 PM
Junior Member
 
Join Date: May 2006
Posts: 3
mosad2 is on a distinguished road
Import Weekly Data into an excel Sheet

Guys,

Do u know how I can import data from weekly chart into an excel sheet?
I want to import for example
date of week, opening price of the week and closing price of the week
live and historical.

any way to do this?

Regards
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
 
Old 12-26-2007, 12:11 AM
Senior Member
 
Join Date: Jun 2006
Posts: 1,231
prasxz is on a distinguished road
hi

Quote:
Originally Posted by mosad2 View Post
Guys,

Do u know how I can import data from weekly chart into an excel sheet?
I want to import for example
date of week, opening price of the week and closing price of the week
live and historical.

any way to do this?

Regards
did u mean export ?

open your MT4 go to tools ===> History Center ====> find your weekly data ======> export that's it

===================
Forex Indicators Collection
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
 
Old 12-26-2007, 12:49 AM
Senior Member
 
Join Date: Nov 2006
Posts: 215
luxinterior is on a distinguished road
If you take a look in your metatrader folder you'll see a file called 'DDE-Sample.xls'. If you open this you'll see how data is imported via dde.

Regards

Lux
__________________
Build An Expert Advisor. FREE E-course As Seen On TV
ForexArea.com
Users of Gap Trader from 'Forex-Assistant' MUST Read This
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
 
Old 01-12-2008, 02:38 PM
McDuck's Avatar
Junior Member
 
Join Date: Mar 2006
Location: Greece
Posts: 12
McDuck is on a distinguished road
Help with EXcel

Hi fellow traders.

You know it is possible to export data from MT4 to excel. I have done this, but I only want to use the closing prices.

The way the exported file is constructed, I cannot select only the close.

Does anybody know how you can seperate the values in the exported file, in Excel? There seems to be just one big cell that has date,time,open,high,low,close,volume. I only need close.

Thank you.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
 
Old 01-12-2008, 05:49 PM
Guyver's Avatar
Senior Member
 
Join Date: Mar 2006
Posts: 784
Blog Entries: 16
Guyver is on a distinguished road
Hi

Quote:
Originally Posted by McDuck View Post
Hi fellow traders.

You know it is possible to export data from MT4 to excel. I have done this, but I only want to use the closing prices.

The way the exported file is constructed, I cannot select only the close.

Does anybody know how you can seperate the values in the exported file, in Excel? There seems to be just one big cell that has date,time,open,high,low,close,volume. I only need close.

Thank you.
Edited... I understood the problem wrong..

Last edited by Guyver; 01-12-2008 at 07:55 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
 
Old 01-12-2008, 07:24 PM
zupcon's Avatar
Senior Member
 
Join Date: Dec 2005
Location: Malta
Posts: 235
zupcon is on a distinguished road
Quote:
Originally Posted by McDuck View Post
Hi fellow traders.

You know it is possible to export data from MT4 to excel. I have done this, but I only want to use the closing prices.

The way the exported file is constructed, I cannot select only the close.

Does anybody know how you can seperate the values in the exported file, in Excel? There seems to be just one big cell that has date,time,open,high,low,close,volume. I only need close.

Thank you.

If you just double click the file to open, then you'll end up with everything all mixed together in one cell.

To get around this problem, you need to use Excels file import wizard. Click "Data" on the main menu, then "Import External Data" then "Import Data"

The wizard will start, and you'll need to select the file you want to import, and specify what delimiter is being used etc. Each value will then end up in a column of its own.

hope this helps.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
 
Old 01-28-2008, 08:43 AM
Junior Member
 
Join Date: Apr 2007
Posts: 2
diiib is on a distinguished road
How to import data from excel?

can mt4 import data from excel (or from text file)?
It seems difficult for me,can someone help me? thanks!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
 
Old 01-29-2008, 12:06 AM
Linuxser's Avatar
Moderator
 
Join Date: May 2006
Location: Helliconia (Spring)
Posts: 3,303
Blog Entries: 46
Linuxser has disabled reputation
Quote:
Originally Posted by diiib View Post
can mt4 import data from excel (or from text file)?
It seems difficult for me,can someone help me? thanks!
Not from native XLS, MT4 supports ASCII (CSV, PRN and TXT)

Take a look at History Center to find more info.

Or go to :
1-Userguide (with F1)
2-Open Tols
3-Select History Center
__________________
Elite Manual Trading | Portfolio | Calendar | Suggestions to improve the forum | My Blog

Remember: Signatures must have three lines as maximum
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
 
Old 02-09-2008, 04:21 AM
Dreamliner's Avatar
Senior Member
 
Join Date: Jul 2007
Posts: 126
Dreamliner is on a distinguished road
Spreasheet Request

Greetings, can anyone post a simple Excel spreadsheet that I could use to keep track of pips won/lost on multiple pairs, with a sum total at the bottom? Such as column 1 would be EUR/USD, column 2 would be GBP/USD, etc. and I would just enter the number of pips won/lost for the day and the running total would be at the bottom?

I'm just not good with spreadsheets at all but would sure like to have this, if anyone could put it together.

Thank you in advance.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
 

Bookmarks

Tags
adaptive moving average excel, excel, forex excel, Kaufman, parabolic SAR calculation excel, parabolic sar excel, parabolic sar formula excel, kaufman, Excel Hilbert transform
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

LinkBacks (?)
LinkBack to this Thread: http://www.forex-tsd.com/tools-utilities/4457-working-excel-tools-indicators-conversion.html
Posted By For Type Date
hilbert transform trend line This thread Refback 01-31-2008 10:08 PM
Финансовая компания UMIS: Форекс (Forex), обучение Форекс (FOREX) трейдеров, интернет-трейдинг, биржевая игра на рынке Forex, игра на бирже. Фондовый рынок, фьючерсы This thread Refback 01-30-2008 08:54 AM
hilbert transform trend line This thread Refback 01-25-2008 10:06 AM
Biznes i handel » Forex - systemy i strategie :: RE: hilbert transform trend line This thread Pingback 01-25-2008 09:23 AM
Firma - Twoja firma » Blog Archive » Forex - systemy i strategie :: RE: hilbert transform trend line This thread Pingback 01-25-2008 08:51 AM
Working with Excel (tools, indicators, conversion ...) - Forex Trading This thread Refback 12-28-2007 04:09 AM

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mql2Mq4 Conversion Tool Beta V0.2 yousky Tools and utilities 33 10-20-2006 09:59 AM
4 Hr Expert very profitable needs conversion saslam Expert Advisors - Metatrader 4 8 09-24-2006 12:57 PM
Some useful tools ( portable version, so, working WITHOUT installation ) De Vinci Tools and utilities 1 08-18-2006 04:16 PM
Thread subscription tools not working cardio General Discussion 1 02-21-2006 08:13 PM


All times are GMT. The time now is 08:46 PM.



Search Engine Friendly URLs by vBSEO 3.2.0 ©2008, Crawlability, Inc.