search

clincha / ElasticStar

A python script to automate the input of financial data from my bank account into the Elastic Stack
3 stars 0 forks source link

Put all transaction history for a single account into the database #4

Closed clincha closed 1 year ago

clincha commented 1 year ago

I can use my personal Starling account. I'll need to make some changes to the code to transfer the data into JSON documents. The Starling API returns a CSV for each statement period which is the worst way they could have done it but there may be a library to convert that output into JSON.

clincha commented 1 year ago

Visualisations created! It's so much easier to make them using Kibana rather than sheets.

image
clincha commented 1 year ago

Very pleased with so much progress in a couple of hours. I've been playing with it for a bit and there are some improvements to make

I think that adding data will be tough. Starling doesn't seem to give that data on the statement API but they could on the stream API so it's worth investigating the full offering more. The other accounts should be easier but I'll need an identifier added to the JSON document so that I can filter by the right account