Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 11 to 20 of 25
Like Tree16Likes

Excel Indicators (History to Excel)

This is a discussion on Excel Indicators (History to Excel) within the Trading tools forums, part of the Trading Forum category; VR---HISTORY-EXEL - script MetaTrader 4 This is the script to generate stats for the trading and place them in excel ...

      
   
  1. #11
    Administrator newdigital's Avatar
    Join Date
    Feb 2013
    Posts
    10,477
    Blog Entries
    2951
    Follow newdigital On Twitter Add newdigital on Facebook Add newdigital on Google+ Add newdigital on MySpace
    Add newdigital on Linkedin
    VR---HISTORY-EXEL - script MetaTrader 4

    This is the script to generate stats for the trading and place them in excel file which we can find in Files folder. It can be sorted by pairs, order types and so on. This is very usefull for the traders who are analysing the trading and trading systems in excel for example.
    English version of this script is on this post to download.

    Excel Indicators (History to Excel)-excel11.png


    Excel Indicators (History to Excel)-excel1122666.png
    uncle wong and ziahassan like this.
    Premium Trading Forum: subscription, public discussion and latest news
    Trading Forum wiki || MQL5 channel for the forum
    Trading blogs || My blog

  2. #12
    Senior Member matfx's Avatar
    Join Date
    Sep 2013
    Location
    Malaysia
    Posts
    1,178
    Blog Entries
    114
    Follow matfx On Twitter
    The Jojo_Strength v1.1 excel can't be run with libreoffice or openoffice calc spreadsheet macro, so i have converted it from xlsx to xls format and now it can be run under Libreoffice/openoffice.

    Excel Indicators (History to Excel)-jojostregth.jpg
    Attached Files Attached Files

  3. #13
    Administrator newdigital's Avatar
    Join Date
    Feb 2013
    Posts
    10,477
    Blog Entries
    2951
    Follow newdigital On Twitter Add newdigital on Facebook Add newdigital on Google+ Add newdigital on MySpace
    Add newdigital on Linkedin
    This is simple lot size calculator:

    Follow the steps: First, enter your equity.
    Second, enter the percentage you are willing to risk.
    Lastly, enter the number of pips you are willing to hold the trade.
    The blue boxes will automatically calculated.
    Attached Files Attached Files
    Ace Trader Pro likes this.
    Premium Trading Forum: subscription, public discussion and latest news
    Trading Forum wiki || MQL5 channel for the forum
    Trading blogs || My blog

  4. #14
    Junior Member
    Join Date
    Jul 2018
    Posts
    1
    Hello Friend
    How can I get a DDE server and how do I insert it into my mt4? Thank you

  5. #15
    Administrator newdigital's Avatar
    Join Date
    Feb 2013
    Posts
    10,477
    Blog Entries
    2951
    Follow newdigital On Twitter Add newdigital on Facebook Add newdigital on Google+ Add newdigital on MySpace
    Add newdigital on Linkedin
    Quote Originally Posted by Guilherme Pazini View Post
    Hello Friend
    How can I get a DDE server and how do I insert it into my mt4? Thank you
    I am not using excel sorry ... I hope - some other users will reply.
    Premium Trading Forum: subscription, public discussion and latest news
    Trading Forum wiki || MQL5 channel for the forum
    Trading blogs || My blog

  6. #16
    member mql5's Avatar
    Join Date
    May 2013
    Posts
    2,464
    Blog Entries
    1682

    VR Orders History MT5 Lite

    VR Orders History MT5 Lite - script for MetaTrader 5

    VR Orders History MT5 Lite - a script for downloading trading history in the CSV format. The Lite version demonstrates a small part of the source code of the VR Orders History MT5 script.This universal script can run both on hedging and netting accounts.
    Other script versions
    Metatrader 5 / Metatrader 4 for MQL5 / MQL4 articles preview preview
    Trading blogs || My blog

  7. #17
    member mql5's Avatar
    Join Date
    May 2013
    Posts
    2,464
    Blog Entries
    1682

    Export Summary Grouped by Symbols

    Export Summary Grouped by Symbols - script for MetaTrader 5

    Excel Indicators (History to Excel)-capture2.png


    The script exports summary of closed trades selected between two dates grouped by each currency pair. The resulting file is CSV that can be opened/imported with any spreadsheet software.

    To export summary for the entire trading history, keep Start date and End date at their default values.
    Metatrader 5 / Metatrader 4 for MQL5 / MQL4 articles preview preview
    Trading blogs || My blog

  8. #18
    member mql5's Avatar
    Join Date
    May 2013
    Posts
    2,464
    Blog Entries
    1682

    Export Summary Grouped by Trading Days

    Export Summary Grouped by Trading Days - script for MetaTrader 5

    Excel Indicators (History to Excel)-capture3.png


    The script exports summary of closed trades selected between two dates grouped by each trading day. The resulting file is CSV that can be opened/imported with any spreadsheet software.
    Metatrader 5 / Metatrader 4 for MQL5 / MQL4 articles preview preview
    Trading blogs || My blog

  9. #19
    member mql5's Avatar
    Join Date
    May 2013
    Posts
    2,464
    Blog Entries
    1682

    Symbols to Excel

    Symbols to Excel - script for MetaTrader 5

    The script works with the first 5000 characters. If the symbol was successfully added to the 'Market Watch' window and there are no errors when receiving symbol prices, then the following information will be written to the ' File Name ' file: symbol name, BID price and ASK price.

    If this is the first launch, it is recommended to re-launch and then open the learned csv file in Excel.
    Metatrader 5 / Metatrader 4 for MQL5 / MQL4 articles preview preview
    Trading blogs || My blog

  10. #20
    Administrator newdigital's Avatar
    Join Date
    Feb 2013
    Posts
    10,477
    Blog Entries
    2951
    Follow newdigital On Twitter Add newdigital on Facebook Add newdigital on Google+ Add newdigital on MySpace
    Add newdigital on Linkedin
    Quote Originally Posted by joydeepb View Post
    Now u can export OSMA, MACD, ADX, SMA, RSI, CCI values to excel

    + FieldSeparator + Quote + NumberToStr(iOsMA(ccy,tf,mp[0],mp[1],mp[2],0,i),MACDFormat) + Quote
    + FieldSeparator + Quote + NumberToStr(iMACD(ccy,tf,12,26,9,PRICE_CLOSE,MODE_ MAIN,i),OHLCFormat) + Quote //MODE_SIGNAL
    + FieldSeparator + Quote + NumberToStr(iADX(ccy,tf,14,PRICE_CLOSE,MODE_MAIN,i ),OHLCFormat) + Quote
    + FieldSeparator + Quote + NumberToStr(iMA(ccy,tf,5,0,MODE_SMA,PRICE_CLOSE,i) ,OHLCFormat) + Quote
    + FieldSeparator + Quote + NumberToStr(iRSI(ccy,tf,14,PRICE_CLOSE,i),OHLCForm at) + Quote
    + FieldSeparator + Quote + NumberToStr(iCCI(ccy,tf,14,PRICE_TYPICAL,i),OHLCFo rmat) + Quote


    How to change the default period for these indicators from say 14 above to something else ... ?
    Thanks
    I am not professional with excel now (I worked with excel during the few years in past but I am not doing with excel anything now sorry).
    I hope some will reply.
    Premium Trading Forum: subscription, public discussion and latest news
    Trading Forum wiki || MQL5 channel for the forum
    Trading blogs || My blog

Page 2 of 3 FirstFirst 1 2 3 LastLast

LinkBacks (?)


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •