Custom Google Spreadsheets
No doubt about it. I’m old school when it comes to my financial planning tool set. I still prefer spreadsheets to out-of-box apps given their flexibility and ease of customization. I still use balance sheets as my primary method of evaluating household assets and liabilities. I’m picky. I like my financial data in format that I can explain to clients.
Recently, I shared my thoughts regarding Koch Capital’s use of web-based Google Spreadsheets for customized financial reporting and client collaboration with Blueleaf’s Carolyn McRae. Click here to watch the interview on YouTube.
Click image to play video
Opening Up the Kimono
Application vendors like Blueleaf and others are starting to open up what traditionally had been proprietary (closed) systems where the vendor dictated what the user sees and how the data can be used. In more open architectures, the user can retrieve and use the data in ways the vendor may or may not currently envision. Essentially, power is being returned to the user as more and more application vendors seek Apple iTunes-like eco-systems where client-initiated apps run alongside the standard vendor implementations.
Developing a simple integration from Google Spreadsheets to Blueleaf using a straightforward, web-based application interface is the next step in improving product functionality and strengthening the vendor-user relationship. I just hope more financial application vendors get with the program.
Your humble geek advisor…….Jim
Additional Resources for the Intrepid
GoogleFinance() Function Description and Available Attributes:
Google Spreadsheet Complete Function List:
Google Apps Script Tutorials:
Blueleaf API Documentation:
Google Script Snippet for Blueleaf Integration:
--- or ---
About Jim Koch
Jim Koch is the Founder and Principal of Koch Capital Management, an independent State Registered Investment Advisor (RIA) in the San Francisco Bay Area. He specializes in providing customized financial solutions to individuals, families, trusts and business entities so they are better able to achieve their goals. Jim sees himself as an “implementer” of financial innovation, using state-of-the-art technology to provide practical investment management and retirement planning solutions for clients.
This information is provided for informational/educational purposes only. The opinions referenced are as of the date of publication and are subject to change due to changes in the market or economic conditions and may not necessarily come to pass. Nothing presented herein is or is intended to constitute investment advice, and no investment decision should be made based on any information provided herein. The information contained herein, while not guaranteed as to the accuracy or completeness, has been obtained from sources we believe to be reliable. Past performance is no guarantee of future results.
Any forward looking statements or forecasts are based on assumptions and actual results are expected to vary from any such statements or forecasts. No reliance should be placed on any such statements or forecasts when making any investment decision.Under no circumstances does the information contained within represent a recommendation to buy or sell any particular security or pursue any investment strategy. There is a risk of loss from an investment in securities. Different types of investments involve varying degrees of risk, and there can be no assurance that any specific investment will be profitable or suitable for a particular investor’s financial situation or risk tolerance. Asset allocation and portfolio diversification cannot assure or guarantee better performance and cannot eliminate the risk of investment losses. Please refer to the Site Disclosure page for additional information.
Third Party InformationWhile Koch Capital has used reasonable efforts to obtain information from reliable sources, we make no representations or warranties as to the accuracy, reliability, timeliness, or completeness of third party information presented herein. Any third party trademarks appearing herein are the property of their respective owners. At certain places on this website, live 'links' to other Internet addresses can be accessed. Koch Capital does not endorse, approve, certify, or control the content of such websites, and does not guarantee or assume responsibility for the accuracy or completeness of information located on such websites. Any links to other sites are not intended as referrals or endorsements, but are merely provided for convenience and informational purposes. Use of any information obtained from such addresses is voluntary, and reliance on it should only be undertaken after an independent review of its accuracy, completeness, efficacy, and timeliness.