SOFR Futures Explained: 3-Month & 1-Month Pricing in Excel

[@RyanOConnellCFA]

🎓 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: ► Grab the file from this video here: ryanoconnellfinance.com/product/sofr-futures-excel-toolkit/

[@pizzaandmeth4538]

Hey Ryan,Just wanted to let you know your videos on fixed income topics helped me out a lit for the CFA level 1 and 2,i recently moved from an audit role to a structured finance role (CLO,CMBS,ABS etc)...Love a lot of the stuff you put out as it feels more practical and hand on in excel.....Cheers.

[@RyanOConnellCFA]

That feedback means a lot to me as you have been one of the people comment on my channel and videos for the longest time! I appreciate you coming back to let me know that the videos helped you out and that is awesome to hear that you landed such a desirable job. Good luck with the role and please come back to let me know how the new job is going

[@pizzaandmeth4538]

Haha ofcourse,began my level 3 prep lately and will be sure to rewatch some of your videos to brush up lol.

[@pizzaandmeth4538]

​@@RyanOConnellCFAAlso since you seem to have been in the industry for a while now I'm curious what your opinion is about the structured finance/securitization space..Have you worked in this area or seen anyone you know work there?.I'm loving the field so far but would love to hear your take.

[@RyanOConnellCFA]

@@pizzaandmeth4538 Awesome, I hope you get some value out of the videos for Level 3! I have never worked in a role that solely dedicated to securitization but I've got some exposure to it. For example, I managed the risk of an asset backed commercial paper program for the last company I worked for and found it to be very interesting. There was a lot of work that went into setting it up and making sure that everything is reported and measured properly. In my opinion, it is a cool space with lots of meaningful puzzles to solve

[@pizzaandmeth4538]

​@@RyanOConnellCFAThat's pretty cool,it's a bit of a niche area,but 5 months in and I find it interesting..let's see where it goes haha.

[@YoDeNYC]

Thanks Ryan for wonderful videos. One question for SOFR 3m future value you used product of all the daily rates but for 1m you just done the arithmetic average for all 30 days. I do not understand why different method for 3M vs 1M?

[@user-il2bq6mk3c]

amazing channel!!!

[@RyanOConnellCFA]

Thank you!!

[@jainsiddhant99]

Hi Ryan just wanted to ask you do you trade 3m sofr or fed fund futures regularly like the spreads and flys etc?

[@RyanOConnellCFA]

Hello, I do not but I got more intimately familiar with the 3 month SOFR futures math when I built out a complex model for a client that trades them

[@jainsiddhant99]

@@RyanOConnellCFA I understand can you by any chance get me in touch with that client as I would like to learn more about sofr spread trading and beyond

[@sidewalker6003]

where do you get the SOFR percent values from?

[@RyanOConnellCFA]

I got these from CME Groups website. You can get SOFR rates and export them to XLSX for a historical time range that you define using Market Watch

[@timsonparks]

What futures brokerage trades “SOFR”?

[@RyanOConnellCFA]

You can trade them on CME Group!