Avg. portfolio return over ten years following R&D spending

Fragen zu Stata Syntax und Do-Files.

Avg. portfolio return over ten years following R&D spending

Beitragvon AlexST » Mi 27. Jun 2018, 13:59

Dear all,

I have time series for 3 stock portfolios ("0","5" and "10") with data for R&D spending ("pfxrd") and portfolio return ("pfrt"). For each Portfolio ("pf") I want to calculate the average portfolio return over ten years following the initial year of R&D spending. I will provide the data and elaborate a bit more on it then:
Code: Alles auswählen
* Example generated by -dataex-. To install: ssc install dataex
clear
input float(year pf pfxrd pfrt)
1962 0         0  2.0433624
1963 0         0   3.235416
1964 0         0  2.0289717
1965 0         0   4.715116
1966 0       .77   2.840973
1967 0       .48    .876097
1968 0      1.41  2.4592624
1969 0      7.08  -.6605892
1970 0         0   .4436268
1971 0         0   2.881102
1972 0         0  1.0571196
1973 0         0  -3.090473
1974 0         0 -2.3816926
1975 0         0   5.344191
1976 0         0   2.180875
1977 0      4.44   .6919739
1978 0     6.248   1.340753
1979 0     8.422  2.3498313
1980 0    12.246   3.059075
1981 0    13.362   .8223675
1982 0    19.994  4.2377257
1983 0    34.747  2.1897767
1984 0    49.399 -.07765996
1985 0    54.386   2.788236
1986 0   109.911  1.9860017
1987 0   296.832   1.192912
1988 0  7507.789   2.677546
1989 0  7573.345  1.8918866
1990 0  8001.991   .7434589
end
format %ty year

Example: In 1966 the R&D spending of portfolio 0 was .77. I would like to get the portfolio return for 1 year after that date, 2 years after that date,....and 10 years after that date. This should be done for each portfolio and each year where R&D spending is positive. After that I would like to calculate the mean values of those returns for 1-10 years after R&D spending. Can anybody provide some advice, please?

Any help is much appreciated.

Best,
Alex
AlexST
 
Beiträge: 8
Registriert: Fr 15. Jun 2018, 13:07
Danke gegeben: 0
Danke bekommen: 0 mal in 0 Post

Re: Avg. portfolio return over ten years following R&D spend

Beitragvon Muchad » Do 13. Sep 2018, 12:15

In 1966 the R&D spending of portfolio 0 was .77. I would like to get the portfolio return for 1 year after that date, 2 years after that date,....and 10 years after that date. This should be done for each portfolio and each year where R&D spending is positive.
Muchad
 
Beiträge: 13
Registriert: Fr 3. Aug 2018, 05:31
Danke gegeben: 0
Danke bekommen: 0 mal in 0 Post


Zurück zu Stata Syntax

Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 0 Gäste

cron