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
2
votes
1answer
495 views

R: Calculating cumulative return of a portfolio

I've downloaded adjusted closing prices from Yahoo using the quantmod-package, and used that to create a portfolio consisting of 50% ...
2
votes
0answers
67 views

Calculate the True daily Time Weighted Return

I have an access database with records of securities in my portfolio as well as my trades for each security. My aim is to calculate the "Daily Time Weighted Return" then down the line, export it and ...
2
votes
1answer
38 views

Literature on return sensitivy in respect to: growth, risk and profitability

I am currently writing my master's thesis, wherein I am looking for supporting literature. Specifically, I wanted to know if there had been any research relating to how the: growth, risk and ...
1
vote
1answer
94 views

Calculate New Portfolio Weights Given Today's Returns

I'm looking for a formula to recalculate my portfolio's weights at the end of time $T$, given a vector of the asset weights at $T$ and a vector of returns at $T$. For example: ...
1
vote
0answers
33 views

General to specific approach to modelling

I am trying to find the relationship of stock indices across the world. This has been done by the literature, however, I am wondering about the methods chosen. I have decided to go with what I think ...
1
vote
1answer
60 views

In search of nice (approx) function forms of the volatility of cumulative simple returns

Let's consider a period $t\in[0,T]$, and let the simple return over year $t$ ($1\le t\le T$) be $r_t$. Assume $r_t$ are iid normal. The cumualative simple return over the whole period $[0,T]$ is $$R_T=...
0
votes
1answer
163 views

How to calculate annualized simple returns and annualized simple standard deviation given historical daily data

I have daily log returns of my asset that run over several years and I would like to calculate a time series of the Rolling Sharpe Ratio. This Sharpe Ratio asks specifically for: Annualized simple ...
1
vote
2answers
105 views

Short position returns with negative NAV

I am using data on the opening, change and closing of short positions, but I am interested in when the profit/losses are made. Hence, I calculated daily the value of the short position by taking the ...
-1
votes
1answer
37 views

Differences Between Portfolio Daily Average Returns

I have a doubt about the average daily return for a 2 stock porfolio. I have the data of both stock returns over a 1511 day period. I used 2 approachs to calculate the average return. In the first one,...
4
votes
1answer
165 views

relationship between volatility and equity premium

I am working on the equity premium. Does anybody know one or two authors who address the relationship between volatility and equity premium? I.e. how does vola influence the equity premium? In ...
1
vote
1answer
56 views

When modelling ARCH/GARCH effects, do we use excess returns?

When modelling ARCH/GARCH effects, do we use excess returns? Is it common in the literature to use excess returns when modelling volatility as opposed to raw return data?
1
vote
1answer
117 views

What is, here, the relationship between “compound” and “arithmetic return” and “volatility”?

I'm trying to find the exact (ie, not an approximate) relation between the "Compound Return", "Arithmetic Return", and the "Annualised Volatility" as given the assumptions below, and from there the ...
1
vote
0answers
23 views

Sample distribution of cross-sectional statistics of returns

