~1 min read
Google Sheets, and Google Documents for that matter, are turning into some really robust tools. If I were to start a company, I would use those tools for writing documents and building spreadsheets.
I was experimenting with the data import functionality of Google Sheets. I wanted to import some stock data and there is a native function called GOOGLEFINANCE. All I needed to do was enter =GOOGLEFINANCE(AAPL) and I would automatically get the current price of Apple, Inc.
You can take it to the next level and auto load in OHLCV data by just doing:
Similar functionality to Excel but the data import is so much nicer.
One of things that turned me off a few years ago were how clunky the charting capability was in Google Charts. It appears that this problem is being corrected.
Using the raw Google Sheet data for $AAPL, I was able to generate two charts: a candlestick chart and a volume & close chart.
Generating the candlestick chart was a bit tough though. I had to, in order, select the Open, Low, Close and High prices. That was a bit strange and Excel does this better.
Simply put, I like where Google is going with its Docs/Sheets/Charting offering. You can try playing with this here.