Experimenting with Google Sheets

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:

=GOOGLEFINANCE(“AAPL”,“all”,TODAY()720,TODAY(),“weekly”)

appl-google-sheet-raw-ohlcv-data

Similar functionality to Excel but the data import is so much nicer.

Google Sheet Charts

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.

aapl-candlestick

 

AAPL Close vs Volume

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.

However, the do let you do scripting and marcos, which is similar to what Excel does in Visual Basic, but this is very Javascript like.

TL;DR

Simply put, I like where Google is going with its Docs/Sheets/Charting offering. You can try playing with this here.

Has Support Become Resistance

Welcome back to a new week, filled with new possibilities and market turmoil. I never traded the GBPUSD because it was insane to trade, so I’m sticking to the sidelines and watching. It sure has been fun to watch.

The question in my mind now is, has the support line flipped to resistance now? Only time will tell.

Viva La Resistance!

]]>

Brexit

I’m of the opinion that is will be good for the UK in the long run, but in the short term it will be very tumultuous for both the UK and the EU.

Source: Blot NMT Feed