Get the value of the end of month with excel
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,167

    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 14:55.

Similar Threads

  1. Relative drawdown calculation in Excel
    By fxtester in forum MQL programming
    Replies: 0
    Last Post: 02-28-2015, 09:57
  2. Min if month with excel
    By fxtester in forum General discussion
    Replies: 0
    Last Post: 01-29-2015, 08:30
  3. Max if month with excel
    By fxtester in forum General discussion
    Replies: 0
    Last Post: 01-29-2015, 01:41
  4. EXCEL INDICATOR
    By ptcbuxz in forum Indicators
    Replies: 2
    Last Post: 02-09-2014, 12:50
  5. Excel data into Metatrader
    By jeet1970 in forum MQL programming
    Replies: 6
    Last Post: 09-20-2009, 18: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
  •  

Get the value of the end of month with excel