I'm a big fan of Tiller [1], which is a paid service that basically just connects Yodlee to Google Docs or Excel. It will dump all your transactions and balance info into a spreadsheet and you can do what you want with it. It also has lots of templates for things like budgeting etc. I run a daily cron job that loads the transaction data and produces a nice Jupyter-based report. It will require some custom building, but the API plumbing is done for you.

[1]: https://www.tillerhq.com/