Dear All
I would like to calculate weekly stock prices from the daily prices data. But I don't know how to average weekly stock price.
The format I require is below:
week / stock_price
"2022-W30" xxx
"2022-W29" yyy
"2022-W28" zzz
.
.
.
"2022-W02" aaa
"2022-W01" bbb
"2021-W52" ccc
"2021-W51" ddd
Thank you very much in advance,
Travis
I would like to calculate weekly stock prices from the daily prices data. But I don't know how to average weekly stock price.
The format I require is below:
week / stock_price
"2022-W30" xxx
"2022-W29" yyy
"2022-W28" zzz
.
.
.
"2022-W02" aaa
"2022-W01" bbb
"2021-W52" ccc
"2021-W51" ddd
Code:
clear all set more off import excel "/Users/travischang/Desktop/ifo380.xlsx", sheet("sheet1") firstrow drop if price ==. gen date1 = date(Date,"YMD") format date %td order date1, after(Date) gen week_start = date - dow(date) + 1 format week_start %td gen wwy = ceil((week_start-mdy(1, 1, yofd(week_start)))/7) gen YEAR = yofd(date1) egen week = concat(YEAR wwy), punct("-")
Thank you very much in advance,
Travis
Comment