Yahoo financial data for weekly stock closes starts with Mondays. The series ends with the closing price that week, a Friday. How do I change the dates in Numbers so that it reflects Fridays, that is, the week ending on a certain date?

Question

Yahoo financial data for weekly stock closes starts with Mondays. The series ends with the closing price that week, a Friday. How do I change the dates in Numbers so that it reflects Fridays, that is, the week ending on a certain date?

I downloaded Yahoo financial data, the weekly prices for cetain stocks. The various weeks start with the dates for Mondays. But the closing stock prices are on Fridays. How do I change the dates in Numbers so that the weekly data series are associated with the closing dates, that is, Fridays?

Posted on Jan 22, 2012 11:01 AM

Reply

Answer 1

Jan 22, 2012 2:40 PM in response to james soriano

If I understand the problem, this should work.

Let's say the Yahoo date (Monday) is in cell B2 and you want the closing date (Friday) in cell C2. Enter the formula =B2 + 4 in cell C2 and it will add four days to the Monday which takes you to Friday.

If you run into problems check that the cells involved are formated as dates.

If I misunderstood the question post and I will try again.

Reply

Answer 2

Feb 20, 2012 11:21 AM in response to John De Banzie

John,

This worked. Belated thanks. There was another way, but I don't know the right terms to use to describe it. The dates are alpha-numeric, correct? But is there not some kind of numeric scale only, assigning a number to each day, say, in the past century? Then one would convert the alpha-numeric dates to this numeric scale kind of date (I don't know the term for it), add four, and this would bump up all alpha-numeric dates in a series by four days.

If not clear, no worry. Issue solved. Thanks again.

Reply

Answer 3

Barry

Level 9

60,023 points

Feb 20, 2012 3:28 PM in response to james soriano

James,

Dates in Numbers are a "Date and Time value". Both parts are present in every cell displaying a date or time or both. The cell may be formatted to show only the date (in several choices of format), only the time (of day, again in several formats), or both.

Where only the date part of the value has been entered, the time part is set to 00:00:00.

Where only the time part is entered, the date part is set to the date of entry.

A number added to or subtracted from a date is treated as a Duration value of that many Days (and fraction of day). The result is a Date and Time value.

Regards,

Barry

Reply