Forex
Google
New signals service!

Go Back   Forex Trading > Downloads > Tools and utilities
Working with Excel (tools, indicators, conversion ...) Working with Excel (tools, indicators, conversion ...)
Forex Forum Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read


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

Reply
Page 16 of 17 « First < 61415 16 17 >
 
LinkBack (6) Thread Tools Display Modes
  #151 (permalink)  
Old 10-07-2008, 06:03 AM
Member
  
Join Date: Dec 2007
Posts: 77
ztdep is on a distinguished road
read the history data
Dear friends:
I want to analyze the history data of usdchf, could you pleaase tell me how to load it into excel.
regards
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #152 (permalink)  
Old 10-07-2008, 03:55 PM
Senior Member
  
Join Date: Feb 2007
Posts: 947
FerruFx is on a distinguished road
Quote:
Originally Posted by ztdep View Post
Dear friends:
I want to analyze the history data of usdchf, could you pleaase tell me how to load it into excel.
regards
You have an excel file in your broker platform folder (DDE-Sample.xls). Check it and you will understand how it works.

Bid: =MT4|BID!USDCHF
Ask: =MT4|ASK!USDCHF
High: =MT4|HIGH!USDCHF
Low: =MT4|LOW!USDCHF
Time: =MT4|TIME!USDCHF

FerruFx
__________________
THE HEART of FOREX & THE PROBABILITY METER - Trade with 100% confidence and ... Stress Less!!!
Coding services: Experts Advisors, indicators, alerts, etc ... more info by PM
NEW: video presentation of the Probability Meter ... 24hrs action on the website
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #153 (permalink)  
Old 10-08-2008, 02:13 AM
Linuxser's Avatar
Moderator
  
Join Date: May 2006
Location: Helliconia (Spring)
Posts: 3,305
Blog Entries: 46
Linuxser has disabled reputation
Quote:
Originally Posted by ztdep View Post
Dear friends:
I want to analyze the history data of usdchf, could you pleaase tell me how to load it into excel.
regards
Hi,

Sorry to move your post but this long thread have all answers you need.

Besides, here is the short answer:

Open the History Center (Tools --> History Center or just press F2).
Go to USDCHF and double click on desired timeframe

Click on export and sabe the file. In the picture we're going to save USDCHF M30.

Note:best to import is to save file using CSV.

2008-10-07_220850.gif


Then go to your Excel and import the file. For more http://office.microsoft.com/en-us/ex...997251033.aspx
__________________
Elite Manual Trading | Portfolio | Calendar | Suggestions to improve the forum | My Blog

Remember: Signatures must have three lines as maximum
Last edited by Linuxser; 10-08-2008 at 02:15 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #154 (permalink)  
Old 10-08-2008, 02:39 AM
Senior Member
  
Join Date: Feb 2007
Posts: 947
FerruFx is on a distinguished road
Quote:
Originally Posted by ztdep View Post
Dear friends:
I want to analyze the history data of usdchf, could you pleaase tell me how to load it into excel.
regards
Sorry for my last answer. My bad. I understood wrong your need (historical datas).

Linuxser's answer is the good one!

FerruFx
__________________
THE HEART of FOREX & THE PROBABILITY METER - Trade with 100% confidence and ... Stress Less!!!
Coding services: Experts Advisors, indicators, alerts, etc ... more info by PM
NEW: video presentation of the Probability Meter ... 24hrs action on the website
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #155 (permalink)  
Old 10-10-2008, 01:17 PM
Member
  
Join Date: Dec 2007
Posts: 77
ztdep is on a distinguished road
Quote:
Originally Posted by Linuxser View Post
Hi,

Sorry to move your post but this long thread have all answers you need.

Besides, here is the short answer:

Open the History Center (Tools --> History Center or just press F2).
Go to USDCHF and double click on desired timeframe

Click on export and sabe the file. In the picture we're going to save USDCHF M30.

Note:best to import is to save file using CSV.

Attachment 70294


Then go to your Excel and import the file. For more http://office.microsoft.com/en-us/ex...997251033.aspx
Thank you very much! i am working on it by the way , how to find all my post that i posted.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #156 (permalink)  
Old 10-10-2008, 01:26 PM
Linuxser's Avatar
Moderator
  
Join Date: May 2006
Location: Helliconia (Spring)
Posts: 3,305
Blog Entries: 46
Linuxser has disabled reputation
Quote:
Originally Posted by ztdep View Post
Thank you very much! i am working on it by the way , how to find all my post that i posted.
The easy way:

Click over you own name and then click on Find all posts.

2008-10-10_092529.gif
__________________
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!
Reply With Quote
  #157 (permalink)  
Old 11-07-2008, 06:47 AM
WRR WRR is offline
Member
  
Join Date: Nov 2005
Posts: 58
WRR is on a distinguished road
Quote:
Originally Posted by elihayun View Post
I have 2 scripts that I wrote. the 1st one will write to the history, up to the datetime you can change. The 2nd will write to a CVS file. Hope it will help you
Eli
Eli,
your getprices script was very helpful. It was the first time I had ever tried writing my own script and it worked beautifully based on your sample code.

Thanks for posting it.
WRR
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #158 (permalink)  
Old 11-12-2008, 01:13 AM
giraia_br's Avatar
Senior Member
  
Join Date: Feb 2006
Posts: 140
giraia_br is on a distinguished road
Expert to read a Excel spreadsheet and put trades?
exist something like it? Than can read cells of a spreadsheet and open trades?

thanks in advance.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #159 (permalink)  
Old 11-12-2008, 01:19 AM
giraia_br's Avatar
Senior Member
  
Join Date: Feb 2006
Posts: 140
giraia_br is on a distinguished road
Expert to read a Excel spreadsheet and put trades?

exist something like it? Than can read cells of a spreadsheet and open trades?

thanks in advance.

EDIT: i just found this thread after my last post in MT4 section. I see now that i am not able to delete the previous post. If any admin wants to do it please fell free.
Last edited by giraia_br; 11-12-2008 at 01:21 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #160 (permalink)  
Old 11-12-2008, 01:24 AM
Linuxser's Avatar
Moderator
  
Join Date: May 2006
Location: Helliconia (Spring)
Posts: 3,305
Blog Entries: 46
Linuxser has disabled reputation
Quote:
Originally Posted by giraia_br View Post
Expert to read a Excel spreadsheet and put trades?

exist something like it? Than can read cells of a spreadsheet and open trades?

thanks in advance.

EDIT: i just found this thread after my last post in MT4 section. I see now that i am not able to delete the previous post. If any admin wants to do it please fell free.
I guess that bridge is yet programmed and I not trust if can be done.
__________________
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!
Reply With Quote
Reply
Page 16 of 17 « First < 61415 16 17 >

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

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

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 03:13 AM.

Contact Us - Forex TSD| Metatrader Indicators and Experts Advisors - Archive - Top


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