# Tagged Questions

The asset rate of returns is the profit on a particular investment; it includes any change in the asset value, interest, commission or dividends and so, all other cash-flows which an investors receive or pays due to the investment.

414 views

### Trading days or Calendar days for Compound Annual Growth Rate?

When calculating CAGR for intervals shorter than a year (or intervals that are longer than, but not integer years in length), should you use the 252 trading days or the 365.25 calendar days? The ...
9k views

### Should I use an arithmetic or a geometric calculation for the Sharpe Ratio?

What are the advantages/disadvantages of using the arithmetic Sharpe Ratio vs the geometric Sharpe Ratio? Is one more correct? Or is one better in certain circumstances?
57 views

### How to convert Jensen's Alpha from monthly to quarterly observations

I am being puzzled while calculating jensen's alpha for single stocks. I have monthly returns data and have calculated alpha for each stock on a monthly basis (used 36-month rolling window for beta ...
105 views

### Comparing a money-weighted return of my own portfolio with a benchmark ETF/other portfolio that is subject to the same cashflows

I am able to calculate the money-weighted return (XIRR equivalent in Excel) of my portfolio. Whilst I can compare this with ‘headline’ returns of ETF’s, Mutual Funds etc, I want to isolate the timing ...
45 views

### s&p500 companies value vs growth

I was thinking of examining how the constituent companies of the s&p500 are affected by sentiment in crises. Is there any way to download stock prices for all the companies? Moreover how can I ...
195 views

### Market returns below risk free rate

Let's say I'm using CAPM to estimate the cost of equity, so I need expected market returns for the calculations. The standard approach is simply to compute arithmetic mean of an index (or rather its ...
60 views

### Why do two perfectly negatively correlated assets not return 0%? [closed]

So, per the title, why would a combination of two risky assets that have the same exact expected return and standard deviation while being perfectly negatively correlated not return 0%? Why do you ...
52 views

### Calculating weekly portfolio returns for portfolios sorted by volatility

I am having some issues with finding the right code in STATA for sorting the data into portfolios by historical volatility (standard deviation) of returns and then calculating portfolio returns and ...
7 views

### Proxying returns for PE and Alternative Investments

The data for these asset classes don't go back very far. Anyone have any methods to proxy their "index" returns for analysis?
32 views

### Rblpapi-Getting different numbers than Bloomberg

I used the following code to pull day to day total returns (net dividends) from Bloomberg Terminal for a list of securities I have. When I compare my data using the GF function in Bloomberg, I am ...
34 views

### R:log return calculation for panel data structure

I have a long form panel for hourly prices of stocks. I want to do log return calculation for this panel data structure. This is sample data: ...
14 views

### Are the returns in this regression signed returns?

In this paper about combining multiple alphas are the returns signed returns? if not wouldn't they be mean zero? Also, it mentions "realized alpha returns" - does that just mean "realized" past alpha ...
86 views

### Calculating Portfolio Returns Across Sectors

I have a table of asset (mutual fund) returns and the percentage that each asset is in a particular stock sector: ...
43 views

### cumulative return calculation, disagreement

A friend of mine and myself are having an argument on how to correctly determine cumulative return. The dataset has monthly return data and we are trying to determine the 6-month cumulative return. ...
27 views

### student-t asset path

I am trying to simulate an asset path based on a t-distribution. I found a lot of ressources and the fact that it will be difficult to do a path. But now I changed my Geometric Brownian Motion ...
23 views

### Polynomial interpolation of corrected lognormal distribution

Can anyone provide a formula for a polynomial interpolation of the corrected lognormal distribution used to model returns traditionally resulting from the wrong Brownian motion generated model? ...
75 views

### Correlation between 2 stocks [closed]

If Stock A returns 5% on average in year Y And Stock B returns 2% on average in year Y Does this mean that correlation is 40%?
120 views

### Estimation of annualized volatility depending on data frequency - exceptions to the general rule?

From my understanding, the annualized standard deviation of daily returns is generally higher than of annualized standard deviation of weekly returns is generally higher than.... monthly...quarterly......
24 views

### Why do people use weighted regression with returns?

For example, by ADV. Intuitively it makes sense that a very liquid high ADV stock should carry more weight, but when I try it with some real life data I get higher standard error than unweighted...is ...
49 views

### Modelling log-returns and calculating the portfolio return

I know this might be a trivial question, however, I would be grateful for some clarification. I am working on weekly log-return data, doing volatility-foracasting using GARCH models and then using ...
447 views

### comparing total returns from various data vendors

I need to use various data sources to cover all of my data, and I am concerned by the discrepancies in total returns. Data vendors were helpful, but their simple documentation did not help resolve why ...
55 views

35 views

### returns series for daily strategy

I have a trend following OTC futures strategy which is trading a day-ahead commodity contract. If a signal is triggered the strategy goes long / short into delivery. The holding period of a contract ...
51 views

### VaR interpretation for positive returns

I used Extreme Value Theory to separate extreme negative returns from extreme positive returns, then, I calculated the VaR for both. I need to know what could be the interpretation of VaR for ...
201 views

### How to compute simple and log portfolio returns?

I am looking for more details to perform simple and log returns for an entire portfolio. However, I've only been able to find the following semi-reliable source (see Page 9 and Page 19): Here are my ...
466 views

### How to calculate annualised tracking error?

I have 36 months of relative returns and I need to calculate the annualised tracking error. So, using 36 months of returns is it simply like below: ...
97 views

### Interpretation of t-test in event study with dummy regression

I am not sure about my interpretation of the t-ratios in dummy regression models for event studies. I have the results for two different groups of models examining the impact of news on stock returns ...
104 views

### Sharpe Ratio versus Cumulative Returns

I was asked whether Sharpe Ratio was a better measure than Cumulative Returns, in the context of hedge funds. To me, personally, Sharpe Ratio is a more important measure. By definition, it tells us ...