Questions tagged [returns]

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.

Filter by
Sorted by
Tagged with
0
votes
0answers
27 views

Estimating the XIRR of a very non uniform cash flows

It's my second post, so please bear my lack of experience in this field. I've a very irregular cash flow (here you can see the set of date - cumulative cash flow) The XIRR, calculated with Excel, is ...
1
vote
1answer
41 views

Event study using sector indices

Analyzing Covid-19's impact on different sectors I would like to use sector indices. Can you use CAPM or similar to calculate abnormal returns of indices or does it only work with stock prices?
0
votes
0answers
28 views

Performance return of holdings if you know the returns of top10 holdings?

I think this is a simple question, but struggling to get my head around it. There is a fund that showcases its top 10 holdings and their respective weights. I want to infer the performance of the rest ...
0
votes
1answer
74 views

Which relation stands between IRR and the cumulative profits?

In the graph below you can see an irregular Cash Flow. The graph is cumulative, on the y axes there are moneys, on the x the dates. In the second graph the IRR (...
3
votes
0answers
150 views

Does the Shannon entropy of stock returns change over time?

Shannon entropy, $H(X) = -\sum_{i=1}^n p(x) \ln p(x)$ is a probabilistic measure of randomness or disorder within a random variable's probability distribution or histogram. If we take rolling window ...
0
votes
1answer
90 views

How to calculate Money-weighted Rate of Return when there are multiple negative cash flows during investment period?

I know that when there are multiple changes of sign in the sequence of cash flows of a project, the project may have multiple IRR, which render this criterion impractical. Therefore, in such ...
2
votes
1answer
74 views

Correlation sensitivity in multivariate $t$-copula for portfolio VaR of electricity futures using Kendall's tau-$b$ correlation matrix

My t-copula model captures the daily dollar returns of a portfolio of approximately 400 assets. I am curious if there's a generally accepted way to quantify the sensitivity of portfolio movements with ...
0
votes
3answers
111 views

Modelling NPV with negative cashflows?

When making capital investment decisions that have cost saving implications instead of cash flow generation, is NPV still valid? For example: A state wishes to decide whether to replace a section of ...
2
votes
2answers
94 views

How to calculate monthly returns in R for every company in a dataset of 4000 companies?

I want to calculate monthly returns for a time series of 4000 companies between 2014 and 2019. This is how my dataset looks like I'm using the following code to calculate the returns nyseamex <- ...
0
votes
1answer
49 views

Using Taylor formula with logarithmic returns

I would like to calculate PnL scenarios for an FX portfolio using Taylor series approximation: $$ \begin{align} \text{PnL} \approx \delta \Delta r + \frac{1}{2} (\Delta r)^2 \Gamma \end{align} $$ I ...
0
votes
1answer
49 views

How can a stock have negative returns but positive 3-factor alpha?

I've come across a research paper where for a specific period of time, the portfolio has negative returns (or roughly flat returns). During this same period of time, the portfolio's Fama-French 3-...
0
votes
1answer
54 views

Annualised returns and volatility for 3 month data

I have a portofolio with 30 indexes and I want to calculate the annulised returns and volatility because I want to compare it with another portofolio with different number of indexes (but same time ...
0
votes
1answer
80 views

How to up-sample monthly returns into daily returns?

I know how to down-sample daily returns (large-sample data) to monthly returns (small-sample data) by using rolling windows, which feels like estimating a sub-sample from the population (something ...
0
votes
0answers
38 views

Cumulative returns from ROI of individual trades

I've a series of ROIs: $R(n) = [r_1, r_2, ... r_n]$ generated from taking $n$ trades. Each ROI value is in percent $[0, 1]$. How do I generate cumulative return $C(n)$ from this data? My understanding ...
0
votes
2answers
43 views

Calculating excess returns with 3M T-Bill

I have to calculate weekly log excess returns using the 3-month T-bill. However I am not really sure if I am doing this correctly. This is what I did: first I calculated the returns with ln(price/...
0
votes
1answer
90 views

pairs trading algorithm with returns

I'm having a difficulty grasping how to write a pair algorithm using returns instead of prices. With price differences, I have the mean difference over a long time period. When the current price ...
1
vote
1answer
51 views

Calculating Dollar-Neutral Strategy Net Return

An example in the book, Quantiative Trading, the net return of a dollar neutral strategy of IGE and SPY is calculated. ...
7
votes
5answers
5k views

How to calculate compound returns of leveraged ETFs?

Forewarning: this is a complete newbie question :-) I am starting to learn about ETFs by trying to do the numbers. When learning about the compounding effect in leveraged ETFs, I wanted to simulate ...
0
votes
0answers
108 views

Inter-temporal structural stability of stock markets

For my bachelor thesis I am trying to determine structural stability of some stock market in the following way: Identify an ARMA model for the whole sample Split the sample in two parts, and estimate ...
0
votes
0answers
33 views

variance of asset returns linear for time

I am reading Wilmott's book, "Quantitative Finance" and try to understand the derivation that the variance of asset-returns, $V[\Delta S/S]$, is a linear function of the time step $\delta t$....
0
votes
0answers
39 views

internal rate of return ((M/X)IRR ?) of a fund

I have the following data for a fund. The contributions come from the LPs (i.e., the investors invest more in the fund, or withdraw money from the fund), MV stands for market value. The timing is not ...
0
votes
0answers
22 views

Calculation of 5-minute returns

My goal is time series clustering, I would like to compare 5 minute returns, liquidity seems to be very low sometimes, so is it better idea to calculate average volume weighted price in 5 minute ...
1
vote
1answer
80 views

Do EWMA weights remove autocorrelation in asset returns?

I know that the exponentially weighted moving average (EWMA) volatility estimator drapes a decaying weight function over historical returns in order to weight the past according to the decay of their ...
2
votes
2answers
85 views

Convention for computing returns on bond futures

From the CME website, we know that the contract unit for bond futures is "face value at maturity of $100,000". Which of the following is more appropriate the convention to compute "...
3
votes
2answers
120 views

Interpretation of a uniform asset return distribution

Typically asset return distributions are bell-shaped with most mass occurring in and around the center, 0% returns, and less so in the tails, with the left tail representing the probability of large ...
1
vote
0answers
48 views

Formula for coskewness and cokurtosis of LogN to project linear returns

I want to find the coskewness and cokurtosis of the multivariate LogN(mu, sigma) distribution from the moments of a normally distributed multivariate distribution (ie: log returns). These higher order ...
0
votes
1answer
89 views

How important is the chronological ordering of historical returns?

The returns of asset $A$ in chronological order are 0.03 0.01 -0.04 0.02 0.05 -0.10 0.02 The expected return, or sample mean, is $-0.00143$ while its sample ...
1
vote
4answers
306 views

How to calculate return on investment for an adjustment to a complex options position?

Say I currently hold a set of options positions with the same symbol/expiry that collectively have a net present value based on the estimated value at expiration of +10. I could also liquidate the ...
0
votes
2answers
110 views

What kind of returns should I use for my model?

I'm building a machine learning model with the aim of learning a daily strategy of buy or sell the stock. I was wondering if I should use adjusted close price or something else to calculate returns (I ...
1
vote
1answer
479 views

How do you define returns when price may be negative (electricity price)?

I'm trying to model GARCH volatility on electricity prices. Typically the first step is to use prices to obtain log returns to make them stationary. I have encountered a small problem however: ...
0
votes
1answer
80 views

Monte Carlo approach and methods for generating random returns

Recently I found myself reading more about Monte Carlo approach in m.v. portfolio optimization framework. I already discuss the topic on this forum (if interested please consider the following links - ...
0
votes
3answers
244 views

Are cumulative returns stationary?

Log differenced returns, computed from stock prices, are known to be stationary. What about cumulative returns, are they also stationary? if not why not? Are there other properties, like non-i.i.d., ...
1
vote
1answer
352 views

Return Contribution for Annual Returns

I have a portfolio $p$ made up of a bunch of assets $i$ where the weights change slowly over time. The returns over each period $j$ composed of the weighted returns of the asset $r^j_p$ $$ r^j_p =...
0
votes
1answer
34 views

How to deal with missing stock returns?

If I want to calculate the Covariance between two stocks but there are missing days in both, how can I deal with missing data? I want to use Pairwise deletion and only use the days of which both ...
0
votes
1answer
108 views

How to apply derived beta to daily change?

I've taken three months of price return data for two instruments and calculated a $\beta$ between the two using the formula $\beta = \frac{Cov(x,y}{Var(y)}$ with the goal of estimating what the ...
0
votes
1answer
54 views

Calculate annualized returns and annualized volatility from monthly returns?

I have a dataset with monthly returns (In decimals) Jan-2008, Feb-2008 .... Dec-2008, Jan-2009 .... Dec-2017 This is what I have done, ...
0
votes
0answers
31 views

Excess Daily Returns to Excess Quarterly Returns

I am building a model which predicts the Excess Daily Returns over a time period. How do I convert these excess daily returns to excess quarterly returns? Should I just do an average of all the daily ...
0
votes
1answer
47 views

Mutual fund performance over time

I am a little bit stuck with my dissertation thesis, so help will be greatly appreciated. I am trying to analyze the performance of different mutual funds, which I have classified according to ...
17
votes
5answers
70k views

Calculating log returns using R

I am trying to calculate the log returns of a dataset in R using the usual log differencing method. However, the calculated data is simply a vector of zeroes. I can't see what I'm doing wrong. Here ...
0
votes
0answers
59 views

Volatility of multimodal distribution of returns

Take $x_1, x_2, \ldots, x_T$ to be the price of a stock, indexed by $t=1, 2, \ldots, T$. Define rate of return at time $t>W$ for a window size of $W$ to be $$r_t = \frac{x_t - x_{t-W}}{x_{t-W}}$$ ...
0
votes
1answer
109 views

Is it always better to use the entire distribution of a financial dataset, not just mu and sigma?

In finance models that use historical returns for inputs, including option pricing models, forecasting and portfolio optimization, only the statistical moments of the returns distribution, $\mu$ and $\...
0
votes
1answer
76 views

Predict Log Stock Return Direction and Trading Strategy

The $k$ period log return is defined as $$r_{t}(k)=log(S_{t}/S_{t-k}),$$ Where $S_{t}$ is the stock closing price at time $t$. For argument sake, assume that by time I mean a stock trading day and ...
0
votes
0answers
23 views

Portfolio models that maximize cumulative returns

Portfolio optimization typically looks at minimizing portfolio volatility, or maximizing the portfolio's Sharpe ratio (risk-adjusted return), but are there any recent, reasonable approaches to ...
1
vote
1answer
153 views

Why do cumulative returns have a bimodal distribution?

Regular returns (log-differenced prices) have statistical distributions that are bell-shaped and unimodal (one mode/peak) despite being non-normal and fat-tailed. Cumulative returns, on the other hand,...
1
vote
1answer
5k views

What are DGTW adjusted returns?

Many papers, e.g. in The Journal of Finance, discuss DGTW adjusted returns (or DGTW abnormal returns) instead of just returns. What are these and how does one compute them?
1
vote
1answer
69 views

How to compute portfolio returns when constructing a dollar-neutral portfolio

I am trying to wrap my head around this statement: dollar-neutral portfolios are built: dollar amounts of both long and short positions are equal. Furthermore, it is also true at the stock level: ...
0
votes
0answers
38 views

How to annualize skewness and kurtosis of a forecasted distribution

I have a (non-normal) distribution of expected cumulative returns 10 quarters in the future, from which I have calculated mean, standard deviation, skewness and kurtosis. I would like to annualize ...
1
vote
0answers
48 views

Cumulative returns are more correlated than non-cumulative

I was just comparing two daily returns series and noted that the correlation between them is a lot higher if they are cumulated (about .95 for cumulative returns, vs .15 for non-cumulative). I feel ...
3
votes
2answers
213 views

Normality or Log-Normality of Regular Returns

Another old question on this site (How to simulate stock prices with a Geometric Brownian Motion?) inspired me to ask the following question: if we assume that regular returns could be normally ...
1
vote
0answers
49 views

Get the weights of porfolio variance given standard deviation

I am trying to create a Simulated Portfolio Optimization based on Efficient Frontier on 50 stocks, which you can find the csv here. Yet it already takes me several minutes to get a suboptimal solution:...

1
2 3 4 5
9