Results 1 to 1 of 1
 0 Attachment(s)    

Thread: Get the value of the end of month with excel

  1. #1
    Senior Member fxtester's Avatar
    Join Date
    Nov 2008
    Posts
    3,165

    Default Get the value of the end of month with excel

    Get the last day of the month

    Code:
    =MAX(IF((MONTH(dates)=MONTH(Z409))*(YEAR(dates)=YEAR(Z409));DAY(dates);0))
    Then we get the respective date :

    Code:
    =Z409+AA409-1
    Then we index the value :

    Code:
    =INDEX(values;MATCH(AB409;dates;0))
    Last edited by fxtester; 01-29-2015 at 15:55.

Similar Threads

  1. Relative drawdown calculation in Excel
    By fxtester in forum MQL programming
    Replies: 0
    Last Post: 02-28-2015, 10:57
  2. Min if month with excel
    By fxtester in forum General discussion
    Replies: 0
    Last Post: 01-29-2015, 09:30
  3. Max if month with excel
    By fxtester in forum General discussion
    Replies: 0
    Last Post: 01-29-2015, 02:41
  4. EXCEL INDICATOR
    By ptcbuxz in forum Indicators
    Replies: 2
    Last Post: 02-09-2014, 13:50
  5. Excel data into Metatrader
    By jeet1970 in forum MQL programming
    Replies: 6
    Last Post: 09-20-2009, 19:36

Tags for this Thread

index

Posting Permissions

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