Finding the difference between the first and last trading days of a quarter

**GS751** · 05-22-2011, 05:57 PM

In the A column I have the date of the trading day from Jan. 3rd 1950 - present
A2 = 12/31/2010
A15350 = 1/3/1950
In the B column I have the closing value of the S&P 500 from Jan. 3rd 1950 - present
B2 = 1257.64
B15350 = 16.66
I want to design a formula to find the difference between the first and last trading day of each quarter. E.g. B65-B2

Not every quarter starts on the first of the month of the month and ends on the 30th or the 31st due to holidays.

I am getting stuck and any help would be greatly appreciated.

**martindwilson** · 05-22-2011, 06:10 PM

what defines the start of each quarter?

**Ron Coderre** · 05-22-2011, 06:54 PM

• Arrange your data so the dates are in ascending order in Col_A with the associated prices in Col_B

• Then build this 2-column, Year/Qtr table...mine starts in G1:H1
1950 1
1950 2
1950 3
1950 4
1951 1
1951 2
1951 3
1951 4
1952 1
etc

• This regular formula returns the EOQtr-BOQtr, Col_B difference for
the first pair: 1950, Q1

Please Login or Register  to view this content.

Copy that formula down as far as you need to get the 1950-Q2, 1950-Q3, etc differences.
Is that something you can work with?

Finding the difference between the first and last trading days of a quarter

LinkBack

Thread Tools

Rate This Thread

Display

Finding the difference between the first and last trading days of a quarter

Re: Finding the difference between the first and last trading days of a quarter

Re: Finding the difference between the first and last trading days of a quarter

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions