Currently, I’m trying to consolidate all my financial information into one place so that I can see (the solution I’m currently using is Excel – see attached):
- Valuation at a particular date
2 .Breakdown by investment product
- Various other analytics (Allocation by class etc.)
I’ve tried to use access, but it complains about outer joins in the excel workbook that I’m importing from google sheets (it automatically scrapes information from one of the sites that I have investments in)
What I’m using now
I’ve uploaded my info into PowerBI however, I can’t seem to create a table to get valuations on my information (the tables I want aren’t directed related to each other do it gives errors).
- See attached excel / screenshot below, how would I create that table in PowerBI?
- What is the best way to store/access that information? E.g. Access/Excell/PowerBi/SQL etc. (free solutions please)
Thank you so much for your help.