David, this is such a brilliant explanation! Log returns are time additive, which are why they are used more commonly than simple returns that are portfolio additive.
@@Rey_B I think RETURN = means a value "X" LOG RETURN = means function "log X" ADDITIVE = means by adding a list of X Summary: - R1 = additive portfolio returns (adding a list of X) - R2 = additive portfolio log returns (adding a list of log X) R1 ≠ R2 (ARe not the same) I don't know why that is important still. I need more maths experience
Before is the calculation of log return in excel 3:17 explaining of Why we use log returns in finance: time consistent/ time additive: 2 period return of asset = 1 period log return advantage: if the log return is normally distributed, adding this normally distributed variable produce an in period log return which is also normally distributed disadvantage: log-returns are not a linear function of the component or asset weights, hence will have problem when there is a profolio weight
Since using log returns have disadvantages over discrete returns can you please explain an instance when to use log returns and when not while analyzing or calculating returns?
in my opinion, log returns should be used for shorter period and highly heterogeneous investments analysis whereas for simple analysis of homogenous and pretty long period portfolio, simple return should do (it's all about complexity/accuracy trade off)
Thanks David. It sounds like the upside is only in case of Gaussian-ness, whereas the downside is pretty big (not additive across portfolio weightings). A sensitivity analysis on the portfolio weights seems like the most obvious question to be asking all the time ("Should I switch some of A into B?"), so why does the balance fall on the side of using logs?
But how do you find the excess real log return? Do you first find the real log return by subtracting off log inflation from nominal log return… then subtract off log inflation from nominal risk free return… then take the difference between the real log return and the real log risk free return to arrive at excess real log return? Or… do you find excess nominal log return by taking the difference between nominal log return and nominal log risk free return, and then subtracting off log inflation? It’s all very confusing to me.
Great explanation! Essentially, you are using continuous compounding to find the period over period rate of return for your hypothetical portfolio. Maybe I need a better understanding of modern portfolio theory, but if return is based on dividends and or capital gains realized(from an accrual accounting perspective) at the end of each period, then the simple or discrete method would seem to be the more practical choice. Under what scenario would we want to use logs to calculate return?
@chatturanga so what is the correct way to use weighted returns over time ie. cumulative returns for a portfolio with unequal weights if both methods mentioned in the video don't work? Is this possible?
i would love to see an example of how these log returns take the assets in period 1 to period 3. for instance, how would you use these log returns to take asset A (p1) = 100 to asset a (p3) ??
Taking first difference of asset price process [I(1)=>first difference stationary] sufficiently removes mean non-stationarity After the first differencing is performed, there is still variance non-stationarity.Thus, one could use a scaled Box-Cox transformation. One would usually get a lambda=0 within the confidence bounds, thus use the GM(y)*log() or simply log() transformation.Thus the asset price process should be transformed into=> first difference of the log process {r(t)=ln(P(t)/P(t-1) }
Hey David, thanks for a nice video Say the price of an asset is 13,13 at day one and 1,81 at day to, thus the logreturn between day one and to is -198,16%, how schould this be understud??
That is a -86.21% return (1.81/13.13-1). The log return is -198.16% (LN(1.81/13.13)). This log return would need to be converted to the normal return (e^(-1.9816)-1) which gives -86.21% return. The log return should always leave you with the actual return once it's converted.
Side note: To get the SIMPLE Weighted ROI of LN-ROI you can just Exponentiate the ROI (delogging it): exp(6.9%)-1 = 7.14% [it's like saying, ok I know what exponential ROI % {i.e. endless compounding interest rate} we have, but what SIMPLE ROI would correspond to it? ] This is the same as: Log2.71828(69/1000) - 1 Or in Google Sheets, you can alternatively write the following: POW(2.71828, 69/1000) - 1 Additionally: 20%*29%+-5%*57%+30%*14% = 7.15% while exp(6.9%) - 1 = 7.14%
I have seen people using Natural Log "log (p2/p1)", while calculating daily returns of stock/Index for long period data (15-20 years), instead of using '(p2 - p1)/p1'. Could not know very good reason. Is it more accurate to use Natural Log ? Can you make a Video on this in detail for benefit of all of us. Rgds.
The first difference of log-asset price process still contains non-level variance non-stationary. Given unconditional distribution extreme non-normality, conditional heteroscedasticity, asymmetry in volatility response and conditional distribution non-normality, one should additional modify the model to incorporate volatility clustering, asymmetrical responses and non-volatility clustering induces excess kurtosis==> DMM-MFIEGARCH with tempered stable innovations
People like you putting up material like this is probably the best part of the internet. Thank you very much. Very well explained.
Agreed wish they showed the formula bar + donation button and would make it perfect!
@J M years later, same on all counts
I was lost on eular constanta, log and natural log correlation, to understand its function on finance. Until i found this. Very helpful.
David, this is such a brilliant explanation! Log returns are time additive, which are why they are used more commonly than simple returns that are portfolio additive.
can you please explain this more - by detailing about what is additive meaning here ?
?
@@Rey_B I think
RETURN = means a value "X"
LOG RETURN = means function "log X"
ADDITIVE = means by adding a list of X
Summary:
- R1 = additive portfolio returns (adding a list of X)
- R2 = additive portfolio log returns (adding a list of log X)
R1 ≠ R2 (ARe not the same)
I don't know why that is important still.
I need more maths experience
Your mic must have been high end 12 years ago, it sounds more clear then some RUclipsrs today
Before is the calculation of log return in excel
3:17 explaining of Why we use log returns in finance:
time consistent/ time additive:
2 period return of asset = 1 period log return
advantage:
if the log return is normally distributed, adding this normally distributed variable produce an in period log return which is also normally distributed
disadvantage:
log-returns are not a linear function of the component or asset weights, hence will have problem when there is a profolio weight
i never knew i could understand this so easily!
Since using log returns have disadvantages over discrete returns can you please explain an instance when to use log returns and when not while analyzing or calculating returns?
log returns have to be continuously compounding in nature. Discrete returns are not
in my opinion, log returns should be used for shorter period and highly heterogeneous investments analysis whereas for simple analysis of homogenous and pretty long period portfolio, simple return should do (it's all about complexity/accuracy trade off)
So question- why is additive an advantage? In what scenario would we want to add (or subtract) returns? Why is that useful?
Thanks David. It sounds like the upside is only in case of Gaussian-ness, whereas the downside is pretty big (not additive across portfolio weightings). A sensitivity analysis on the portfolio weights seems like the most obvious question to be asking all the time ("Should I switch some of A into B?"), so why does the balance fall on the side of using logs?
Lao Tzu Anyone reading this have an answer please do share .
But how do you find the excess real log return? Do you first find the real log return by subtracting off log inflation from nominal log return… then subtract off log inflation from nominal risk free return… then take the difference between the real log return and the real log risk free return to arrive at excess real log return? Or… do you find excess nominal log return by taking the difference between nominal log return and nominal log risk free return, and then subtracting off log inflation? It’s all very confusing to me.
10/10 simple explanation
thanks for the video. one question: so do you need recalculate the weights for P2 return?
what difference will it make if we assign minus(-) for LN. -LN(P2/P1)
What if you want to calculate the average return for a portfolio for every subperiod?
Can we use log returns for option prices or simple returns? Please reply
Great explanation!
Essentially, you are using continuous compounding to find the period over period rate of return for your hypothetical portfolio.
Maybe I need a better understanding of modern portfolio theory, but if return is based on dividends and or capital gains realized(from an accrual accounting perspective) at the end of each period, then the simple or discrete method would seem to be the more practical choice. Under what scenario would we want to use logs to calculate return?
read nassim talebs work
I'll have to look into this, is it the best channel?
@chatturanga so what is the correct way to use weighted returns over time ie. cumulative returns for a portfolio with unequal weights if both methods mentioned in the video don't work? Is this possible?
i would love to see an example of how these log returns take the assets in period 1 to period 3. for instance, how would you use these log returns to take asset A (p1) = 100 to asset a (p3) ??
Taking first difference of asset price process [I(1)=>first difference stationary] sufficiently removes mean non-stationarity After the first differencing is performed, there is still variance non-stationarity.Thus, one could use a scaled Box-Cox transformation. One would usually get a lambda=0 within the confidence bounds, thus use the GM(y)*log() or simply log() transformation.Thus the asset price process should be transformed into=> first difference of the log process {r(t)=ln(P(t)/P(t-1) }
Isn't e value is approximate? So, it can't be used as equality.
100*(1+r) = 120 .... r is not 18.2% by using ln are compounding daily?
why you don't directly say ln a + ln b = ln ab
Very clear-cut, thank you.
You're welcome! Thank you for watching :)
Hey David, thanks for a nice video
Say the price of an asset is 13,13 at day one and 1,81 at day to, thus the logreturn between day one and to is -198,16%, how schould this be understud??
That is a -86.21% return (1.81/13.13-1). The log return is -198.16% (LN(1.81/13.13)). This log return would need to be converted to the normal return (e^(-1.9816)-1) which gives -86.21% return. The log return should always leave you with the actual return once it's converted.
Thanks. Nice and straightforward.
Yes but what does time additive actually mean? How much time?
log(B/A) + log(C/B) = log(B) - log(A) + log(C) - log(B) = log(C/A) makes that 2 period = sum of first two
It works ?
Side note:
To get the SIMPLE Weighted ROI of LN-ROI you can just Exponentiate the ROI (delogging it):
exp(6.9%)-1 = 7.14% [it's like saying, ok I know what exponential ROI % {i.e. endless compounding interest rate} we have, but what SIMPLE ROI would correspond to it? ]
This is the same as: Log2.71828(69/1000) - 1
Or in Google Sheets, you can alternatively write the following: POW(2.71828, 69/1000) - 1
Additionally:
20%*29%+-5%*57%+30%*14% = 7.15%
while exp(6.9%) - 1 = 7.14%
well what an eye opener :D
Excellent!!! Thanks!!!!!
hi what is cumulative return if i have return in month 1: 3% month 2: 4% month 3: 7%
pls help
I have seen people using Natural Log "log (p2/p1)", while calculating daily returns of stock/Index for long period data (15-20 years), instead of using '(p2 - p1)/p1'. Could not know very good reason.
Is it more accurate to use Natural Log ?
Can you make a Video on this in detail for benefit of all of us.
Rgds.
really well explained
Many thanks
Yes, but why? No answer.
Because log returns add over time. ln(t1/t0) + ln(t2/t1) = ln(t2/t1) ... as the video explains
this is awesome.
Log rocks!
thanks!
great!
The first difference of log-asset price process still contains non-level variance non-stationary. Given unconditional distribution extreme non-normality, conditional heteroscedasticity, asymmetry in volatility response and conditional distribution non-normality, one should additional modify the model to incorporate volatility clustering, asymmetrical responses and non-volatility clustering induces excess kurtosis==> DMM-MFIEGARCH with tempered stable innovations
very nice!
Who else is here from Worldquant University?
G
zhina!