Matt Macarty
Matt Macarty
  • 139
  • 6 860 530
Calculate How Much You Can Spend in Retirement with Excel: A Step-by-Step Guide
@MattMacarty
#excel #nper #pmt
alphabench.com/data/excel-nper-function.html
✅ Download the file used in the tutorial: alphabench.com/data/excel-nper-function.html
✅ Learn how to use the PMT function: alphabench.com/data/excel-pmt-function.html
✅ See more advanced loan amortization: alphabench.com/data/excel-amortization-tutorial.html
✅ Get the tool that helps you get subscribers: vidiq.com/alphabench
Do you want to know how long your retirement savings will last? Luckily, you can use Excel functions to estimate the answer! In this video, we're going to show you how to use the Excel NPER and PMT functions to calculate how long your retirement savings will last.
This video is a great resource for anyone who wants to know how long their retirement savings will last. We'll walk you through the steps necessary to use these functions to calculate a reasonable estimate. After watching this video, you'll be able to estimate how long your retirement savings will last with ease!
If you're planning on retiring soon, then you'll want to learn how to use Excel's NPER and PMT functions to estimate how long your retirement savings will last.
In this video, we'll show you how to use Excel's NPER and PMT functions to calculate how long your retirement savings will last. We'll also discuss some common scenarios in which you might use these functions, and give you some tips on how to get the most out of them. So whether you're a beginner or a power user, this video is a great introduction to Excel's NPER and PMT functions!
Переглядів: 1 278

Відео

