A candlestick chart is a multiple purpose graph that can provide information about stock history (i.e., open, close, high and low prices) in one consolidated view. Google Sheets give you a way to view a stock history via the ticker symbol in a table and then put it into a candlestick chart. In addition, you can set it up to dynamically pull in different stocks as you enter the new ticker symbol in.
In this video, I'll cover how to cover how to create a basic candlestick chart and how to create a box plot (or box and whiskers) with the candlestick chart feature. Caveat: It's not a full fledge box plot, more of a pseudo box plot because it doesn't include a median statistic. Lastly I'll cover how to create a dynamic stock history table and the candlestick chart that pulls it's data from that table.
0:00 Intro
2:04 Basic Candlestick Chart
3:45 Pseudo Box Plot Chart
5:08 Editing Candlestick Chart
6:36 Dynamic Stock Ticker Candlestick Chart
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#googlesheets
#excel
#msexcel
#doughexcel
11 июл 2024