Investboy
Member of DD Central
Trying to recover from P2P revolution
Posts: 564 
Likes: 201
|
Post by Investboy on Apr 22, 2016 9:08:12 GMT
It's a bit mind-blowing what you guys do with your spreadsheets. And when you find time to do this. No offence but I have no time to do it between commuting & work, family & young children, house chores ect. I barely do a monthly review of my whole finances, which P2P is part where I record amount invested, received interests, current value. SteveT , GSV3MIaC : are you guys employed or maybe retired or running own businesses? |
|
SteveT
Member of DD Central
Posts: 6,873
Likes: 7,918
|
Post by SteveT on Apr 22, 2016 9:15:06 GMT
It's a bit mind-blowing what you guys do with your spreadsheets. And when you find time to do this. No offence but I have no time to do it between commuting & work, family & young children, house chores ect. I barely do a monthly review of my whole finances, which P2P is part where I record amount invested, received interests, current value. SteveT , @gsv3miac: are you guys employed or maybe retired or running own businesses? Semi-retired but treating P2P as a part-time "hobby that pays" ... with luck! Most of the time investment is getting the tracking spreadsheets set up in the first place so that a quick copy & paste from a CSV extract every so often updates things automatically.
|
|
|
|
Post by GSV3MIaC on Apr 22, 2016 16:20:34 GMT
/mod hat off ..
Retired these many years, so coding the odd database/bot is a bit of light relief, with the occasional opportunity of a profit (for good causes), or at least an excuse to hover over the PC.
I suppose I could go back into the profession and sort out FC's software management for them, but it's much more fun (and less stressful) to watch the car crash from the sidelines, and snipe.
|
|
michaelc
Member of DD Central
Posts: 4,866
Likes: 2,762
|
Post by michaelc on Jul 8, 2017 20:21:24 GMT
Apologies also for bringing up a slightly old thread but it seemed the most relevant to my point which is why don't the transaction statements include a "balance" figure?
|
|
|
|
Post by william0101 on Jul 8, 2017 21:45:57 GMT
michaelc because they're a transaction stream and FC are actually doing that bit right IMO, the balance is a post-event sum not a transaction time sum, the double entry accounting in the transaction list is abysmal and requires considerable effort to reconcile (more below about how I do that),
|
|
|
|
Post by william0101 on Jul 14, 2017 14:04:46 GMT
michaelc because they're a transaction stream and FC are actually doing that bit right IMO, the balance is a post-event sum not a transaction time sum, the double entry accounting in the transaction list is abysmal and requires considerable effort to reconcile (more below about how I do that), ff self, apols Has anyone done an SQL Entity Relationship Diagram for the FC csv files before? No point in redoing it if already done. Also if I explain further (the tables are incomplete) is it usual practice to start what might be quite a lengthy and (for some) detailed thread or should I carry on here? As well as making database sense of the FC stuff I've also worked the accounting out and can describe that in a general sense. Guidance, please.
|
|
adrian77
Member of DD Central
Posts: 3,895
Likes: 4,122
|
Post by adrian77 on Jul 14, 2017 19:48:32 GMT
SQL Entity Relationship Diagram - are you having a laugh!
I really don't believe this database is properly structured -in fact I don't think it is anywhere close
I am ex-IT and the data relationships look a right mess to me and I wonder if it has flat files in places as he data retrieval is so slow in places.
|
|
|
|
Post by william0101 on Jul 15, 2017 8:56:08 GMT
If it was properly structured in the first place I wouldn't be offering an ERD with a glue / link table and rebuilt statement file to make the damn thing work and we wouldn't be having this conversation at all.
Since I have worked it out (including the accounting) I'm offering it to other people that are interested.
Notes from reading back through the thread:
1. my "glue / link table" is for fixing the problem of parts disjointing from loans GSV3MIaC mentions above
2. re accounting: mine is penny perfect except for SQL rounding errors so far but I've only been at this for a few months so there may be some weirdness I haven't seen. The main problem with the statement csv files is working out what constitutes a single double entry tx, I've managed to script all of the oddness I've come across so far but expect I haven't seen everything yet.
To others earlier in the thread, the idea of whether loans were anonymous came up before in the FCViz thread, I decided my loans weren't a grand secret, if anyone is interested in me checking the accounting of their FC stuff I just need the basic FC csv files, if you want to munge them that's fine but I would need all loan parts and numbers of signifcance munged consistently to do my check.
Thoughts from all welcomed.
|
|
|
|
Post by grahamreeds on Jul 15, 2017 10:20:13 GMT
Put it up on GitHub so myself and others can pick over it.
|
|
