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 Наука
Please increase the voice of vidio