Currently doing an application of VaR on sample of industry portfolios in the US. I have a matrix of $n$ industry portfolios with $m$ time-series observations. I calculate cross-sectionally (for each ...
1
vote
1answer
231 views

Are Kenneth French Research Returns log-Returns?

Does anyone know if Kenneth French's return data on his website is log returns?
0
votes
0answers
73 views

Market Invariant for Commodity Futures

In the same sense that Meucci describes "compounded returns" as the invariant for equities and "changes in yield-to-maturity" as the invariant for fixed-income, what is the invariant for a commodity ...
0
votes
1answer
345 views

Creating value weighted portfolio returns. How to handle missing data?

I am creating portfolios using stock data. I have some missing data for certain months. What is the best way to handle this? Should I treat missing months as a return of zero? I want to try and ...
0
votes
2answers
143 views

Daily returns to monthly basic question [closed]

I am currently a little bit puzzled. I am trying to compute the monthly returns from a set of data. ...
0
votes
1answer
45 views

Calculating Compound Annualized Rate of Return (Negative Mantissa)

According to Kaufman (Trading Systems and Methods, 2013), the compound annualized rate of return is calculated as follows: $$\mathrm{AROR}_\mathrm{compound} = \left[ \left( \frac{\mathrm{Final ...
1
vote
2answers
1k views

Predicting stock returns with GARCH in Python

I have seen this post: Correctly applying GARCH in Python which shows how to correctly apply GARCH models in Python using the arch library. Now I am wondering how I ...
1
vote
2answers
123 views

Volatility Index for Industries

The VIX index is based on the S&P, I am wondering the feasibility of creating a VIX index for each of the S&P 500 Industries? Would this even be possible?
2
votes
3answers
227 views

Calculating Sharpe Ratio with dynamic position sizing

I'm currently backtesting a mean reversion pairs trading strategy. However, instead of simple long or short trading signals, I'm using multiple "levels", where the further away the spread is from the ...
-1
votes
1answer
81 views

IRR for irregular cashflow in and out

So I work for a real estate development umbrella company and the developers that work within it borrow money as needed from the company and receive a percentage of the inflows after repayment of debt. ...
-5
votes
1answer
124 views

Why is there no closed-form equation for XIRR?

Everything I have read about XIRR (e.g., as calculated in Excel) says that there is no closed-form equation and it must be calculated by iterated approximation. Could someone give a brief ...
2
votes
2answers
95 views

Calculating excess returns

I would like to know if I am calculating these excess returns correctly. I have here an R dataframe with weekly 3-month treasury bill rates, and the arithmetic ...
0
votes
2answers
288 views

question on XIRR (excel)

Let's say we have an initial investment of -10 on 1/1/2000, and from 1/1/2001 to 1/1/2018 (with annual payments on Jan-1 of each year for 18 years) we get a CF of +2 each year with a final payment of ...
2
votes
1answer
359 views

How are Fama French Factor Returns for the last 3 and 12 months calculated?

In the Fama/French data library the monthly research factors for the Fama-French-3-Factor-Model and the Fama-French-5-Factor-Model are presented. I don't see how they are calculating the factor ...
0
votes
2answers
2k views

How to calculate “portfolio cumulative return” from individual price data and weight of them?

I'm trying to run backtest in a vectorized way using Python Pandas and need to calculate a portfolio cumulative return from price data and weight of asset data. I ...
7
votes
2answers
219 views

Portfolio returns with unequal asset return histories

Using the package PerformanceAnalytics in R, I am trying to calculate the return of an equal-weighted portfolio that contains 30 assets. However, these assets do not have the same starting point in ...
1
vote
1answer
51 views

How does inflation impact stock returns? Academic examples

For a literature survey in my university class, I have been asked the question "How does inflation impact stock returns?". After reading some informal articles (in periodicals/ the general internet), ...
1
vote
1answer
363 views

What is the Probability Distribution of Max-Drawdown?

How to obtain the probability distribution of Maximum Drawdown, starting from the probability distribution of Daily Returns? Here the details: Suppose I have a time serie of N=1000 daily returns. ...
0
votes
1answer
64 views

How to Calculate Stock Return with Stock Bonuses and Rights?

I would appreciate if you could let me know how to calculate stock return for a given company when the company issued bonus shares and rights. If company just paid dividends, stock return would be: ...
1
vote
1answer
79 views

What are the units of the variance of returns?

I am a little confused about the units of the variance of returns. One way to compute that would be to look at the units of returns- $$r=\frac{1}{\Delta t}\ln\frac{P(t+\Delta t)}{P(t)}=\text{...
1
vote
0answers
1k 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 ...
1
vote
0answers
103 views

Black Litterman - numerical instability

I am trying to work out the formula for the posterior mean in Black Litterman's model assuming 100% confidence : Ref: https://corporate.morningstar.com/ib/documents/MethodologyDocuments/IBBAssociates/...
0
votes
2answers
183 views

Return on a CDS portfolio

Good evening, I try to compute the performance of a portfolio of a CDS. I already know how to mark-to-market a CDS but typically, the first time you enter a CDS, you invest zero as the mark-to-market ...
0
votes
1answer
228 views

How to compute bond drawdowns?

I came across a very interesting article which shows a picture with the drawdowns bondholders would have faced by investing in Fixed Income since 1919. The data is based on the Moody's seasoned AAA ...
4
votes
1answer
204 views

Is positive skewness preferences rational or irrational?

Is positive skewness preference rational or irrational? I have a great trouble understanding why investors should prefer positive skewness over negative one. Sometimes it is argued that preference ...
8
votes
4answers
8k views

Calculate Average Price, Cost, (Un)Realized P&L of a position based on executed trades

We have built an algorithmic trading software and need to calculate the following parameters for each position in our portfolio. Average Price Cost Realized Profit & Loss Unrealized Profit & ...
3
votes
1answer
505 views

Portfolio forward return

I am working on a project which needs to find portfolio return for the next m months. To begin, let say investor hold a portfolio of $N$ stocks with weight $w_i$ invested in stock $i$, what is the ...
2
votes
3answers
260 views

If markets are efficient, why are most returns systematically high?

Suppose markets are perfectly efficient and asset prices reflect all available information. Under this assumption one expects current prices to be non-biased estimators of future prices. It seems to ...
3
votes
2answers
352 views

Estimation Risk-Neutral Variance of Returns

I am trying to find a method which allows me to estimate $Var_{\mathbb{Q}}\left(\frac{S_{t_{i+1}}}{S_{t_i}}\right)$ where $S$ denotes the price process of an underlying stock (which has to be assumed ...
1
vote
0answers
50 views

Computing squared returns given differential equation for prices

I am looking for general advice on how to start tackling the problem below. My background in math is fairly bad when it comes to stochastic differential equations, but if you have any recommendations ...
-2
votes
1answer
138 views

Variance covariance matrix - number of periods required

Hi I am reviewing the example of Barra risk model in the following document page 23 there is the statement: "Estimating a covariance matrix for, say, 3,000 stocks requires data for at least 3,...
0
votes
0answers
195 views

Monte Carlo simulation based VaR: daily vs annual parameters

I am given the initial price, annualized return, and volatility of a security. I am trying to calculate annualized VaR using Monte Carlo simulation approach. To do this I will use the following ...
1
vote
0answers
39 views

Bootstrapping to Judge the Fit of a Sampled Return Distribution

Consider the following: I have sampled yearly stock returns from a specified distribution. What I want to do is compare how well my sampled distribution fits the empirical distribution of yearly ...
1
vote
1answer
234 views

Should log returns be used in multilinear regressions?

As the title already says, should log returns, instead of simple returns, be used in regression analysis? In this case, I want to analyse the impact of specific factors (Dividend yield etc.) on the ...
0
votes
1answer
361 views

Pandas: Close-to-Open return on stocks

I am trying to daily calculate the close-to-open return for j stocks for t days. Is there anyway I can calculate without using a for loop? I have one Dataframe for daily close prices and one for daily ...
4
votes
1answer
129 views

Returns and Factors for European Market Kenneth French Database

I am planning to estimate Fama-French model for mutual funds with European equity scope. I am thinking about using the European factors from Kenneth French database, which are computed in USD. The ...
15
votes
4answers
58k 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 ...
1
vote
2answers
107 views

Does forecasting asset returns by default assumes non-stationarity of asset returns?

If we assume the assets returns are stationary then the best forecast can only be the mean of the distribution. But if we assume non-stationarity we are forecasting the mean parameter (assuming ...