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
21 views

Is “time value of currency” to be accounted for in returns calculation?

A simple question: When exchanging currency in order to finance an investment, is it standard/best practice to adjusted for exchange rates when calculating the NPL of that investment? For example: I, ...
0
votes
1answer
63 views

The use of volatility from log returns and raw return

As far as I know, we usually use log returns( $ln\frac{p_{t+1}}{p_{t}}$ ) in quantitative finance. For example, let's say we have lots of monthly log returns data, $R_m$. Then, we can get the mean ...
9
votes
5answers
9k 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 & ...
0
votes
2answers
40 views

Daily to Monthly Performance Attribution - Getting Effects to equal the Excess Return

I am building a performance attribution tool on Python to help us understand the asset allocation, stock selection effects of our fund. We are using daily price data for each component within the ...
1
vote
1answer
67 views

Calculating returns with trading costs

This perhaps is an over simplification of calculating trading returns while including trading costs. I've made some assumptions - the commission for investing and extracting an investment is 1% and 2% ...
0
votes
3answers
63 views

Does asset volume, rather than asset returns, predict performance?

Asset returns are the most common data type used in finance. They are derived from closing price data. Ordinary level 1 data for stocks not only consists of closing prices, but also gross volume ...
0
votes
0answers
20 views

Fama Foundations of Finance today

Which could be a recent equivalent of Fama's book Foundations of Finance? By "equivalent" I mean a book which is rigorous, but without being a book on stochastic calculus; which is focused on stock ...
1
vote
0answers
35 views

Results of Fama MacBeth regression

I have run Fama MacBeth cross section regression of of Excess Return of stocks on Idiosyncratic volatility, the log of market capitalization, book to equity ratio and Beta. I'm getting all significant ...
0
votes
1answer
56 views

The ratio of upside deviation to downside deviation in portfolio weighting

I've been calling this ratio "acceleration" in my head, so I'll do the same in this post. The question is, is this relationship used anywhere and if so, how? My thought process is as follows. Risk ...
0
votes
1answer
45 views

Correct calculation of returns from a pairs trade

I am trying to understand how pairs trading works but I am confused about how to go about calculating the return on the pairs trade when I reverse my positions. I have been reading 'Pairs Trading - ...
0
votes
0answers
24 views

Stock returns: Exponential time decay

I am replicating some research that uses two years of single stock returns (i.e. N= 250*2= 500) and then applies an exponential decay with a half-life of one year to these returns. Does this mean ...
0
votes
0answers
18 views

How can I find the exit equity value from my dataset (please read description and see screenshot below)

I am investigating the returns of private equity using a public market equivalent (PME) and have been given a dataset from the that has provided us with the deal level IRR, the entry equity data and ...
0
votes
0answers
19 views

is it possible to have a leverage ratio of less than 1?

I know you can leverage to be greater than 1, but is it possible to have less than 1? Like 0.5 for example? So that this scenario could be realized? ...
0
votes
1answer
62 views

Compound the monthly returns to make them quarterly [closed]

How can someone make the Kenneth French library data returns quarterly from monthly? Since they are not loq returns, then you need to compound returns rather than summing them up. I want to make the ...
0
votes
1answer
25 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-...
7
votes
2answers
7k views

Fama-French Data from daily to monthly returns

Ken French on his website publishes daily, monthly and yearly returns for the Fama-French 3 Factors model which are excess market (Rm-Rf), small-minus-big (SMB) and high-minus-low (HML) returns. I ...
1
vote
0answers
46 views

How do I maximize my expected utility of wealth?

Suppose I have a utility function say $U(p)=p^{1/2}$ and I bet on a basketball game. I have my initial investment, payouts and probabilities of winning, how can I determine the maximum I need to bet ...
1
vote
1answer
58 views

Calculating the daily continuously compounded return from index values

Given I have 3 index values at time $t = 0, 1 , 2$, how would I go about calculating the daily continuously compounded return? Time: $ 0, 1, 2$ Index Values: $4000, 4086, 4114$ Any help would be ...
2
votes
1answer
33 views

How can I convert rolling annual returns back to quarterly returns?

I have a series of rolling annual returns and would like to convert these back to quarterly returns, which have not been provided. Is this possible formulaically, or is something like Excel's solver ...
3
votes
0answers
37 views

Statistical significance of mean returns between two portfolios

Suppose I have developed two versions ($A$ and $B$) of a factor model for ranking stocks. Both versions of the model use the same scoring system: stocks are percentile ranked within a given universe ...
1
vote
4answers
297 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 ...
4
votes
6answers
608 views

CAPM - Expected vs. actual returns

I'm trying to calculate alpha in excess of CAPM and have seen a few slightly different calculations for CAPM. The primary difference I am seeing is that some equations use expected market returns (e....
2
votes
1answer
38 views

Incremental/marginal contribution to VaR in a simulation setting

Estimating marginal contributions to VaR in a simulation setting is apparently quite difficult (see e.g. this blog post) due to issues with sampling variability. My question is whether the following ...
1
vote
1answer
366 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: ...
1
vote
1answer
42 views

