3 ms·

Nice use of Sankey. Here's an ask or thought, I would like to feed this automatically with my spend data from my bank account. So I can export a csv that has ti

Nice use of Sankey. Here's an ask or thought, I would like to feed this automatically with my spend data from my bank account. So I can export a csv that has time-date, entity, amount (credit/debit) - would be great if it could spit this out by category (where perhaps an llm could help with this task). I would then like flow to be automated monthly or perhaps quarterly with major deltas (per my definition) then pushed to me via alerts. So this isn't so much active budget management but passive nudging where the shape of my spend changes something I don't look at now but would like to.

jvanderbot 2y ago
If you have a CSV and are happy using LLM, then you should ask an LLM to give you python code to generate a sankey plot. It's not difficult to wrangle.
- westurner 2y ago
  The Plaid API JSON includes inferred transaction categories. OFX is one alternative to CSV for transaction data. ofparse parses OFX: https://pypi.org/project/ofxparse/ https://pypi.org/project/ofxparse/ W3C ILP Interledger protocol is for inter-ledger data for traditional and digital ledgers. ILP also has a message spec for transactions.
strofocles 2y ago
I am working on an app like that. Far from being complete, at this point is syncing with live data from the banks (well, almost live, a few hours behind). My idea is to have the app do as much as possible for you and just tell you how you're doing: if you're saving enough, if you're spending more than usual on something, show you charts, project future savings at the current rate of saving accounting for interest/capital-gains etc. The app would incorporate sound financial planning principles (prioritise paying dept, invest some of the money, live below your means, etc). I'd love to hear from people who would be interested in this.
Ozzie_osman 2y ago
Hi! Co-founder or Monarch Money here. Our app actually does a big part of this (once you connect your bank accounts), and the Sankey flow visualization is one of our more popular visuals.
- jevogel 2y ago
  Thanks for chiming in here. I use Monarch and didn't realize there was a Sankey visualization. Actually I didn't know what that type of visual was even called before this post.
- deleted 2y ago
  [deleted]

jvanderbot 2y ago

If you have a CSV and are happy using LLM, then you should ask an LLM to give you python code to generate a sankey plot. It's not difficult to wrangle.

westurner 2y ago
The Plaid API JSON includes inferred transaction categories. OFX is one alternative to CSV for transaction data. ofparse parses OFX: https://pypi.org/project/ofxparse/ https://pypi.org/project/ofxparse/ W3C ILP Interledger protocol is for inter-ledger data for traditional and digital ledgers. ILP also has a message spec for transactions.

strofocles 2y ago

I am working on an app like that. Far from being complete, at this point is syncing with live data from the banks (well, almost live, a few hours behind). My idea is to have the app do as much as possible for you and just tell you how you're doing: if you're saving enough, if you're spending more than usual on something, show you charts, project future savings at the current rate of saving accounting for interest/capital-gains etc. The app would incorporate sound financial planning principles (prioritise paying dept, invest some of the money, live below your means, etc). I'd love to hear from people who would be interested in this.

Ozzie_osman 2y ago

Hi! Co-founder or Monarch Money here. Our app actually does a big part of this (once you connect your bank accounts), and the Sankey flow visualization is one of our more popular visuals.

jevogel 2y ago
Thanks for chiming in here. I use Monarch and didn't realize there was a Sankey visualization. Actually I didn't know what that type of visual was even called before this post.
deleted 2y ago
[deleted]