📈 CFA Exam Prep Discount - AnalystPrep: ► Get 20% off CFA Level 1, 2, and 3 packages with promo code "RYAN20". ► Level 1 Packages: analystprep.com/shop/cfa-level-1-complete-course-by-analystprep/?ref=mgmymmr ► Level 2 Packages: analystprep.com/shop/cfa-level-2-complete-course-by-analystprep/?ref=mgmymmr ► Level 3 Packages: analystprep.com/shop/cfa-level-3-complete-course-by-analystprep/?ref=mgmymmr 📊 FRM Exam Prep Discount - AnalystPrep: ► Get 20% off FRM packages with promo code "RYAN20": analystprep.com/shop/frm-part-1-and-part-2-complete-course-by-analystprep/?ref=mgmymmr 🎓 Tutor With Me: 1-On-1 Video Call Sessions Available ► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/ 💾 Download Free Excel File: ► Download the file created in this video free here: ryanoconnellfinance.com/product/information-ratio-tracking-error-excel-workbook/
Hi Ryan, shouldnt the formula be =(1+product)^(1/n)-1, I am not sure but when using your formula, I get very high percentages like in the thousands, any reason why ?
Great video as always! thank you for this gems. I have a question: if I take the average of the Portfolio Return - Benchmark Return column, shouldn't that tell me whether the fund has outperformed the index? Because if the average is >0, it means that the fund has outperformed the index most of the time. I tried to calculate this on your spreadsheet but it comes out positive for both funds with my stupor😅. By my reasoning it should be negative for ARKK. Can you please explain why?
I'm finding the number of days in the whole period so that we can figure out how many years there are and scale the annual return appropriately to the number of years!
@@RyanOConnellCFA I got a little confused with this part because in the other formulas you consider the year as having 252 days but, in this calculation, when subtracting the last from the first date, you're using 365 (or 366) days per year, right? Shouldn't we use COUNT() to count how many days of data we have?
Hey Ryan, Just kne doubt information ratio to division of cumulative excess return and tracking error, so the result would have percentage as unit or will it be without percentage as we dividing 2 percentage values.
📈 CFA Exam Prep Discount - AnalystPrep:
► Get 20% off CFA Level 1, 2, and 3 packages with promo code "RYAN20".
► Level 1 Packages: analystprep.com/shop/cfa-level-1-complete-course-by-analystprep/?ref=mgmymmr
► Level 2 Packages: analystprep.com/shop/cfa-level-2-complete-course-by-analystprep/?ref=mgmymmr
► Level 3 Packages: analystprep.com/shop/cfa-level-3-complete-course-by-analystprep/?ref=mgmymmr
📊 FRM Exam Prep Discount - AnalystPrep:
► Get 20% off FRM packages with promo code "RYAN20": analystprep.com/shop/frm-part-1-and-part-2-complete-course-by-analystprep/?ref=mgmymmr
🎓 Tutor With Me: 1-On-1 Video Call Sessions Available
► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/
💾 Download Free Excel File:
► Download the file created in this video free here: ryanoconnellfinance.com/product/information-ratio-tracking-error-excel-workbook/
Hi Ryan, shouldnt the formula be =(1+product)^(1/n)-1, I am not sure but when using your formula, I get very high percentages like in the thousands, any reason why ?
Thanks Ryan, great as usual. But isn't the same methodology of Sharpe Measure?
why not log returns? I’ve learned from you their importance and now you don’t use them 😢
hi, can I ask for your help with the difference between annual and annualized returns?
If I see a new video from Ryan, I immediately like it 👍
Thank you for that!
Great video as always! thank you for this gems.
I have a question: if I take the average of the Portfolio Return - Benchmark Return column, shouldn't that tell me whether the fund has outperformed the index? Because if the average is >0, it means that the fund has outperformed the index most of the time. I tried to calculate this on your spreadsheet but it comes out positive for both funds with my stupor😅. By my reasoning it should be negative for ARKK. Can you please explain why?
Thanks for a very clear explanation. Your videos are great.
You are welcome! I appreciate the kind feedback
Hey Ryan, can u pls explain how are u calculating 3381 days I mean up to how many yrs have u taken the data
I'm finding the number of days in the whole period so that we can figure out how many years there are and scale the annual return appropriately to the number of years!
@@RyanOConnellCFA I got a little confused with this part because in the other formulas you consider the year as having 252 days but, in this calculation, when subtracting the last from the first date, you're using 365 (or 366) days per year, right? Shouldn't we use COUNT() to count how many days of data we have?
Hey Ryan,
Just kne doubt information ratio to division of cumulative excess return and tracking error, so the result would have percentage as unit or will it be without percentage as we dividing 2 percentage values.
Hello, If I hadn't multiplied by 100 at the end it would have been quoted as a percentage value!
Hey Ryan, have you done video on stresstest on loans? :)
Hello, I have not yet but I'm looking to make a stress testing video in the future
Nice. Looking forward.