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
1answer
106 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 ...
-5
votes
0answers
17 views

Total return using spot rates [closed]

Please explain how you solved it using concepts and formulas, not only numerical answer. Do I calculate irr future spot rates? I do not know how to approach this problem: should I calculate the coupon ...
1
vote
4answers
315 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 ...
2
votes
1answer
565 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
46 views

Calculate daily account value & returns on trading system backtest

Quick question, I'm having a brain freeze. I've done a simple system to practice array based backtesting. I was able to calculate my PnL by subtracting the "close" from the "buyPrice&...
1
vote
1answer
383 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 =...
1
vote
2answers
83 views

How does one calculate carry-roll-down theoretically assuming expectations of short-term rates are realised

I am not asking for an explanation that is hugely quantitative, but rather one that is more intuitive. I am aware that there are different assumptions that one could take when it comes to carry-roll-...
0
votes
0answers
35 views

Return of a bond held to maturity and realised forward rates

Let's assume that forward rates are realised as part of a carry-roll-down scenario. The gross return of a bond under the realised forward assumption to maturity is: $\frac{c(1+f(2))(1+f(3))...(1+f(T))}...
0
votes
1answer
119 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 ...
2
votes
1answer
107 views

Covariance matrix for multiple assets - Second attempt

Ok, on the advice of administration I open a new question, hoping that in this way it becomes clearer. Like I said before, I am trying to understand how the authors of this (page 76) and this (page ...
0
votes
0answers
39 views

Prices and returns

I want to convert the payoff of an Asian and a lookback Call option with prices in their corresponding with returns. Example: for an European Call $\varphi(S_T)=(S_T-K)^+$, so knowing that $S_T=S_0(1+...
1
vote
0answers
54 views

How to calculate portfolio returns from assets with different valuation frequencies and return methdologies?

I have a situation in which I'd like to calculate a total portfolio return for a portfolio made up of funds with different valuation frequencies and return methodologies. As an example, say I have a ...
2
votes
0answers
34 views

Boundaries on the single-period returns

I know that $e^{t\mu_{\operatorname{log}}-\Gamma\sqrt{t}\sigma_{\operatorname{log}}}\leq \widetilde{R}_t^S \leq e^{t\mu_{\operatorname{log}}+\Gamma\sqrt{t}\sigma_{\operatorname{log}}}$, with $\mu_{\...
11
votes
5answers
10k 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 & ...
2
votes
1answer
161 views

Is it always better to use the entire distribution of a financial returns series, 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 $\...
1
vote
0answers
56 views

Please help me understand this dataset regarding stock prices

I am supposed to predict column E but I cannot figure out what any of these columns mean. The information provided with the dataset is as follows: column A: past 28 week slope value column B: past 48 ...
2
votes
0answers
35 views

Relationship between risk and return for GBM and riskless bond

Suppose we have $S$, a stock following geometric Brownian motion ($dS_t = S_t (\mu dt + \sigma dZ_t)$ for $Z =$ Brownian motion) and $B$, a zero coupon bond with rate $r$, i.e. $dB_t = rB_t dt$. In ...
1
vote
0answers
30 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
48 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?
1
vote
0answers
31 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
76 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
171 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 ...
1
vote
1answer
95 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 ...
3
votes
1answer
82 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
115 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
113 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
54 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
57 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
57 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
83 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
40 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
48 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/...
1
vote
1answer
60 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
34 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
40 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
30 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
101 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
95 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
129 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
51 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 ...
0
votes
2answers
124 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 ...
0
votes
1answer
85 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
256 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., ...
0
votes
1answer
38 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
76 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 ...

1
2 3 4 5
9