Dear all,
I am a new user of Stata that is facing some difficulties! I am asking for help :-)
I have the following dataset:
In other words, for fund ID 3, I would like the average of "Index_return" over 12/31/1993, 01/01/1994, 01/02/1994 until 05/15/2001.
I hope I was clear and I would be very pleased if you could help!
Thank you in advance,
Best regards,
Max
I am a new user of Stata that is facing some difficulties! I am asking for help :-)
I have the following dataset:
- Fund ID represents the identification of a particular fund (can be 3, 10, 1512, etc.).
- TDate represents the date at which the flow of the column NetCFs occured. These dates are different across funds.
- For each fund, I thus have a different start date (for fund ID 3, it is 12/31/1993, the date of the first flow) and end date (for fund ID 3, it is let's say 05/15/2001, the date of the last flow (not displayed)).
- Index_return represents the return over a benchmark (e.g. the S&P500) for each "IndexDate" (from 01/01/1980 to today).
In other words, for fund ID 3, I would like the average of "Index_return" over 12/31/1993, 01/01/1994, 01/02/1994 until 05/15/2001.
I hope I was clear and I would be very pleased if you could help!
Thank you in advance,
Best regards,
Max
Comment