1
$\begingroup$

I am confused about the following: I checked daily and weekly prices for Exxon (and also GE). But the values for Open, Low, High, Close, Vol., Adj. Close for both data streams seem to differ from each other.

Example (Exxon financial data via Finance Yahoo):

---Date ----------------- Close -------------- Close

Jan.19.1970 ----- 60.25 (weekly) ----- 61.87 (daily)

or

Sep.18.2014 ----- 95.78 (weekly) ----- 97.77 (daily)

On the eye it seems that the only value which is the same in both data streams is Open price.

Why is this? Normally I would suggest that it should be possible to convert a daily dataset into a monthly dataset.

Hope anyone can help to solve the confusion.

Cheers Peter

$\endgroup$
0
$\begingroup$

enter image description here

If you look at the image above you will find data for Exonn mobile. The first 10 rows are daily data and below that is weekly data. I have calculated the weekly price for daily closing values. The red coloured cell is the average for the brownish cells, which is similar to the green cell (weekly price from yahoo finance).

So they have taken average price for the next next 4 days (after 6th) and assigned that value to the first date (6th). I do not thing it is the right way to do.

I would suggest you to download the daily price and make further changes in it, rather than using weekly data from Yahoo finance or let it be any source.

$\endgroup$
  • $\begingroup$ Very interesting. This makes no sense to me why Yahoo is doing this. Wonder if other data providers do the same!? And what is the intention of this? Would be very happy to hear other opinions? $\endgroup$ – Peter Sep 24 '14 at 11:16
  • $\begingroup$ This is just the process of defining a week. I am fine with their defining of the week if they are consistent with one definition. Mostly during analysis depending on the characteristic of the variable, by characteristic I mean stock/flow, aggregate figures are defined average or last value. Hence, I prefer to deal with daily values and defining aggregate figures as per my requirement, rather than using theirs. It would be problematic if they change the definition later. $\endgroup$ – vikram Sep 24 '14 at 12:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.