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.

0
votes
1answer
50 views

How to add annualized quarterly returns? [on hold]

I have four quarterly returns that have all been annualized. How do I calculate the annualized return for the year from these values? Or do I need to back into them to get the holding period returns
2
votes
2answers
43 views

How to calculate necessary gain to compensate a loss in a financial transaction?

(Feel free to suggest the correct Stackexchange community - or otherwise - if this is not the correct one) When trading financial markets, a gain of x%, won't ...
0
votes
0answers
40 views

Calculation of IRR Given Stage Assumptions

I am trying to replicate Union Square Ventures Fund #1 model. A number of assumptions are given and the outcomes are listed. I have copied these into google sheets. I am not sure exactly how IRR is ...
0
votes
0answers
37 views
1
vote
2answers
71 views

Why can we assume that asset return rates are normally (or lognormally) distributed?

In many theories of financial mathematics it is assumed that asset return rates are normally distributed (e.g. VaR models) or lognormally distributed (e.g. Black-Scholes model). In practice, asset ...
1
vote
0answers
23 views

Source for derivation of acquisition price for given IRR and cash flows

Does anyone know a quotable source - book/academic or practitioner's paper - that derives the acquisiton price for a target firm when the buyer's desired IRR and all cash flows over time of the target ...
1
vote
1answer
44 views

ETF performance/returns

I was going over some ETF return data on yahoo finance and encountered some numbers that did not make sense to me. The image below shows a ytd return of 17.94% and 13.52%. I checked ETF.com and ETFdb ...
1
vote
0answers
47 views

Predicting stock returns using principal components of macroeconomic variables

I'm trying to detect return predictability by regressing stock returns on the first couple of principal components of a set of macroeconomic variables. I'm doing this for different stock styles such ...
1
vote
1answer
49 views

Proof that IRR(A) < IRR(A+B) < IRR(B) ? Ie that the IRR of two cashflows together must be within the range of the IRR of the two cashflows?

The question The IRR of two sets of cashflow is not (necessarily) the weighted average of each set of cashflows. E.g. if ...
0
votes
1answer
67 views

Should the sum of daily returns be close to monthly returns

I am calculating value-weighted returns with monthly dividends reinvested and for some reason when I sum the daily returns some are a little bit off with monthly returns. Is this normal?
1
vote
1answer
49 views

Efficient Frontier Graph

I'm writing some C code to create different portfolios using a few stocks that are given as inputs. I am having some trouble trying to find if these results are correct. My biggest hesitation is that ...
1
vote
0answers
65 views

Logic behind calculating a Carry Multiple associated with Startup Valuation [closed]

I'm reading a book called "The #1 Guide to Startup Valuation: How to value your startup in 12 easy steps" (p. 22-23) by Joachim Blazer. As one of the building blocks, namely "Return", the Carry ...
2
votes
1answer
93 views

Convert Geometric Direct Alpha PME to Arithmetic Excess IRR (PME Alpha / Implied Private Premium)

As a followup to this old question, Private Equity: Direct Alpha vs Excess IRR, I have a new one. In automating PME calculations, the Direct Alpha (DA) approach is computationally simpler and ...
2
votes
2answers
106 views

Distribution of simple returns vs logreturns

I understand that stock prices are conditionally modeled using a log normal distribution by the relationship $ y_t/y_{t−1}∼logN(μ_{daily},σ^2_{daily})$ $y_t∼logN(log(y_{t-1})+μ_{daily},σ^2_{...
2
votes
0answers
48 views

Possible application of Polya's Urn on Portfolio's Investments?

I wanted to find some more information of this topic, but I found very little. I might be interested in optimizing a stock investment portfolio. Maybe I could use beta or some other common risk ...
1
vote
1answer
55 views

Return On a Spread

This is a beginner level question. I have a $spread = aluminium - 0.7*lead $ $s = a - 0.7*l$ I have two methods to calculate return on this spread: $ return = (s_t - s_{t-1})/(a_t + 0.7*l_t) $ ...
1
vote
1answer
70 views

How to calculate the daily rate of return for an actively traded account

I have a spot currency exchange account where the base currency is USD and where I can deposit and/or withdraw money from the account in any currency at any point in time. I can also exchange any ...
4
votes
1answer
128 views

Neural Networks for Estimation of Unmarked Private Asset Returns from Market Data

Let's assume it is March and my illiquid private assets portfolio is only 50% marked for 12/31, but I want to get the most accurate estimate of my final return for the quarter ended on 12/31. What is ...
2
votes
1answer
273 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
54 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 ...
4
votes
2answers
81 views

Finding Lead-Lag Relationship [duplicate]

Given two series of data, volatility and returns, is there a way (Excel) of finding which one is the leading factor and lagging factor? Thank you for your help.
1
vote
0answers
31 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 ...
2
votes
1answer
36 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
77 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
1answer
59 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=...
1
vote
2answers
65 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 ...
0
votes
1answer
123 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
votes
1answer
34 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,...
1
vote
1answer
49 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
79 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
22 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
163 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
57 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
217 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
96 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
37 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 ...
0
votes
1answer
74 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 ...
1
vote
2answers
110 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?
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 ...
2
votes
3answers
161 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
69 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. ...
2
votes
2answers
88 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 ...
2
votes
2answers
147 views

Cumulative Return on Futures

In my current backtesting, I am using log returns as a proxy for simple returns via the relationship $\ln(1 + r) \approx r$ for small enough r. This gives me wonderful properties like time additivity, ...
0
votes
2answers
1k 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 ...
1
vote
1answer
49 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
275 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
63 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
76 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
97 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
135 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 ...