Pay Off Your Mortgage Loan Faster with Excel NPER Function
Переглядів 1,8 тис.Рік тому
​@MattMacarty #Excel #NPER #mortgagepayoff alphabench.com/data/excel-nper-function.html ✅ Download the spreadsheet: alphabench.com/data/excel-nper-function.html ✅ See our PMT function tutorial: alphabench.com/data/excel-pmt-function.html ✅ Learn more advanced amortization: alphabench.com/data/excel-amortization-tutorial.html Learn mortgage payoff strategies using Excel and the NPER function. Th...
Create a Live Trend Following Algorithmic Trading Bot for Gold
Переглядів 9 тис.Рік тому
​ @MattMacarty #algotrading #python #tradingbots How to Code a Trading Bot in Python Building a Gold Trend Trading Bot with Python, Lumibot and Alpaca: A Step by Step Guide ✅ Please SUBSCRIBE: ua-cam.com/users/mjmacarty ✅ Get the code: github.com/mjmacarty/algorithmic-trading ✅ Learn the basics here: ua-cam.com/video/Dek7sKHJ7Zw/v-deo.html ✅ Lumibot Documentation: lumibot.lumiwealth.com ✅ Alpac...
How to Build a Python Momentum Algorithm Trading Bot w/ Lumibot & Alpaca
Переглядів 11 тис.Рік тому
​ @MattMacarty #algotrading #python #tradingbots How to Code a Trading Bot in Python Building a LIVE Stock Trading Bot with Python, Lumibot and Alpaca: A Step by Step Guide ✅ Please SUBSCRIBE: ua-cam.com/users/mjmacarty ✅ Get the code: github.com/mjmacarty/algorithmic-trading ✅ Learn the basics here: ua-cam.com/video/Dek7sKHJ7Zw/v-deo.html ✅ Lumibot Documentation: lumibot.lumiwealth.com ✅ Alpac...
Building a LIVE Algorithmic Trading Bot with Python, Lumibot and Alpaca: A Step by Step Guide
Переглядів 21 тис.Рік тому
​@MattMacarty #algotrading #python #tradingbots How to Code a Trading Bot in Python Building a LIVE Stock Trading Bot with Python, Lumibot and Alpaca: A Step by Step Guide ✅ Please SUBSCRIBE: ua-cam.com/users/mjmacarty ✅ Get the code: github.com/mjmacarty/algorithmic-trading ✅ Lumibot Documentation: lumibot.lumiwealth.com ✅ Alpaca Markets: alpaca.markets ✅ Visit alphabench.com for more Excel, P...
Build a Stock Trading System with Python Trading Bots and Alpaca Markets Trading API
Переглядів 25 тис.Рік тому
@MattMacarty #python #trading #algotrading ✅ Please SUBSCRIBE: ua-cam.com/users/mjmacarty ✅ Get a free class and support us by visiting our sponsor: lumiwealth.com/macarty ✅ Visit alphabench.com for more Excel Python and MySQL tutorials ✅ Get the code: github.com/mjmacarty/algorithmic-trading In this tutorial, we'll show you how to get started with the Alpaca Markets Python trading API. This AP...
How to Backtest Trading Algorithms and Portfolio Metrics with Python and QuantStats
Переглядів 10 тис.Рік тому
​@MattMacarty #python #trading #algotrading How to Backtest Trading Strategies and Algorithms, Generate Portfolio Metrics ✅ Please SUBSCRIBE: ua-cam.com/users/mjmacarty ✅ Get a free class and support us by visiting our sponsor: lumiwealth.com/macarty ✅ Visit alphabench.com for more Excel Python and MySQL tutorials ✅ Get the code: github.com/mjmacarty/algorithmic-trading In this video, we'll be ...
Python Stock Analysis: Create & Publish Your Own Custom Python Packages with Pip in VS Code
Переглядів 2,1 тис.Рік тому
​ @Matt Macarty #python #trading #algotrading ✅ Please SUBSCRIBE: ua-cam.com/users/mjmacarty ✅ Visit Lumiwealth for more about their algorithmic trading courses & signup for a free course: lumiwealth.com/macarty Make Python Packages for Distributing and Installing Code ✅ Please SUBSCRIBE: ua-cam.com/users/mjmacarty Videos: [Part 1](ua-cam.com/video/bKUZrBAzqJs/v-deo.html) [Part 2](ua-cam.com/vi...
How to Resize Images for Use on Webpages and Websites
Переглядів 2,6 тис.Рік тому
@MattMacarty Use a free tool to resize your large images for use on the web www.online-image-editor.com/
How to Automatically Integrate Financial Data with Google Sheets
Переглядів 6 тис.Рік тому
@MattMacarty Use a free add on to access data financial data from around the world. For more information about our sponsor please visit: lumiwealth.com/macarty 0:00 - Introduction to EODHD Financial Data APIs with Google Sheets Add-In ✅ If you are interested in subscribing to a data bundle from EODHistoricalData, use this link for special pricing (I get a referral): eodhistoricaldata.com/alphab...
Python for Stock Analysis: Filter Data by Option Expiration and Volatility || Part 13
Переглядів 1,7 тис.Рік тому
​ @Matt Macarty #dataanalytics #pythonprogramming #stockmarket Calculate and Normalize Stock Returns ✅ Please SUBSCRIBE: ua-cam.com/users/mjmacarty Videos: [Part 1](ua-cam.com/video/bKUZrBAzqJs/v-deo.html) [Part 2](ua-cam.com/video/KKVZHKDEKFA/v-deo.html) [Part 3](ua-cam.com/video/emHY55Svxac/v-deo.html) [Part 4](ua-cam.com/video/dPloA2TAo_c/v-deo.html) [Part 5](ua-cam.com/video/OYS75jihV5Y/v-d...
How to Calculate & Normalize Expected Stock Returns || Python Stock Analysis Part 12
Переглядів 1,9 тис.Рік тому
​ @Matt Macarty #dataanalytics #pythonprogramming #stockmarket Calculate and Normalize Stock Returns ✅ Please SUBSCRIBE: ua-cam.com/users/mjmacarty Videos: [Part 1](ua-cam.com/video/bKUZrBAzqJs/v-deo.html) [Part 2](ua-cam.com/video/KKVZHKDEKFA/v-deo.html) [Part 3](ua-cam.com/video/emHY55Svxac/v-deo.html) [Part 4](ua-cam.com/video/dPloA2TAo_c/v-deo.html) [Part 5](ua-cam.com/video/OYS75jihV5Y/v-d...
Python for Stock Analysis: Automatically Calculate & Graph Stock Returns & Volatility || Part 11
Переглядів 3,3 тис.Рік тому
​ @Matt Macarty #dataanalytics #pythonprogramming #stockmarket Use API to create a stock screener ✅ Please SUBSCRIBE: ua-cam.com/users/mjmacarty Videos: [Part 1](ua-cam.com/video/bKUZrBAzqJs/v-deo.html) [Part 2](ua-cam.com/video/KKVZHKDEKFA/v-deo.html) [Part 3](ua-cam.com/video/emHY55Svxac/v-deo.html) [Part 4](ua-cam.com/video/dPloA2TAo_c/v-deo.html) [Part 5](ua-cam.com/video/OYS75jihV5Y/v-deo....
Automate Stock Analysis with Python & Excel
Переглядів 2,2 тис.Рік тому
​ @Matt Macarty #dataanalytics #pythonprogramming #stockmarket Create Stock class in Python to automate stock data analysis ✅ Please SUBSCRIBE: ua-cam.com/users/mjmacarty Videos: [Part 1](ua-cam.com/video/bKUZrBAzqJs/v-deo.html) [Part 2](ua-cam.com/video/KKVZHKDEKFA/v-deo.html) [Part 3](ua-cam.com/video/emHY55Svxac/v-deo.html) [Part 4](ua-cam.com/video/dPloA2TAo_c/v-deo.html) [Part 5](ua-cam.co...
How to Create a Stock Screener Using an API || Stock Analysis with Python Part 9
Переглядів 5 тис.Рік тому
​ @Matt Macarty #dataanalytics #pythonprogramming #stockmarket Use API to create a stock screener ✅ Please SUBSCRIBE: ua-cam.com/users/mjmacarty Videos: [Part 1](ua-cam.com/video/bKUZrBAzqJs/v-deo.html) [Part 2](ua-cam.com/video/KKVZHKDEKFA/v-deo.html) [Part 3](ua-cam.com/video/emHY55Svxac/v-deo.html) [Part 4](ua-cam.com/video/dPloA2TAo_c/v-deo.html) [Part 5](ua-cam.com/video/OYS75jihV5Y/v-deo....
Stocks About to Announce Earnings or Dividends! (Download Now!)
Переглядів 1,1 тис.2 роки тому
Stocks About to Announce Earnings or Dividends! (Download Now!)
Python for Stock Analysis: Plotting Performance Grid of Multiple Securities w\\matplotlib || Part 7
Переглядів 1,2 тис.2 роки тому
Python for Stock Analysis: Plotting Performance Grid of Multiple Securities w\\matplotlib || Part 7
Download, Transform and Write Data to Excel with Python || Stock Analysis with Python Part 6
Переглядів 1,1 тис.2 роки тому
Download, Transform and Write Data to Excel with Python || Stock Analysis with Python Part 6
Calculate Returns, Create Correlation Matrix, Plot Performance || Stock Analysis with Python Part 5
Переглядів 2,2 тис.2 роки тому
Calculate Returns, Create Correlation Matrix, Plot Performance || Stock Analysis with Python Part 5
Stock Analysis with Python: How to Extract Price Data from Files || Part 4
Переглядів 1,9 тис.2 роки тому
Stock Analysis with Python: How to Extract Price Data from Files || Part 4
How to Download and Save Stock Price Data || Stock Analysis with Python Part 3
Переглядів 2,8 тис.2 роки тому
How to Download and Save Stock Price Data || Stock Analysis with Python Part 3
How to Download S&P 500 Stock Symbols, Filter by Sector || Stock Analysis with Python Part 2
Переглядів 4,6 тис.2 роки тому
How to Download S&P 500 Stock Symbols, Filter by Sector || Stock Analysis with Python Part 2
How to Get a List of Stocks on an Exchange || Stock Analysis with Python Part 1
Переглядів 9 тис.2 роки тому
How to Get a List of Stocks on an Exchange || Stock Analysis with Python Part 1
How to Add Image Icons to HTML Web Pages with Font Awesome
Переглядів 6 тис.2 роки тому
How to Add Image Icons to HTML Web Pages with Font Awesome
How to RENAME, COPY, EDIT & MODIFY DATABASES, ADD & DROP FOREIGN KEY, CONSTRAINTS in MySQL Workbench
Переглядів 11 тис.2 роки тому
How to RENAME, COPY, EDIT & MODIFY DATABASES, ADD & DROP FOREIGN KEY, CONSTRAINTS in MySQL Workbench
How Add a Foreign Key Constraint (Make Relationships) in MySQL WorkBench
Переглядів 138 тис.2 роки тому
How Add a Foreign Key Constraint (Make Relationships) in MySQL WorkBench
Python Automation Project: Mortgage Loan Analysis Application Part II
Переглядів 1,5 тис.2 роки тому
Python Automation Project: Mortgage Loan Analysis Application Part II
Python for Finance Automation Project: Make a Mortgage Loan Analysis Class
Переглядів 3,9 тис.2 роки тому
Python for Finance Automation Project: Make a Mortgage Loan Analysis Class
Find Number of Payments in a Loan with Python & NumPy Financial nper Function
Переглядів 1,5 тис.2 роки тому
Find Number of Payments in a Loan with Python & NumPy Financial nper Function
Calculate & Analyze Loan Payments with Python NumPy Financial pmt Function
Переглядів 4,1 тис.2 роки тому
Calculate & Analyze Loan Payments with Python NumPy Financial pmt Function

