You can find the spreadsheets for this video and some additional materials here: drive.google.com/drive/folders/1sP40IW0p0w5IETCgo464uhDFfdyR6rh7 Please consider supporting NEDL on Patreon: www.patreon.com/NEDLeducation
Hi Corrado, and glad you enjoyed the video! As I am have been moving through some portfolio optimisation topics as of lately (you might have seen videos on the Omega ratio and portfolio concentration already), will definitely touch upon the optimisation of VaR and Expected Shortfall as well. Thanks for the suggestion!
@@NEDLeducation one question: when the independent variables have different unit of measurement, do we need to standardize them before applying the LASSO?
@@corradoforza Hi Corrado, and thanks for the question! This is a common practice, you could z-score the variables by subtracting the mean and dividing by the standard deviation for additional robustness.
Excuse me, i want to ask sir. Why there is a different formula in objective function to minimize SSE, between sklearn library and this video. What is the different ?? Thx
Hi Divya, and glad you liked the video. As for your question, it depends on what hypothesis you want to test. If you are concerned with the individual relationships between variables, which is most often the case, t-stats are enough. F-tests are required only when you want to test for the significance of the model overall.
@NEDL could you please elaborate why you have calculated the daily returns using the formula lower value/upper value-1, why this formula is used. Or in place of that, could we normalize the variables using log or anything? The results will be same or not?
Hi Aradhana, and thanks for the question! Yes, you can use log(lower value/upper value) in this case to get logarithmic returns. The results will be similar.
Hi Sheena, and thanks for the question! The "constant" column is needed if the matrix method for regression modelling is used (when coefficients and standard errors are obtained by multiplying a bunch of matrices together).
You can find the spreadsheets for this video and some additional materials here: drive.google.com/drive/folders/1sP40IW0p0w5IETCgo464uhDFfdyR6rh7
Please consider supporting NEDL on Patreon: www.patreon.com/NEDLeducation
You are smart Brother . Wouldn't have imagined that someone will utilize Excel in statistics that you do !
Fascinated by the use of matrix to calculate the regression and excel mmult
tough implementation in excel, great learning
Great!!!
excellent video. Please keep up the good work
Thank you so much I was hoping to see this video 😁 Video suggestion conditional VaR aka Expected Shortfall portfolio optimization with Excel
Hi Corrado, and glad you enjoyed the video! As I am have been moving through some portfolio optimisation topics as of lately (you might have seen videos on the Omega ratio and portfolio concentration already), will definitely touch upon the optimisation of VaR and Expected Shortfall as well. Thanks for the suggestion!
@@NEDLeducation one question: when the independent variables have different unit of measurement, do we need to standardize them before applying the LASSO?
@@corradoforza Hi Corrado, and thanks for the question! This is a common practice, you could z-score the variables by subtracting the mean and dividing by the standard deviation for additional robustness.
Excuse me, i want to ask sir. Why there is a different formula in objective function to minimize SSE, between sklearn library and this video. What is the different ?? Thx
Is there not any way we could find the coefficient of the LASSO regression without using the OLS?
Thank you
Great content, especially using matrix.. Did not find such a clear one, over internet...Just want to know, if F-statistic/Annova is not required?
Hi Divya, and glad you liked the video. As for your question, it depends on what hypothesis you want to test. If you are concerned with the individual relationships between variables, which is most often the case, t-stats are enough. F-tests are required only when you want to test for the significance of the model overall.
Got it.. Thank you again
@NEDL could you please elaborate why you have calculated the daily returns using the formula lower value/upper value-1, why this formula is used. Or in place of that, could we normalize the variables using log or anything? The results will be same or not?
Hi Aradhana, and thanks for the question! Yes, you can use log(lower value/upper value) in this case to get logarithmic returns. The results will be similar.
hi can you help me to do in my data?
Why do you add a column of "constant" in the given data? what is the use of this. Please confirm. @NEDL
Hi Sheena, and thanks for the question! The "constant" column is needed if the matrix method for regression modelling is used (when coefficients and standard errors are obtained by multiplying a bunch of matrices together).
@@NEDLeducation Thank you for your prompt answer!
Nice to know ur site, may I ask how about group lasso ? Can you tell me or teach me how to operate in excel :(
@NEDL