Static reports are dead.
Really. They’re physically dead [static (adj.) “lacking in movement, action, or change”] and metaphorically dead as financial advisors move toward live data reporting options.
Live financial data is easy to get your hands on. It’s HOW you use the live data that matters.
I recently recorded a conversation (below) with one advisor who uses live, publicly available data from Google Finance (similar to Yahoo Finance, etc) to build highly-customized reports in Google Spreadsheets. He also goes one step further and found a way to access live client portfolio data, too.
It’s a trick EVERY advisor can do. All you need is a Google account or the willingness to create one. If you want to pull in live data from clients’ portfolios (including their held-away accounts) like Jim does in the video, feel free to contact our team. We’d love to help.
If you’re a Blueleaf advisor, you can access live client data, too. Jim developed a way for ANY Blueleaf user to access client portfolio data in a Google Spreadsheet via the Blueleaf API. Watch the video to see what Jim does, and check out the resources listed below so you can do it, too.
Create LIVE Financial Reports in Google Spreadsheet
– basic understanding of how spreadsheets work
– a Google account, or willingness to create one
– a Blueleaf account (optional)
1.) Go to drive.google.com and ‘Create’ a new spreadsheet
2.) Pull in LIVE market data
-Use the GoogleFinance() functions to reference live market data.
Jim demonstrated these:
3.) Pull in LIVE client data (optional)
i. Implement the Blueleaf integration with Google Spreadsheets. Jim has enabled this using a ‘Google Script’. You can get his ‘Script’ code here: https://gist.github.com/jimkoch/8312098
ii. Create a “PARM” or “BlueleafData” tab to reference your Blueleaf advisor API token, an individual client’s Blueleaf ID#, and create a bank of their portfolio data. This will help you easily reference client portfolio data within the spreadsheet.
Jim demonstrated these:
=GetShareCountFromBlueleaf(<client id>,<account name>,”VBR”,<api token>)
=HYPERLINK(CONCATENATE(“https://<your site domain name>.blueleaf.com/home/select_active_user/”,<client id>)),”Click here!”)
4.) Format, design and share the info!
http://bit.ly/1eQtgis – GoogleFinance() Function Description and Available Attributes
http://bit.ly/JYyNKl – Google Spreadsheet Complete Function List
http://bit.ly/1eQReu7 – Google Script Snippet for Blueleaf Integration