КОМЕНТАРІ

  • @gabrielbarwick9547
    @gabrielbarwick9547 День тому

    Hi, great video, for the last one, would you need to add shift() after the mean() so that it doesnt use future data?

  • @user-lu5jj8qs3h
    @user-lu5jj8qs3h 2 дні тому

    You could simplify a bit by using monthly returns and basically get the same result.

  • @pz1430
    @pz1430 2 дні тому

    Very nicely done.

  • @SRHarkreader
    @SRHarkreader 12 днів тому

    Excellent! Clear verbal instructions with demonstrations of exactly what I needed to know. Thank you!

  • @grandsroisverifiedproperti9286
    @grandsroisverifiedproperti9286 14 днів тому

    Ho i am implenting a trading application with REST. Stream and Websockets. It supoort live and paper use cases for allpaca users I am stock with the get_account() initialize_api_client since its Ouath 2.0 how do we ensure the api calls are made to ensure the alpaca user information is fetch. Will this be done woith headers annd base_url or access_token and base_url

  • @yuxuanlin1971
    @yuxuanlin1971 18 днів тому

    Thank you for sharing Matt! I have one question - It's very cool to generate a Plotly interactive graph from Lumibot. I wanted to dig into the package and find the code that generated the graph but I couldn't find it. Do you know where in Lumibot embedded this function? It'll be so much easier to leverage it on other data visualization projects.

    • @MattMacarty
      @MattMacarty 15 днів тому

      Sorry. I haven't examined their code. Try holding control key and click on the lumibot class to open the underlying code.

    • @yuxuanlin1971
      @yuxuanlin1971 14 днів тому

      @@MattMacartyYea, that's what I did. I was guessing it's in lumibot.strategies but I only found matplotlib library but the graph is generated by plotly. Also, I didn't find where in lumibot is embedded QuantStats neither. Appreciate it if you could help provide some clues.

  • @kakhatabatadze5106
    @kakhatabatadze5106 19 днів тому

    Thanks but download link does not work.

    • @MattMacarty
      @MattMacarty 15 днів тому

      Seems to be working. Can you try again?

  • @Donxkelo
    @Donxkelo 22 дні тому

    I can’t get the file for the data. I NEED HELP

    • @MattMacarty
      @MattMacarty 15 днів тому

      Trey cloning the github repository to your computer

  • @jacquesmieny1705
    @jacquesmieny1705 Місяць тому

    what is the maximum amount of iterations you can run on Excel for something such as this? I have a project similar but must run about 1 000 000 iterations

    • @MattMacarty
      @MattMacarty Місяць тому

      Technically you can do 1,000,000 but I think it will be quite slow.

    • @jacquesmieny1705
      @jacquesmieny1705 Місяць тому

      @@MattMacarty thanks!

  • @lokeshsomu5444
    @lokeshsomu5444 Місяць тому

    great job sir👏

  • @monkeyhanger115
    @monkeyhanger115 Місяць тому

    For some reason, mine won't work when applying column B3 into the formulae at 2:00

    • @MattMacarty
      @MattMacarty Місяць тому

      You can download the file I used by following the link in the description

    • @monkeyhanger115
      @monkeyhanger115 Місяць тому

      @@MattMacarty ah okay great thank you

  • @raphaelbonillo2192
    @raphaelbonillo2192 Місяць тому

    This is not a forecast. Where is the extrapolation with the data? You are just drawing the trend

    • @MattMacarty
      @MattMacarty Місяць тому

      This kind of model will forecast out one period into the future. Most of the work is to fit the model and measure how well it can be expected to forecast.

  • @ElCidPhysics90
    @ElCidPhysics90 Місяць тому

    Thank you for these videos.

  • @HisyamHilmiOmar-jx7mx
    @HisyamHilmiOmar-jx7mx Місяць тому

    Hi, great tutorial! Just one quick question, for the value of the moving average, what does 21 stand for, is it the length of the moving average or the actual value of the moving average? Can you elaborate further on how you derived the value of 21 for the moving average?

    • @MattMacarty
      @MattMacarty Місяць тому

      21 is the number of periods in the moving average. This is the number of trading days in a month.

  • @vivig7727
    @vivig7727 Місяць тому

    Can you elaborate more on why you multiplied the variance of AAPL by 252? I downloaded data for a stock of the past 3 years, what would i do there to adjust the variance? Also multiply by 252? If I do this, is my VaR having the same interpretation as yours?

    • @MattMacarty
      @MattMacarty Місяць тому

      I calculated the daily variance for one year of data (252 days). To annualize the variance multiply by 252.

  • @JanWestend
    @JanWestend Місяць тому

    Great video! Can you tell me how to stop the bot/ the run_all function for the Trader? I know there is a function called stop_all, but once I started run_all, it runs forever

    • @MattMacarty
      @MattMacarty Місяць тому

      You can just stop in the IDE or close the program

  • @jacobjones4387
    @jacobjones4387 2 місяці тому

    Really helpfull. Thanks!

  • @EricNsi
    @EricNsi 2 місяці тому

    You sound like the dude from ua-cam.com/channels/mrLCXSDScliR7q8AxxjvXg.html

    • @MattMacarty
      @MattMacarty 2 місяці тому

      Yeah sort of I guess

    • @MattMacarty
      @MattMacarty 2 місяці тому

      But gosh I don't push propaganda do I?

    • @EricNsi
      @EricNsi Місяць тому

      @@MattMacarty SQL propaganda I guess

  • @munivoltarc
    @munivoltarc 2 місяці тому

    Hi, try not to use price, lagging indicators, instead use price action strategy, will give accurate results, can you do this, many viewers are fed-up seeing these price lagging indicators usage in different channels of youtube.

    • @MattMacarty
      @MattMacarty 2 місяці тому

      This is for demonstrating how to write a simple back tester, not really interested in a strategy. Any strategy worth anything will not be found on UA-cam.

  • @kamalkushwah2659
    @kamalkushwah2659 2 місяці тому

    Thank you so much for this type of detailed video you save me...

  • @greenblue980
    @greenblue980 2 місяці тому

    thanks alot! i forgot about that lightning thing 😂

  • @imnitin97
    @imnitin97 2 місяці тому

    Hi , I have a doubt about the calculation, The covar. Between SPY and SPY should be 1 but why we have such a less number in the calculation

    • @MattMacarty
      @MattMacarty 2 місяці тому

      The COVAR of SPY vs SPY is the variance

  • @possessedbear651
    @possessedbear651 2 місяці тому

    i get an error now saying endpoint in my config file is deprecated and should be replaced with "PAPER"... however... then it wont run the program

    • @MattMacarty
      @MattMacarty 2 місяці тому

      It looks like the lumibot package has been updated since making the video. Check their documentation

  • @gaurav2979
    @gaurav2979 2 місяці тому

    Thanks for sharing Man, keep up the good work

  • @adindahumairah1511
    @adindahumairah1511 2 місяці тому

    Thank youuu

  • @BrianGarside
    @BrianGarside 2 місяці тому

    Helpful, but take too long to make a point like when creating a foreign key.

  • @gustavorosas-dev
    @gustavorosas-dev 2 місяці тому

    Thank you so muuuuch!

  • @zoeorlich5445
    @zoeorlich5445 2 місяці тому

    Was so frustrated trying to remember what I did in excel for a certain problem in my finance class and this helped me so much thank you!!!

  • @vyetundebello810
    @vyetundebello810 2 місяці тому

    This is the most explainative and concise MYSQL, thanks so much, really appreciate and will definitely follow u all the way.🙏🏽

  • @mdawg998
    @mdawg998 2 місяці тому

    I'm new to coding. I straight up cannot figure out how to get Lumibot available for this program. I went to terminal. Did the pip install. Now what? I cannot find out to actually include it.

    • @MattMacarty
      @MattMacarty 2 місяці тому

      You can follow the link in the description to get the code. You just need to import lumibot in your code

  • @gtrdotone3735
    @gtrdotone3735 2 місяці тому

    @ 11:27 should the square of cell I5 equal to cell D5 since SPY to SPY is variance of SPY? Square of .3204=.1017 which is not what is shown in cell D5!!!

    • @MattMacarty
      @MattMacarty 2 місяці тому

      These are daily values and need to get adjusted to annualize ( x 252)

  • @jameskydd459
    @jameskydd459 2 місяці тому

    Hi Matt, thanks for the really useful tutorial, wondered if you are able to add a variable to this calculations if you invest an extra amount each month? i would assume to use an average of the month beg or month end price, or just by picking month end or month beginning. if you have a video on that already or a way to add it to the model this would be great.

    • @MattMacarty
      @MattMacarty 2 місяці тому

      Thanks. Yes you can do it that way , or just add money at the end of each month where you have a data point that is closer to where you can buy. Just remember these models are approximations.

  • @chentomerify
    @chentomerify 3 місяці тому

    hey matt!, loved the video! i have trouble installing pip lumibot. it says there is something wrong with the package itself(not pip). is it possible that lumibot isnt working with my python version (3.12.12)? thank you!

    • @MattMacarty
      @MattMacarty 2 місяці тому

      My guess is it is one of the dependencies such as pandas that is causing the problem. You likely havea newer version of pandas than is supported by lumibot. You can try downgrading to something like 1.5 and see if that solves the probelm. ALso you can contact lumiwealth and they will get you going.

  • @dikshamatia1962
    @dikshamatia1962 3 місяці тому

    Is it possible to do it on google sheets?

    • @MattMacarty
      @MattMacarty 2 місяці тому

      I don't think there is an extension that does this in Sheets

  • @robbiefelts6895
    @robbiefelts6895 3 місяці тому

    12 Years later and still helps, Thanks.

    • @MattMacarty
      @MattMacarty 2 місяці тому

      Yeah, this stuff doesn't really change, just the interface looks a little different

  • @AleksOMFG
    @AleksOMFG 3 місяці тому

    I can't get the data ( TypeError: string indices must be integers, not 'str' ) I tryied the override of yfinance but it doesn't work neither.

    • @MattMacarty
      @MattMacarty 3 місяці тому

      Try using yfinance directly: yf.download(...)

    • @AleksOMFG
      @AleksOMFG 3 місяці тому

      @@MattMacarty Just finished doing a program with tkinker with it thank you, Im new in coding. 😂 Great tutorial keep it up!!!

  • @mrityunjaypathak8792
    @mrityunjaypathak8792 3 місяці тому

    You saved my time. Was looking for this for my project ! Thank you Matt.

  • @hackerborabora7212
    @hackerborabora7212 3 місяці тому

    I just find this channel waw you are amazing put more videos

  • @LeonardoZ-wq8vr
    @LeonardoZ-wq8vr 3 місяці тому

    Can someone explain what's the difference between Buy/Hold (blue line) and System line (orange one) at 14:31?

    • @MattMacarty
      @MattMacarty 3 місяці тому

      So the blue line shows what would happen if you bought in 2016 and just held gold without any adjustments. The orange line is what would have happened if you tried to catch the swings in prices based on a simple moving average.

  • @zirusgaming3245
    @zirusgaming3245 3 місяці тому

    I am using a mac and for some reason the tools to create the relationship is not there. How do I get the tools on the left hand side. Thank you

    • @MattMacarty
      @MattMacarty 3 місяці тому

      I think the tools are just not super obvious in MAC. They should run down left edge of the diagram window.

  • @b4f495
    @b4f495 3 місяці тому

    if im buying and holidng why is the growth percentage different from the charts?

    • @MattMacarty
      @MattMacarty 3 місяці тому

      Not sure what you mean by this. If you mean percent change in value that will be somewhat different than an annual growth rate.

    • @b4f495
      @b4f495 3 місяці тому

      @@MattMacarty why is that since im just buying and holding? good video tho thanks!

  • @navaneethmajji
    @navaneethmajji 3 місяці тому

    Files are not opened in m desktop

    • @MattMacarty
      @MattMacarty 3 місяці тому

      You want to open files from within Workbench. Choose open script

  • @henrytzuo8517
    @henrytzuo8517 3 місяці тому

    Thank you so much!! Very clear!!🙂🙂🙂

  • @user-yj9pi9fo6t
    @user-yj9pi9fo6t 3 місяці тому

    this is excellent work! many thanks

  • @sagetimmy6310
    @sagetimmy6310 3 місяці тому

    Well explained ❤

  • @smash666
    @smash666 3 місяці тому

    Thanks Matt!

  • @skynet7065
    @skynet7065 3 місяці тому

    I'm attempting to make some adjustments to the model, but I believe I might be overlooking something. I'm trying to shift from daily stock prices to annual ones. I hypothesized that I would observe the stock price at the end of year 20 (and not day 21), so I used annual volatility (30,42) instead of the daily computed volatility. However, the results I'm obtaining are strange. Firstly, the mean price is no longer centered around the initial price. Secondly, the distributions of quantiles are inconsistent; I'm only observing 25% of simulated results exceeding the starting price, whereas I expect at least 50% on average. What could be the missing element in my approach?

    • @MattMacarty
      @MattMacarty 3 місяці тому

      The method I am using would require you to simulate each day out to 252 days. If you want generate a possible ending price in one-step you would need to use a different formulation: price * exp((r - .5 * sigma^2)* T + sigma * sqrt(T) * standard_normal variate)

    • @skynet7065
      @skynet7065 3 місяці тому

      @@MattMacartythanks, still I don’t quite get it. The formula you provided is the one which I would use if I wanted to have the price at the end of the period right? (e.g. the price 21 days in the future) I’m actually trying to “substitute” the days in the future with the years in the future in your calculation. For this I would use the annual volatility and keep the formula you used in the video but I get inconsistent results. Also, i don’t quite understand why if the daily volatility is higher the distribution of ending prices is not normal anymore. I’m worried I’m missing something

    • @MattMacarty
      @MattMacarty 3 місяці тому

      @@skynet7065Yes that's right, but it's a possible price

  • @user-gb9sc8mf7u
    @user-gb9sc8mf7u 4 місяці тому

    congratulation from Brazil

  • @jimgrant1776
    @jimgrant1776 4 місяці тому

    Matt, fine video. Excellent explanation of the models. In regard to the 7 security model, the solution is near-obvious. That is, maximize the allocation to the securities with the highest returns and minimize the allocations to the securities with low Sharpe Ratios, subject to the mins and maxs pre-established by the user.

    • @MattMacarty
      @MattMacarty 4 місяці тому

      Yes that's right. You could set constraints in Solver to make sure some minimum and/or maximum allocation is met. I more or less just wanted to show how to use portfolio theory with more than 2 or 3 securities.

  • @Ibrahim-bv3dy
    @Ibrahim-bv3dy 4 місяці тому

    I'm trying to change the gld to NVDA in your lumibot_trend.py file but no such luck. I'm following along on google colab since you have to pay for an anaconda environment setup anyway. I got it to work and it kept buying and selling GLD but I think the algorithm was confused and would sell low and buy high instead. Do you have a course or consultation specifically on trading bots with colab on alpaca?