Returns on the Fama-French size sorted portfolios

For my thesis, I need to replicate a specific research paper in the field of empirical asset pricing, mentioning the CAPM in particular. The data mainly consists of monthly returns on portfolios ...
1
vote
0answers
22 views

Overnight and intraday returns of stock index and ETF seem inconsistent

Figure 2 of the 2019 paper "Celebrating Three Decades of Worldwide Stock Market Manipulation" shows that 29 Jan 1993 to 31 Oct 2019, overnight returns (from close to open) of SPY were 1232% while ...
1
vote
1answer
292 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
46 views

pair 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 ...
2
votes
2answers
66 views

Closing prices are predicted very well but returns are predicted poorly

I'm learning some time series analysis and forecasting techniques, I've tried to predict stock prices for Netflix but I'm very confused. At first I've tried Auto ARIMA which gave me a straight line, ...
0
votes
0answers
28 views

calculating sharpe-ratio and annualized returns

Im trying to get the sharpe ratio to be calculated daily but I can only calculate it annually, this is also happening for my annualized returns, can somebody help me please? ...
1
vote
0answers
28 views

Time and asset weighted rate of return of a portfolio

If I have a portfolio with 3 initial assets on day 1 (say, stock 1 with beginning market value of \$100, stock 2 \$150 and stock 3 \$175) and after 10 days the stock 2 is sold for \$200, how can I ...
0
votes
1answer
90 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
2answers
66 views

How can I calculate returns for three investment strategy?

Assume that the price of DF stock went from a price of $104 on March 2 to 146 on April 1. With a current stock price of 146, there is a call option available on the DF stock with an exercise price ...
1
vote
1answer
117 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 ...
1
vote
2answers
691 views

Calculation of dividend yield from index returns

For a research project, I need to find or calculate dividend yield for all the index of major countries in the world (e.g: s&p500,DAX,CAC40 and so on), and I am struggling a bit with it. I cannot ...
0
votes
1answer
59 views

Optimize risk return of portfolio

I have gathered stock prices from 15 companies over a year. I calculated the averages, yearly volatilizes, and the correlation matrix. I was asked to find the optimum weight for each stock with a ...
3
votes
4answers
2k views

Portfolio software that shows 'total return' for each investment

I'm a high school technology teacher and sponsor for the Charity Student Investment Project. Currently our students track our investment portfolio via a google spreadsheet (http://...
0
votes
0answers
44 views

How to Calculate Discrete Currency Returns for Short Positions

I need to calculate currency returns for 1) short selling the currency and 2) going long in the currency. When going long, the currency is sold at Forward price $F_t$ and bought at spot price $S_{t+1}$...
1
vote
1answer
75 views

Which returns to use for portfolio optimiaztion?

On the base of which returns do I have to derive optimal portfolio weights of an investment strategy? More specifically, do I have to use the excess returns or just the normal returns of the ...
0
votes
1answer
66 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 ...
0
votes
3answers
83 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 ...
3
votes
1answer
89 views

Is there an issue with estimating future returns from autocorrelated returns?

I have a time series $X_t$ generated from a standard GBM $$dS_t = \mu S_t dt + \sigma S_t dW_t$$ If I take the log returns over a rolling window of length $l$ $$r^{(l)}_i = \log \left( \frac{S_i}{...
1
vote
1answer
68 views

Understanding Fama Macbeth Regressions of Returns

I'm trying to understand what the Fama-Macbeth regressions of returns actually mean. The source of confusion is a 2013 Novy-Marx paper, in which he states the following: "The first specification of ...
1
vote
3answers
3k 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 ...
9
votes
2answers
13k views

What kind of return can an average algorithmic trading firm achieve today?

What kind of rate of return can an average, equities-focused algorithmic trading firm expect to achieve today? I come from a background of control and optimization, working in the industry in China, ...
1
vote
0answers
85 views

Bloomberg Treasuries PX_Last and daily returns

I tried to search for this specific question, although I didn’t found a conclusive answer. I have a dataset containing the yields of several T-Bills and T-Notes that were downloaded from a Bloomberg ...
1
vote
1answer
58 views

What does a regression of squared returns of stock on squared index returns and lags show?

We have a squared stock return at t regressed on 3 variables: squared index return, squared stock return at t-1, and squared index return at t-1. My two questions would be: 1. What does this test ...
1
vote
3answers
517 views

How to calculate standard deviation of continuously compounded four-year stock returns?

Currently I am preparing for quant interview and I encounter the following question in Heard on the street. Question: If the standard deviation of continuously compounded annual stock returns is $...
3
votes
4answers
5k views

Calculate bond returns from yields

I have to construct and evaluate portfolio of bonds and stocks, namely I need to get return on portfolio, standard deviation and sharpe ratios. I have weekly data that contains stock prices, and I ...
0
votes
1answer
195 views

Value-weighted return: which date should the market-capitalization be based on?

I got a short question regarding calculating the value-weighted return of portfolios. Example: The portfolio is constructed based on the value of a certain criteria on date 31.1 (Jan 31st). The ...

1
2 3 4 5
8