Visualize Stock Data in Google Sheets

Поделиться
HTML-код
  • Опубликовано: 17 июл 2024
  • Learn how to import securities data into Google Sheets with the GOOGLEFINACE function. Then, learn to visualize that data with charts and custom number formatting.
    Links:
    Insert Special Characters Add-On -workspace.google.com/marketpl...
    GOOGLEFINANCE - sheetshelp.com/googlefinance/
    INDEX - sheetshelp.com/index/
    Timestamps:
    0:00 Intro
    0:24 GOOGLEFINANCE function
    1:08 Real-time stock data
    8:01 Historical stock data
    10:21 INDEX function
    11:43 Year-over-year change
    14:20 Charting the data
    16:45 Colors and arrow with custom number formatting
    19:40 Next video - Use EVERY date function
    #spreadsheet #googlesheets #googlefinance
  • НаукаНаука

Комментарии • 1